Redshift Observatory

System Table Tracker

System view pg_catalog.stl_super_query version 1.0.46806 / 2023-02-21

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