Re: List all querys from a open transaction - Mailing list pgsql-admin

From Greg Sabino Mullane
Subject Re: List all querys from a open transaction
Date
Msg-id 1b9306ca6eef99c955d048bc47871e49@biglumber.com
Whole thread Raw
In response to List all querys from a open transaction  (Sebastian SWC <sebastianswc@gmail.com>)
List pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> anyone know how can I show all querys from a open transaction?
>
> pg_stat_activity only show "<IDLE> in transaction", any ideas?

What would you have it show? The other session is between commands.
Nothing is tracked at a historical level except in the database
logs, so you would have to look there.


- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201107052131
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk4TuygACgkQvJuQZxSWSsi6FgCg8ybmvOriaopUsnW11sbXJdHm
HZIAoNfx/7QLm9xlk8H3EqhqZCX9okp3
=LAHI
-----END PGP SIGNATURE-----



pgsql-admin by date:

Previous
From: Sebastian SWC
Date:
Subject: List all querys from a open transaction
Next
From: c k
Date:
Subject: Re: Python UCS4 error