analyze_connections
Detect idle-in-transaction sessions, lock contention, and long-running queries on PostgreSQL to troubleshoot blocking and connection pool issues.
Instructions
Analyze active database connections. Detects idle-in-transaction sessions and lock contention between sessions (PostgreSQL), long-running queries flagged at >30 seconds, and connection pool utilization. Idle-in-transaction and lock contention detection are not available on MySQL — use this tool's output to investigate PostgreSQL-specific blocking scenarios. Not available for SQLite.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| timeout_ms | No | Connection timeout in milliseconds (default: 30000). Increase for slow or remote databases. |