Re: EXPLAIN ANALYZE - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: EXPLAIN ANALYZE
Date
Msg-id 200612110024.13036.peter_e@gmx.net
Whole thread Raw
In response to Re: EXPLAIN ANALYZE  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: EXPLAIN ANALYZE  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
Simon Riggs wrote:
> Well, I'd like a way of making EXPLAIN ANALYZE return something
> useful within a reasonable amount of time. We can define that as the
> amount of time that the user considers is their goal for the query.

What sort of "useful" results would you expect to be able to see from 
such an aborted EXPLAIN ANALYZE?  I cannot quite imagine what 
instructive value a partially executed plan output would have.  It's 
not like we can somehow ensure executing an equal proportion of each 
plan node or something.  Do you have a specific case in mind?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: postgresql roadmap for horizontal scalability?
Next
From: Mark Kirkwood
Date:
Subject: Re: EXPLAIN ANALYZE