Re: Default gucs for EXPLAIN

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Default gucs for EXPLAIN
Date: 2020-05-24 08:57:49
Message-ID: alpine.DEB.2.22.394.2005241053030.463947@pseudo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> The safe option seems not allowing to change ANALYZE option default.

> EXPLAIN [ ANALYZE ] [ VERBOSE ] statement

Some more thoughts:

An argument for keeping it that way is that there is already a special
syntax to enable ANALYSE explicitely, which as far as I am concerned I
only ever attempt after having tried a "EXPLAIN query" first.

Moreover, having to just add the ANALYSE keyword is kind of cheap, while
having to type "(some list of options)" is pretty cumbersome.

--
Fabien.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2020-05-24 09:25:28 Re: Default gucs for EXPLAIN
Previous Message Fabien COELHO 2020-05-24 07:31:47 Re: Default gucs for EXPLAIN