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. |
