From: "Michel SALAIS" <msalais@msym.fr>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: "'Julien Rouhaud'" <rjuju123@gmail.com>,
	"'postgres performance list'" <pgsql-performance@postgresql.org>
References: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr>
 <006601d7a5ab$6e01c780$4a055680$@msym.fr>
 <CAOBaU_Zn5V7vsFaTZKjJgFCb5hQPAQNqV1ro-Kw-VE9n5zBzVQ@mail.gmail.com>
 <007201d7a667$1516d860$3f448920$@msym.fr> <4078764.1631295728@sss.pgh.pa.us>
In-Reply-To: <4078764.1631295728@sss.pgh.pa.us>
Subject: RE: sql execution time in pg_stat_statements
Date: Sun, 19 Sep 2021 17:41:48 +0200
Message-ID: <000001d7ad6c$dc44d250$94ce76f0$@msym.fr>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQJfVqXLzTD3tJt7ImS9sFGS32Fv3QH0n7V9AjP2INACQvqRvgJgvkG4qlXIYTA=
Content-Language: fr
Archived-At: 
 <https://www.postgresql.org/message-id/000001d7ad6c%24dc44d250%2494ce76f0%24%40msym.fr>
Precedence: bulk

Hi Tom,

I was out of this list for a while.
Unfortunately, I have now no access to the server where I have seen =
this.

Best regards

Michel SALAIS

-----Message d'origine-----
De=A0: Tom Lane <tgl@sss.pgh.pa.us>=20
Envoy=E9=A0: vendredi 10 septembre 2021 19:42
=C0=A0: Michel SALAIS <msalais@msym.fr>
Cc=A0: 'Julien Rouhaud' <rjuju123@gmail.com>; 'postgres performance =
list'
<pgsql-performance@postgresql.org>
Objet=A0: Re: sql execution time in pg_stat_statements

"Michel SALAIS" <msalais@msym.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