pgsql: Extend EXPLAIN to allow generic options to be specified.

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Extend EXPLAIN to allow generic options to be specified.
Дата
Msg-id 20090726233418.8114875331E@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Extend EXPLAIN to allow generic options to be specified.

The original syntax made it difficult to add options without making them
into reserved words.  This change parenthesizes the options to avoid that
problem, and makes provision for an explicit (and perhaps non-Boolean)
value for each option.  The original syntax is still supported, but only
for the two original options ANALYZE and VERBOSE.

As a test case, add a COSTS option that can suppress the planner cost
estimates.  This may be useful for including EXPLAIN output in the regression
tests, which are otherwise unable to cope with cross-platform variations in
cost estimates.

Robert Haas

Modified Files:
--------------
    pgsql/contrib/auto_explain:
        auto_explain.c (r1.5 -> r1.6)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/auto_explain/auto_explain.c?r1=1.5&r2=1.6)
    pgsql/doc/src/sgml/ref:
        explain.sgml (r1.44 -> r1.45)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/explain.sgml?r1=1.44&r2=1.45)
    pgsql/src/backend/commands:
        define.c (r1.104 -> r1.105)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/define.c?r1=1.104&r2=1.105)
        explain.c (r1.187 -> r1.188)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/explain.c?r1=1.187&r2=1.188)
        prepare.c (r1.97 -> r1.98)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/prepare.c?r1=1.97&r2=1.98)
    pgsql/src/backend/nodes:
        copyfuncs.c (r1.434 -> r1.435)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c?r1=1.434&r2=1.435)
        equalfuncs.c (r1.357 -> r1.358)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c?r1=1.357&r2=1.358)
    pgsql/src/backend/parser:
        gram.y (r2.672 -> r2.673)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.672&r2=2.673)
    pgsql/src/backend/tcop:
        utility.c (r1.310 -> r1.311)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c?r1=1.310&r2=1.311)
    pgsql/src/include/commands:
        explain.h (r1.39 -> r1.40)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/explain.h?r1=1.39&r2=1.40)
        prepare.h (r1.30 -> r1.31)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/prepare.h?r1=1.30&r2=1.31)
    pgsql/src/include/nodes:
        parsenodes.h (r1.397 -> r1.398)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.397&r2=1.398)

В списке pgsql-committers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: pgsql: Small stylistic improvement in recent FORCE QUOTE * code - use a
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Experiment with using EXPLAIN COSTS OFF in regression tests.