Check currently running queries

[ 1 Overview ] [ 2 What permissions do I need? ] [ 3 Exploring queries ] [ 4 Expanding query details ] [ 5 Closing a query ]

Overview

Users with the necessary permissions can go to Administration → Data management → Current queries to consult a list of the queries currently running in a domain. This lets you check their priority, CPU consumption, the number of parsed and returned events, and bytes parsed. You can also copy a query to the clipboard or cancel a query.

What permissions do I need?

To access this area and investigating queries as needed:

Non-admin users require the 'Finders' permission to view and manage their own running queries on the domain, for example those created, opened by them.
Admin users can view and manage all queries running on the domain.

Know more about permissions here.

Exploring queries

You will see a list of the queries that are currently running. Click the refresh icon at the top right corner to update the list of queries. Here's a closer look at what you'll see in this view:

Application	Whether the query was run using the Web or API application.
Created by	The email address of the user that created the query.
Table name	The name of the data table the query is executed on.
Started	The time the query was executed.
From	The start of the date range searched by the query.
To	The end of the date range searched by the query.
CPU	The percentage of total CPU capacity used to run the query. Devo uses a color-coding system to reveal the impact of consumption, using the following ranges: 0-10 green 10-30 amber 30+ red
Bytes Parsed	The number of bytes processed while running the query.
Events Parsed	The number of events parsed for the query.
Events returned	The number of events matching the query after groupings, filters, or any other conditions included in the query.

Expanding query details

Click a row to expand the full details of the query, as well as the percentage of the histogram that has been loaded. You can also click the icon at the end of the row and select Show query.

You can copy a query to the clipboard by clicking the copy icon at the bottom right of the code box.

Closing a query

To cancel a query, click the icon at the end of the row and select Close query. Closing a query stops it from running until it is activated again. When a query has been closed, it disappears from the list.