Originally published on the Hubfly space blog . By Octave, drafted with AI, tested on Hubfly space.
TL;DR
What you get: a repeatable way to find the queries that cost your database the most time, prove why they're slow, and fix them, with before-and-after numbers.
Who it's for: developers running Postgres for a real app who don't have a DBA.
Time needed: about 20 minutes, plus a few minutes for the database to start.
Cost: a Nano managed Postgres on Hubfly space is $2.02 a month (about $0.003 an hour). Delete the instance when you're done and following along costs well under a cent.
Checked on: PostgreSQL 18.6 on a Hubfly space Nano instance, October 2026.
Your app was fast in the demo. Now the orders page takes a second to load and nobody knows why. You could guess, add a few indexes and hope. Or you could ask Postgres which queries actually eat its time, fix the worst one, and measure the result.
In this guide you'll do exactly that.…