From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Felipe de Jesús Molina Bravo <fjmolinabravo(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: query reboot pgsql 9.5.1 |
Date: | 2016-03-04 21:30:53 |
Message-ID: | CAKFQuwY0o6aO-sji1H3DYE-WuoJQ721SyayuDR7uFW2Ud1_QZg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Mar 4, 2016 at 2:16 PM, Felipe de Jesús Molina Bravo <
fjmolinabravo(at)gmail(dot)com> wrote:
> the output is:
>
> pba=# EXPLAIN (ANALYZE, TIMING, BUFFERS) SELECT idprodxintegrar FROM
> _gc_tb a LEFT join _gc_cat b on ( b.arama <@ a.arama and a.arama <@
> b.arama )
> ;
> QUERY
> PLAN
>
> ---------------------------------------------------------------------------------------------------------
> Nested Loop Left Join (cost=0.00..0.01 rows=1 width=4) (actual
> time=0.003..0.003 rows=0 loops=1)
> Join Filter: ((b.arama <@ a.arama) AND (a.arama <@ b.arama))
> -> Seq Scan on _gc_tb a (cost=0.00..0.00 rows=1 width=66) (actual
> time=0.002..0.002 rows=0 loops=1)
> -> Seq Scan on _gc_cat b (cost=0.00..0.00 rows=1 width=70) (never
> executed)
> Planning time: 0.206 ms
> Execution time: 0.074 ms
> (6 filas)
>
>
OK, so this _gc_tb is empty which means that an extremely fast execution
time is not unsurprising. If the other version actually contains data I
would expect that it would take considerably longer...
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Felipe de Jesús Molina Bravo | 2016-03-04 21:41:15 | Re: query reboot pgsql 9.5.1 |
Previous Message | Felipe de Jesús Molina Bravo | 2016-03-04 21:16:33 | Re: query reboot pgsql 9.5.1 |