Skip to main content
Skip table of contents

Query History

Access Query History

Screen overview

When you click on Queries, you will get the following screen divided into:

  1. Filter Zone.
  2. SQL query information.

SQL query list with main overview information

Field NameDescription
(Execution) DateTimestamp of the execution of the Query
Progress

Execution duration when the operation is finished

  • When GREEN, the execution was successful
  • When RED there was an error during the execution

or

Progression of the operation when it is currently running

UserUsername & IP address of the user that executes the SQL command
Source
  • Index(es) used to answer the query => Only when the query is a SELECT statement
    • When GREEN, the index contains all the columns of the query; Performance is optimum.
    • When ORANGE, the query fetches fine data from the disk.
SQL

SQL statement and number of results that this query generates

SQL query detailed information

When you click on SELECT statements, the user can access more information about the SQL query.

  1. SQL Query main overview information
  2. SQL Statement
  3. Progress
  4. Query Profile
  5. External Source Details
  6. (Used) Indexes

2. SQL Statement sub-panel

3. Progress sub-panel

The progress sub-panel displays the information regarding the progress of the query:

  • the number of results for a select, or number of inserted lines for a load
  • the number of tasks executed / to execute, for queries triggering sub-tasks
  • the progress indicator for queries when it is still in progress

4. Query Profile sub-panel

Commun Metrics

There are three common metrics:

  • memory used by the master node
  • memory used by all nodes (incl. master node)
  • network byte sent
Metric "Lines read from K-store"

When the engine needs to get detailed rows to answer the query, the engine provides information about the number of lines that have been scanned.

Metric "Spill To Disk"

When a query spills on a disk, Query Profile shows you how much memory Indexima has allocated to local storage to perform the query. 

More information on Spill-to-Disk is available here.

5. External source Details sub-panel

When a query is delegated to an external source (using an external table), the engine displays information about the external source & query.

More information on External tables is available here.

NameDescription
Delegation period

Duration to execute the query on the external data source

Query delegated executionPercentage of delegation period to send the query and wait for execution 
Rows fetching from sourcePercentage of delegation period to retrieve results
External sourceName of the external data source
TableTarget table in the data source  
Lines fetched from external sourceNumber of results fetched from the data source

6. (Used) Indexes

The Indexes' sub-panel displays the detail of indexes used to execute the current query.
Indexes used by the current queries are displayed in green whereas the unused indexes are displayed in grey.

Filter queries

To facilitate research, queries can be filtered. 

  • You can combine multiple filters.
  • You can go through the "quick filters" or type in the search bar directly.

By default, the search is only performed through the SQL statement.

When a user needs to filter queries attributes, he can use both quick (modifiable) filters and other custom filters.

Available filters

FilterOperatorAvailable filter valuesDescriptionQuick filterApplied filter when using a quick filter
user: (means =)Any stringName of the user executing the queryMy Queriesuser:admin
hybridQueries: (means =)true/falseQueries requesting unindexed data on diskHybrid QuerieshybridQueries:true
external: (means =)true/falseQueries delegated to an external databaseExternal Queriesexternal:true
responseTime<, >integer + ms / s / minResponse time of the queryResponse TimeresponseTime:>5000ms
resultsNb<, >integerNumber of resultsResultsresultsNb:>5000
inError: (means =)true/falseQuery in errorErrorsinError:true
diskUsage: (means =)true/falseQueries using disk access for any reason (Spill to disk, Disk backed results or BigIndex)Disk UsagediskUsage:true
spillToDisk: (means =)true/falseQuery using disk for temporary storage during execution

diskBackedResult: (means =)true/false

Query using disk for output buffering 



bigIndex: (means =)true/false

Query using disk to store index on disk



freezing: (means =)true/false

Query currently frozen due to Big requests feature



freezeDuration<, >integer + ms / s / minQuery frozen more than this duration

ip:192.168.1.1: (means =)One IP address

Displays query launched by a specific IP address




Display Events

You can also display the "events" by clicking on the button on the right. 
Note that you cannot filter events.

More information: see Events API.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.