On Wed, Sep 23, 2015 at 11:26 AM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> wrote:
Jeff Dik wrote:
> Is there any way to inspect a multixact via psql to see what transaction ID
> values it has? I wasn't able to find anything while searching for an hour
> or so.
There's the function pg_get_multixact_members(xid),
=# select * from pg_get_multixact_members('1');
xid | mode
------+--------
5401 | keysh
5402 | forupd
...
That's fantastic. Thanks so much!
Jeff
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
