ClickHouse is an excellent OLAP database
While I'm looking for the slow queries, I found many query_log_N and query_thread_log_N tables.
SHOW TABLES
...
โ query_log โ
โ query_log_0 โ
โ query_log_1 โ
โ query_log_2 โ
โ query_log_3 โ
โ query_log_4 โ
โ query_thread_log โ
โ query_thread_log_0 โ
โ query_thread_log_1 โ
โ query_thread_log_2 โ
โ query_thread_log_3 โ
โ query_thread_log_4 โ
...
I am developing a monitoring system for slow queries and considered to use the query_log table,
but there are other tables with the same postfix of names.
I wonder what the tailing numbers of tables mean.
Thank you.
It's renamed after each CH upgrade which changes table's schema
@den-crane
Thank you for your answer.
Most helpful comment
It's renamed after each CH upgrade which changes table's schema