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