Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_step_times version 1.0.41533 / 2022-09-18

schema name column data type
pg_catalog stl_query_step_times duration int8
pg_catalog stl_query_step_times off_cpu int8
pg_catalog stl_query_step_times on_cpu int8
pg_catalog stl_query_step_times query int4
pg_catalog stl_query_step_times segment int4
pg_catalog stl_query_step_times slice int4
pg_catalog stl_query_step_times step int4
pg_catalog stl_query_step_times step_common char(32)
pg_catalog stl_query_step_times step_name char(32)
pg_catalog stl_query_step_times step_shared char(32)
pg_catalog stl_query_step_times step_specific char(32)
pg_catalog stl_query_step_times step_type char(32)
pg_catalog stl_query_step_times xid int8

View Text

SELECT stll_query_step_times.xid,
       stll_query_step_times.query,
       stll_query_step_times.segment,
       stll_query_step_times.step,
       stll_query_step_times.slice,
       stll_query_step_times.step_name,
       stll_query_step_times.step_type,
       stll_query_step_times.step_specific,
       stll_query_step_times.step_shared,
       stll_query_step_times.step_common,
       stll_query_step_times.duration,
       stll_query_step_times.on_cpu,
       stll_query_step_times.off_cpu
FROM stll_query_step_times


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