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