Redshift Observatory

System Table Tracker

System view pg_catalog.svl_table_mutex version 1.0.45698 / 2023-01-27

View Text

SELECT a.query,
       a.segment,
       a.step,
       a.slice,
       a.pid,
       a.eventtime,
       a.table_id,
       a.data_slice,
       CASE
         WHEN a.mode = 1
           THEN CAST('SHARED' AS text)
         WHEN a.mode = 2
           THEN CAST('EXCLUSIVE' AS text)
         ELSE CAST(NULL AS text)
       END AS mode,
       CASE
         WHEN a.type = 0
           THEN CAST('ATTEMPT' AS text)
         WHEN a.type = 1
           THEN CAST('ACQUIRED' AS text)
         WHEN a.type = 2
           THEN CAST('RELEASED' AS text)
         WHEN a.type = 3
           THEN CAST('TRY-LOCK-FAILED' AS text)
         WHEN a.type = 4
           THEN CAST('RELINQUISHED' AS text)
         ELSE CAST(NULL AS text)
       END AS type
FROM stl_table_mutex AS a

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