Postgres Pro
Downloads
Home   >   mailing lists

Re: Please help! Query jumps from 1s -> 4m - Mailing list pgsql-performance

From David Rowley
Subject Re: Please help! Query jumps from 1s -> 4m
Date
Msg-id CAApHDvr2a0c+vS3u=jVUFsT_=N=ofvhFoH_FUdcBaNS-0EQ1MA@mail.gmail.com
Whole thread Raw
In response to Please help! Query jumps from 1s -> 4m  (James Thompson <james@jthompson.dev>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: James Thompson
Date:
Subject: Re: Please help! Query jumps from 1s -> 4m
Next
From: Michael Lewis
Date:
Subject: Re: good book or any other resources for Postgresql