Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_local_s3_scan_io_stats	avg_max_memory	int8
pg_catalog	stl_local_s3_scan_io_stats	avg_max_parallelism	int8
pg_catalog	stl_local_s3_scan_io_stats	avg_used_memory	int8
pg_catalog	stl_local_s3_scan_io_stats	avg_used_parallelism	int8
pg_catalog	stl_local_s3_scan_io_stats	max_max_memory	int8
pg_catalog	stl_local_s3_scan_io_stats	max_max_parallelism	int8
pg_catalog	stl_local_s3_scan_io_stats	max_used_memory	int8
pg_catalog	stl_local_s3_scan_io_stats	max_used_parallelism	int8
pg_catalog	stl_local_s3_scan_io_stats	min_max_memory	int8
pg_catalog	stl_local_s3_scan_io_stats	min_max_parallelism	int8
pg_catalog	stl_local_s3_scan_io_stats	min_used_memory	int8
pg_catalog	stl_local_s3_scan_io_stats	min_used_parallelism	int8
pg_catalog	stl_local_s3_scan_io_stats	query	int4
pg_catalog	stl_local_s3_scan_io_stats	segment	int4
pg_catalog	stl_local_s3_scan_io_stats	slice	int4

View Text

SELECT stll_local_s3_scan_io_stats.query,
       stll_local_s3_scan_io_stats.segment,
       stll_local_s3_scan_io_stats.slice,
       stll_local_s3_scan_io_stats.min_used_parallelism,
       stll_local_s3_scan_io_stats.max_used_parallelism,
       stll_local_s3_scan_io_stats.avg_used_parallelism,
       stll_local_s3_scan_io_stats.min_max_parallelism,
       stll_local_s3_scan_io_stats.max_max_parallelism,
       stll_local_s3_scan_io_stats.avg_max_parallelism,
       stll_local_s3_scan_io_stats.min_used_memory,
       stll_local_s3_scan_io_stats.max_used_memory,
       stll_local_s3_scan_io_stats.avg_used_memory,
       stll_local_s3_scan_io_stats.min_max_memory,
       stll_local_s3_scan_io_stats.max_max_memory,
       stll_local_s3_scan_io_stats.avg_max_memory
FROM stll_local_s3_scan_io_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 System Table Tracker The Known Universe White Papers