Redshift Observatory

System Table Tracker

System view pg_catalog.stl_iceberg_query_detail version 1.0.118447 / 2025-08-02

schema	name	column	data type
pg_catalog	stl_iceberg_query_detail	compression_type	char(64)
pg_catalog	stl_iceberg_query_detail	elapsed_write_time_us	int8
pg_catalog	stl_iceberg_query_detail	endtime	timestamp
pg_catalog	stl_iceberg_query_detail	file_format	char(64)
pg_catalog	stl_iceberg_query_detail	iceberg_files_count	int8
pg_catalog	stl_iceberg_query_detail	iceberg_files_total_bytes	int8
pg_catalog	stl_iceberg_query_detail	iceberg_snapshot_id	int8
pg_catalog	stl_iceberg_query_detail	partitions_accessed	int8
pg_catalog	stl_iceberg_query_detail	query	int4
pg_catalog	stl_iceberg_query_detail	rows	int8
pg_catalog	stl_iceberg_query_detail	segment	int4
pg_catalog	stl_iceberg_query_detail	slice	int4
pg_catalog	stl_iceberg_query_detail	starttime	timestamp
pg_catalog	stl_iceberg_query_detail	step	int4
pg_catalog	stl_iceberg_query_detail	table_name	char(128)
pg_catalog	stl_iceberg_query_detail	tasknum	int4
pg_catalog	stl_iceberg_query_detail	tbl	int4
pg_catalog	stl_iceberg_query_detail	user_id	int4
pg_catalog	stl_iceberg_query_detail	xid	int8

View Text

SELECT stll_iceberg_query_detail.user_id,
       stll_iceberg_query_detail.query,
       stll_iceberg_query_detail.xid,
       stll_iceberg_query_detail.segment,
       stll_iceberg_query_detail.step,
       stll_iceberg_query_detail.slice,
       stll_iceberg_query_detail.starttime,
       stll_iceberg_query_detail.endtime,
       stll_iceberg_query_detail.tasknum,
       stll_iceberg_query_detail.rows,
       stll_iceberg_query_detail.tbl,
       stll_iceberg_query_detail.file_format,
       stll_iceberg_query_detail.compression_type,
       stll_iceberg_query_detail.iceberg_files_count,
       stll_iceberg_query_detail.iceberg_files_total_bytes,
       stll_iceberg_query_detail.elapsed_write_time_us,
       stll_iceberg_query_detail.partitions_accessed,
       stll_iceberg_query_detail.table_name,
       stll_iceberg_query_detail.iceberg_snapshot_id
FROM stll_iceberg_query_detail
WHERE stll_iceberg_query_detail.access_control = 0
   OR stll_iceberg_query_detail.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers