27; ; 'postgres performance list'
Objet : Re: sql execution time in pg_stat_statements
"Michel SALAIS" 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 difficul
On Sat, Sep 11, 2021 at 1:12 AM Michel SALAIS wrote:
>
> 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...
Maybe not that difficult. If the
"Michel SALAIS" 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 incli
-Message d'origine-
De : Julien Rouhaud
Envoyé : vendredi 10 septembre 2021 07:18
À : Michel SALAIS
Cc : postgres performance list
Objet : Re: sql execution time in pg_stat_statements
On Fri, Sep 10, 2021 at 2:49 AM Michel SALAIS wrote:
>
> I think that to
On Fri, Sep 10, 2021 at 2:49 AM Michel SALAIS wrote:
>
> 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.
In version 12 and below, tota
Just to say that for PostgreSQL 13, total_time is replaced by
total_exec_time + total_plan_time
Michel SALAIS
De : Michel SALAIS
Envoyé : jeudi 9 septembre 2021 20:14
À : pgsql-performa...@postgresql.org
Objet : sql execution time in pg_stat_statements
Hi all,
I think that total_ti
