schema | name | column | data type |
---|---|---|---|
pg_catalog | svcs_segment_ends_cleanly | dispatched | timestamp |
pg_catalog | svcs_segment_ends_cleanly | endtime | timestamp |
pg_catalog | svcs_segment_ends_cleanly | node | int4 |
pg_catalog | svcs_segment_ends_cleanly | pid | int4 |
pg_catalog | svcs_segment_ends_cleanly | query | int4 |
pg_catalog | svcs_segment_ends_cleanly | seg | int4 |
pg_catalog | svcs_segment_ends_cleanly | slice | int4 |
pg_catalog | svcs_segment_ends_cleanly | starttime | timestamp |
pg_catalog | svcs_segment_ends_cleanly | tasknum | int4 |
pg_catalog | svcs_segment_ends_cleanly | userid | int4 |
SELECT stcs.userid, stcs.node, stcs.tasknum, stcs.pid, CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs.dispatched AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS dispatched, CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs.starttime AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS starttime, CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs.endtime AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS endtime, map.primary_query AS query, stcs.slice, stcs.seg FROM stcs_segment_ends_cleanly AS stcs INNER JOIN stcs_concurrency_scaling_query_mapping AS map ON map.concurrency_scaling_query = stcs.query WHERE stcs.__cluster_type = CAST('cs' AS bpchar) AND to_date(CAST(stcs.__log_generated_date AS text), CAST('YYYYMMDD' AS text)) > (getdate() - CAST('7 days' AS interval)) AND to_date(CAST(map.__log_generated_date AS text), CAST('YYYYMMDD' AS text)) > (getdate() - CAST('7 days' AS interval)) AND CAST(map.concurrency_scaling_cluster AS text) = split_part(CAST(stcs.__path AS text), CAST('/' AS text), 10)
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