Redshift Observatory

System Table Tracker

System view pg_catalog.stl_local_s3_scan_read_requests version 1.0.105722 / 2025-01-19

schema	name	column	data type
pg_catalog	stl_local_s3_scan_read_requests	avg_request_size_bytes	int8
pg_catalog	stl_local_s3_scan_read_requests	column_id	int4
pg_catalog	stl_local_s3_scan_read_requests	file	char(512)
pg_catalog	stl_local_s3_scan_read_requests	max_request_size_bytes	int8
pg_catalog	stl_local_s3_scan_read_requests	min_request_size_bytes	int8
pg_catalog	stl_local_s3_scan_read_requests	num_cancelled_prefetch_calls	int8
pg_catalog	stl_local_s3_scan_read_requests	num_loading_prefetch_hits	int8
pg_catalog	stl_local_s3_scan_read_requests	num_prefetched_hits	int8
pg_catalog	stl_local_s3_scan_read_requests	num_prefetch_misses	int8
pg_catalog	stl_local_s3_scan_read_requests	num_requests	int8
pg_catalog	stl_local_s3_scan_read_requests	num_stitched_reads	int8
pg_catalog	stl_local_s3_scan_read_requests	on_demand_wait_time_ms	int8
pg_catalog	stl_local_s3_scan_read_requests	prefetch_wait_time_ms	int8
pg_catalog	stl_local_s3_scan_read_requests	query	int4
pg_catalog	stl_local_s3_scan_read_requests	request_category	int4
pg_catalog	stl_local_s3_scan_read_requests	segment	int4
pg_catalog	stl_local_s3_scan_read_requests	slice	int4

View Text

SELECT stll_local_s3_scan_read_requests.query,
       stll_local_s3_scan_read_requests.segment,
       stll_local_s3_scan_read_requests.slice,
       stll_local_s3_scan_read_requests.file,
       stll_local_s3_scan_read_requests.request_category,
       stll_local_s3_scan_read_requests.column_id,
       stll_local_s3_scan_read_requests.num_requests,
       stll_local_s3_scan_read_requests.min_request_size_bytes,
       stll_local_s3_scan_read_requests.max_request_size_bytes,
       stll_local_s3_scan_read_requests.avg_request_size_bytes,
       stll_local_s3_scan_read_requests.num_prefetched_hits,
       stll_local_s3_scan_read_requests.num_loading_prefetch_hits,
       stll_local_s3_scan_read_requests.num_prefetch_misses,
       stll_local_s3_scan_read_requests.num_cancelled_prefetch_calls,
       stll_local_s3_scan_read_requests.num_stitched_reads,
       stll_local_s3_scan_read_requests.on_demand_wait_time_ms,
       stll_local_s3_scan_read_requests.prefetch_wait_time_ms
FROM stll_local_s3_scan_read_requests

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 System Table Tracker The Known Universe White Papers