On Tue, Mar 7, 2023 at 7:14 AM Praneel Devisetty
wrote:
> Hi,
>
> I have a query which is taking roughly 10mins to complete and the query
> planner is choosing a nested loop.
>
> query and query plan with analyze,verbose,buffers
> qsEn | explain.depesz.com
Hi Praneel,
It is hard to propose a solution without seeing the actual query and
knowing details of the tables. If I were you, I would try to increase
statistics target for the columns used in joins. Default value is 100. You
need to analyze those tables again after updating the statistics