Skip to content
JM.
Back to work

Postgres Query Toolkit

PLACEHOLDER — CLI that surfaces slow queries, missing indexes, and unused ones from pg_stat_statements.

Stack
Node.js · TypeScript · PostgreSQL
Links
GitHub

DUMMY CONTENT. Replace before launch.

The problem

Placeholder. Reading pg_stat_statements by hand every incident.

What I built

Placeholder. A CLI ranking queries by total time, flagging sequential scans on large tables, and listing indexes never used.

Architecture

Placeholder.

Results

Placeholder. Found three missing indexes in the first run on production.

What I'd do differently

Placeholder. Should output machine-readable JSON for CI, not just a table.

Next projectWebhook Delivery Service