STV_ACTIVE_CURSORS - Amazon Redshift

STV_ACTIVE_CURSORS

STV_ACTIVE_CURSORS displays details for currently open cursors. For more information, see DECLARE.

STV_ACTIVE_CURSORS is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views. A user can only view cursors opened by that user. A superuser can view all cursors.

Table columns

Column name Data type Description
userid integer ID of user who generated entry.
name character(256) Cursor name.
xid bigint Transaction context.
pid integer Leader process running the query.
starttime timestamp Time when the cursor was declared.
row_count bigint Number of rows in the cursor result set.
byte_count bigint Number of bytes in the cursor result set.
fetched_rows bigint Number of rows currently fetched from the cursor result set.