DML Snapshots

Overview

QueryPie records pre- and post-data snapshots when INSERT, UPDATE, or DELETE queries are executed. These snapshots are saved if the DML Snapshot setting is enabled for each DB connection. (Refer to Additional Settings in DB Connections for more details.)

Viewing DML Snapshots

1. Navigate to the Administrator > Audit > Databases > DML Snapshots menu.

2. Logs are displayed in descending order for the current month.

3. You can search the logs using the search bar at the top left of the table by the user's name.

4. Click the filter button to the right of the search field to filter logs using AND/OR conditions with the following options:

   

   1. Connection Name: Name of the DB connection

   2. Executed At: Date and time of execution

   3. Statement: Type of statement (Insert/Update/Delete)

5. Click the refresh button at the top right of the table to update the log list.

6. The table provides the following column information:

   1. No: Event identification number

   2. Executed At: Date and time of execution

   3. Name: User's name

   4. Email: User's email

   5. Statement: Type of statement (Insert/Update/Delete)

   6. Connection Name: Name of the DB connection

   7. Database Type: Type of the database

   8. Replication Type: Type of DB replication

   9. DB Host: Connected DB host

   10. DB User: DB user ID

   11. DB Name: Name of the database

   12. Table(s): Name of the table(s) involved

   13. Query: Executed query statement

   14. Time(ms): Execution time in milliseconds

   15. Rows: Number of rows affected

   16. Executed From: Source of the query execution

Viewing DML Snapshot Details

Click on any row to view detailed information about the DML snapshot.

• The drawer on the right displays the following basic query audit information:

  • Name: User's name

  • Executed At: Date and time of execution

  • Connection Name: Name of the DB connection

  • Replication Type: Type of DB replication

  • Statement: Type of statement (Insert/Update/Delete)

  • Time(ms): Execution time in milliseconds

  • Rows: Number of rows affected

  • Executed From: Source of the query execution

  • Database Type: Type of the database

  • DB Host: Connected DB host

  • DB Name: Name of the database

  • DB User: DB user ID

  • Table(s): Name of the table(s) involved

• At the bottom, the executed query statement and pre- and post-data are displayed:

  • Query: Executed query statement

  • {database.table}: Name of the target table

    • Before: Data before query execution

    • After: Data after query execution

    • Copy Data: Button to copy pre/post data