Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3list version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	stl_s3list	avg_file_size	float8
pg_catalog	stl_s3list	avg_split_length	float8
pg_catalog	stl_s3list	bucket	char(256)
pg_catalog	stl_s3list	duration	int8
pg_catalog	stl_s3list	eventtime	timestamp
pg_catalog	stl_s3list	generated_splits	int4
pg_catalog	stl_s3list	list_type	int4
pg_catalog	stl_s3list	max_file_size	int8
pg_catalog	stl_s3list	node	int4
pg_catalog	stl_s3list	prefix	char(256)
pg_catalog	stl_s3list	query	int4
pg_catalog	stl_s3list	recursive	char(1)
pg_catalog	stl_s3list	retrieved_files	int4
pg_catalog	stl_s3list	scan_type	int4
pg_catalog	stl_s3list	segment	int4
pg_catalog	stl_s3list	slice	int4
pg_catalog	stl_s3list	userid	int4
pg_catalog	stl_s3list	uuid	char(36)

View Text

SELECT stll_s3list.userid,
       stll_s3list.query,
       stll_s3list.uuid,
       stll_s3list.segment,
       stll_s3list.node,
       stll_s3list.slice,
       stll_s3list.eventtime,
       stll_s3list.bucket,
       stll_s3list.prefix,
       stll_s3list.recursive,
       stll_s3list.retrieved_files,
       stll_s3list.max_file_size,
       stll_s3list.avg_file_size,
       stll_s3list.duration,
       stll_s3list.generated_splits,
       stll_s3list.avg_split_length,
       stll_s3list.scan_type,
       stll_s3list.list_type
FROM stll_s3list
WHERE stll_s3list.access_control = 0
   OR stll_s3list.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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