On Fri, 15 Mar 2024 at 08:01, hassan rafi <haassaan(dot)khann(at)gmail(dot)com> wrote:
> We have migrated to postgres version 16.1, but still due to very high update activity on our DB, we are seeing elevated response 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