configuration_review
Review PostgreSQL configuration settings and provide tuning observations for memory, connections, autovacuum, logging, and extensions. Diagnose global performance issues.
Instructions
Reviews PostgreSQL configuration settings and provides tuning observations.
LEVEL: Server (PostgreSQL instance configuration)
USE FOR: configuration, settings, postgresql.conf, parameters, tuning, memory, extensions, "why is DB slow globally?", "is autovacuum configured correctly?", server tuning review. DO NOT USE FOR: database-level health (use database_health), query optimization (use query_optimizer), replication settings (use replication_status), table-specific issues (use maintenance_analysis).
INCLUDE OPTIONS:
'all': Everything (default)
'memory': shared_buffers, effective_cache_size, work_mem analysis
'connections': max_connections, current utilization, pooling recommendations
'logging': log_min_duration_statement, log_checkpoints, statement_timeout
'autovacuum': autovacuum enabled, workers, thresholds
'extensions': Installed extensions, recommended extensions not installed
Examples: configuration_review() - Full configuration review configuration_review(include='memory') - Memory settings only configuration_review(include='connections') - Connection limits only configuration_review(include='autovacuum') - Autovacuum settings only configuration_review(include='logging') - Logging configuration configuration_review(include='extensions') - Installed extensions
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include | No | What to include: 'all', 'memory', 'connections', 'logging', 'autovacuum', 'extensions' | all |
| url | No | Database URL for auto-connection | |
| format | No | Output format: 'json' or 'markdown' | json |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |