Re: explain plans with information about (modified) gucs
Alvaro Herrera <alvherre@2ndquadrant.com>
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Sergei Agalakov <sergei.agalakov@gmail.com>, pgsql-hackers@postgresql.org
Date: 2019-01-14T22:13:07Z
Lists: pgsql-hackers
On 2019-Jan-14, Tomas Vondra wrote: > The one slightly annoying issue is that currently all the options are > formatted as text, including e.g. cpu_tuple_cost. That's because the GUC > options may have show hook, so I can't access the value directly (not > sure if there's an option around it). I think the problem is that you'd have to know how to print the value, which can be in one of several different C types. You'd have to grow some more infrastructure in the GUC tables, I think, and that doesn't seem worth the trouble. Printing as text seems enough. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Add SETTINGS option to EXPLAIN, to print modified settings.
- ea569d64ac71 12.0 landed
-
Switch some palloc/memset calls to palloc0
- 1983af8e8993 12.0 cited