How to get Transaction Timestamp ?

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get Transaction Timestamp ?
Date: 2011-09-16 18:39:51
Message-ID: CA+h6AhgBjwy39CKKKJswscdB3F7CqZx+ei0SRX+eQPUuEVuVng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Respected All,

Can we get the transaction timestamp for INSERT/UPDATE/DELETE ran against
table in the database ?

postgres=# create table trx_test(id int, name char(30));
CREATE TABLE
postgres=# insert into trx_test VALUES (1,'AAA');
INSERT 0 1
postgres=# insert into trx_test VALUES (2,'BBB');
INSERT 0 1
postgres=# insert into trx_test VALUES (3,'CCC');
INSERT 0 1
postgres=# select xmin,* from trx_test ;
xmin | id | name
---------+----+--------------------------------
1348711 | 1 | AAA
1348712 | 2 | BBB
1348713 | 3 | CCC
(3 rows)

We can get a Transaction ID, but not the transaction timestamp when it
performed.
Kindly advice me.

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vitor Reus 2011-09-16 19:50:06 CUDA Sorting
Previous Message Alec Swan 2011-09-16 17:29:48 Re: Log duration and statement for slow queries + limiting the number of log files generated