Help Center/ GaussDB(DWS)/ More Documents/ User Guide(ME-Abu Dhabi Region)/ FAQs/ Database Performance/ How Do I View SQL Execution Records in a Certain Period When GaussDB(DWS) Read and Write Are Blocked?
Updated on 2025-05-27 GMT+08:00

How Do I View SQL Execution Records in a Certain Period When GaussDB(DWS) Read and Write 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 query, see "Real-Time Top SQL" in the Data Warehouse Service (DWS) Developer Guide.
  • For details about real-time SQL query, see "Historical Top SQL" in the Data Warehouse Service (DWS) Developer Guide.