Re: The standard 'why does it take so long' question - Mailing list pgsql-general

On 8 Aug 2002, Neil Conway wrote:

> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > I have this query which used to yield this EXPLAIN ANALYZE
> > [reformated] output:
>
> Uh, *which* query, exactly?

Hmmm...I suppose I should have written 'I have a query...'

Never mind I'll repost the whole message along with the query, just so that
it's all together for easier reference.

The query refered to in the post below:

explain analyze
 select u.name
        , p.session_id
        , p.post_number
        , to_char(p.time,'Dy, Mon DD YYYY HH:MIam ET')
   from chat_post p
        , chat_user u
   where
        p.poster_id = u.id
       AND
        p.time >= 'epoch'::timestamptz + '959904000 seconds'::interval
       and
        p.time <= 'epoch'::timestamptz + '1023667200 seconds'::interval
       and
        ( u.lower_name = 'thrifty' OR u.lower_name = 'hope1' )
   order by p.time

---