Re: [ADMIN] List all querys from a open transaction

2011-07-05 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > anyone know how can I show all querys from a open transaction? > > pg_stat_activity only show " in transaction", any ideas? What would you have it show? The other session is between commands. Nothing is tracked at a historical level except i

[ADMIN] List all querys from a open transaction

2011-07-05 Thread Sebastian SWC
Hey all, anyone know how can I show all querys from a open transaction? pg_stat_activity only show " in transaction", any ideas? Sample: ### conection 1 root@server:~# psql -U postgres psql (8.4.4) postgres=# begin; BEGIN postgres=# select now(); now -