Viewing and Exporting Slow Query Logs

This section describes how to view database-level slow query logs. Any query that takes longer than an execution time threshold (in milliseconds) will be logged. You can identify the SQL statements that take a long time to execute and tune them based on slow query logs.

Viewing and Exporting Log Details

Log in to the Huawei Cloud console.
In the service list, choose Databases > GeminiDB.
On the Instances page, click the target instance.
In the navigation pane on the left, choose Slow Query Logs.
On the Slow Query Logs page, set search criteria and click Search to view log information.
- Select All nodes and view slow query logs of all nodes. Alternatively, select a specific node to view its slow query logs.
- View slow query logs of a specific node in different time ranges.
- View slow query logs of the following types of SQL statements:
  - SELECT
On the Log Details page, click in the upper right corner of the log list to export log details.
- You can view the exported CSV file to your local PC.
- Up to 2,000 logs can be exported at a time.