/* ... */ SELECT toDate(toStartOfDay(event_time)) AS event_time, user, COUNT(*) AS count FROM merge(... | ff7ffceb-4d20-495e-a894-187272a20598 | app_ch_monitor | 0.00 B | 0 seconds | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 B | 0 | 0 seconds | 17 | 0 | |||
/* ... */ SELECT SUM(memory_usage) as memory_usage, formatReadableSize(memory_usage) as readable_mem... | 08d5bc4b-e2d6-49ee-905e-89514cb23472 | app_ch_monitor | 0.00 B | 0 seconds | 30.00 | 0.00 | 0.00 | 0.00 | 0.00 B | 0 | 0 seconds | 14 | 1 | |||
/* ... */ WITH event_count AS ( SELECT toStartOfFiveMinutes(event_time) AS event_time, COUNT() AS qu... | 3a23c554-157f-4f21-82b7-0955a367b07d | app_ch_monitor | 0.00 B | 0 seconds | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 B | 0 | 0 seconds | 31 | 0 | |||
/* ... */ SELECT COUNT() as query_count, SUM(memory_usage) as memory_usage, formatReadableSize(memor... | 000de50f-64a3-40de-aff9-f98c7b82ea43 | app_ch_monitor | 2.00 MiB | 0 seconds | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 B | 0 | 0 seconds | 34 | 1 | |||
/* ... */ SELECT *, query_id as query_detail, multiIf (elapsed < 30, format('{} seconds', round(elap... | 410922bc-724e-4900-ba6d-25a00233d675 | app_ch_monitor | 0.00 B | 0 seconds | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 B | 0 | 0 seconds | 93 | 1 | |||
INSERT INTO C2C_CAN FORMAT JSONEachRow | 16e31fa9-b7ae-4da7-8643-7bd38c034b8f | app_beamd | 335.85 MiB | 1.3 seconds | 975.40 thousand | 975.40 thousand | 0.00 | 0.00 | 0.00 B | 31 | 0 seconds | 147 | 20 | |||
INSERT INTO prodenv.C2C_CAN_ghz FORMAT Arrow | 941accc4-4e78-4571-b470-9c02cbbe1775 | app_beamd | 281.85 MiB | 6.7 seconds | 1.00 million | 1.00 million | 0.00 | 0.00 | 0.00 B | 31 | 0 seconds | 37 | 5 | |||
INSERT INTO prodenv.C2C_CAN_ghz FORMAT Arrow | b2200ab1-bc3a-4ed7-8e35-b0f5826355d3 | app_beamd | 263.97 MiB | 8.6 seconds | 1.00 million | 1.00 million | 0.00 | 0.00 | 0.00 B | 43 | 0 seconds | 45 | 5 | |||
INSERT INTO prodenv.C2C_CAN_ghz FORMAT Arrow | 64bbb9d1-dcc2-4fa3-9257-4fa7d9ab1d8e | app_beamd | 208.63 MiB | 10 seconds | 1.00 million | 1.00 million | 0.00 | 0.00 | 0.00 B | 31 | 0 seconds | 37 | 5 | |||
INSERT INTO prodenv.C2C_CAN_ghz FORMAT Arrow | 26129406-f17c-4f9a-b481-1b91d2b0d0ed | app_beamd | 217.06 MiB | 15.3 seconds | 2.00 million | 2.00 million | 0.00 | 0.00 | 0.00 B | 71 | 0 seconds | 63 | 7 | |||
SELECT count() FROM device_shadow WHERE toDate(insert_timestamp) = toDate('2025-12-05') | 5d104cd0-607d-429e-95cf-89575258dcec | default | 0.00 B | a minute | 90.28% | 544.46 million | 0.00 | 0.00 | 0.00 | 0.00 B | 77 | 0 seconds | 32 | 1 |
