Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3query version 1.0.47470 / 2023-03-11

schema name column data type
pg_catalog stl_s3query avg_request_duration int8
pg_catalog stl_s3query avg_request_parallelism float8
pg_catalog stl_s3query cache_hits int4
pg_catalog stl_s3query endtime timestamp
pg_catalog stl_s3query external_table_name char(136)
pg_catalog stl_s3query file_format char(16)
pg_catalog stl_s3query files int4
pg_catalog stl_s3query has_cell_level_security int4
pg_catalog stl_s3query is_copy int4
pg_catalog stl_s3query is_evr int4
pg_catalog stl_s3query is_governed int4
pg_catalog stl_s3query is_lakeformation int4
pg_catalog stl_s3query is_local int4
pg_catalog stl_s3query is_nested char(1)
pg_catalog stl_s3query is_partitioned char(1)
pg_catalog stl_s3query is_rrscan char(1)
pg_catalog stl_s3query max_allowed_parallelism int4
pg_catalog stl_s3query max_concurrent_slowdown_count int4
pg_catalog stl_s3query max_request_duration int8
pg_catalog stl_s3query max_request_parallelism int4
pg_catalog stl_s3query max_retries int4
pg_catalog stl_s3query max_split_size int8
pg_catalog stl_s3query node int4
pg_catalog stl_s3query peakmem int8
pg_catalog stl_s3query query int4
pg_catalog stl_s3query query_as_of_time timestamp
pg_catalog stl_s3query request_fingerprint int8
pg_catalog stl_s3query s3_billable_scanned_bytes int8
pg_catalog stl_s3query s3query_returned_bytes int8
pg_catalog stl_s3query s3query_returned_rows int8
pg_catalog stl_s3query s3query_returned_uncompressed_bytes int8
pg_catalog stl_s3query s3_scanned_bytes int8
pg_catalog stl_s3query s3_scanned_rows int8
pg_catalog stl_s3query scan_type int4
pg_catalog stl_s3query segment int4
pg_catalog stl_s3query slice int4
pg_catalog stl_s3query slowdown_count int4
pg_catalog stl_s3query splits int4
pg_catalog stl_s3query starttime timestamp
pg_catalog stl_s3query step int4
pg_catalog stl_s3query throttled_requests int4
pg_catalog stl_s3query total_retries int4
pg_catalog stl_s3query total_split_size int8
pg_catalog stl_s3query transaction_id char(32)
pg_catalog stl_s3query userid int4
pg_catalog stl_s3query uuid char(36)

View Text

SELECT stll_s3query.userid,
       stll_s3query.query,
       stll_s3query.uuid,
       stll_s3query.segment,
       stll_s3query.step,
       stll_s3query.node,
       stll_s3query.slice,
       stll_s3query.starttime,
       stll_s3query.endtime,
       stll_s3query.external_table_name,
       stll_s3query.is_partitioned,
       stll_s3query.is_rrscan,
       stll_s3query.s3_scanned_rows,
       stll_s3query.s3_scanned_bytes,
       stll_s3query.s3query_returned_rows,
       stll_s3query.s3query_returned_bytes,
       stll_s3query.files,
       stll_s3query.total_retries,
       stll_s3query.max_retries,
       stll_s3query.max_request_duration,
       stll_s3query.avg_request_duration,
       stll_s3query.max_request_parallelism,
       stll_s3query.max_allowed_parallelism,
       stll_s3query.avg_request_parallelism,
       stll_s3query.splits,
       stll_s3query.total_split_size,
       stll_s3query.max_split_size,
       stll_s3query.request_fingerprint,
       stll_s3query.file_format,
       stll_s3query.cache_hits,
       stll_s3query.is_copy,
       stll_s3query.is_nested,
       stll_s3query.slowdown_count,
       stll_s3query.max_concurrent_slowdown_count,
       stll_s3query.s3_billable_scanned_bytes,
       stll_s3query.scan_type,
       stll_s3query.s3query_returned_uncompressed_bytes,
       stll_s3query.is_lakeformation,
       stll_s3query.is_governed,
       stll_s3query.transaction_id,
       stll_s3query.query_as_of_time,
       stll_s3query.throttled_requests,
       stll_s3query.peakmem,
       stll_s3query.is_local,
       stll_s3query.is_evr,
       stll_s3query.has_cell_level_security
FROM stll_s3query


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