pg_ps
Monitor active database queries and processes on Heroku apps to identify long-running queries, track progress, debug performance issues, and view resource usage in real-time.
Instructions
Monitor active database queries and processes. Use this tool when you need to: 1) View currently executing queries, 2) Track query progress and resource usage, 3) Identify long-running or blocked queries, 4) Debug performance issues in real-time. The tool provides detailed visibility into database activity with optional verbose output.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| app | Yes | The name of the Heroku app whose database processes to view. | |
| database | No | Config var containing the connection string, unique name, ID, or alias of the database. To access another app's database, prepend the app name to the config var or alias with `APP_NAME::`. If omitted, DATABASE_URL is used. | |
| verbose | No | When true, shows additional query details including query plan and memory usage. |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"app": {
"description": "The name of the Heroku app whose database processes to view.",
"type": "string"
},
"database": {
"description": "Config var containing the connection string, unique name, ID, or alias of the database. To access another app's database, prepend the app name to the config var or alias with `APP_NAME::`. If omitted, DATABASE_URL is used.",
"type": "string"
},
"verbose": {
"description": "When true, shows additional query details including query plan and memory usage.",
"type": "boolean"
}
},
"required": [
"app"
],
"type": "object"
}