| From: | Avinash Kumar <avinash(dot)vallarapu(at)gmail(dot)com> |
|---|---|
| To: | Shrikant Bhende <shrikantpostgresql(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Query taking seq scan on a table |
| Date: | 2020-09-20 13:25:25 |
| Message-ID: | CAN0TujdziL1CD7FFwKogObZSoe-b1rLLHUPc9m-H+GNbLm5naQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun., Sep. 20, 2020, 10:19 a.m. Shrikant Bhende, <
shrikantpostgresql(at)gmail(dot)com> wrote:
> 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.
>
Just wanted to clarify one thing before looking at the query.
What is random_page_cost set to ?
> Thanks and regards
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shrikant Bhende | 2020-09-20 13:48:22 | Re: Query taking seq scan on a table |
| Previous Message | Shrikant Bhende | 2020-09-20 13:18:46 | Query taking seq scan on a table |