A007 Alter system vs postgresql.conf

[ane4ka]

A007 Alter system vs postgresql.conf

[NikolayS]

select sourcefile, count(*) from pg_settings group by 1 ;
                    sourcefile                     | count
---------------------------------------------------+-------
                                                   |   201
 /etc/postgresql/9.6/main/postgresql.conf          |    71
 /var/lib/postgresql/9.6/main/postgresql.auto.conf |     2
(3 rows)

[NikolayS]

# select sourcefile, count(*), (array_agg(name order by name) filter (where sourcefile is not null))[1:10] from pg_settings group by 1 ;
                    sourcefile                     | count |                                                                                                                  array_agg
---------------------------------------------------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 /etc/postgresql/9.6/main/postgresql.conf          |    71 | {archive_command,archive_mode,archive_timeout,auto_explain.log_analyze,auto_explain.log_buffers,auto_explain.log_format,auto_explain.log_min_duration,auto_explain.log_nested_statements,auto_explain.log_timing,auto_explain.log_triggers}
 /var/lib/postgresql/9.6/main/postgresql.auto.conf |     2 | {effective_cache_size,work_mem}
                                                   |   201 |
(3 rows)