Libraries loaded at server start (extensions, hooks).
At a glance
| Property | Value |
|---|---|
| Parameter | shared_preload_libraries |
| Category | Preset |
| Default | '' |
| Value type | boolean / enum / numeric |
| Change scope | Restart required |
What it does
Comma-separated shared libraries loaded into every backend at server start. Required by extensions that install hooks, such as pg_stat_statements and auto_explain.
How to apply a change
Requires a full server restart (postmaster context). Set it in postgresql.conf and restart PostgreSQL.
Inspect the current value and source with SHOW shared_preload_libraries; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'shared_preload_libraries';.
Tuning guidance
Add pg_stat_statements as a baseline observability tool. Each library adds startup cost; changes require a restart.