Redshift Observatory

System Table Tracker

System view pg_catalog.svv_query_inflight version 1.0.56952 / 2023-09-29

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers