Displays information about transactions that have been undone.
This table is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of Data in System Tables and Views.
|Column Name||Data Type||Description|
|userid||integer||ID of the user who generated the entry.|
|xact_id||bigint||ID for the undo transaction.|
|xact_id_undone||bigint||ID for the transaction that was undone.|
|undo_start_ts||timestamp||Start time for the undo transaction.|
|undo_end_ts||timestamp||End time for the undo transaction.|
|table_id||bigint||ID for the table that was affected by the undo transaction.|
To view a concise log of all undone transactions, type the following command:
select xact_id, xact_id_undone, table_id from stl_undone;
This command returns the following sample output:
xact_id | xact_id_undone | table_id ---------+----------------+---------- 1344 | 1344 | 100192 1326 | 1326 | 100192 1551 | 1551 | 100192 (3 rows)