Show HN: iCli – Postgres health reporter and index optimizer

Show HN: iCli – Postgres health reporter and index optimizer abhiraj-ku / iCli Public Notifications You must be signed in to change notification settings Fork 0 Star 1 Branches Tags Open more actions menu Latest commit History 33 Commits 33 Commits Folders and files Name Name Last commit message Last commit date .github/ workflows .github/ workflows assets assets cmd/ icli cmd/ icli internals internals .gitignore .gitignore .goreleaser.yaml .goreleaser.yaml CONTRIBUTING.md CONTRIBUTING.md LICENSE LICENSE README.md README.md go.mod go.mod go.sum go.sum Repository files navigation iCli - PostgreSQL query and index advisor iCli is a Go CLI that reads PostgreSQL query statistics, explains the most expensive queries, identifies execution-plan bottlenecks, detects missing foreign key indexes, and reports unused indexes. Note 🔒 Read-Only Guarantee : iCli only executes read-only SQL queries ( SELECT metadata and EXPLAIN plan analysis).

This ProductUpdate is relevant to the technology intelligence record because it involves GitHub, Meta, Apple, Intel. The source article should remain the factual reference for follow-up coverage.

• abhiraj-ku / iCli Public Notifications You must be signed in to change notification settings Fork 0 Star 1 Branches Tags Open more actions menu Latest commit History 33 Commits 33 Commits Folders and files Name Name Last commit message Last commit date .github/ workflows .github/ workflows assets assets cmd/ icli cmd/ icli internals internals .gitignore .gitignore .goreleaser.yaml .goreleaser.yaml CONTRIBUTING.md CONTRIBUTING.md LICENSE LICENSE README.md README.md go.mod go.mod go.sum go.sum Repository files navigation iCli - PostgreSQL query and index advisor iCli is a Go CLI that reads PostgreSQL query statistics, explains the most expensive queries, identifies execution-plan bottlenecks, detects missing foreign key indexes, and reports unused indexes.
• Note 🔒 Read-Only Guarantee : iCli only executes read-only SQL queries ( SELECT metadata and EXPLAIN plan analysis).
• It never mutates, inserts, or deletes any data in your database.
• Demo Features Expensive Query Analysis : Identifies slow and resource-heavy queries using pg_stat_statements .
• Execution Plan Profiling : Runs EXPLAIN (FORMAT JSON) and detects plan bottlenecks (e.g., sequential scans, disk sort spillage, inefficient joins).
• Missing Foreign Key Index Detection : Finds foreign key constraints on child tables without a covering index, preventing severe sequential scan table locks on parent UPDATE or DELETE operations.