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