On Tue, Mar 7, 2023 at 7:14 AM Praneel Devisetty <devisettypraneel@xxxxxxxxx> 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
What version is this? Any chance you can share this without anonymization? Not knowing the actual names makes it a lot harder to understand. In particular, what is the actual function golf_romeo()? And five_two()? And what is the regexp pattern that is bastardized into 'oscar_mike'::text ?
Disabling the nested loop on session is allowing the query planner to choose a better plan and complete it in 2mins.Stats are up to date and analyze was performed a few hours ago.
A lot can change in a few hours, do another analyze immediately before gathering the execution plan. Your row estimates are dreadful, but we can't really tell why with the info provided.
Cheers,
Jeff
