Re: Multixacts wraparound monitoring

There is nothing:
select * from pg_prepared_xacts;
transaction | gid | prepared | owner | database
-------------+-----+----------+-------+----------
(0 rows)
It is also noticed that a lot of files in a directory main/pg_multixact/members/, now - 69640.

Kind regards,
 
Vladimir Pavlov

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)2ndquadrant(dot)com]
Sent: Thursday, March 24, 2016 9:03 PM
To: Pavlov Vladimir
Cc: 'Adrian Klaver'; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Multixacts wraparound monitoring

Pavlov, Vladimir wrote:
> Thanks for your reply.
> Yes, the first thing I looked at the statistics from pg_stat_activity.
> But I have a transaction is not more than 60 seconds and the condition 'idle in transaction' lasts only a few seconds.

Maybe you have a prepared transaction? See select * from pg_prepared_xacts;

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services