review_settings
Analyze PostgreSQL configuration settings to identify performance issues and receive optimization recommendations for memory, checkpoints, WAL, autovacuum, and connection parameters based on system resources and best practices.
Instructions
Review PostgreSQL configuration settings and get recommendations.
Analyzes key performance-related settings:
Memory settings (shared_buffers, work_mem, etc.)
Checkpoint settings
WAL settings
Autovacuum settings
Connection settings
Compares against best practices and system resources.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| category | No | Category of settings to review | all |
| include_all_settings | No | Include all settings, not just performance-related ones |