Re: List all querys from a open transaction

-----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-----