Re: sql execution time in pg_stat_statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: sql execution time in pg_stat_statements
Дата
Msg-id 4078764.1631295728@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: sql execution time in pg_stat_statements  ("Michel SALAIS" <msalais@msym.fr>)
Ответы RE: sql execution time in pg_stat_statements  ("Michel SALAIS" <msalais@msym.fr>)
Список pgsql-performance
"Michel SALAIS" <msalais@msym.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



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

Предыдущее
От: "Michel SALAIS"
Дата:
Сообщение: RE: sql execution time in pg_stat_statements
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: sql execution time in pg_stat_statements