Help Center/ GaussDB/ FAQs/ Log Management/ How Do I View All SQL Logs Executed by GaussDB?
Updated on 2024-07-11 GMT+08:00

How Do I View All SQL Logs Executed by GaussDB?

You can use the visualized database management service Data Admin Service (DAS) to quickly search for target SQL execution records.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, locate the target DB instance and click Log In in the Operation column.
  5. On the displayed page, enter the username and password and click Log In.
  6. On the top menu bar, choose SQL Operations > SQL History.
  7. On the displayed page, search for execution information about the target SQL statement by time range, database name, or keyword.

    Figure 1 SQL History
    • To access the Database Management page, click a database name.
    • To copy and use a SQL statement, click it in the SQL Statement column.
    • To directly execute a SQL statement, click Open in SQL window in the Operation column.