Get Query Status

User Interface

Field
Description
Comment

Query

Redshift Query


Example Query

// Example query for system tables:
SELECT *
FROM stv_recents           -- Recent running query information 
WHERE status = 'Running';  -- Filter only the queries that are currently running

// Query for active sessions:
SELECT *
FROM stv_blocklist;        -- Displays queries that are waiting or blocked

Execution Result

The execution result is returned in an array format, and the returned data values may vary depending on the query.

Last updated

Was this helpful?