Re: contrib/pg_stat_statements 1202 - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: contrib/pg_stat_statements 1202
Date
Msg-id 87bpvliayg.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: contrib/pg_stat_statements 1202  ("Robert Haas" <robertmhaas@gmail.com>)
Responses Re: contrib/pg_stat_statements 1202  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-hackers
"Robert Haas" <robertmhaas@gmail.com> writes:

>> On the other hand, we don't have to
>> think of compatibility in EXPLAIN ANALYZE VERBOSE because it is newly
>> added in 8.4.
>
> Uh, it exists for me in 8.2.9.

The current behaviour is newly added in 8.4. In 8.2 it meant something
completely different and quite useless for end-users in any case, so backwards
compatibility isn't important.

What strikes me as a convenient approach is basically using EXPLAIN VERBOSE as
a playground where we feel free to add everything we think of. If people run a
command marked "VERBOSE" and complain it prints too much...

As stuff matures and becomes indispensable we could consider moving it to the
regular EXPLAIN or implement some way to specify precisely which data the user
wants. Or just say XML/table data/whatever will solve the problem for us.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication
support!


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SQL/MED compatible connection manager
Next
From: Tom Lane
Date:
Subject: Re: contrib/pg_stat_statements 1202