Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Stephen Frost <sfr...@snowman.net> writes: > > I'm generally in favor of doing something like what Tom is suggesting > > with VERBOSE, but I also feel like it should be the default for formats > > like JSON. If you're asking for the output in JSON, then we really > > should include everything that a flag like VERBOSE would contain because > > you're pretty clearly planning to copy/paste that output into something > > else to read it anyway. > > Meh --- I don't especially care for non-orthogonal behaviors like that. > If you wanted JSON but *not* all of the additional info, how would you > specify that? (The implementation I had in mind would make VERBOSE OFF > more or less a no-op, so that wouldn't get you there.)
You'd do it the same way you proposed for verbose- eg: BUFFERS OFF, et al, but, really, the point here is that what you're doing with the JSON result is fundamentally different- you're going to paste it into some other tool and it should be that tool's job to manage the visualization of it and what's included or not in what you see. Passing the information about what should be seen in the json-based EXPLAIN viewer by way of omitting things from the JSON output strikes me as downright odd, and doesn't give that other tool the ability to show that data if the users ends up wanting it without rerunning the query. > >> I do feel that it's a good idea to keep ANALYZE separate. "Execute > >> the query or not" is a mighty fundamental thing. I've never liked > >> that name for the option though --- maybe we could deprecate it > >> in favor of EXECUTE? > > > Let's not fool ourselves by saying we'd 'deprecate' it because that > > implies, at least to me, that there's some intention of later on > > removing it > > True, the odds of ever actually removing it are small :-(. I meant > mostly changing all of our docs to use the other spelling, except > for some footnote. Maybe we could call ANALYZE a "legacy spelling" > of EXECUTE. Sure, that'd be fine too. Thanks, Stephen
signature.asc
Description: PGP signature
