Re: sql execution time in pg_stat_statements

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: sql execution time in pg_stat_statements
Дата
Msg-id CAOBaU_Z=+-SeHeG4wBOLUEAYs+ngrtFYUTUyE0RATLZ-RJ=AjA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: sql execution time in pg_stat_statements  ("Michel SALAIS" <msalais@msym.fr>)
Список pgsql-performance
On Sat, Sep 11, 2021 at 1:12 AM Michel SALAIS <msalais@msym.fr> 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 queries use parallelism, the query
total execution time may be say 1 second, but if there were X workers
it could actually cumulate X+1 seconds of execution time, and
therefore reach more than 1 second of cumulated read/write time.



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: sql execution time in pg_stat_statements
Следующее
От: Kristjan Mustkivi
Дата:
Сообщение: Postgres chooses slow query plan from time to time