Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svcs_s3partition_summary assignment char(1)
pg_catalog svcs_s3partition_summary avg_assigned_partitions int8
pg_catalog svcs_s3partition_summary avg_duration int8
pg_catalog svcs_s3partition_summary max_assigned_partitions int4
pg_catalog svcs_s3partition_summary max_duration int8
pg_catalog svcs_s3partition_summary max_endtime timestamp
pg_catalog svcs_s3partition_summary min_assigned_partitions int4
pg_catalog svcs_s3partition_summary min_duration int8
pg_catalog svcs_s3partition_summary min_starttime timestamp
pg_catalog svcs_s3partition_summary qualified_partitions int4
pg_catalog svcs_s3partition_summary query int4
pg_catalog svcs_s3partition_summary segment int4
pg_catalog svcs_s3partition_summary total_partitions int4

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