Re: sql execution time in pg_stat_statements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michel SALAIS" <msalais(at)msym(dot)fr>
Cc: "'Julien Rouhaud'" <rjuju123(at)gmail(dot)com>, "'postgres performance list'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: sql execution time in pg_stat_statements
Date: 2021-09-10 17:42:08
Message-ID: 4078764.1631295728@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Michel SALAIS" <msalais(at)msym(dot)fr> writes:
> I thaught that total_time (total_exec_time + total_plan_time) included I/O but when we have blk_read_time + blk_write_time equals several times total_time it is difficult to continue to think that...

That's an interesting report, but on the whole I'd be more inclined
to disbelieve the I/O timings than the overall time. Can you create
a reproducible test case where this happens? Also, exactly what
PG version and pg_stat_statements version are you using?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2021-09-10 17:43:06 Re: sql execution time in pg_stat_statements
Previous Message Michel SALAIS 2021-09-10 17:12:48 RE: sql execution time in pg_stat_statements