{"skill":{"slug":"postgres-query-optimizer","displayName":"Postgres Query Optimizer","summary":"Analyze slow PostgreSQL queries, interpret EXPLAIN ANALYZE output, identify performance bottlenecks, and recommend indexes, query rewrites, and configuration...","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":38,"installsAllTime":0,"installsCurrent":0,"stars":0,"versions":1},"createdAt":1777509748154,"updatedAt":1777510310702},"latestVersion":{"version":"1.0.0","createdAt":1777509748154,"changelog":"Initial release—analyzes PostgreSQL query performance, interprets EXPLAIN ANALYZE output, and provides actionable optimization recommendations.\n\n- Detects performance bottlenecks such as sequential scans, inefficient joins, missing or suboptimal indexes, and query plan issues.\n- Suggests index creation (including partial, covering, composite, and expression indexes) based on query and schema patterns.\n- Offers advice on query rewrites and PostgreSQL configuration tuning (e.g., work_mem adjustments).\n- Parses query execution plans node by node, flagging costly operations and providing explanations.\n- Helps interpret table statistics, index definitions, and bloat information to further improve performance.","license":"MIT-0"},"metadata":null,"owner":{"handle":"charlie-morrison","userId":"s17cttbdxry5kkyafjw983mq8s83p4y3","displayName":"charlie-morrison","image":"https://avatars.githubusercontent.com/u/271589886?v=4"},"moderation":null}