Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_local_s3_scan_file_stats	avg_row_group_size_bytes	int8
pg_catalog	stl_local_s3_scan_file_stats	file	char(512)
pg_catalog	stl_local_s3_scan_file_stats	file_size_bytes	int8
pg_catalog	stl_local_s3_scan_file_stats	file_type	int4
pg_catalog	stl_local_s3_scan_file_stats	footer_size_bytes	int8
pg_catalog	stl_local_s3_scan_file_stats	max_row_group_size_bytes	int8
pg_catalog	stl_local_s3_scan_file_stats	min_row_group_size_bytes	int8
pg_catalog	stl_local_s3_scan_file_stats	num_columns	int8
pg_catalog	stl_local_s3_scan_file_stats	num_row_groups	int8
pg_catalog	stl_local_s3_scan_file_stats	page_index_size_bytes	int8
pg_catalog	stl_local_s3_scan_file_stats	query	int4
pg_catalog	stl_local_s3_scan_file_stats	segment	int4
pg_catalog	stl_local_s3_scan_file_stats	slice	int4

View Text

SELECT stll_local_s3_scan_file_stats.query,
       stll_local_s3_scan_file_stats.segment,
       stll_local_s3_scan_file_stats.slice,
       stll_local_s3_scan_file_stats.file,
       stll_local_s3_scan_file_stats.file_type,
       stll_local_s3_scan_file_stats.file_size_bytes,
       stll_local_s3_scan_file_stats.num_columns,
       stll_local_s3_scan_file_stats.footer_size_bytes,
       stll_local_s3_scan_file_stats.page_index_size_bytes,
       stll_local_s3_scan_file_stats.num_row_groups,
       stll_local_s3_scan_file_stats.min_row_group_size_bytes,
       stll_local_s3_scan_file_stats.max_row_group_size_bytes,
       stll_local_s3_scan_file_stats.avg_row_group_size_bytes
FROM stll_local_s3_scan_file_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