Running Queries

Overview

You can view currently running queries in QueryPie. Once a query execution is completed, the details are recorded in the Query Audit log.

Viewing Running Queries

1. Navigate to the Administrator > Audit > Databases > Running Queries menu.

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

3. Click the filter button at the top left of the table to filter logs using AND/OR conditions with the following options:

   

   1. SQL Type: Type of SQL statement

   2. Action At: Date and time range of query execution

   3. Executed From: Source of the query execution

      • Web Editor: Executed from the QueryPie web editor

      • Proxy: Executed through QueryPie proxy

      • SQL Request: Executed through the SQL Request workflow

      • SQL Job: Executed by an SQL Job

      • SQL Export Request: Executed through the SQL Export Request workflow

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

5. The table provides the following column information:

   • No: Event identification number

   • Executed At: Date and time of query execution

   • Name: User's name

   • Email: User's email

   • Action Type: Type of action

   • Connection Name: Name of the DB connection

   • Database Type: Type of the database

   • Privilege Name: User's access privilege

   • Client IP: User's client IP address

   • Replication Type: Type of DB replication

   • DB Host: Connected DB host

   • DB Name: Name of the database

   • DB User: DB user ID

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

   • SQL Type: Type of SQL statement

   • Query: Executed query statement

   • Client Name: Name of the client used (e.g., DataGrip)

   • Execution Reason: Reason for executing the query

   • Executed From: Source of the query execution

Viewing Running Query Details

Click on any row to view detailed information about the running query.

• The drawer on the right displays the following information:

  1. Name: User's name

  2. Action Type: Type of action

  3. Privilege Name: User's access privilege

  4. Privilege Type: Type of user access privilege

  5. SQL Type: Type of SQL statement

  6. Executed From: Source of the query execution

  7. Connection Name: Name of the DB connection

  8. Replication Type: Type of DB replication

  9. Client Name: Name of the client used (e.g., DataGrip)

  10. Client IP: User's client IP address

  11. Database Type: Type of the database

  12. DB Host: Connected DB host

  13. DB Name: Name of the database

  14. DB User: DB user ID

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

  16. Query: Executed query statement