Thread: decoding pg_log

Are there any existant utilities to decode pg_log?

I'd like to be able to generate a list of all OIDs and their current status.
Doing this by timestamp would even be better.

Thanks,
Bryan

"Ingram, Bryan" <BIngram@sixtyfootspider.com> writes:
> Are there any existant utilities to decode pg_log?

No, but the format is brain-dead simple: two bits per transaction ID,
indexed from ID 0 if I recall correctly.  See the access routines in
src/backend/access/transam/transsup.c for details of bit order etc.

            regards, tom lane