Updated on 2023-11-21 GMT+08:00

Slow Query Logs

GeminiDB Cassandra API allows you to view slow query logs of databases. The unit of the execution time is ms. 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

  1. Log in to the management console.
  2. In the service list, choose Databases > GeminiDB Cassandra API.
  3. On the Instances page, locate the instance whose log details you want to view and click its name.
  4. In the navigation pane on the left, choose Slow Query Logs.
  5. 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

  6. 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.