Postgres Pro
Downloads
Home   >   mailing lists

Thread: EXPLAIN (ANALYZE) broken

EXPLAIN (ANALYZE) broken

From
Kevin Grittner
Date:
Commit 2c92edad48796119c83d7dbe6c33425d1924626d has broken
EXPLAIN's ANALYZE option in parentheses, which also makes some
other options unusable.

test=# EXPLAIN (ANALYZE) SELECT 1;
ERROR:  syntax error at or near "ANALYZE"
LINE 1: EXPLAIN (ANALYZE) SELECT 1;               ^

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: EXPLAIN (ANALYZE) broken

From
Tom Lane
Date:
Kevin Grittner <kgrittn@ymail.com> writes:
> Commit 2c92edad48796119c83d7dbe6c33425d1924626d has broken
> EXPLAIN's ANALYZE option in parentheses, which also makes some
> other options unusable.

> test=# EXPLAIN (ANALYZE) SELECT 1;
> ERROR:� syntax error at or near "ANALYZE"
> LINE 1: EXPLAIN (ANALYZE) SELECT 1;
> �������������� ^

[ scratches head... ]  Coulda sworn I checked that.  Will look into it.
        regards, tom lane