Queries Screen for GridGain 9 Clusters
The Queries screen allows you to execute SQL queries against the GridGain 9 cluster and view the query results.
Screen consists of two tabs:
-
Queries List — execute SQL queries
-
Running Queries — view the list of running queries
You can add multiple tabs to the screen, each containing an SQL expression and the query results (after you have executed the query). To add a tab, click the + icon on the tab bar.
Defining Queries
Type the SQL expression in the "SQL editor" section of the tab.
You can enter multiple expressions in a single query. These are executed sequentially by an SQL script.
Executing Queries
To execute a SQL statement, click Execute on the tab toolbar.
The query results are displayed in the lower part of the screen, in a tab matching the query expression one.
The tab-level context menu includes the following options:
-
Copy - copies the result set to the clipboard
-
Remove - deletes query and closes the tab
-
Rename - set a custom name for the tab
The row-level context menu includes the Copy option, which copies the corresponding row to the clipboard.
Running queries
The Running Queries tab shows all tracked queries. When you first connect a cluster, you need to enable the tab via cluster update configuration button:
If successful, Running Queries tab will be activated:
You can filter the display by status, query duration, and apply other filters for a more precise view.
The table context menu lets you refine the queries shown. Each query includes the following query details:
| Column | Description |
|---|---|
ID |
Query ID. |
Initiator node |
Node where the query is executed. |
Type |
Query type. |
Schema |
The schema used. This column is hidden by default. To display it, use the tab-level context menu. |
Status |
Query status. Possible values:
|
Statement number |
Position of the statement within the SQL script. Hidden by default. Enable it via the tab-level context menu. |
Transaction ID |
Transaction ID. Not applicable for DDL queries. |
Start time |
Range of date and time during which the queries were executed. |
Parent ID |
ID of the parent query that initiated this query. This is available for queries executed via the SQL CLI on the cluster, but not for those run in the Queries tab editor. |
Duration |
Query duration. |
Checking Failure Reasons
If a query is marked as Failed, click its status to see detailed error information.
Cancelling Queries
When a query is in Running status, you can cancel it from the row-level context menu. Once canceled, its status will change to Canceled.
Explaining Queries
To analyze an executed query, run an EXPLAIN query using the row-level context menu. For more details on how the EXPLAIN query works in GridGain, refer to the documentation.
A new tab opens in the Queries List, displaying the results of the EXPLAIN query.
Selecting Queries to Track
To reduce Control Center load and minimize disk space usage, you can specify which running queries to track by setting a specific query duration. Only queries that exceed the specified duration will appear in the Running Queries tab.
To select queries to track:
-
Click Configure running queries in the top-right corner of the tab.
-
In the Configure running queries dialog, define query duration and click Save.
For example, entering "500" in the Duration field will track only queries lasting longer than 500 ms. This applies even to the queries already running (in the Running status) when you save the configuration.
© 2025 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.