{"id":"7c0a85b6-2607-47cd-a20d-96f9740b3db1","shortId":"FnLpvy","kind":"skill","title":"PostgreSQL Slow Query Analyzer","tagline":"Queries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency. Runs EXPLAIN ANALYZE on worst offenders and suggests index additions, rewrite candidates, or vacuum triggers. Works on RDS and Supabase.","description":"# PostgreSQL Slow Query Analyzer\n\nQueries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency. Runs EXPLAIN ANALYZE on worst offenders and suggests index additions, rewrite candidates, or vacuum triggers. Works on RDS and Supabase.\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-slow-query-analyzer/)","tags":["postgresql","slow","query","analyzer","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-slow-query-analyzer","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-slow-query-analyzer","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,299 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.336Z","embedding":null,"createdAt":"2026-05-18T13:18:29.489Z","updatedAt":"2026-05-18T19:11:50.336Z","lastSeenAt":"2026-05-18T19:11:50.336Z","tsv":"'/brianc/node-postgres':200 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':141 '/brianc/node-postgres/head/readme.md':207 '/skills/postgresql-slow-query-analyzer/)':214 'activ':12,59 'addit':37,84 'agent':209 'agentskillexchange.com':213 'agentskillexchange.com/skills/postgresql-slow-query-analyzer/)':212 'analyz':4,30,51,77 'basic':156 'bind':155 'block':144 'bootstrap':120 'build':137 'call':26,73 'candid':39,86 'caveat':131 'client':146 'develop/contribute':179 'doc':204 'document':163,182 'environ':106 'exchang':211 'execut':21,68 'explain':29,76 'extract':201 'featur':196 'focus':175 'frequenc':27,74 'get':160 'getting-start':159 'github.com':140,199 'github.com/brianc/node-postgres':198 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':139 'index':36,83 'instal':95,99,108 'javascript':150 'latenc':24,71 'lerna':119 'libpq':154 'manag':190 'match':104 'mean':23,70 'modul':189 'nativ':153 'node':135 'node-postgr':134 'node.js':148 'non':143 'non-block':142 'note':162 'npm':107 'offend':33,80 'option':152 'overal':181 'packag':165 'path':102 'pg':6,10,53,57,109 'pleas':194 'postgr':136 'postgresql':1,48,145 'project':185 'pure':149 'queri':3,5,18,50,52,65 'raw.githubusercontent.com':206 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':205 'rds':45,92 'readm':173 'relat':188 'repo':168,193 'requir':129 'rewrit':38,85 'root':113 'run':28,75,114,121,125 'see':195 'setup':101 'skill':210 'skill-postgresql-slow-query-analyzer' 'slow':2,17,49,64 'sourc':197,208 'source-agentskillexchange' 'start':161 'stat':7,11,54,58 'statement':8,55 'status':138 'suggest':35,82 'supabas':47,94 'surfac':14,61 'test':123,128 'time':22,69 'top':16,63 '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' 'total':20,67 'trigger':42,89 'upstream':98,133,203 'usag':157 'use':96 'vacuum':41,88 'work':43,90 'workspac':112 'worst':32,79 'yarn':115,118,122","prices":[{"id":"f5f8efe9-d5f6-4517-9ba5-4fa9d79b3ed4","listingId":"7c0a85b6-2607-47cd-a20d-96f9740b3db1","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.489Z"}],"sources":[{"listingId":"7c0a85b6-2607-47cd-a20d-96f9740b3db1","source":"github","sourceId":"agentskillexchange/skills/postgresql-slow-query-analyzer","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-slow-query-analyzer","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:29.489Z","lastSeenAt":"2026-05-18T19:11:50.336Z"}],"details":{"listingId":"7c0a85b6-2607-47cd-a20d-96f9740b3db1","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-slow-query-analyzer","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":"5b87e125b05500c8119b5a10e3b8c47ddc0c79e7","skill_md_path":"skills/postgresql-slow-query-analyzer/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-slow-query-analyzer"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Slow Query Analyzer","description":"Queries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency. Runs EXPLAIN ANALYZE on worst offenders and suggests index additions, rewrite candidates, or vacuum triggers. Works on RDS and Supabase."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-slow-query-analyzer"},"updatedAt":"2026-05-18T19:11:50.336Z"}}