Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3requests version 1.0.52931 / 2023-07-07

View Text

SELECT r.query,
       r.uuid,
       r.pid,
       r.segment,
       r.node,
       r.slice,
       r.eventtime,
       round(CAST(r.duration AS double precision) / CAST(1000 AS double precision),
             CAST(1 AS numeric)) AS duration_msec,
       r.retry_count,
       r.returned_rows,
       r.returned_bytes,
       r.s3_scanned_rows,
       r.s3_scanned_bytes,
       r.row_groups,
       r.skipped_row_groups,
       r.skipped_rows,
       r.fetched,
       r.file_size,
       r.start_offset,
       r.length,
       btrim(CAST(r.location AS text)) AS location,
       btrim(CAST(r.file_name AS text)) AS file,
       r.num_splits,
       round(CAST(r.last_timeout AS double precision) / CAST(1000 AS double precision),
             CAST(1 AS numeric)) AS last_timeout_msec,
       r.failed,
       btrim(CAST(r.etag AS text)) AS etag,
       q.request_fingerprint AS fingerprint,
       CASE
         WHEN r.cache_status > 1
           THEN -1
         ELSE r.cache_status
       END AS cache_status,
       r.s3_physical_scanned_bytes,
       r.starttime,
       r.client_fetch_wait_time,
       CASE
         WHEN r.cache_compressed_size > 1
           THEN round(CAST(r.cache_uncompressed_size AS double precision) / CAST(r.cache_compressed_size AS double precision),
                      CAST(1 AS numeric))
         ELSE CAST(0 AS double precision)
       END AS cache_compression_ratio,
       r.cache_compression_latency,
       r.serialize_time
FROM stl_s3requests AS r
     LEFT JOIN stl_s3query AS q ON r.query = q.query
                               AND r.segment = q.segment
                               AND r.node = q.node
                               AND r.slice = q.slice

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