View a markdown version of this page

STV_ACTIVE_CURSORS - Amazon Redshift
Table columns
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).

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

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.