Check Queries That Being Processed In ClickHouse

Following sql query will show you queries that being processed.

SELECT user, address as client, elapsed as time_seconds, formatReadableSize(memory_usage) as memory, formatReadableSize(read_bytes) as read, read_rows, total_rows_approx as total_rows, query_id, substring(query,1,40) as query
FROM system.processes
ORDER BY elapsed desc FORMAT PrettyCompact

Example output:

Query id: 0c5031d3-37b8-4f62-894d-084c8e923c45

Row 1:
──────
user:         default
client:       ::ffff:127.0.0.1
time_seconds: 0.004283
memory:       0.00 B
read:         0.00 B
read_rows:    0
total_rows:   0
query_id:     0c5031d3-37b8-4f62-894d-084c8e923c45
query:        SELECT user, address as client, elapsed 

1 row in set. Elapsed: 0.012 sec.