Re: [PERFORM] Query/database optimization

2006-08-02 Thread Eugeny N Dzhurinsky
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

Re: [PERFORM] Query/database optimization

2006-08-01 Thread Tom Lane
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