Check what has been done for a uncommitted prepared transaction - Mailing list pgsql-general

From Andy Fan
Subject Check what has been done for a uncommitted prepared transaction
Date
Msg-id CAKU4AWpyT1NMKjuX0myda8Q2SukrA7JROtjVcv9tNxqAptuwKQ@mail.gmail.com
Whole thread Raw
Responses Re: Check what has been done for a uncommitted prepared transaction
Re: Check what has been done for a uncommitted prepared transaction
List pgsql-general

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

pgsql-general by date:

Previous
From: Santhosh Kumar
Date:
Subject: Clarification related to BDR
Next
From: Andreas Joseph Krogh
Date:
Subject: Sv: Practical usage of large objects.