Skip to main content

system.query_log

A read-only in-memory table stores all the query logs;

mysql> select * from system.query_log order by event_time desc limit 1\G
*************************** 1. row ***************************
log_type: 1
handler_type: MySQL
tenant_id: test_tenant
cluster_id: test_cluster
sql_user: root
sql_user_quota: UserQuota<cpu:0,mem:0,store:0>
sql_user_privileges: GRANT ALL ON *.* TO 'root'@'127.0.0.1', ROLES: []
query_id: da879c17-94bb-4163-b2ac-ff4786bbe69e
query_kind: SelectPlan
query_text: select * from system.query_log order by event_time desc limit 1
event_date: 2022-03-24
event_time: 2022-03-24 11:13:27.414
current_database: default
databases:
tables:
columns:
projections:
written_rows: 0
written_bytes: 0
written_io_bytes: 0
written_io_bytes_cost_ms: 0
scan_rows: 0
scan_bytes: 0
scan_io_bytes: 0
scan_io_bytes_cost_ms: 0
scan_partitions: 0
total_partitions: 0
result_rows: 0
result_bytes: 0
cpu_usage: 10
memory_usage: 1603
client_info:
client_address: 127.0.0.1:56744
exception_code: 0
exception_text:
stack_trace:
server_version:
session_settings: enable_new_processor_framework=1, flight_client_timeout=60, max_block_size=10000, max_threads=8, storage_occ_backoff_init_delay_ms=5, storage_occ_backoff_max_delay_ms=20000, storage_occ_backoff_max_elapsed_ms=120000, storage_read_buffer_size=1048576, scope: SESSION
extra:
1 row in set (0.03 sec)
Read 1 rows, 969 B in 0.011 sec., 87.06 rows/sec., 84.36 KB/sec.