On Thu, Feb 1, 2024 at 4:13 PM Laurenz Albe <laurenz.a...@cybertec.at> wrote:
> On Fri, 2024-02-02 at 02:27 +0530, veem v wrote: > > We have the below query which is running for ~45 seconds on postgres > aurora reader instance. > > I have captured the explain analyze. Want to understand, where exactly > the resources are > > getting spent and if we can be able to optimize it further. > > Aurora <> PostgreSQL, but here is what I can see: > > - The index scan on SCHEMA1."TAB2" has to check 2 million extra > rows because "work_mem" is too small. Almost the complete time > is spent there. > Is that these numbers? Buffers: shared hit=xxxxxx read=22xxxxx > >