Help Center> GaussDB(DWS)> User Guide (Moscow Region)> FAQs> Database Performance> How Can I View SQL Execution Records in a Certain Period When Read and Write Requests Are Blocked?
Updated on 2024-02-26 GMT+08:00

How Can I View SQL Execution Records in a Certain Period When Read and Write Requests Are Blocked?

You can use the top SQL feature to view SQL statements executed in a specified period. SQL statements of the current CN or all CNs can be viewed.

Top SQL allows you to view real-time and historical SQL statements.

  • For details about real-time SQL statement query, see section "Real-time TopSQL" in Data Warehouse Service Development Guide.
  • For details about how to query historical SQL statements, see section "Historical TopSQL" in Data Warehouse Service Development Guide.