pg_kill
Terminate specific database processes on Heroku to stop stuck queries, clear blocking transactions, manage resource-heavy operations, and handle runaway processes with controlled, optional force termination.
Instructions
Terminate specific database processes. Use this tool when you need to: 1) Stop problematic or stuck queries, 2) Clear blocking transactions, 3) Manage resource-intensive operations, 4) Handle runaway processes safely. The tool provides controlled process termination with optional force mode.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
app | Yes | The name of the Heroku app whose database process to terminate. | |
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. | |
force | No | When true, forces immediate termination instead of graceful shutdown. | |
pid | Yes | The process ID to terminate, as shown by pg_ps. |