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 |
