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