get_bgwriter_stats
Analyze PostgreSQL background writer and checkpoint performance statistics to monitor I/O efficiency and troubleshoot checkpoint-related issues.
Instructions
[Tool Purpose]: Analyze background writer and checkpoint performance statistics with version compatibility
[Exact Functionality]:
Show checkpoint execution statistics (timed vs requested)
Display checkpoint timing information (write and sync times)
Provide buffer writing statistics by different processes
Analyze background writer performance and efficiency
Automatically adapts to PostgreSQL version (15+ uses separate checkpointer view)
[Required Use Cases]:
When user requests "checkpoint stats", "bgwriter performance", "buffer stats", etc.
When analyzing I/O performance and checkpoint impact
When investigating background writer efficiency
When troubleshooting checkpoint-related performance issues
[Strictly Prohibited Use Cases]:
Requests for checkpoint execution or configuration changes
Requests for background writer parameter modifications
Requests for statistics reset
Returns: Background writer and checkpoint performance statistics with version-appropriate data
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |