Re: [PERFORM] Recursive query performance issue

2015-10-22 Thread vincent elschot
On 20-10-15 19:34, Jamie Koceniak wrote: Version: --- PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit Query Plan http://explain.depesz.com/s/4s37 Nor

Re: [PERFORM] Explain analyze time overhead

2013-12-05 Thread vincent elschot
On 05-12-13 15:09, salah jubeh wrote: 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 an