Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sub_transaction_commit_info version 1.0.72899 / 2024-08-17

schema	name	column	data type
pg_catalog	stl_sub_transaction_commit_info	commitlevel	int4
pg_catalog	stl_sub_transaction_commit_info	endtime	timestamp
pg_catalog	stl_sub_transaction_commit_info	masterxid	int8
pg_catalog	stl_sub_transaction_commit_info	node	int4
pg_catalog	stl_sub_transaction_commit_info	refreshtype	char(10)
pg_catalog	stl_sub_transaction_commit_info	starttime	timestamp
pg_catalog	stl_sub_transaction_commit_info	xid	int8

View Text

SELECT stll_sub_transaction_commit_info.masterxid,
       stll_sub_transaction_commit_info.xid,
       stll_sub_transaction_commit_info.node,
       stll_sub_transaction_commit_info.commitlevel,
       stll_sub_transaction_commit_info.refreshtype,
       stll_sub_transaction_commit_info.starttime,
       stll_sub_transaction_commit_info.endtime
FROM stll_sub_transaction_commit_info

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