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 |
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