I am facing an issue where one of the queries is taking time in production. When I put that query in explain, I found many nested loop conditions were being used, so just for testing, I disabled the enable_nestloop flag for a session, and now the query is running fast. I also ran an analyze on every table of that query and also indexing is there on required columns.
Tell me where i am wrong and what can be done, as i don't want to disable it because, according to me, it's not a good practise.