Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_detail version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_query_detail alert char(1024)
pg_catalog stl_query_detail blocks_read int8
pg_catalog stl_query_detail blocks_write int8
pg_catalog stl_query_detail child_query_id int4
pg_catalog stl_query_detail child_query_sequence int4
pg_catalog stl_query_detail endtime timestamp
pg_catalog stl_query_detail input_bytes int8
pg_catalog stl_query_detail input_rows int8
pg_catalog stl_query_detail internal_query char(1)
pg_catalog stl_query_detail is_rrscan char(1)
pg_catalog stl_query_detail local_read_io int8
pg_catalog stl_query_detail output_bytes int8
pg_catalog stl_query_detail output_rows int8
pg_catalog stl_query_detail query_id int8
pg_catalog stl_query_detail remote_read_io int8
pg_catalog stl_query_detail segment_id int4
pg_catalog stl_query_detail slice int4
pg_catalog stl_query_detail starttime timestamp
pg_catalog stl_query_detail step_id int4
pg_catalog stl_query_detail step_name int4
pg_catalog stl_query_detail stream_id int4
pg_catalog stl_query_detail table_id int4
pg_catalog stl_query_detail table_name char(136)
pg_catalog stl_query_detail user_id int4

View Text

SELECT stll_query_detail.user_id,
       stll_query_detail.query_id,
       stll_query_detail.child_query_id,
       stll_query_detail.child_query_sequence,
       stll_query_detail.stream_id,
       stll_query_detail.segment_id,
       stll_query_detail.step_id,
       stll_query_detail.slice,
       stll_query_detail.starttime,
       stll_query_detail.endtime,
       stll_query_detail.step_name,
       stll_query_detail.table_id,
       stll_query_detail.table_name,
       stll_query_detail.input_rows,
       stll_query_detail.input_bytes,
       stll_query_detail.output_rows,
       stll_query_detail.output_bytes,
       stll_query_detail.is_rrscan,
       stll_query_detail.blocks_read,
       stll_query_detail.blocks_write,
       stll_query_detail.local_read_io,
       stll_query_detail.remote_read_io,
       stll_query_detail.alert,
       stll_query_detail.internal_query
FROM stll_query_detail


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