Redshift Observatory

System Table Tracker

System view pg_catalog.svv_active_cursors version 1.0.72899 / 2024-08-17

schema	name	column	data type
pg_catalog	svv_active_cursors	cursor_name	char(256)
pg_catalog	svv_active_cursors	cursor_storage_limit_used_percent	float8
pg_catalog	svv_active_cursors	declare_time	timestamp
pg_catalog	svv_active_cursors	fetched_rows	int8
pg_catalog	svv_active_cursors	session_id	int4
pg_catalog	svv_active_cursors	total_bytes	int8
pg_catalog	svv_active_cursors	total_rows	int8
pg_catalog	svv_active_cursors	transaction_id	int8
pg_catalog	svv_active_cursors	user_id	int4

View Text

SELECT stv.userid AS user_id,
       stv.name AS cursor_name,
       stv.xid AS transaction_id,
       stv.pid AS session_id,
       stv.starttime AS declare_time,
       stv.byte_count AS total_bytes,
       stv.row_count AS total_rows,
       stv.fetched_rows,
       CASE
         WHEN (cof.max_diskspace_usable + cof.current_diskspace_used) = 0
           THEN CAST(100.00 AS double precision)
         ELSE round((CAST(stv.byte_count AS double precision) / (CAST(1048576 AS double precision) * CAST(cof.max_diskspace_usable + cof.current_diskspace_used AS double precision))) * CAST(100 AS double precision),
                    CAST(2 AS numeric))
       END AS cursor_storage_limit_used_percent
FROM stv_active_cursors AS stv
     LEFT JOIN stv_cursor_configuration AS cof ON 1 = 1

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers