Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing high query planning time on Azure Postgres Single Server version 11. - Mailing list pgsql-general

From David Rowley
Subject Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Date
Msg-id CAApHDvqY-TWudNYdMhhnWE8RVYDSOZL-0TmBpV+P7ZhD_tLj2Q@mail.gmail.com
Whole thread Raw
In response to Re: Seeing high query planning time on Azure Postgres Single Server version 11.  (hassan rafi <haassaan.khann@gmail.com>)
List pgsql-general
Tree view 
On Fri, 15 Mar 2024 at 08:01, hassan rafi <haassaan.khann@gmail.com> wrote:
> We have migrated to postgres version 16.1, but still due to very high update activity on our DB, we are seeing
elevatedresponse times, though now the planning time is less.
 

>    Buffers: shared hit=33359 read=6590 dirtied=9379

>  Execution Time: 5049.131 ms

You could try "SET track_io_timing = 1;" to see how much of that time
is spent in reads.

David

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: select results on pg_class incomplete
Next
From: "Bandi, Venkataramana - Dell Team"
Date:
Subject: Query on Postgres SQL transaction