| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | svl_query_concurrency_scaling_status | concurrency_scaling_status | int4 |
| pg_catalog | svl_query_concurrency_scaling_status | concurrency_scaling_status_txt | text |
| pg_catalog | svl_query_concurrency_scaling_status | endtime | timestamp |
| pg_catalog | svl_query_concurrency_scaling_status | pid | int4 |
| pg_catalog | svl_query_concurrency_scaling_status | query | int4 |
| pg_catalog | svl_query_concurrency_scaling_status | source_query | int4 |
| pg_catalog | svl_query_concurrency_scaling_status | starttime | timestamp |
| pg_catalog | svl_query_concurrency_scaling_status | userid | int4 |
| pg_catalog | svl_query_concurrency_scaling_status | xid | int8 |
SELECT sq.userid,
sq.query,
sq.xid,
sq.pid,
sr.source_query,
sq.concurrency_scaling_status,
CASE
WHEN sq.userid = 1
THEN CAST('Concurrency Scaling ineligible query - Bootstrap user query' AS text)
WHEN sq.concurrency_scaling_status = 1
THEN CAST('Ran on a Concurrency Scaling cluster' AS text)
WHEN sq.concurrency_scaling_status = 0
AND sr.source_query IS NOT NULL
THEN CAST('Ran on the main cluster - Cache hit' AS text)
WHEN sq.concurrency_scaling_status = 0
AND sw.service_class = 14
THEN CAST('Ran on the main cluster - SQA' AS text)
WHEN sq.concurrency_scaling_status = 32
AND sw.service_class = 14
THEN CAST('Ran on the main cluster - Concurrency scaling is not enabled in SQA' AS text)
WHEN sq.concurrency_scaling_status = 0
AND sq.query IN (SELECT stl_burst_prepare.query
FROM stl_burst_prepare)
AND NOT sq.query IN (SELECT stl_burst_prepare.query
FROM stl_burst_prepare
WHERE stl_burst_prepare.code = 0)
THEN CAST('Concurrency Scaling elegible query - Failed to prepare cluster ' AS text)
WHEN sq.concurrency_scaling_status = 0
AND sq.query IN (SELECT stl_burst_async_mark.query
FROM stl_burst_async_mark
WHERE stl_burst_async_mark.event ~~ CAST('%Mark%' AS text))
AND sq.query IN (SELECT stl_burst_async_mark.query
FROM stl_burst_async_mark
WHERE stl_burst_async_mark.event ~~ CAST('%Unmark%' AS text))
THEN CAST('Concurrency Scaling elegible query - Cluster was not prepared in time ' AS text)
WHEN sq.concurrency_scaling_status = 0
THEN CAST('Ran on the main cluster' AS text)
WHEN sq.concurrency_scaling_status = 2
THEN CAST('Concurrency Scaling not enabled' AS text)
WHEN sq.concurrency_scaling_status = 4
THEN CAST('Concurrency Scaling ineligible query - System temporary table accessed' AS text)
WHEN sq.concurrency_scaling_status = 5
THEN CAST('Concurrency Scaling ineligible query - User temporary table accessed' AS text)
WHEN sq.concurrency_scaling_status = 6
THEN CAST('Concurrency Scaling ineligible query - System table accessed' AS text)
WHEN sq.concurrency_scaling_status = 3
THEN CAST('Concurrency Scaling ineligible query - Query is an Unsupported DML' AS text)
WHEN sq.concurrency_scaling_status = 7
THEN CAST('Concurrency Scaling ineligible query - No backup table accessed' AS text)
WHEN sq.concurrency_scaling_status = 8
THEN CAST('Concurrency Scaling ineligible query - Zindex table accessed' AS text)
WHEN sq.concurrency_scaling_status = 9
THEN CAST('Concurrency Scaling ineligible query - Query uses UDF' AS text)
WHEN sq.concurrency_scaling_status = 10
THEN CAST('Concurrency Scaling ineligible query - Catalog tables accessed' AS text)
WHEN sq.concurrency_scaling_status = 11
THEN CAST('Concurrency Scaling ineligible query - Dirty table accessed' AS text)
WHEN sq.concurrency_scaling_status = 12
THEN CAST('Concurrency Scaling ineligible query - Direct dispatched query' AS text)
WHEN sq.concurrency_scaling_status = 16
THEN CAST('Concurrency Scaling ineligible query - No tables accessed' AS text)
WHEN sq.concurrency_scaling_status = 17
THEN CAST('Concurrency Scaling ineligible query - Spectrum queries are disabled' AS text)
WHEN sq.concurrency_scaling_status = 18
THEN CAST('Concurrency Scaling ineligible query - Function not supported ' AS text)
WHEN sq.concurrency_scaling_status = 19
THEN CAST('Concurrency Scaling ineligible query - Instance type not supported ' AS text)
WHEN sq.concurrency_scaling_status = 20
THEN CAST('Concurrency Scaling ineligible query - Burst temporarily disabled ' AS text)
WHEN sq.concurrency_scaling_status = 21
THEN CAST('Concurrency Scaling ineligible query - Unload queries are disabled ' AS text)
WHEN sq.concurrency_scaling_status = 22
THEN CAST('Concurrency Scaling ineligible query - Unsupported unload type ' AS text)
WHEN sq.concurrency_scaling_status = 23
THEN CAST('Concurrency Scaling ineligible query - Non VPC clusters cannot burst ' AS text)
WHEN sq.concurrency_scaling_status = 24
THEN CAST('Concurrency Scaling ineligible query - VPCE not setup ' AS text)
WHEN sq.concurrency_scaling_status = 25
THEN CAST('Concurrency Scaling failed query - Inelegible to rerun on main cluster due to failure handling not enabled' AS text)
WHEN sq.concurrency_scaling_status = 26
THEN CAST('Concurrency Scaling failed query - Inelegible to rerun on main cluster due to concurrency scaling not auto' AS text)
WHEN sq.concurrency_scaling_status = 27
THEN CAST('Concurrency Scaling failed query - Inelegible to rerun on main cluster due to results already returning ' AS text)
WHEN sq.concurrency_scaling_status = 28
THEN CAST('Concurrency Scaling failed query - Inelegible to rerun on main cluster due to non retriable error ' AS text)
WHEN sq.concurrency_scaling_status = 29
THEN CAST('Concurrency Scaling failed query - Elegible to rerun on main cluster ' AS text)
WHEN sq.concurrency_scaling_status = 30
THEN CAST('Concurrency Scaling inelegible query - Cumulative time not met ' AS text)
WHEN sq.concurrency_scaling_status = 31
THEN CAST('Concurrency Scaling inelegible query - Paused query ' AS text)
WHEN sq.concurrency_scaling_status = 32
THEN CAST('Query assigned to non Concurrency Scaling queue ' AS text)
WHEN sq.concurrency_scaling_status = 33
THEN CAST('Concurrency Scaling ineligible query - Query has state on Main cluster ' AS text)
WHEN sq.concurrency_scaling_status = 34
THEN CAST('Concurrency Scaling ineligible query - Query is inelegible for bursting Volt CTAS ' AS text)
WHEN sq.concurrency_scaling_status = 35
THEN CAST('Concurrency Scaling ineligible query - Resource blacklisted ' AS text)
WHEN sq.concurrency_scaling_status = 36
THEN CAST('Concurrency Scaling ineligible query - Non-retryable VoltTT queries are blacklisted ' AS text)
WHEN sq.concurrency_scaling_status = 37
THEN CAST('Concurrency Scaling ineligible query - Query is retrying on Main cluster ' AS text)
WHEN sq.concurrency_scaling_status = 38
THEN CAST('Concurrency Scaling ineligible query - Cannot burst Volt-created CTAS using cursors ' AS text)
WHEN sq.concurrency_scaling_status = 39
THEN CAST('Concurrency Scaling usage limit reached ' AS text)
WHEN sq.concurrency_scaling_status = 40
THEN CAST('Concurrency Scaling ineligible query - Unsupported VoltTT Utility query ' AS text)
WHEN sq.concurrency_scaling_status = 41
THEN CAST('Concurrency Scaling ineligible query - Write query generating Volt TTs ' AS text)
WHEN sq.concurrency_scaling_status = 42
THEN CAST('Concurrency Scaling ineligible query - VoltTT query with invalid state ' AS text)
WHEN sq.concurrency_scaling_status = 43
THEN CAST('Concurrency Scaling ineligible query - Explain query generating Volt TTs ' AS text)
WHEN sq.concurrency_scaling_status = 44
THEN CAST('Concurrency Scaling ineligible query - Bursting Volt-generated queries is disabled ' AS text)
WHEN sq.concurrency_scaling_status = 45
THEN CAST('Concurrency Scaling ineligible query - Resource of VoltTT UNLOAD is blacklisted ' AS text)
WHEN sq.concurrency_scaling_status = 46
THEN CAST('Concurrency Scaling ineligible query - Multiple pre-Volt query trees ' AS text)
WHEN sq.concurrency_scaling_status = 48
THEN CAST('Concurrency Scaling ineligible query - Target table is DistAll/DistAutoAll ' AS text)
WHEN sq.concurrency_scaling_status = 49
THEN CAST('Concurrency Scaling ineligible query - Table that has diststyle changed in current txn accessed ' AS text)
WHEN sq.concurrency_scaling_status = 50
THEN CAST('Concurrency Scaling ineligible query - Cannot burst spectrum copy ' AS text)
WHEN sq.concurrency_scaling_status = 51
THEN CAST('Concurrency Scaling ineligible query - Dirty transaction tables accessed ' AS text)
WHEN sq.concurrency_scaling_status = 52
THEN CAST('Concurrency Scaling ineligible query - Table that has identity column as a target table ' AS text)
WHEN sq.concurrency_scaling_status = 53
THEN CAST('Concurrency Scaling ineligible query - Datasharing remote tables accessed' AS text)
WHEN sq.concurrency_scaling_status = 54
THEN CAST('Concurrency Scaling ineligible query - Target table with comp update' AS text)
WHEN sq.concurrency_scaling_status = 55
THEN CAST('Concurrency Scaling ineligible query - Nested tables accessed' AS text)
WHEN sq.concurrency_scaling_status = 56
THEN CAST('Concurrency Scaling ineligible query - Copy from EMR ' AS text)
WHEN sq.concurrency_scaling_status = 59
THEN CAST('Concurrency Scaling ineligible query - Table that has column encode changed in current txn accessed ' AS text)
WHEN sq.concurrency_scaling_status = 60
THEN CAST('Concurrency Scaling ineligible query - MV refresh disabled ' AS text)
WHEN sq.concurrency_scaling_status = 61
THEN CAST('Concurrency Scaling ineligible query - Too many concurrent writes ' AS text)
WHEN sq.concurrency_scaling_status = 62
THEN CAST('Concurrency Scaling ineligible query - Main cluster too big for writes ' AS text)
WHEN sq.concurrency_scaling_status = 63
THEN CAST('Concurrency Scaling ineligible query - Datasharing VoltTT ' AS text)
WHEN sq.concurrency_scaling_status = 64
THEN CAST('Concurrency Scaling ineligible query - Target table has super/geo column ' AS text)
WHEN sq.concurrency_scaling_status = 65
THEN CAST('Concurrency Scaling rejected query - Ineligible to queue on burst cluster, eligible to rerun on any cluster ' AS text)
WHEN sq.concurrency_scaling_status = 66
THEN CAST('Concurrency Scaling ineligible query - Datasharing with burst-write' AS text)
WHEN sq.concurrency_scaling_status = 67
THEN CAST('Concurrency Scaling ineligible query - CTAS with burst-write' AS text)
WHEN sq.concurrency_scaling_status = 68
THEN CAST('Concurrency Scaling ineligible query - COPY on tables with identity columns' AS text)
WHEN sq.concurrency_scaling_status = 70
THEN CAST('Concurrency Scaling ineligible query - Datasharing query with cursor' AS text)
WHEN sq.concurrency_scaling_status = 71
THEN CAST('Ran on a Multi-AZ secondary cluster' AS text)
WHEN sq.concurrency_scaling_status = 72
THEN CAST('Concurrency Scaling ineligible query - Burst MERGE is disabled' AS text)
WHEN sq.concurrency_scaling_status = 73
THEN CAST('Concurrency Scaling ineligible query - Redshift Table via Lake Formation accessed' AS text)
ELSE CAST('Concurrency Scaling ineligible query - Unknown status' AS text)
END AS concurrency_scaling_status_txt,
sq.starttime,
sq.endtime
FROM stl_query AS sq
LEFT JOIN stl_result_cache_history AS sr ON sq.query = sr.cache_hit_query
LEFT JOIN stl_wlm_query AS sw ON sq.query = sw.query
AND sq.userid = sw.userid
AND sq.xid = sw.xid 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