get_database_stats
Retrieve comprehensive PostgreSQL database statistics including transaction counts, I/O performance, tuple operations, and system metrics for performance analysis and monitoring.
Instructions
[Tool Purpose]: Get comprehensive database-wide statistics and performance metrics
[Exact Functionality]:
Show database-wide transaction statistics (commits, rollbacks)
Display block I/O statistics (disk reads vs buffer hits)
Provide tuple operation statistics (returned, fetched, inserted, updated, deleted)
Show temporary file usage and deadlock counts
Include checksum failure information and I/O timing data
[Required Use Cases]:
When user requests "database statistics", "database performance", "transaction stats", etc.
When analyzing overall database performance and activity
When investigating I/O performance or buffer cache efficiency
When checking for deadlocks or temporary file usage
[Strictly Prohibited Use Cases]:
Requests for statistics reset or modification
Requests for database configuration changes
Requests for performance tuning actions
Returns: Comprehensive database statistics including transactions, I/O, tuples, and performance metrics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |