Redshift Observatory

System Table Tracker

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

View Text

SELECT e.userid,
       e.query,
       q.xid,
       q.pid,
       e.segment,
       e.step,
       min(e.starttime) AS starttime,
       max(e.endtime) AS endtime,
       date_diff(CAST('us' AS text),
                 min(e.starttime),
                 max(e.endtime)) AS elapsed,
       q.aborted,
       e.external_table_name,
       e.file_format,
       max(CAST(e.is_partitioned AS text)) AS is_partitioned,
       max(CAST(e.is_rrscan AS text)) AS is_rrscan,
       max(CAST(e.is_nested AS text)) AS is_nested,
       sum(e.s3_scanned_rows) AS s3_scanned_rows,
       sum(e.s3_scanned_bytes) AS s3_scanned_bytes,
       sum(e.s3query_returned_rows) AS s3query_returned_rows,
       sum(e.s3query_returned_bytes) AS s3query_returned_bytes,
       sum(e.files) AS files,
       max(e.files) AS files_max,
       avg(e.files) AS files_avg,
       sum(e.splits) AS splits,
       max(e.splits) AS splits_max,
       avg(e.splits) AS splits_avg,
       sum(e.total_split_size) AS total_split_size,
       max(e.max_split_size) AS max_split_size,
       CASE
         WHEN sum(e.splits) > 0
           THEN sum(e.total_split_size) / sum(e.splits)
         ELSE CAST(NULL AS bigint)
       END AS avg_split_size,
       sum(e.total_retries) AS total_retries,
       max(e.max_retries) AS max_retries,
       max(e.max_request_duration) AS max_request_duration,
       avg(e.avg_request_duration) AS avg_request_duration,
       max(e.max_request_parallelism) AS max_request_parallelism,
       round(avg(e.avg_request_parallelism),
             CAST(1 AS numeric)) AS avg_request_parallelism,
       sum(e.slowdown_count) AS total_slowdown_count,
       max(e.slowdown_count) AS max_slowdown_count
FROM svl_s3query AS e, stl_query AS q
WHERE e.query = q.query
GROUP BY e.userid, e.query, q.xid, q.pid, e.segment, e.step, q.aborted, e.external_table_name, e.file_format

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