Describes the fields in audit logs, slow logs, and error logs collected from ApsaraDB RDS instances.
Audit logs
| Field | Description |
| __topic__ | The log topic. The value is always rds_audit_log. |
| instance_id | The ID of the ApsaraDB RDS instance. |
| check_rows | The number of rows scanned. |
| db | The name of the database. |
| fail | Indicates whether the SQL statement executed successfully.
|
| client_ip | The IP address of the client accessing the ApsaraDB RDS instance. |
| latency | The time taken to return the SQL statement result. Unit: microseconds. |
| origin_time | The time at which the SQL statement was executed. |
| return_rows | The number of rows returned. |
| sql | The SQL statement that was executed. |
| thread_id | The ID of the thread. |
| user | The name of the user who executed the SQL statement. |
| update_rows | The number of rows updated. |
Slow logs
| Field | Description |
| __topic__ | The log topic.
|
| db_name | The name of the database. |
| db_type | The database engine type. Valid values: MySQL and PostgreSQL. |
| db_version | The database engine version of the ApsaraDB RDS instance. |
| instance_id | The ID of the cluster. |
| lock_time | The duration of the lock wait. Unit: seconds. |
| owner_id | The ID of the Alibaba Cloud account. |
| query_sql | The SQL statement of the slow query. |
| query_time | The time taken to execute the SQL statement. Unit: seconds. |
| region | The region where the ApsaraDB RDS instance resides. |
| rows_examined | The number of rows scanned. |
| rows_sent | The number of rows returned. |
| start_time | The time at which the SQL statement was executed. |
| user_host | The host and user information of the client. |
Error logs
| Field | Description |
| __topic__ | The log topic.
|
| instance_id | The ID of the cluster. |
| collect_time | The time at which the log was collected. |
| db_type | The database engine type. Valid values: MySQL and PostgreSQL. |
| db_version | The database engine version of the ApsaraDB RDS instance. |
| content | The content of the log entry. |
| eventType | The type of the event. |