Inspect live PostgreSQL waits locks and pressure before guessing at the bottleneck with pg_activity

Open a live PostgreSQL activity view during incidents so you can see sessions, waits, locks, and pressure before making a bad call.

Inspect live PostgreSQL waits locks and pressure before guessing at the bottleneck with pg_activity

Open a live PostgreSQL activity view during incidents so you can see sessions, waits, locks, and pressure before making a bad call.

Installation

Method 1, Agent Skill Exchange

Method 2, Git clone

git clone https://github.com/agentskillexchange/skills.git && cd skills/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity

Method 3, Download ZIP

  • Download the repository ZIP and extract skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity.

Method 4, Manual copy

  • Copy this skill folder into your local skills directory, then reload your agent tooling.

Method 5, Fork and sync

  • Fork the repository if you want to maintain local edits while syncing upstream changes.

Source