Help Center/ GaussDB(DWS)/ More Documents/ User Guide (Kuala Lumpur Region)/ FAQs/ Database Performance/ How Can I View SQL Execution Records in a Certain Period When Read and Write Requests Are Blocked?
Updated on 2023-03-17 GMT+08:00
View PDF
Share

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.
Parent topic: Database Performance