Understand time taken by individual SQL statements in a procedure

Hi Listers, We would like to determine how long it takes for each SQL statement to execute within a long-running procedure. I tried to see if pg_stat_statements could offer any insight into the matter. But I was unable to locate any. Is this even possible? How can we also determine the precise SQ

Re: Understand time taken by individual SQL statements in a procedure

Hi, On Sat, Jun 03, 2023 at 12:48:37PM +0530, Satalabaha Postgres wrote: > Hi Listers, > > We would like to determine how long it takes for each SQL statement to > execute within a long-running procedure. I tried to see if > pg_stat_statements could offer any insight into the matter. But I was > u

Re: Understand time taken by individual SQL statements in a procedure

Thanks Julien. Regards, Satalabha On Sat, 3 Jun 2023 at 13:06, Julien Rouhaud wrote: > Hi, > > On Sat, Jun 03, 2023 at 12:48:37PM +0530, Satalabaha Postgres wrote: > > Hi Listers, > > > > We would like to determine how long it takes for each SQL statement to > > execute within a long-running