You can view the proportions of SQL queries by using dimensions such as databases, SQL types, SQL execution durations, and users within a specific time range in the AnalyticDB for PostgreSQL console.

Procedure

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to manage and click its ID.
  4. In the left-side navigation pane, choose Diagnosis and Optimization > SQL distribution statistics.
  5. On the SQL distribution statistics page, select a time range and click Search to view SQL distribution statistics.

    AnalyticDB for PostgreSQL allows you to view the proportions of SQL queries by using the following dimensions: databases, SQL types, SQL execution durations, and users.