{"id":"e34c1444-fbb3-4f57-b53e-246c84e3e0fb","shortId":"QsKaHr","kind":"skill","title":"Inspect live PostgreSQL waits locks and pressure before guessing at the bottleneck with pg_activity","tagline":"Open a live PostgreSQL activity view during incidents so you can see sessions, waits, locks, and pressure before making a bad call.","description":"# Inspect live PostgreSQL waits locks and pressure before guessing at the bottleneck with pg_activity\n\nOpen a live PostgreSQL activity view during incidents so you can see sessions, waits, locks, and pressure before making a bad call.\n\n## Prerequisites\n\nPostgreSQL connection access, pg_activity installation, terminal access to the target environment\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- $ pipx install \"pg_activity[psycopg]\"\n- $ git clone https://github.com/dalibo/pg_activity.git\n- $ git clone https://github.com/dalibo/pg_activity\n\nRequirements and caveats from upstream:\n- [![Latest PyPI version](https://img.shields.io/pypi/v/pg_activity.svg)](https://pypi.python.org/pypi/pg_activity)\n- pg\\_activity can be installed using pip on Python 3.8 or later along with\n- pg_activity must be the same user running postgresql server (postgres by\n\nBasic usage or getting-started notes:\n- ## From distribution packages\n- The simplest way to install pg\\_activity is through the package manager of your\n- Linux distribution, if it ships with a package. E.g., on Debian-based\n\n- Source: https://github.com/dalibo/pg_activity\n- Extracted from upstream docs: https://raw.githubusercontent.com/dalibo/pg_activity/HEAD/README.md\n\n## Documentation\n\n- https://github.com/dalibo/pg_activity\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity/)","tags":["inspect","live","postgresql","waits","locks","and","pressure","before","guessing","the","bottleneck","with"],"capabilities":["skill","source-agentskillexchange","skill-inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,505 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:10:56.417Z","embedding":null,"createdAt":"2026-05-18T13:17:12.026Z","updatedAt":"2026-05-18T19:10:56.417Z","lastSeenAt":"2026-05-18T19:10:56.417Z","tsv":"'/dalibo/pg_activity':114,192,203 '/dalibo/pg_activity.git':109 '/dalibo/pg_activity/head/readme.md':199 '/pypi/v/pg_activity.svg)](https://pypi.python.org/pypi/pg_activity)':125 '/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity/)':210 '3.8':135 'access':78,83 'activ':15,20,52,57,80,103,127,141,168 'agent':205 'agentskillexchange.com':209 'agentskillexchange.com/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity/)':208 'along':138 'bad':36,73 'base':188 'basic':152 'bottleneck':12,49 'call':37,74 'caveat':117 'clone':106,111 'connect':77 'debian':187 'debian-bas':186 'distribut':160,177 'doc':196 'document':200 'e.g':184 'environ':87,99 'exchang':207 'extract':193 'get':156 'getting-start':155 'git':105,110 'github.com':108,113,191,202 'github.com/dalibo/pg_activity':112,190,201 'github.com/dalibo/pg_activity.git':107 'guess':9,46 'img.shields.io':124 'img.shields.io/pypi/v/pg_activity.svg)](https://pypi.python.org/pypi/pg_activity)':123 'incid':23,60 'inspect':1,38 'instal':81,88,92,101,130,166 'later':137 'latest':120 'linux':176 'live':2,18,39,55 'lock':5,30,42,67 'make':34,71 'manag':173 'match':97 'must':142 'note':158 'open':16,53 'packag':161,172,183 'path':95 'pg':14,51,79,102,126,140,167 'pip':132 'pipx':100 'postgr':150 'postgresql':3,19,40,56,76,148 'prerequisit':75 'pressur':7,32,44,69 'psycopg':104 'pypi':121 'python':134 'raw.githubusercontent.com':198 'raw.githubusercontent.com/dalibo/pg_activity/head/readme.md':197 'requir':115 'run':147 'see':27,64 'server':149 'session':28,65 'setup':94 'ship':180 'simplest':163 'skill':206 'skill-inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity' 'sourc':189,204 'source-agentskillexchange' 'start':157 'target':86 'termin':82 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'upstream':91,119,195 'usag':153 'use':89,131 'user':146 'version':122 'view':21,58 'wait':4,29,41,66 'way':164","prices":[{"id":"22633264-6c47-4e68-aaf0-25a3096b7b79","listingId":"e34c1444-fbb3-4f57-b53e-246c84e3e0fb","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:17:12.026Z"}],"sources":[{"listingId":"e34c1444-fbb3-4f57-b53e-246c84e3e0fb","source":"github","sourceId":"agentskillexchange/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity","isPrimary":false,"firstSeenAt":"2026-05-18T13:17:12.026Z","lastSeenAt":"2026-05-18T19:10:56.417Z"}],"details":{"listingId":"e34c1444-fbb3-4f57-b53e-246c84e3e0fb","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"127fd4d3bdd7b038b8ba352e182f58df887ba292","skill_md_path":"skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Inspect live PostgreSQL waits locks and pressure before guessing at the bottleneck with pg_activity","description":"Open a live PostgreSQL activity view during incidents so you can see sessions, waits, locks, and pressure before making a bad call."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/inspect-live-postgresql-waits-locks-and-pressure-before-guessing-at-the-bottleneck-with-pg-activity"},"updatedAt":"2026-05-18T19:10:56.417Z"}}