Re: [PERFORM] random_page_cost = 2.0 on Heroku Postgres

2012-02-11 Thread Peter van Hardenberg
On Sat, Feb 11, 2012 at 8:26 AM, Jeff Janes wrote: > By the time you realize the query is running long, it is too late to > start analyzing it.  And without analyzing it, you probably can't get > the information you need. > > Maybe with the timing = off feature,it would might make sense to just >

Re: [PERFORM] random_page_cost = 2.0 on Heroku Postgres

2012-02-11 Thread Jeff Janes
On Thu, Feb 9, 2012 at 2:41 PM, Peter van Hardenberg wrote: > Hmm, perhaps we could usefully aggregate auto_explain output. By the time you realize the query is running long, it is too late to start analyzing it. And without analyzing it, you probably can't get the information you need. Maybe