Postgres Pro
Downloads
Home   >   mailing lists

Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction - Mailing list pgsql-general

From Jeff Dik
Subject Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction
Date
Msg-id CAG9nzwTMa8D-ibSCLL4vnQt043B0tOAjSP8YsZvRbEvXxVfBdA@mail.gmail.com
Whole thread Raw
In response to Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view
On Wed, Sep 23, 2015 at 11:26 AM, Alvaro Herrera <alvherre@2ndquadrant.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

pgsql-general by date:

Previous
From: Daniel Begin
Date:
Subject: PostgreSQL and Windows 10 upgrade
Next
From: Israel Brewster
Date:
Subject: Postgresql HA questions