Redshift Observatory

System Table Tracker

System view pg_catalog.svv_query_inflight version 1.0.52931 / 2023-07-07

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