Postgres Pro
Downloads
Home   >   mailing lists

Query taking seq scan on a table - Mailing list pgsql-admin

From Shrikant Bhende
Subject Query taking seq scan on a table
Date
Msg-id CAMTQpJA7eNEXJuLk=Yu5ubo0Wp8xYRwFzzpghRshDYCYPmJHJQ@mail.gmail.com
Whole thread Raw
Responses Re: Query taking seq scan on a table  (Avinash Kumar <avinash.vallarapu@gmail.com>)
List pgsql-admin
Tree view
Hello all, 

I am facing issues with one of the queries running on Amazon Aurora (PG VERSION 9.6) which is taking more than a minute to complete. As per the initial investigation I assume that one part of the query is taking a sequential scan on a table("wldbowner.member") which is consuming most of the execution time. I tried to use index (Btree and GIN ) as well but none of them were helping to get the query to run faster. Attached is the query along with the explain analyze of the same, any help on the same would be appreciated. 

NOTE : I have done the vacuum on the table already to get rid of bloat issues.
             Reindex and test with more work mem is also helping.

Thanks and regards


Attachment

pgsql-admin by date:

Previous
From: Gavin Fleming
Date:
Subject: pgAdmin support: setup.py --dump-servers
Next
From: Avinash Kumar
Date:
Subject: Re: Query taking seq scan on a table