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?
On Fri, Mar 4, 2016 at 3:06 PM, Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com> wrote:
No, these messages are not confuse; I just wanted to show output
Then when don't you add "ANALYZE" to those commands and show meaningful output instead of showing us useless errors?
To be more clear, you need to run a query that will complete in our lifetime (and without an OOM error) with all three of ANALYZE, BUFFERS, and TIMING specified for the EXPLAIN.
