A few Rails apps I have worked on have unused indexes silently slowing down writes, tables that havent been vacuumed in weeks, and bloat creeping up with nobody noticing. You can check these things manually with pg_stat queries but nobody does it consistently.
I built Lantern to automate this. You add the lantern-rails gem and it collects pg_stat metrics every 5 minutes through your existing ActiveRecord connection. You get a 0-100 health score covering cache hit ratio, index usage, bloat, vacuum health, and connection utilization. It also tags each snapshot with your git SHA so you can see which deploy changed your metrics.
On my own production app it found 12 unused indexes, 5 tables that had never been vacuumed, and a bloat ratio of 12.7 percent. No credentials leave your app, no Redis, no external agent.
Free tier is 1 database with 3 day history. Would love to hear what Postgres metrics matter most to you.
Top comments (0)