Redshift Research Project

System Table Tracker

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

View Text

SELECT rtrim(CAST(s.user_name AS text)) AS txn_owner,
       rtrim(CAST(s.db_name AS text)) AS txn_db,
       t.xid,
       CAST(t.pid AS integer) AS pid,
       t.start_ts AS txn_start,
       CAST(l.mode AS varchar(24)) AS lock_mode,
       CAST(CASE
              WHEN l.relation IS NULL
                THEN CAST('transactionid' AS text)
              ELSE CAST('relation' AS text)
            END AS varchar(14)) AS lockable_object_type,
       CAST(l.relation AS integer) AS relation,
       l.granted
FROM stv_transactions AS t
     LEFT JOIN pg_locks AS l ON l.pid = t.pid
     LEFT JOIN stv_sessions AS s ON s.process = t.pid
WHERE t.ended = 0
  AND s.user_name <> CAST('rdsdb' AS bpchar)
ORDER BY t.start_ts,
         t.xid,
         l.granted,
         l.relation

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