SVV_ACTIVE_CURSORS - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).


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

SVV_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
user_id integer The ID of the user who created the cursor.
cursor_name varchar(128) The name of the cursor.
transaction_id bigint(128) The ID of the transaction.
session_id integer The ID of the process with the active cursor.
declare_time timestamp The time the cursor was declared.
total_bytes bigint The size of the cursor result set, in bytes.
total_rows bigint The number of rows in the cursor result set.
fetched_rows bigint The number of rows currently fetched from the cursor result set.
cursor_storage_limit_used_percent integer The percentage of disk space currently used by the cursor.