Query logs and add charts to a dashboard

Last updated:2020-12-28 14:55:33

Query logs

On the details page of a project, click Log Query in the left navigation pane or click Search in the Actions column for a LogPool. The Log Query page appears. KLog supports different query methods, including full-text query, key-value query, and SQL query.

Full-text query

To query the logs that contain select * limit 10 in any field in the last 7 Days, select default in LogPool, select Last 7 Days as the time range to query, enter select * limit 10 in the text box, and then click Query. The text that you enter is case-sensitive. The following figure shows the query result.Lark20201221170954.png

Key-value query

To query the logs where the value of the timestamp field is 1608675721051 in the last 7 Days, select default in LogPool, select Last 7 Days as the time range to query, enter timestamp: 1608675721051 in the text box, and then click Query. The following figure shows the query result.image.png

SQL query

Select default in LogPool, select This month as the time range to query, enter select * limit 20 in the text box, and then click Query. The following figure shows the query result.11.png

Add a chart to a dashboard

Click Add to Dashboard on the right side of a chart. Add To Dashboard.pngIn the panel that appears, enter a dashboard name in Dashboard Name or select an existing dashboard to add the chart to the dashboard.

save dashboard.png

Did you find the above information helpful?

Unhelpful
Mostly Unhelpful
A little helpful
Helpful
Very helpful

What might be the problems?

Insufficient
Outdated
Unclear or awkward
Redundant or clumsy
Lack of context for the complex system or functionality

More suggestions

0/200

Please give us your feedback.

Submitted

Thank you for your feedback.

问题反馈