Document Center

All Products

Document Center

Simple Log Service:Log fields

Last Updated:Jun 02, 2023

This topic describes the fields in logs that are collected from ApsaraDB RDS instances.

Audit logs


Field	Description
__topic__	The topic of the log. The value is fixed as rds_audit_log.
instance_id	The ID of the ApsaraDB RDS instance.
check_rows	The number of scanned rows.
db	The name of the database.
fail	Indicates whether the SQL statement is successfully executed. If the instance is a MySQL instance or an SQL Server instance and the SQL statement is successfully executed, the value of this field is 0. All values other than 0 indicate a failure. If the instance is a PostgreSQL instance and the SQL statement is successfully executed, the value of this field is 0000. All values other than 0000 indicate a failure.
client_ip	The IP address of the client that accesses the ApsaraDB RDS instance.
latency	The time that is consumed to return the result of the SQL statement. Unit: microseconds.
origin_time	The point in time at which the SQL statement is executed.
return_rows	The number of returned rows.
sql	The SQL statement that is executed.
thread_id	The ID of the thread.
user	The name of the user who executes the SQL statement.
update_rows	The number of updated rows.

Slow logs


Field	Description
__topic__	The topic of the log. The topic of a slow log in ApsaraDB RDS for MySQL is rds_slow_log. The topic of a slow log in ApsaraDB RDS for PostgreSQL is rds_slow_log_pg.
db_name	The name of the database.
db_type	The database type of the ApsaraDB RDS instance. Valid values: MySQL and PostgrepSQL.
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 that is consumed to execute the SQL statement. Unit: seconds.
region	The region where the ApsaraDB RDS instance resides.
rows_examined	The number of scanned rows.
rows_sent	The number of returned rows.
start_time	The point in time at which the SQL statement is executed.
user_host	The information about the client.

Error logs


Field	Description
__topic__	The topic of the log. The topic of an error log in ApsaraDB RDS for MySQL is rds_error_log. The topic of an error log in ApsaraDB RDS for PostgreSQL is rds_error_log_pg.
instance_id	The ID of the cluster.
collect_time	The time at which the log is collected.
db_type	The database type of the ApsaraDB RDS instance. Valid values: MySQL and PostgrepSQL.
db_version	The database engine version of the ApsaraDB RDS instance.
content	The content of the log.
eventType	The type of the event.