Redshift Observatory

System Table Tracker

System view pg_catalog.svv_transactions version 1.0.40677 / 2022-08-14

schema name column data type
pg_catalog svv_transactions granted bool
pg_catalog svv_transactions lockable_object_type varchar(14)
pg_catalog svv_transactions lock_mode varchar(24)
pg_catalog svv_transactions pid int4
pg_catalog svv_transactions relation int4
pg_catalog svv_transactions txn_db text
pg_catalog svv_transactions txn_owner text
pg_catalog svv_transactions txn_start timestamp
pg_catalog svv_transactions xid int8

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