Avg Queries Duration over last 14 days (AVG(duration in seconds) / day)
Total Queries over last 14 days by users
Running Queries over last 14 days (query / day)
Avg Memory Usage for queries over last 14 days
Contains information about executed queries: start time, duration of processing, error messages
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | bd8582e6-e6dc-4491-82d2-e89c8f661ca9 | 5 minutes | 0.00 B | 5 hours ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | fab973f8-0d7c-4e07-adc9-387b4a5e268f | 5 minutes | 0.00 B | a day ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | eb51d4ac-7a06-47df-b2c1-0fe2255a069f | 5 minutes | 0.00 B | 2 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | cd3b37e8-b078-4d1a-89d8-dec98e2fb204 | 5 minutes | 0.00 B | 3 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 5886c2aa-68b3-458d-b4a3-ae4c62ca66c2 | 5 minutes | 0.00 B | 4 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
default | SELECT hostName() AS `hostName()`, count() AS `count()` FROM `home_assistant`.`event_data` AS `__tab... | ae5a309b-0464-4018-a80c-cd018e10c9eb | a few seconds | 23.17 KiB | 5 days ago | 1.00 | 0.00 | 1.00 | Select | QueryFinish | ClickHouse client |
duyet | SELECT hostName(), count() FROM clusterAllReplicas(`{cluster}`, home_assistant.event_data) GROUP BY ... | 2d36e2ab-1705-460e-b594-e47f193b2160 | a few seconds | 370.93 KiB | 5 days ago | 2.00 | 0.00 | 2.00 | Select | QueryFinish | ClickHouse client |
duyet | INSERT INTO TABLE event_data SELECT * FROM event_data_old; | 6d135f65-7c64-419e-af3d-7372e2be0567 | a few seconds | 8.75 MiB | 5 days ago | 8.85 thousand | 8.85 thousand | 8.85 thousand | Insert | QueryFinish | ClickHouse client |
duyet | CREATE TABLE IF NOT EXISTS home_assistant.event_data ON CLUSTER '{cluster}' (`data_id` Int64, `hash`... | ba8398dc-60d1-4ebd-a8ce-11a2d4cb537b | a few seconds | 61.18 KiB | 5 days ago | 2.00 | 0.00 | 2.00 | Create | QueryFinish | ClickHouse client |
/* ... */ CREATE TABLE IF NOT EXISTS home_assistant.event_data UUID '25cd4831-2168-4bf7-9d49-0b6ed6e... | d38eb5f1-efec-4987-9562-f262dc2fb34b | a few seconds | 704.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Create | QueryFinish | ||
duyet | DROP TABLE home_assistant.event_data ON CLUSTER '{cluster}' SYNC; | bc06fe5d-d159-4388-b7b3-4ffb971bbc50 | a few seconds | 61.13 KiB | 5 days ago | 2.00 | 0.00 | 2.00 | Drop | QueryFinish | ClickHouse client |
/* ... */ DROP TABLE home_assistant.event_data SYNC | 10c16585-a057-4318-9286-fe5d0059ec2f | a few seconds | 0.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Drop | QueryFinish | ||
duyet | INSERT INTO TABLE event_data SELECT * FROM event_data_old; | 4a1e088e-7105-4113-8acf-a495642cb6dd | a few seconds | 8.75 MiB | 5 days ago | 8.85 thousand | 8.85 thousand | 8.85 thousand | Insert | QueryFinish | ClickHouse client |
duyet | CREATE TABLE IF NOT EXISTS home_assistant.event_data ON CLUSTER '{cluster}' (`data_id` Int64, `hash`... | 680b9fb8-4f81-4ebc-b304-f75fa4c7c35f | a few seconds | 60.34 KiB | 5 days ago | 2.00 | 0.00 | 2.00 | Create | QueryFinish | ClickHouse client |
/* ... */ CREATE TABLE IF NOT EXISTS home_assistant.event_data UUID 'ea8ac0ad-c4dc-4d87-8a44-b5546fe... | c51c098e-64af-4e60-ab7f-78703d402dd8 | a few seconds | 704.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Create | QueryFinish | ||
duyet | DROP TABLE home_assistant.event_data SYNC; | 97f75bac-1aba-4299-9eb4-c5cd45d27de9 | a few seconds | 0.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Drop | QueryFinish | ClickHouse client |
duyet | SELECT hostName(), count() FROM clusterAllReplicas(`{cluster}`, home_assistant.event_data) GROUP BY ... | 80bd7c6c-ce94-40c6-a652-2d7e7124e64f | a few seconds | 370.91 KiB | 5 days ago | 1.00 | 0.00 | 1.00 | Select | QueryFinish | ClickHouse client |
duyet | SHOW CREATE TABLE event_data | f628fc2e-965e-429b-b151-b8f9367ebb4a | a few seconds | 8.99 KiB | 5 days ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | ClickHouse client |
duyet | SELECT hostName(), count() FROM clusterAllReplicas(`{cluster}`, home_assistant.event_data) GROUP BY ... | f1354e71-8fd6-4a14-bd57-9d79010179ae | a few seconds | 370.91 KiB | 5 days ago | 1.00 | 0.00 | 1.00 | Select | QueryFinish | ClickHouse client |
duyet | SELECT hostName(), count() FROM clusterAllReplicas('{cluster}', home_assistant.event_data) GROUP BY ... | 14361961-90f8-458e-b6ca-90fa32b76584 | a few seconds | 371.46 KiB | 5 days ago | 1.00 | 0.00 | 1.00 | Select | QueryFinish | ClickHouse client |
duyet | INSERT INTO TABLE event_data SELECT * FROM event_data_old; | 6ab8619c-1e55-4433-84fb-cbbd37ea1269 | a few seconds | 8.75 MiB | 5 days ago | 8.85 thousand | 8.85 thousand | 8.85 thousand | Insert | QueryFinish | ClickHouse client |
/* ... */ CREATE TABLE IF NOT EXISTS home_assistant.event_data UUID '29b17bed-7bd2-46ce-80d8-05ad27a... | 2de02511-af34-4352-9458-29115ca2584c | a few seconds | 704.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Create | QueryFinish | ||
duyet | CREATE TABLE IF NOT EXISTS home_assistant.event_data ON CLUSTER '{cluster}' (`data_id` Int64, `hash`... | b0546764-edb7-44da-bd6c-22ac08a7610a | a few seconds | 60.34 KiB | 5 days ago | 2.00 | 0.00 | 2.00 | Create | QueryFinish | ClickHouse client |
duyet | RENAME TABLE event_data TO event_data_old; | 87ff0316-6b02-4963-9cba-f396a6222869 | a few seconds | 0.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Rename | QueryFinish | ClickHouse client |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 142b9917-564b-4ef0-a3dd-8bf8a48cd261 | 5 minutes | 0.00 B | 5 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 94700824-2527-47cb-b3cb-de5a61f48cfd | 5 minutes | 0.00 B | 6 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 493cd88c-e12b-410a-afbe-e0bf2790a91c | 5 minutes | 0.00 B | 13 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 3d400ffb-09f6-4e42-ad8d-3766ffde756c | 5 minutes | 0.00 B | 14 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 93c7dfd5-ca6c-452c-b6e7-edcd9a22829a | 5 minutes | 0.00 B | 15 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | 71e7c819-6a86-489c-b67c-55b3218d8fb0 | a few seconds | 3.00 MiB | 16 days ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | 41947a92-6e66-4764-9b23-60ae9fb0bf64 | a few seconds | 3.00 MiB | 16 days ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 5c4ed4f2-1e40-4188-a07b-6d1f601b189c | 5 minutes | 0.00 B | 16 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | f8305f53-31e5-4b6f-a6e4-7f5d8813ac61 | a few seconds | 3.00 MiB | 17 days ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | 65bf42ae-93f0-4a9f-b4db-7ecb0f55b3fd | a few seconds | 3.00 MiB | 17 days ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | e3e5a159-9d33-43a1-8a16-00c54295c070 | 5 minutes | 0.00 B | 17 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 6842d579-6549-4629-bc30-2f4c65f2c198 | 5 minutes | 0.00 B | 18 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | d53ad76f-a0d0-440b-8507-55b2ed1e8fd3 | 5 minutes | 0.00 B | 19 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 1ca3c57c-c634-4754-b326-8782ab1526e6 | 5 minutes | 0.00 B | 20 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | d402c532-21fc-4a31-a637-48a137353ef4 | a few seconds | 3.00 MiB | 20 days ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | 47232fa9-fd1a-4a23-a7dd-593c6d0e8b68 | a few seconds | 3.00 MiB | 20 days ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 88aefbeb-85b4-4a13-94e4-c87fa0da1ad2 | 5 minutes | 0.00 B | 21 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | e01408af-5ddd-43aa-9593-b24888e9c545 | 5 minutes | 0.00 B | 22 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 922b1fb0-e118-47cf-822b-f48a20fb41fd | 5 minutes | 0.00 B | 23 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | af8dd09d-fa1a-4ebd-a404-b27f2d090c47 | a few seconds | 3.00 MiB | 24 days ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | a9e3f338-0322-4b4c-9a1d-34c5e56efef1 | a few seconds | 3.00 MiB | 24 days ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | e5788b73-6211-4d23-9dd2-f3cb6677749c | 5 minutes | 0.00 B | 24 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 570e6f9f-6a8d-4b46-8dd8-d17459c9841c | 5 minutes | 0.00 B | 25 days ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | 9da4e279-0f4b-4cc4-beb1-e5681dc48c2a | a few seconds | 3.00 MiB | 25 days ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | 71f8df52-6164-4ba5-b7aa-9060fd570c43 | a few seconds | 3.00 MiB | 25 days ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | bcd8cd8b-b1e8-4da0-b8c8-30e6717d5fd6 | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | a52c6323-55cf-410d-b4ef-4dd0514bdea5 | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 62e7f049-4fd9-42fa-a774-c4d9a02edb98 | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 4956164e-f0a6-46bd-b06e-81e3d965d91e | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 46c10d0e-e28e-4b32-95e5-75d9b52f772f | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | 6c78c2e7-2490-48d8-bf89-7f8e3fcae5b9 | a few seconds | 3.00 MiB | a month ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | 69388e9d-bb5a-4d57-8100-ec2e9f066e83 | a few seconds | 3.00 MiB | a month ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | ab26a8f6-f393-4c0a-bc9f-08fb557d50be | a few seconds | 3.00 MiB | a month ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | 7279e25f-ade3-4600-b476-4d313314e107 | a few seconds | 3.00 MiB | a month ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 28d8a890-b496-4e79-8fa0-190f15d714ff | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
homelab | INSERT INTO home_assistant.event_data (data_id, hash, shared_data) VALUES | 28cb4778-b92f-4e13-860e-b0f78e18780d | 5 minutes | 0.00 B | a month ago | 0.00 | 0.00 | 0.00 | Insert | ExceptionWhileProcessing | ClickHouse python-driver |
monitoring | /* ... */ SHOW CREATE TABLE home_assistant.event_data FORMAT JSONEachRow | c5aee823-cc5c-43be-9555-021013657645 | a few seconds | 3.00 MiB | a month ago | 1.00 | 0.00 | 1.00 | Show | QueryFinish | |
monitoring | /* ... */ SELECT * FROM home_assistant.event_data LIMIT 20 FORMAT JSONEachRow | de97ce02-b586-4d9c-93b5-ef9c1d3ad26a | a few seconds | 3.00 MiB | a month ago | 8.19 thousand | 0.00 | 20.00 | Select | QueryFinish | |
monitoring |