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

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: James Thompson <james(at)jthompson(dot)dev>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Please help! Query jumps from 1s -> 4m
Date: 2020-05-04 20:12:51
Message-ID: CAApHDvr2a0c+vS3u=jVUFsT_=N=ofvhFoH_FUdcBaNS-0EQ1MA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 4 May 2020 at 02:35, James Thompson <james(at)jthompson(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bhupendra Babu 2020-05-04 22:45:22 good book or any other resources for Postgresql
Previous Message James Thompson 2020-05-04 19:12:06 Re: Please help! Query jumps from 1s -> 4m