On Fri, 2022-05-20 at 07:37 +, Kumar, Mukesh wrote:
> We are facing an issue in running the query which takes at least 30 sec to
> run in PostgreSQL.
>
> We have tried to create the indexes and done the maintenance and still that
> query is taking same time.
>
> Below are the explain plan
Hi Team,
We are facing an issue in running the query which takes at least 30 sec to run
in PostgreSQL.
We have tried to create the indexes and done the maintenance and still that
query is taking same time.
Below are the explain plan for the query.
https://explain.depesz.com/s/sPo2#html
We ha