Hello guys,
When I excute a query, the exection time is about 1 minute; however, when I execute the query with explain analyze the excution time jumps to 10 minutes.
I have tried this for several queries, where I need to optimize; and using explain analyze leads alway to a huge time overhead in factor of 10.
This is a little bit starnge for me; did any one experience somthing like this? Can I trust the generated plans?
Regards
