Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_local_s3_scan_fetches	avg_fetch_size_bytes	int8
pg_catalog	stl_local_s3_scan_fetches	avg_fetch_time_ms	int8
pg_catalog	stl_local_s3_scan_fetches	column_id	int4
pg_catalog	stl_local_s3_scan_fetches	file	char(512)
pg_catalog	stl_local_s3_scan_fetches	max_fetch_size_bytes	int8
pg_catalog	stl_local_s3_scan_fetches	max_fetch_time_ms	int8
pg_catalog	stl_local_s3_scan_fetches	min_fetch_size_bytes	int8
pg_catalog	stl_local_s3_scan_fetches	min_fetch_time_ms	int8
pg_catalog	stl_local_s3_scan_fetches	num_aborted_fetches	int8
pg_catalog	stl_local_s3_scan_fetches	num_fetch_errors	int8
pg_catalog	stl_local_s3_scan_fetches	num_fetches	int8
pg_catalog	stl_local_s3_scan_fetches	num_retried_fetches	int8
pg_catalog	stl_local_s3_scan_fetches	num_unused_fetches	int8
pg_catalog	stl_local_s3_scan_fetches	num_used_fetches	int8
pg_catalog	stl_local_s3_scan_fetches	query	int4
pg_catalog	stl_local_s3_scan_fetches	segment	int4
pg_catalog	stl_local_s3_scan_fetches	slice	int4

View Text

SELECT stll_local_s3_scan_fetches.query,
       stll_local_s3_scan_fetches.segment,
       stll_local_s3_scan_fetches.slice,
       stll_local_s3_scan_fetches.file,
       stll_local_s3_scan_fetches.column_id,
       stll_local_s3_scan_fetches.num_fetches,
       stll_local_s3_scan_fetches.min_fetch_size_bytes,
       stll_local_s3_scan_fetches.max_fetch_size_bytes,
       stll_local_s3_scan_fetches.avg_fetch_size_bytes,
       stll_local_s3_scan_fetches.min_fetch_time_ms,
       stll_local_s3_scan_fetches.max_fetch_time_ms,
       stll_local_s3_scan_fetches.avg_fetch_time_ms,
       stll_local_s3_scan_fetches.num_used_fetches,
       stll_local_s3_scan_fetches.num_unused_fetches,
       stll_local_s3_scan_fetches.num_aborted_fetches,
       stll_local_s3_scan_fetches.num_retried_fetches,
       stll_local_s3_scan_fetches.num_fetch_errors
FROM stll_local_s3_scan_fetches

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