Re: query reboot pgsql 9.5.1 - Mailing list pgsql-general

From David G. Johnston
Subject Re: query reboot pgsql 9.5.1
Date
Msg-id CAKFQuwbhPzeA7g2Q=7gGLpyCb5oRSygk-YbNaJ0TXdRWdP2C0Q@mail.gmail.com
Whole thread Raw
In response to Re: query reboot pgsql 9.5.1  (Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com>)
Responses Re: query reboot pgsql 9.5.1  (Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com>)
List pgsql-general
On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com> wrote:
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


​What is it about those error messages that is confusing you?​

​David J.

pgsql-general by date:

Previous
From: Felipe de Jesús Molina Bravo
Date:
Subject: Re: query reboot pgsql 9.5.1
Next
From: Felipe de Jesús Molina Bravo
Date:
Subject: Re: query reboot pgsql 9.5.1