On Tue, Aug 01, 2006 at 11:15:11PM -0400, Tom Lane wrote:
> Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
> > [slow query]
> The bulk of your time seems to be going into this indexscan:
> > -> Index Scan using
> > task_scheduler_icustomer_id on task_scheduler ts
Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
> [slow query]
The bulk of your time seems to be going into this indexscan:
> -> Index Scan using
> task_scheduler_icustomer_id on task_scheduler ts (cost=2.03..11.51 rows=1
> width=51) (actual time=2.785..2.785
Hello, I have a query:
explain analyze select tu.url_id, tu.url, coalesce(sd.recurse, 100), case when
COALESCE(get_option('use_banner')::integer,0) = 0 then 0 else ts.use_banner
end as use_banner, ts.use_cookies, ts.use_robots, ts.includes, ts.excludes,
ts.track_domain, ts.task_id,get_available_p
