Redshift Observatory

System Table Tracker

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

View Text

SELECT svcs_s3partition_elimination.query,
       svcs_s3partition_elimination.segment,
       svcs_s3partition_elimination.assignment,
       min(svcs_s3partition_elimination.starttime) AS min_starttime,
       max(svcs_s3partition_elimination.endtime) AS max_endtime,
       min(date_diff(CAST('us' AS text),
                     svcs_s3partition_elimination.starttime,
                     svcs_s3partition_elimination.endtime)) AS min_duration,
       max(date_diff(CAST('us' AS text),
                     svcs_s3partition_elimination.starttime,
                     svcs_s3partition_elimination.endtime)) AS max_duration,
       avg(date_diff(CAST('us' AS text),
                     svcs_s3partition_elimination.starttime,
                     svcs_s3partition_elimination.endtime)) AS avg_duration,
       max(svcs_s3partition_elimination.total_partitions) AS total_partitions,
       max(svcs_s3partition_elimination.qualified_partitions) AS qualified_partitions,
       min(svcs_s3partition_elimination.assigned_partitions) AS min_assigned_partitions,
       max(svcs_s3partition_elimination.assigned_partitions) AS max_assigned_partitions,
       avg(svcs_s3partition_elimination.assigned_partitions) AS avg_assigned_partitions
FROM svcs_s3partition_elimination
WHERE svcs_s3partition_elimination.scan_type = 2
  AND (EXISTS (SELECT 1
               FROM pg_user
               WHERE pg_user.usename = CAST("current_user"() AS name)
                 AND pg_user.usesuper = TRUE)
    OR EXISTS (SELECT 1
               FROM pg_shadow_extended
               WHERE pg_shadow_extended.sysid = current_user_id()
                 AND pg_shadow_extended.colnum = 2
                 AND pg_shadow_extended.value = CAST(-1 AS text))
    OR svcs_s3partition_elimination.userid = current_user_id())
GROUP BY svcs_s3partition_elimination.query, svcs_s3partition_elimination.segment, svcs_s3partition_elimination.assignment

UNION ALL

SELECT svl_s3partition_summary.query,
       svl_s3partition_summary.segment,
       svl_s3partition_summary.assignment,
       svl_s3partition_summary.min_starttime,
       svl_s3partition_summary.max_endtime,
       svl_s3partition_summary.min_duration,
       svl_s3partition_summary.max_duration,
       svl_s3partition_summary.avg_duration,
       svl_s3partition_summary.total_partitions,
       svl_s3partition_summary.qualified_partitions,
       svl_s3partition_summary.min_assigned_partitions,
       svl_s3partition_summary.max_assigned_partitions,
       svl_s3partition_summary.avg_assigned_partitions
FROM svl_s3partition_summary

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