Query logs and add charts to a dashboard

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.

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.

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.

Add a chart to a dashboard

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