On Wed, Sep 23, 2015 at 11:26 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
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
>