Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3query version 1.0.51594 / 2023-06-10

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