Deploy PgHero in one click installation.
Open-source PostgreSQL performance dashboard for monitoring queries, indexes, and database health in real time.
What you can build with PgHero
PgHero is an open-source performance dashboard built specifically for PostgreSQL. It surfaces slow queries, unused indexes, bloated tables, duplicate indexes, invalid constraints, and connection counts in a clean web interface — no database expertise required to read what it shows. Every metric is PostgreSQL-specific, so the dashboard cuts straight to the information that matters for tuning and troubleshooting.
Self-hosting PgHero means your database credentials and query patterns never leave your infrastructure. Connect it to any PostgreSQL instance — a container on the same VPS, a remote managed database, or multiple databases at once — and get a persistent monitoring dashboard accessible through your browser.
Key features of PgHero
Slow query detection
PgHero ranks queries by total and average execution time so you can immediately identify which queries are degrading application performance.
Index analysis
Surfaces unused, duplicate, and missing indexes so you can clean up index bloat and add the indexes that will actually speed up your workload.
Space and bloat tracking
Shows table and index sizes with dead tuple counts, so you know when a VACUUM or REINDEX is needed before space becomes a problem.
Connection monitoring
Tracks active connections by user, database, and state so you can spot connection leaks and pool exhaustion before they cause outages.
Historical query stats
Captures query statistics over time and displays them with a time range slider, making it easy to correlate performance regressions with deploys or load changes.
Why run PgHero on Hostinger
Launch in one click
Get your application up and running instantly with a preconfigured setup. No manual installation or complex setup steps.
Security you can rely on
Keep your applications protected with a built-in firewall, DDoS protection, and continuous monitoring.
Built in Docker manager
Run and manage multiple Docker containers from one place. Deploy, update, and monitor your projects with ease.
Launch in one click
Get your application up and running instantly with a preconfigured setup. No manual installation or complex setup steps.
Security you can rely on
Keep your applications protected with a built-in firewall, DDoS protection, and continuous monitoring.
Built in Docker manager
Run and manage multiple Docker containers from one place. Deploy, update, and monitor your projects with ease.
Docker VPS hosting you can rely on
I'm incredibly happy with Hostinger's VPS hosting! Their uptime is consistently top-notch, keeping my site running smoothly. Whenever I've needed help, their technical support team has been quick, knowledgeable, and genuinely helpful.
Everything is smooth and great with Hostinger, the AI chat bot + human chat, if AI can't resolve your question. Oh and them VPS is just fire, no ups and downs. Thank you dev team and everyone else involved. Keep it up 🚀
Finally a VPS hosting company that does it right! Well-priced. Excellent portal that respects their users' time. Seamless backups. Good support. Reliable. Feels rock-solid.
I reached out to Hostinger support after losing access to my self-hosted n8n instance, and I couldn’t be more impressed. Hostinger Agent and Mohammad from the support team were incredibly patient and thorough.
Many thanks to Carla for helping me with this N8N upgrade on my Hostinger VPS. Professional and knowledgeable, thank you again Carla.
Hostinger VPS is absolutely outstanding. It just always works. It is always fast and stable. Never down, never crashes.
The company is doing well, I am very happy with the specific services I use through them. Not as expensive as some places with really great VPS set ups and price plans.