decoding pg_log
Started by Ingram, Bryanover 25 years ago2 messagesgeneral
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
Re: decoding pg_log
"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