# 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.

- Skill: `agentskillexchange/inspect-live-postgresql-waits-locks-and-pressure-before-gues` (Agent Skill)
- Install (CLI): `npx skillmds@latest add agentskillexchange/inspect-live-postgresql-waits-locks-and-pressure-before-gues`
- Raw SKILL.md: https://api.skillmd.com/api/skills/agentskillexchange/inspect-live-postgresql-waits-locks-and-pressure-before-gues/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: agentskillexchange (https://skillmd.com/u/agentskillexchange)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/agentskillexchange/inspect-live-postgresql-waits-locks-and-pressure-before-gues

---


# 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.

## Prerequisites

PostgreSQL connection access, pg_activity installation, terminal access to the target environment

## Installation

Use the upstream install or setup path that matches your environment:
- $ pipx install "pg_activity[psycopg]"
- $ git clone https://github.com/dalibo/pg_activity.git
- $ git clone https://github.com/dalibo/pg_activity

Requirements and caveats from upstream:
- [![Latest PyPI version](https://img.shields.io/pypi/v/pg_activity.svg)](https://pypi.python.org/pypi/pg_activity)
- pg\_activity can be installed using pip on Python 3.8 or later along with
- pg_activity must be the same user running postgresql server (postgres by

Basic usage or getting-started notes:
- ## From distribution packages
- The simplest way to install pg\_activity is through the package manager of your
- Linux distribution, if it ships with a package. E.g., on Debian-based

- Source: https://github.com/dalibo/pg_activity
- Extracted from upstream docs: https://raw.githubusercontent.com/dalibo/pg_activity/HEAD/README.md

## Documentation

- https://github.com/dalibo/pg_activity

## Source

- [Agent Skill Exchange](https://agentskillexchange.com/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity/)