How Do I View SQL Execution Records of a Certain Period When GaussDB(DWS) Service 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 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.