From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Michel SALAIS" <msalais@msym.fr>
cc: "'Julien Rouhaud'" <rjuju123@gmail.com>,
        "'postgres performance list'" <pgsql-performance@postgresql.org>
Subject: Re: sql execution time in pg_stat_statements
In-reply-to: <007201d7a667$1516d860$3f448920$@msym.fr>
References: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr>
 <006601d7a5ab$6e01c780$4a055680$@msym.fr>
 <CAOBaU_Zn5V7vsFaTZKjJgFCb5hQPAQNqV1ro-Kw-VE9n5zBzVQ@mail.gmail.com>
 <007201d7a667$1516d860$3f448920$@msym.fr>
Comments: In-reply-to "Michel SALAIS" <msalais@msym.fr>
	message dated "Fri, 10 Sep 2021 19:12:48 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4078763.1631295728.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 10 Sep 2021 13:42:08 -0400
Message-ID: <4078764.1631295728@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/4078764.1631295728%40sss.pgh.pa.us>
Precedence: bulk

"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 t=
otal_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