On Thu, Feb 1, 2024 at 4:13 PM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
