From: Michel SALAIS <msalais@msym.fr>
To: pgsql-performance@postgresql.org
Subject: RE: sql execution time in pg_stat_statements
Date: Thu, 9 Sep 2021 20:49:32 +0200
Message-ID: <006601d7a5ab$6e01c780$4a055680$@msym.fr> (raw)
In-Reply-To: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr>
References: <005f01d7a5a6$67784b50$3668e1f0$@msym.fr>
Just to say that for PostgreSQL 13, total_time is replaced by
total_exec_time + total_plan_time
Michel SALAIS
De : Michel SALAIS <msalais@msym.fr>
Envoyé : jeudi 9 septembre 2021 20:14
À : pgsql-performance@postgresql.org
Objet : sql execution time in pg_stat_statements
Hi all,
I think that total_time in pg_stat_statements is cpu time + possible waits.
So, can I say that:
Total_sql_time = total_time + blk_read_time + blk_write_time
Documentation is not clear at all on that.
Thanks in advance
Michel SALAIS
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: msalais@msym.fr
Subject: RE: sql execution time in pg_stat_statements
In-Reply-To: <006601d7a5ab$6e01c780$4a055680$@msym.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox