Logo

ClickHouse MonitoringMonitoring

  • Overview
Running Queries over last 14 days (query / day)
Avg Memory Usage for queries over last 14 days
Total Queries over last 14 days by users

history queries

Contains information about executed queries: start time, duration of processing, error messages

app_ch_monitor/* ... */ SELECT * FROM system.monitoring_events LIMIT 20 FORMAT JSONEachRow4b5a98e4-91cf-4ff2-af96-6dbc5685b421a few seconds
3.99 MiB
an hour ago
44.00
0.00
20.00SelectQueryFinish
app_ch_monitor/* ... */ SHOW CREATE TABLE system.monitoring_events FORMAT JSONEachRowef8af803-57de-437b-b6cd-b9c5460c9f8aa few seconds
4.00 MiB
an hour ago
1.00
0.00
1.00ShowQueryFinish
app_ch_monitor
SELECT max(event_time) as last_cleanup, now() as now FROM system.monitoring_events WHERE kind = 'Las...
af8b97cb-45ac-46ef-898b-0733e77a1b00a few seconds
4.21 MiB
3 days ago
730.00
0.00
1.00SelectQueryFinish
app_ch_monitorINSERT INTO system.monitoring_events FORMAT JSONEachRowd4156368-4358-44ac-9072-8cc5c462b75ca few seconds
4.34 MiB
3 days ago
1.00
1.00
1.00InsertQueryFinish
app_ch_monitor
CREATE TABLE IF NOT EXISTS system.monitoring_events ( kind Enum('PageView', 'UserKillQuery', 'System...
f6eb5ed5-8e8f-4bdb-af6c-9ff630703c89a few seconds
0.00 B
3 days ago
0.00
0.00
0.00CreateQueryFinish
5 row(s) in 1.024 seconds.

Rows per page

Page 1 of 1