Re: Poor Plan selected w/ not provided a date/time but selecting date/time from a table

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