Redshift Observatory

System Table Tracker

System view pg_catalog.stl_local_s3_scan_sr_processing_stats version 1.0.109768 / 2025-03-30

schema	name	column	data type
pg_catalog	stl_local_s3_scan_sr_processing_stats	assigned_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	blf_endtime	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	blf_starttime	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	deserialize_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	execution_endtime	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	execution_starttime	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	file	char(512)
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_first_fetch_ready_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_first_fetch_sent_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_first_prefetch_trigger_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_parse_endtime	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_parse_starttime	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_second_fetch_ready_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_second_fetch_sent_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	footer_second_prefetch_trigger_time	timestamp
pg_catalog	stl_local_s3_scan_sr_processing_stats	length_bytes	int8
pg_catalog	stl_local_s3_scan_sr_processing_stats	node	int4
pg_catalog	stl_local_s3_scan_sr_processing_stats	offset_bytes	int8
pg_catalog	stl_local_s3_scan_sr_processing_stats	query	int4
pg_catalog	stl_local_s3_scan_sr_processing_stats	segment	int4
pg_catalog	stl_local_s3_scan_sr_processing_stats	slice	int4
pg_catalog	stl_local_s3_scan_sr_processing_stats	step	int4
pg_catalog	stl_local_s3_scan_sr_processing_stats	triggered_second_footer_prefetch	char(1)

View Text

SELECT stll_local_s3_scan_sr_processing_stats.query,
       stll_local_s3_scan_sr_processing_stats.segment,
       stll_local_s3_scan_sr_processing_stats.step,
       stll_local_s3_scan_sr_processing_stats.node,
       stll_local_s3_scan_sr_processing_stats.slice,
       stll_local_s3_scan_sr_processing_stats.file,
       stll_local_s3_scan_sr_processing_stats.offset_bytes,
       stll_local_s3_scan_sr_processing_stats.length_bytes,
       stll_local_s3_scan_sr_processing_stats.deserialize_time,
       stll_local_s3_scan_sr_processing_stats.footer_first_prefetch_trigger_time,
       stll_local_s3_scan_sr_processing_stats.footer_first_fetch_sent_time,
       stll_local_s3_scan_sr_processing_stats.footer_first_fetch_ready_time,
       stll_local_s3_scan_sr_processing_stats.triggered_second_footer_prefetch,
       stll_local_s3_scan_sr_processing_stats.footer_second_prefetch_trigger_time,
       stll_local_s3_scan_sr_processing_stats.footer_second_fetch_sent_time,
       stll_local_s3_scan_sr_processing_stats.footer_second_fetch_ready_time,
       stll_local_s3_scan_sr_processing_stats.footer_parse_starttime,
       stll_local_s3_scan_sr_processing_stats.footer_parse_endtime,
       stll_local_s3_scan_sr_processing_stats.blf_starttime,
       stll_local_s3_scan_sr_processing_stats.blf_endtime,
       stll_local_s3_scan_sr_processing_stats.assigned_time,
       stll_local_s3_scan_sr_processing_stats.execution_starttime,
       stll_local_s3_scan_sr_processing_stats.execution_endtime
FROM stll_local_s3_scan_sr_processing_stats

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