Help Center> Relational Database Service> Best Practices> RDS for PostgreSQL> Viewing Slow Query Logs of RDS for PostgreSQL DB Instances
Updated on 2022-09-21 GMT+08:00

Viewing Slow Query Logs of RDS for PostgreSQL DB Instances

Scenarios

Slow query logs record statements that exceed the log_min_duration_statement value (1 second by default). You can view log details and statistics to identify statements that are slowly executed and optimize the statements. RDS for PostgreSQL supports the following statement types:
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • CREATE
  • DROP
  • ALTER
  • DO
  • CALL
  • COPY

Parameter Description

Table 1 Parameters related to RDS for PostgreSQL slow queries

Parameter

Description

log_min_duration_statement

Specifies the minimum execution time. The statements whose execution time is greater than or equal to the value of this parameter are recorded.

log_statement

Specifies the statement type. The value can be none, ddl, mod, or all.

The default value is none. If you change the value to all, the database log format changes and slow query logs fail to be parsed.

Procedure

  1. Log in to the management console.
  2. On the Instances page, click the target DB instance.
  3. In the navigation pane on the left, choose Logs. On the Slow Query Logs page, click Log Details.

    You can view the slow query log records of a specified statement type in a specified time period.