RE: pg_stat_statements doesn't track commit from pl/pgsql blocks

2019-02-22 Thread legrand legrand
forgot to cc pgsql-general list De : legrand legrand Envoyé : vendredi 22 février 2019 20:26 À : Bruce Momjian Objet : RE: pg_stat_statements doesn't track commit from pl/pgsql blocks Hello Bruce, thank you for taking time to answer. yes, I was expecting

Re: pg_stat_statements doesn't track commit from pl/pgsql blocks

2019-02-21 Thread Bruce Momjian
On Sun, Feb 17, 2019 at 02:52:07PM -0700, legrand legrand wrote: > Hello, > > It seems that pgss doesn't track commit (nor rollback) commands from > pl/pgsql blocks. > using psql in version 11.1: > > select pg_stat_statements_reset(); > do $$ begin commit; end $$; > select calls,query from