Get prewarm extension status
get_prewarm_extension_statusChecks whether pg_prewarm and pg_buffercache extensions are installed and if pg_prewarm's autoprewarm worker is enabled via shared_preload_libraries.
Instructions
Report whether pg_prewarm (and the supporting pg_buffercache) are installed, and whether pg_prewarm is listed in shared_preload_libraries (the autoprewarm worker requires it). Returns an object with pg_prewarm_installed (bool), pg_buffercache_installed (bool), autoprewarm_libraries_present (bool), and shared_preload_libraries (the raw setting).
Example: get_prewarm_extension_status()
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pg_prewarm_installed | Yes | ||
| pg_buffercache_installed | Yes | ||
| shared_preload_libraries | Yes | ||
| autoprewarm_libraries_present | Yes |