Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_super_query	aborted	int4
pg_catalog	stl_super_query	endtime	timestamp
pg_catalog	stl_super_query	has_unnest_subquery	int4
pg_catalog	stl_super_query	num_of_array_nav	int4
pg_catalog	stl_super_query	num_of_object_nav	int4
pg_catalog	stl_super_query	query	int8
pg_catalog	stl_super_query	query_cmd_type	int4
pg_catalog	stl_super_query	starttime	timestamp
pg_catalog	stl_super_query	userid	int4

View Text

SELECT stll_super_query.userid,
       stll_super_query.query,
       stll_super_query.starttime,
       stll_super_query.endtime,
       stll_super_query.query_cmd_type,
       stll_super_query.num_of_array_nav,
       stll_super_query.num_of_object_nav,
       stll_super_query.has_unnest_subquery,
       stll_super_query.aborted
FROM stll_super_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