Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svl_s3requests cache_compression_latency int8
pg_catalog svl_s3requests cache_compression_ratio float8
pg_catalog svl_s3requests cache_status int4
pg_catalog svl_s3requests client_fetch_wait_time int8
pg_catalog svl_s3requests duration_msec float8
pg_catalog svl_s3requests etag text
pg_catalog svl_s3requests eventtime timestamp
pg_catalog svl_s3requests failed int4
pg_catalog svl_s3requests fetched int4
pg_catalog svl_s3requests file text
pg_catalog svl_s3requests file_size int8
pg_catalog svl_s3requests fingerprint int8
pg_catalog svl_s3requests last_timeout_msec float8
pg_catalog svl_s3requests length int8
pg_catalog svl_s3requests location text
pg_catalog svl_s3requests node int4
pg_catalog svl_s3requests num_splits int4
pg_catalog svl_s3requests pid int4
pg_catalog svl_s3requests query int4
pg_catalog svl_s3requests retry_count int4
pg_catalog svl_s3requests returned_bytes int8
pg_catalog svl_s3requests returned_rows int8
pg_catalog svl_s3requests row_groups int8
pg_catalog svl_s3requests s3_physical_scanned_bytes int8
pg_catalog svl_s3requests s3_scanned_bytes int8
pg_catalog svl_s3requests s3_scanned_rows int8
pg_catalog svl_s3requests segment int4
pg_catalog svl_s3requests serialize_time int8
pg_catalog svl_s3requests skipped_row_groups int8
pg_catalog svl_s3requests skipped_rows int8
pg_catalog svl_s3requests slice int4
pg_catalog svl_s3requests start_offset int8
pg_catalog svl_s3requests starttime timestamp
pg_catalog svl_s3requests uuid char(36)

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