Ow Mun Heng wrote:
On Wed, 2007-10-17 at 20:37 +0100, Richard Huxton wrote:
Your query plans don't seem to match your queries. That makes it
difficult to provide meaningful advice.
Well, then that makes both you and me(both) stumped. because the 2
queries are exactly the same except for the data part.
Your queries were like this:
> select
> foo,
> bar,
> foobar
> from
> A,
> join B
> on a.id = b.id
> join C
> on c.id = b.id
> and c.start_dtime = b.start_dtime
> where audit_key_dtime >= '2007-08-08 18:00:00'
> and audit_key_dtime < '2007-08-08 18:01:00'
Your plans contained these:
> Filter: (pber_err_rate_hd_zn_2 <> 0::numeric)
> Filter: (web_id <> 0::numeric)
I don't see the <> 0 condition anywhere in your SQL - presumably there's
a view involved somehwere?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
