From: | "Michel SALAIS" <msalais(at)msym(dot)fr> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "'Julien Rouhaud'" <rjuju123(at)gmail(dot)com>, "'postgres performance list'" <pgsql-performance(at)postgresql(dot)org> |
Subject: | RE: sql execution time in pg_stat_statements |
Date: | 2021-09-19 15:41:48 |
Message-ID: | 000001d7ad6c$dc44d250$94ce76f0$@msym.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi Tom,
I was out of this list for a while.
Unfortunately, I have now no access to the server where I have seen this.
Best regards
Michel SALAIS
-----Message d'origine-----
De : Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Envoyé : vendredi 10 septembre 2021 19:42
À : Michel SALAIS <msalais(at)msym(dot)fr>
Cc : 'Julien Rouhaud' <rjuju123(at)gmail(dot)com>; 'postgres performance list'
<pgsql-performance(at)postgresql(dot)org>
Objet : Re: sql execution time in pg_stat_statements
"Michel SALAIS" <msalais(at)msym(dot)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
total_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
From | Date | Subject | |
---|---|---|---|
Next Message | Ulf Lohbrügge | 2021-09-19 18:28:48 | Re: Query executed during pg_dump leads to excessive memory usage |
Previous Message | Ranier Vilela | 2021-09-19 12:05:56 | Re: Query executed during pg_dump leads to excessive memory usage |