Expose pg_stat_statements.track_planning Configuration Parameter
As a database administrator, platform engineer or developer
I want to be able to enable the pgstatstatements.track_planning configuration parameter.
Felix Wu
shared this idea
-
defaultdb=> CREATE EXTENSION pg_stat_statements;
CREATE EXTENSIONdefaultdb=> SELECT * FROM pg_settings WHERE name LIKE 'pg_stat_statements%';
name | setting | unit | category | short_desc | extra_desc | context | vartype | source | min_val | max_val | enumvals | boot_val | reset_val | sourcefile | sourceline | pending_restart
-----------------------------------+---------+------+--------------------+----------------------------------------------------------------------+------------+------------+---------+---------+---------+------------+----------------+----------+-----------+------------+------------+-----------------
pg_stat_statements.max | 5000 | | Customized Options | Sets the maximum number of statements tracked by pg_stat_statements. | | postmaster | integer | default | 100 | 1073741823 | | 5000 | 5000 | | | f
pg_stat_statements.save | on | | Customized Options | Save pg_stat_statements statistics across server shutdowns. | | sighup | bool | default | | | | on | on | | | f
pg_stat_statements.track | top | | Customized Options | Selects which statements are tracked by pg_stat_statements. | | superuser | enum | default | | | {none,top,all} | top | top | | | f
pg_stat_statements.track_planning | off | | Customized Options | Selects whether planning duration is tracked by pg_stat_statements. | | superuser | bool | default | | | | off | off | | | f
pg_stat_statements.track_utility | on | | Customized Options | Selects whether utility commands are tracked by pg_stat_statements. | | superuser | bool | default | | | | on | on | | | f
(5 rows)