Postgres Pro
Downloads
Home   >   mailing lists

RE: sql execution time in pg_stat_statements - Mailing list pgsql-performance

From Michel SALAIS
Subject RE: sql execution time in pg_stat_statements
Date
Msg-id 006601d7a5ab$6e01c780$4a055680$@msym.fr
Whole thread Raw
In response to sql execution time in pg_stat_statements  ("Michel SALAIS" <msalais@msym.fr>)
Responses Re: sql execution time in pg_stat_statements  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: "Michel SALAIS"
Date:
Subject: sql execution time in pg_stat_statements
Next
From: Julien Rouhaud
Date:
Subject: Re: sql execution time in pg_stat_statements