The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.
SHOW PROCESSLIST 查询。
user(String) – The user who made the query. Keep in mind that for distributed processing, queries are sent to remote servers under the
address(String) – The IP address the request was made from. The same for distributed processing. To track where a distributed query was originally made from, look at
elapsed(Float64) – The time in seconds since request execution started.
rows_read(UInt64) – The number of rows read from the table. For distributed processing, on the requestor server, this is the total for all remote servers.
bytes_read(UInt64) – The number of uncompressed bytes read from the table. For distributed processing, on the requestor server, this is the total for all remote servers.
total_rows_approx(UInt64) – The approximation of the total number of rows that should be read. For distributed processing, on the requestor server, this is the total for all remote servers. It can be updated during request processing, when new sources to process become known.
memory_usage(UInt64) – Amount of RAM the request uses. It might not include some types of dedicated memory. See the max_memory_usage 设置。
query(String) – The query text. For
query_id(String) – Query ID, if defined.