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:alvhe...@2ndquadrant.com] Sent: Thursday, March 24, 2016 9:03 PM To: Pavlov Vladimir Cc: 'Adrian Klaver'; pgsql-general@postgresql.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
