Redshift Observatory

System Table Tracker

System view pg_catalog.stl_transaction_history version 1.0.59596 / 2023-11-12

schema name column data type
pg_catalog stl_transaction_history commit_end_time timestamp
pg_catalog stl_transaction_history commit_start_time timestamp
pg_catalog stl_transaction_history dirty_blocks int8
pg_catalog stl_transaction_history headers int8
pg_catalog stl_transaction_history isolation_level int4
pg_catalog stl_transaction_history node_id int4
pg_catalog stl_transaction_history status int4
pg_catalog stl_transaction_history transaction_id int8
pg_catalog stl_transaction_history transaction_start_time timestamp
pg_catalog stl_transaction_history undo_xid int8
pg_catalog stl_transaction_history user_id int4

View Text

SELECT stll_transaction_history.user_id,
       stll_transaction_history.transaction_id,
       stll_transaction_history.isolation_level,
       stll_transaction_history.node_id,
       stll_transaction_history.status,
       stll_transaction_history.transaction_start_time,
       stll_transaction_history.commit_start_time,
       stll_transaction_history.commit_end_time,
       stll_transaction_history.dirty_blocks,
       stll_transaction_history.headers,
       stll_transaction_history.undo_xid
FROM stll_transaction_history


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