Redshift Observatory

System Table Tracker

System view pg_catalog.stl_transaction_history version 1.0.60353 / 2023-11-24

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