Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql

From: OgiSer Tamade <tamade(dot)ogiser(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql
Date: 2010-07-14 21:39:16
Message-ID: AANLkTikm6gKogn2mvTHvEJAjp_i56DjEG-G6E7ZYu8-z@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Limit  (cost=557838.74..557838.74 rows=1 width=20) (actual
time=0.076..0.076 rows=0 loops=1)

   ->  Sort  (cost=557838.74..557838.95 rows=86 width=20) (actual
time=0.075..0.075 rows=0 loops=1)

         Sort Key: s.callbackdate, c.priority, s.phoneid

         ->  Nested Loop  (cost=1058.59..557835.97 rows=86 width=20)
(actual time=0.017..0.017 rows=0 loops=1)

               ->  Seq Scan on p_campaigns c  (cost=0.00..1.34 rows=4
width=8) (actual time=0.017..0.017 rows=0 loops=1)

                     Filter: ((campaignid = 17) OR (campaignid = 16)
OR (campaignid = 15) OR (campaignid = 14) OR (campaignid = 13))

               ->  Bitmap Heap Scan on p_phonestatus s
(cost=1058.59..139454.62 rows=323 width=20) (never executed)

                     Recheck Cond: ("outer".campaignid = s.campaignid)

                     Filter: (((assignedto IS NULL) OR ((assignedto <>
'A436MA'::text) AND ((status = 'rejected'::text) OR (status =
'error'::text)))) AND ((callbackdate <= now()) OR (callbackdate IS
NULL)) AND (sequenceid = (subplan)))

                     ->  Bitmap Index Scan on phonestatus_campaignid
(cost=0.00..1058.59 rows=36740 width=0) (never executed)

                           Index Cond: ("outer".campaignid = s.campaignid)

                     SubPlan

                       ->  Result  (cost=3.45..3.46 rows=1 width=0)
(never executed)

                             InitPlan

                               ->  Limit  (cost=0.00..3.45 rows=1
width=4) (never executed)

                                     ->  Index Scan Backward using
p_phonestatus_pkey on p_phonestatus s2  (cost=0.00..6.90 rows=2
width=4) (never executed)

                                           Index Cond: (phoneid = $0)

                                           Filter: (sequenceid IS NOT NULL)



El 14 de julio de 2010 23:32, Alvaro Herrera
<alvherre(at)commandprompt(dot)com>escribió:

> Excerpts from OgiSer Tamade's message of mié jul 14 17:25:53 -0400 2010:
> > SELECT S.phoneid, S.sequenceid
> > FROM  d_campaigns C, d_phonestatus S
> > WHERE C.campaignid IN (17,16,15,14,13)   AND C.campaignid=S.campaignid
> AND
> > S.sequenceid=(
> >
> >              SELECT MAX(S2.sequenceid) FROM d_phonestatus S2 WHERE
> > S2.phoneid=S.phoneid  )
> >
> > AND (S.assignedto IS NULL OR (S.assignedto<>'A436MA' AND
> > (S.status='rejected' OR
> > S.status='error')))
> > AND (S.callbackdate <= NOW() OR S.callbackdate IS
> > NULL)
> > ORDER BY S.callbackdate, C.priority DESC, S.phoneid LIMIT 1
>
> Esta no es la misma consulta de la que mostraste el EXPLAIN.
>

In response to

Responses

pgsql-es-ayuda by date

Next:From: OgiSer TamadeDate: 2010-07-14 21:45:49
Subject: Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql
Previous:From: OgiSer TamadeDate: 2010-07-14 21:33:42
Subject: Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group