Building a postgres advisor cli. (update & fixes) How to use: just point it at a db. it finds full-table scans and indexes nobody is using. It gives actionable sql Unused index report , and…

We can now check for unused indexes now. this is so useful as this gives you clear view which indexes are used and which are not so you can safely remove them. postgres built in functions like…

Almost dropped a table in today because I forgot EXPLAIN ANALYZE actually runs the query 💀 changed to pure JSON execution plans, added a regex param sanitizer, and built a recursive Go tree-walker…

Made some progress on pg_advisor today. It now fetches query stats from Postgres and can generate JSON EXPLAIN plans for queries. under the hood it uses Explain and pg_stat_statements Slowly turning…