Redshift Observatory

System Table Tracker

System view pg_catalog.stl_external_query_detail_base_redacted version 1.0.76913 / 2024-10-24

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

View Text

SELECT stll_external_query_detail_base_redacted.user_id,
       stll_external_query_detail_base_redacted.query_id,
       stll_external_query_detail_base_redacted.child_query_sequence,
       stll_external_query_detail_base_redacted.child_query_id,
       stll_external_query_detail_base_redacted.pid,
       stll_external_query_detail_base_redacted.xid,
       stll_external_query_detail_base_redacted.segment_id,
       stll_external_query_detail_base_redacted.node,
       stll_external_query_detail_base_redacted.slice,
       stll_external_query_detail_base_redacted.table_name,
       stll_external_query_detail_base_redacted.sourcetype,
       stll_external_query_detail_base_redacted.eventtime,
       stll_external_query_detail_base_redacted.starttime,
       stll_external_query_detail_base_redacted.endtime,
       stll_external_query_detail_base_redacted.duration,
       stll_external_query_detail_base_redacted.total_partitions,
       stll_external_query_detail_base_redacted.qualified_partitions,
       stll_external_query_detail_base_redacted.total_files,
       stll_external_query_detail_base_redacted.files_scanned,
       stll_external_query_detail_base_redacted.num_rows,
       stll_external_query_detail_base_redacted.num_bytes,
       stll_external_query_detail_base_redacted.file_format,
       stll_external_query_detail_base_redacted.location,
       stll_external_query_detail_base_redacted.pg_query_text_redacted,
       stll_external_query_detail_base_redacted.logging_tag,
       stll_external_query_detail_base_redacted.warning_message,
       stll_external_query_detail_base_redacted.is_recursive,
       stll_external_query_detail_base_redacted.is_nested,
       stll_external_query_detail_base_redacted.s3list_time,
       stll_external_query_detail_base_redacted.get_partition_time
FROM stll_external_query_detail_base_redacted
WHERE stll_external_query_detail_base_redacted.access_control = 0
   OR stll_external_query_detail_base_redacted.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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