Query log analyzer
AuraDB Professional AuraDB Virtual Dedicated Cloud
Query log analyzer is a feature that provides a UI to review the queries executed on an Aura instance.
You can access query logs from Logs in the left-hand navigation or from query-related metrics in the Database tab in Metrics. Use the more menu (…) on the metric to navigate to Explore query logs.
To toggle between instances, use the dropdown menu on the top left.
Query log analyzer is split up in three parts:
-
Query timeline - Timeline showing metrics for number of queries, failed queries and query latency.
-
Summary table - An aggregated view of query logs, giving a high level overview over the selected time period.
-
Details table - A detailed view showing individual query executions in the selected time period.
To fetch logs, first select a time range in the Query timeline. With a time selection done, press the Fetch logs button. You may optionally select any filters or search text if required, then press Fetch.
A summary of query executions is returned, showing aggregations per query. To see the individual query executions, click the right arrow at the end of the line to show details for that query. The details pane shows individual executions.
Query timeline
When viewing the query timeline, you can select from the following time intervals:
-
30 minutes
-
Last hour
-
Last 2 hours
-
Last 6 hours
-
Last 24 hours
-
Last 3 days
-
Last week
The query timeline can be collapsed by clicking on the header.
|
The query timeline may show activity from internal meta queries, which are filtered in the table. |
Zoom
To zoom in to a narrower time interval, select and drag inside the timeline to select your desired time interval. The data in the timeline automatically updates to match the increased resolution. To update the table, click the Fetch logs button.
To reset zoom, double-click anywhere inside the timeline.
Fetch logs
The Fetch logs button opens up a dialog where you can add filters and search before fetching the logs. The Query timeline determines the current time selection, which can be changed by closing the dialog and modifing the timeline. To fetch the logs after selection of filters and search is done, click the Go button.
|
Query logs are available for a period of 7 days, and each request can be for up to 24 hours of data. |
Table interactions
Sort table
By default, the table is sorted on Count for Summary and Status for Details. To sort by a column (such as Max Time ms) click on the column heading.