Redshift Research Project

System Table Tracker

System view pg_catalog.svl_query_concurrency_scaling_status version 1.0.38698 / 2022-05-27

View Text

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