RE: sql execution time in pg_stat_statements

From: "Michel SALAIS" <msalais(at)msym(dot)fr>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: RE: sql execution time in pg_stat_statements
Date: 2021-09-09 18:49:32
Message-ID: 006601d7a5ab$6e01c780$4a055680$@msym.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Just to say that for PostgreSQL 13, total_time is replaced by
“total_exec_time + total_plan_time”

Michel SALAIS

De : Michel SALAIS <msalais(at)msym(dot)fr>
Envoyé : jeudi 9 septembre 2021 20:14
À : pgsql-performance(at)postgresql(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2021-09-10 05:18:29 Re: sql execution time in pg_stat_statements
Previous Message Michel SALAIS 2021-09-09 18:13:33 sql execution time in pg_stat_statements