Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3list version 1.0.41465 / 2022-09-10

schema	name	column	data type
pg_catalog	svl_s3list	avg_file_size	float8
pg_catalog	svl_s3list	avg_split_length	float8
pg_catalog	svl_s3list	bucket	text
pg_catalog	svl_s3list	duration	int8
pg_catalog	svl_s3list	eventtime	timestamp
pg_catalog	svl_s3list	generated_splits	int4
pg_catalog	svl_s3list	max_file_size	int8
pg_catalog	svl_s3list	node	int4
pg_catalog	svl_s3list	prefix	text
pg_catalog	svl_s3list	query	int4
pg_catalog	svl_s3list	recursive	char(1)
pg_catalog	svl_s3list	retrieved_files	int4
pg_catalog	svl_s3list	segment	int4
pg_catalog	svl_s3list	slice	int4

View Text

SELECT stl_s3list.query,
       stl_s3list.segment,
       stl_s3list.node,
       stl_s3list.slice,
       stl_s3list.eventtime,
       btrim(CAST(stl_s3list.bucket AS text)) AS bucket,
       btrim(CAST(stl_s3list.prefix AS text)) AS prefix,
       stl_s3list.recursive,
       stl_s3list.retrieved_files,
       stl_s3list.max_file_size,
       stl_s3list.avg_file_size,
       stl_s3list.generated_splits,
       stl_s3list.avg_split_length,
       stl_s3list.duration
FROM stl_s3list

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers