Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3list version 1.0.40182 / 2022-07-23

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