| From: | Felipe de Jesús Molina Bravo <fjmolinabravo(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, 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:56:55 |
| Message-ID: | CALrs2KO3J=vw_fyXhEpP=m63RtnYAYzrG6RDQaxCn9x+1-8tQw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
when i run without the ANALIZE the output is:
pba=# EXPLAIN ( TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb a LEFT
join _gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama );
ERROR: la opción BUFFERS de EXPLAIN requiere ANALYZE
pba=# EXPLAIN ( TIMING) SELECT idprodxintegrar FROM _gc_tb a LEFT join
_gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama );
ERROR: la opción TIMING de EXPLAIN requiere ANALYZE
if i run only with EXPLAIN the output is:
QUERY
PLAN
--------------------------------------------------------------------------------------
Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
-> Seq Scan on _gc_tb a (cost=0.00..3321.30 rows=120130 width=66)
-> Bitmap Heap Scan on _gc_cat b (cost=0.03..4.06 rows=2 width=70)
Recheck Cond: ((arama <@ a.arama) AND (a.arama <@ arama))
-> Bitmap Index Scan on _gc_cat_arama_gin (cost=0.00..0.03
rows=2 width=0)
Index Cond: ((arama <@ a.arama) AND (a.arama <@ arama))
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-03-04 21:58:26 | Re: query reboot pgsql 9.5.1 |
| Previous Message | Alvaro Herrera | 2016-03-04 21:49:11 | Re: query reboot pgsql 9.5.1 |