Logo

ClickHouse MonitoringMonitoring

  • Overview
Total Queries over last 14 days by users
Avg Memory Usage for queries over last 14 days

history queries

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

app_ch_monitor/* ... */ SHOW CREATE TABLE system.merge_tree_settings FORMAT JSONEachRowbd9128d0-e9b8-4a4e-8b8f-bec6f4f50ee0a few seconds
4.00 MiB
2 hours ago
1.00
0.00
1.00ShowQueryFinish
app_ch_monitor/* ... */ SELECT * FROM system.merge_tree_settings LIMIT 20 FORMAT JSONEachRowf5ff0ba9-3bbc-4ca0-b931-c4960f9692a0a few seconds
3.99 MiB
2 hours ago
188.00
0.00
20.00SelectQueryFinish
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
1b417414-184f-4f60-b1c5-90a0ba0ce7faa few seconds
7.33 MiB
9 hours ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
e44ebd43-ab6f-4781-8b8f-135effcbceefa few seconds
7.32 MiB
9 hours ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
c3a38c1e-fcbf-489e-a567-1c0f8e12241da few seconds
7.32 MiB
9 hours ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
9f0f4c20-4f5d-48f4-ae1a-33592e9ee87aa few seconds
7.32 MiB
9 hours ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
62a79827-2321-4f1c-9cb3-08b4c7b201dda few seconds
7.33 MiB
9 hours ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
e4c75844-5daf-4ef6-b0d4-27871145fc95a few seconds
7.33 MiB
9 hours ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
08fe5d66-41a4-49cb-9d86-a4cab41dd824a few seconds
7.33 MiB
a day ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
default
SELECT DISTINCT arrayJoin(extractAll(name, '[\\w_]{2,}')) AS res FROM (SELECT * FROM viewIfPermitted...
7c334bc7-77e7-4bd1-8a16-d0725640838aa few seconds
7.32 MiB
2 days ago
40.79 thousand
0.00
10.54 thousandSelectQueryFinishClickHouse client
10 row(s) in 0.106 seconds.

Rows per page

Page 1 of 1
Running Queries over last 14 days (query / day)