Redshift Observatory

System Table Tracker

System view pg_catalog.svv_query_inflight version 1.0.45698 / 2023-01-27

schema	name	column	data type
pg_catalog	svv_query_inflight	pid	int4
pg_catalog	svv_query_inflight	query	int4
pg_catalog	svv_query_inflight	sequence	int4
pg_catalog	svv_query_inflight	slice	int4
pg_catalog	svv_query_inflight	starttime	timestamp
pg_catalog	svv_query_inflight	suspended	int4
pg_catalog	svv_query_inflight	text	char(200)
pg_catalog	svv_query_inflight	userid	int4

View Text

SELECT b.userid,
       a.slice,
       a.query,
       a.pid,
       a.starttime,
       a.suspended,
       b.text,
       b.sequence
FROM stv_inflight AS a, stl_querytext AS b
WHERE a.query = b.query

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