Re: [GENERAL] decrease my query duration

2013-07-05 Thread David Johnston
David Carpio wrote > Thank you for your time You're not likely to get too many if any takers who want to try and decipher that mess you call a query/explain. Especially since you've made it pretty much impossible to read by removing/obfuscating information. It is not self-contained and we have n

Re: [GENERAL] decrease my query duration

2013-07-05 Thread David Carpio
On Thu 04 Jul 2013 08:10:45 PM PET, Michael Paquier wrote: On Fri, Jul 5, 2013 at 10:04 AM, bricklen wrote: On Thu, Jul 4, 2013 at 5:26 PM, David Carpio wrote: Also, can you supply the EXPLAIN (ANALYZE, BUFFERS) plan instead of the simple EXPLAIN plan? Then it might be interesting that you sc

Re: [GENERAL] decrease my query duration

2013-07-04 Thread Michael Paquier
On Fri, Jul 5, 2013 at 10:04 AM, bricklen wrote: > On Thu, Jul 4, 2013 at 5:26 PM, David Carpio > wrote: > Also, can you supply the EXPLAIN (ANALYZE, BUFFERS) plan instead of the > simple EXPLAIN plan? Then it might be interesting that you scan what is wrong with this utility: http://explain.depe

Re: [GENERAL] decrease my query duration

2013-07-04 Thread bricklen
On Thu, Jul 4, 2013 at 5:26 PM, David Carpio wrote: > Hello All > > I am newbie in this forum that's why I will be very grateful if would be > able to help me and if you need some additional information please let me > know. > I have a query that I would like decrease its duration > Have a loo