SQL History

  1. Click SQL in the toolbar and select Query History from the dropdown list.


     
  2. Search or filter the list by selecting the State, Database, User, and Time Range or by entering the Query Text.
  3. Search and filter data by the following columns:
    1. Time: Timestamp of when the query was executed, including date and time with timezone information.
    2. Duration: Displays how long the query took to execute in hours, minutes, seconds, and milliseconds.
    3. Tab Name: The name assigned to the SQL editor tab in which the query was run (if available).
    4. Database: The specific database that was queried.
    5. Schema: The schema under the selected database where the query was executed.
    6. Tables: Lists the tables that were involved in the query.
    7. User: Email ID or name of the user who executed the query.
    8. Rows: Number of rows returned or affected by the query.
    9. SQL: A preview of the SQL command executed. It includes basic operations like SELECT, FROM, and limits if any.


       
  4. Under the Action column, you can click theicon to redirect the query in a new tab for re-execution or inspection. For more information refer to Section 3.1 SQL Lab

Was this article helpful?