Re: Please help! Query jumps from 1s -> 4m

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Please help! Query jumps from 1s -> 4m
Дата
Msg-id CAApHDvr2a0c+vS3u=jVUFsT_=N=ofvhFoH_FUdcBaNS-0EQ1MA@mail.gmail.com
обсуждение исходный текст
Ответ на Please help! Query jumps from 1s -> 4m  (James Thompson <james@jthompson.dev>)
Список pgsql-performance
On Mon, 4 May 2020 at 02:35, James Thompson <james@jthompson.dev> wrote:
> buffers do look different - but still, reading 42k doesn't seem like it would cause a delay of 4m?

You could do: SET track_io_timing TO on;

then: EXPLAIN (ANALYZE, BUFFERS) your query and see if the time is
spent doing IO.

David



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

Предыдущее
От: James Thompson
Дата:
Сообщение: Re: Please help! Query jumps from 1s -> 4m
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: good book or any other resources for Postgresql