{"id":"615baf80-a45e-473f-bfec-3c901c05195e","shortId":"bTxcE3","kind":"skill","title":"PostgreSQL Vacuum Deadlock Runbook","tagline":"Automates PostgreSQL vacuum and autovacuum troubleshooting via pg_stat_user_tables, pg_locks, and pg_stat_activity views. Detects table bloat using pgstattuple extension and generates remediation SQL for long-running transaction conflicts.","description":"# PostgreSQL Vacuum Deadlock Runbook\n\nAutomates PostgreSQL vacuum and autovacuum troubleshooting via pg_stat_user_tables, pg_locks, and pg_stat_activity views. Detects table bloat using pgstattuple extension and generates remediation SQL for long-running transaction conflicts.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- npm install pg\n- From your workspace root run yarn and then yarn lerna bootstrap\n- Run yarn test to run all the tests.\n\nRequirements and caveats from upstream:\n- # node-postgres\n- ![Build Status](https://github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)\n- Non-blocking PostgreSQL client for Node.js. Pure JavaScript and optional native libpq bindings.\n\nBasic usage or getting-started notes:\n- ## Documentation\n- Each package in this repo should have its own readme more focused on how to develop/contribute. For overall documentation on the project and the related modules managed by this repo please see:\n- ### Features\n\n- Source: https://github.com/brianc/node-postgres\n- Extracted from upstream docs: https://raw.githubusercontent.com/brianc/node-postgres/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/postgresql-vacuum-deadlock-runbook/)","tags":["postgresql","vacuum","deadlock","runbook","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-vacuum-deadlock-runbook","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/postgresql-vacuum-deadlock-runbook","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,271 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:11:50.547Z","embedding":null,"createdAt":"2026-05-18T13:18:29.676Z","updatedAt":"2026-05-18T19:11:50.547Z","lastSeenAt":"2026-05-18T19:11:50.547Z","tsv":"'/brianc/node-postgres':182 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':123 '/brianc/node-postgres/head/readme.md':189 '/skills/postgresql-vacuum-deadlock-runbook/)':196 'activ':21,59 'agent':191 'agentskillexchange.com':195 'agentskillexchange.com/skills/postgresql-vacuum-deadlock-runbook/)':194 'autom':5,43 'autovacuum':9,47 'basic':138 'bind':137 'bloat':25,63 'block':126 'bootstrap':102 'build':119 'caveat':113 'client':128 'conflict':38,76 'deadlock':3,41 'detect':23,61 'develop/contribute':161 'doc':186 'document':145,164 'environ':88 'exchang':193 'extens':28,66 'extract':183 'featur':178 'focus':157 'generat':30,68 'get':142 'getting-start':141 'github.com':122,181 'github.com/brianc/node-postgres':180 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':121 'instal':77,81,90 'javascript':132 'lerna':101 'libpq':136 'lock':17,55 'long':35,73 'long-run':34,72 'manag':172 'match':86 'modul':171 'nativ':135 'node':117 'node-postgr':116 'node.js':130 'non':125 'non-block':124 'note':144 'npm':89 'option':134 'overal':163 'packag':147 'path':84 'pg':12,16,19,50,54,57,91 'pgstattupl':27,65 'pleas':176 'postgr':118 'postgresql':1,6,39,44,127 'project':167 'pure':131 'raw.githubusercontent.com':188 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':187 'readm':155 'relat':170 'remedi':31,69 'repo':150,175 'requir':111 'root':95 'run':36,74,96,103,107 'runbook':4,42 'see':177 'setup':83 'skill':192 'skill-postgresql-vacuum-deadlock-runbook' 'sourc':179,190 'source-agentskillexchange' 'sql':32,70 'start':143 'stat':13,20,51,58 'status':120 'tabl':15,24,53,62 'test':105,110 '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' 'transact':37,75 'troubleshoot':10,48 'upstream':80,115,185 'usag':139 'use':26,64,78 'user':14,52 'vacuum':2,7,40,45 'via':11,49 'view':22,60 'workspac':94 'yarn':97,100,104","prices":[{"id":"4ad8d993-4e1a-465a-bc58-2edc18fd43d2","listingId":"615baf80-a45e-473f-bfec-3c901c05195e","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:18:29.676Z"}],"sources":[{"listingId":"615baf80-a45e-473f-bfec-3c901c05195e","source":"github","sourceId":"agentskillexchange/skills/postgresql-vacuum-deadlock-runbook","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-vacuum-deadlock-runbook","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:29.676Z","lastSeenAt":"2026-05-18T19:11:50.547Z"}],"details":{"listingId":"615baf80-a45e-473f-bfec-3c901c05195e","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-vacuum-deadlock-runbook","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":"94a56ea137a2bb1c0c82ca346bd0e01ddb21afe5","skill_md_path":"skills/postgresql-vacuum-deadlock-runbook/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-vacuum-deadlock-runbook"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Vacuum Deadlock Runbook","description":"Automates PostgreSQL vacuum and autovacuum troubleshooting via pg_stat_user_tables, pg_locks, and pg_stat_activity views. Detects table bloat using pgstattuple extension and generates remediation SQL for long-running transaction conflicts."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-vacuum-deadlock-runbook"},"updatedAt":"2026-05-18T19:11:50.547Z"}}