On Saturday, May 23, 2020, Vik Fearing <
vik@postgresfriends.org> wrote:
> Do we really want default_explain_analyze ?
> It sounds like bad news that EXPLAIN DELETE might or might not remove rows
> depending on the state of a variable.
I have had sessions where not using ANALYZE was the exception, not the
rule. I would much prefer to type EXPLAIN (ANALYZE OFF) in those cases.
Not sure about the feature as a whole but i’m strongly against having a GUC exist that conditions whether a query is actually executed.
David J.