The Queries page lists information about the last 50 queries that Looker has submitted to your database. If you’d like to see information about queries older than that, try the Usage section of Looker.
Basic Query Information
| Column | Definition |
|---|---|
| Time | The start time of the query, displayed in your application timezone |
| Status | The status of the query, which can include:
|
| Connection | The Looker connection under which this query was run |
| User | The user who ran this query, if that can be determined. Some queries are not executed by a specific user, such as when Looker creates a persistent derived table, or when an unknown user accesses a public Look. |
| Source | The source of the query in Looker, such as the Explore page or the SQL Runner. If possible, a link to saved Look, or the query ID along with the name of the model and explore, is also displayed. Some queries will not have additional information, such as those run in the SQL Runner. |
| Runtime | The length of time it took to run the query |
| Details Button | See below for additional explanation |
The Details Button
Clicking the Details button to the right of any query will bring up additional information about that query. The pop-up includes an Info section and a SQL section, which can be accessed by clicking those buttons in the upper left. The SQL section will show you the raw SQL that was executed against the database. The Info section includes the following information:
| Section | Definition |
|---|---|
| History ID | The history ID of the query, if available. |
| Status | The status of the query, as described above |
| Connection | The Looker connection under which this query was run |
| User | The user who ran this query, if that can be determined. Some queries are not executed by a specific user, such as when Looker creates a persistent derived table, or when an unknown user accesses a public Look. |
| Source | The source of the query in Looker, such as the Explore page or the SQL Runner. If possible, additional information is displayed such as a link to the saved Look, the query ID, model name, explore name, fields selected, etc. |
| Start Time | The start time of the query, displayed in your application timezone |
| End Time | The finish time of the query, displayed in your application timezone |
| Runtime | The length of time it took to run the query |