Hi:

I want to know what happens been done for an uncommitted prepared
transaction with pg_waldump, however I can't find it.

demo=# begin;
BEGIN
demo=*# select txid_current();
 txid_current
--------------
          608
(1 row)

demo=*# prepare transaction 's';
PREPARE TRANSACTION
demo=# insert into mm select generate_series(1, 1000);
INSERT 0 1000
demo=#

===


pg_wal> ~/postgres/bin/pg_waldump  00000001000000000000008F | grep 'tx:
   608'
rmgr: Transaction len (rec/tot):    138/   138, tx:        608, lsn:
0/8F68C020, prev 0/8F68BFD0, desc: PREPARE gid s: 2020-05-14
15:00:33.212997 CST

I can get the log for "prepared command" only,  but nothing was found for
the insert
statement.   what should I do?

My version is 9.4.

Thanks

Reply via email to