Show Active PostgreSQL Queries
pg_active_queriesFind long-running queries, blocked transactions, and performance bottlenecks by listing all active database queries, excluding idle connections.
Instructions
List all currently running queries in the database (excludes idle connections and the MCP server itself).
Args:
min_duration_seconds: Only show queries running longer than N seconds (default: 0 = all active)
include_idle_in_transaction: Include connections stuck in idle-in-transaction state (default: true)
response_format: Output format
Returns: JSON: { queries: ActiveQuery[], count: number } Markdown: table with PID, user, state, wait event, duration, query text
Useful for finding long-running queries, blocked transactions, and identifying performance bottlenecks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| min_duration_seconds | No | Minimum query duration in seconds (0 = all) | |
| include_idle_in_transaction | No | Include idle-in-transaction connections | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |