Re: 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