audit_log
Overview
Store audit logs
Database
__internal_schema
Table Information
Column Name | Type | Description |
---|---|---|
query_id | varchar(48) | ID of the Query |
time | datetime(3) | Time when the query was executed |
client_ip | varchar(128) | IP address of the client sending the query |
user | varchar(128) | User |
catalog | varchar(128) | Current Catalog during statement execution |
db | varchar(128) | Current Database during statement execution |
state | varchar(128) | Execution status of the statement |
error_code | int | Error code |
error_message | text | Error message |
query_time | bigint | Execution time of the statement |
scan_bytes | bigint | Amount of data scanned |
scan_rows | bigint | Number of rows scanned |
return_rows | bigint | Number of rows returned |
stmt_id | bigint | Statement ID |
is_query | tinyint | Whether it is a query |
frontend_ip | varchar(128) | IP address of the connected Frontend |
cpu_time_ms | bigint | Cumulative CPU time (in milliseconds) consumed by the Backend for statement execution |
sql_hash | varchar(128) | Hash value of the statement |
sql_digest | varchar(128) | Digest (signature) of the statement |
peak_memory_bytes | bigint | Peak memory usage of the Backend during statement execution |
workload_group | text | Workload Group used for statement execution |
stmt | text | Statement text |