-
Notifications
You must be signed in to change notification settings - Fork 8.3k
select query always have zero result_rows/result_bytes on system.query_log table #11595
Description
Describe the bug
select query always have zero result_rows/result_bytes on system.query_log table
How to reproduce
- select * from any table with data on your clickhouse db.
- check system.query_log
-
Which ClickHouse server version to use
version 20.4.4.18 -
Queries to run that lead to unexpected result
all select queries have this issue.
e.g.select * from system.settings
Expected behavior
result_rows/result_bytes should tell how many rows/bytes returned by clickhouse
Error message and/or stacktrace
No
Additional context
We monitor result_rows/result_bytes/read_rows/read_bytes as a measurement for the clickhouse cluster usage. read_rows/read_bytes can be get from query_log correctly. However, result_rows/result_bytes are always zero for select clause.
We previously use version 19.14. The measurement works well. However, on 20.4, result_rows/result_bytes becomes always zero.