RE: pg_stat_statements doesn't track commit from pl/pgsql blocks - Mailing list pgsql-general

From legrand legrand
Subject RE: pg_stat_statements doesn't track commit from pl/pgsql blocks
Date
Msg-id DB6PR0301MB213527DA4E3EFDA404EB4418907F0@DB6PR0301MB2135.eurprd03.prod.outlook.com
Whole thread Raw
In response to pg_stat_statements doesn't track commit from pl/pgsql blocks  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-general

forgot to cc pgsql-general list


De : legrand legrand <legrand_legrand@hotmail.com>
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 something like

        SELECT calls,query FROM pg_stat_statements;
         calls |               query
        -------+-----------------------------------
             1 | select pg_stat_statements_reset()
             1 | do $$ begin commit; end $$
             1 | commit

as I didn't found any other place to track this 'commit' information.

nb: I don't "want" anything this is just an open question,
and I'm perfectly able to ear that its not expected or not easy to implement.

Regards
PAscal


pgsql-general by date:

Previous
From: Sergey Burladyan
Date:
Subject: Re: Running from 9.6 backups sometimes fails with fatal error
Next
From: Tiffany Thang
Date:
Subject: Re: Copy entire schema A to a different schema B