STATISTICS REQUEST STATUS¶

This command returns information about your statistics collection request, including whether or not the collection is completed.

More about statistics under Cost-Based Optimizer

Syntax¶

STATISTICS REQUEST STATUS [sessionId '<session_id>'] queryId '<query_id>'

Parameters¶

Parameter	Description	Parameter Type
`session_id`	String literal	Specifies the session ID
`query_id`	String literal	Specifies the query ID

Examples¶

STATISTICS REQUEST STATUS queryId '1';

Output:

session_id                          |query_id|submission_time        |start_execution_time   |termination_time|status   |current_column|total_num_columns|error_message|
------------------------------------+--------+-----------------------+-----------------------+----------------+---------+--------------+-----------------+-------------+
1ebafa4a-c843-4133-8335-54d295bdfdd0|1       |2024-05-21 10:02:30.249|2024-05-21 10:02:30.249|                |EXECUTING|3             |4                |             |

Permissions¶

The role must have the SUPERUSER permissions.