Redshift Observatory

System Table Tracker

System view pg_catalog.stl_tr_conflict version 1.0.70634 / 2024-07-11

schema	name	column	data type
pg_catalog	stl_tr_conflict	abort_time	timestamp
pg_catalog	stl_tr_conflict	process_id	int8
pg_catalog	stl_tr_conflict	table_id	int8
pg_catalog	stl_tr_conflict	xact_id	int8
pg_catalog	stl_tr_conflict	xact_start_ts	timestamp

View Text

SELECT stll_tr_conflict.xact_id,
       stll_tr_conflict.process_id,
       stll_tr_conflict.xact_start_ts,
       stll_tr_conflict.abort_time,
       stll_tr_conflict.table_id
FROM stll_tr_conflict
WHERE stll_tr_conflict.access_control = 0
   OR stll_tr_conflict.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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