Redshift Observatory

System Table Tracker

System view pg_catalog.stl_external_query_detail_base version 1.0.62312 / 2024-01-27

schema name column data type
pg_catalog stl_external_query_detail_base child_query_id int4
pg_catalog stl_external_query_detail_base child_query_sequence int4
pg_catalog stl_external_query_detail_base duration int8
pg_catalog stl_external_query_detail_base endtime timestamp
pg_catalog stl_external_query_detail_base eventtime timestamp
pg_catalog stl_external_query_detail_base file_format char(16)
pg_catalog stl_external_query_detail_base files_scanned int4
pg_catalog stl_external_query_detail_base get_partition_time int8
pg_catalog stl_external_query_detail_base is_nested char(1)
pg_catalog stl_external_query_detail_base is_recursive char(1)
pg_catalog stl_external_query_detail_base location char(256)
pg_catalog stl_external_query_detail_base logging_tag char(32)
pg_catalog stl_external_query_detail_base node int4
pg_catalog stl_external_query_detail_base num_bytes int8
pg_catalog stl_external_query_detail_base num_rows int8
pg_catalog stl_external_query_detail_base pg_query_text char(4000)
pg_catalog stl_external_query_detail_base pid int4
pg_catalog stl_external_query_detail_base qualified_partitions int4
pg_catalog stl_external_query_detail_base query_id int8
pg_catalog stl_external_query_detail_base s3list_time int8
pg_catalog stl_external_query_detail_base segment_id int4
pg_catalog stl_external_query_detail_base slice int4
pg_catalog stl_external_query_detail_base sourcetype char(32)
pg_catalog stl_external_query_detail_base starttime timestamp
pg_catalog stl_external_query_detail_base table_name char(256)
pg_catalog stl_external_query_detail_base total_files int4
pg_catalog stl_external_query_detail_base total_partitions int4
pg_catalog stl_external_query_detail_base user_id int4
pg_catalog stl_external_query_detail_base warning_message char(4000)
pg_catalog stl_external_query_detail_base xid int8

View Text

SELECT stll_external_query_detail_base.user_id,
       stll_external_query_detail_base.query_id,
       stll_external_query_detail_base.child_query_sequence,
       stll_external_query_detail_base.child_query_id,
       stll_external_query_detail_base.pid,
       stll_external_query_detail_base.xid,
       stll_external_query_detail_base.segment_id,
       stll_external_query_detail_base.node,
       stll_external_query_detail_base.slice,
       stll_external_query_detail_base.table_name,
       stll_external_query_detail_base.sourcetype,
       stll_external_query_detail_base.eventtime,
       stll_external_query_detail_base.starttime,
       stll_external_query_detail_base.endtime,
       stll_external_query_detail_base.duration,
       stll_external_query_detail_base.total_partitions,
       stll_external_query_detail_base.qualified_partitions,
       stll_external_query_detail_base.total_files,
       stll_external_query_detail_base.files_scanned,
       stll_external_query_detail_base.num_rows,
       stll_external_query_detail_base.num_bytes,
       stll_external_query_detail_base.file_format,
       stll_external_query_detail_base.location,
       stll_external_query_detail_base.pg_query_text,
       stll_external_query_detail_base.logging_tag,
       stll_external_query_detail_base.warning_message,
       stll_external_query_detail_base.is_recursive,
       stll_external_query_detail_base.is_nested,
       stll_external_query_detail_base.s3list_time,
       stll_external_query_detail_base.get_partition_time
FROM stll_external_query_detail_base


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