Postgres slow-query audit, every fix measured on a copy by Jago WesterduinPostgres slow-query audit, every fix measured on a copy by Jago Westerduin
Postgres slow-query audit, every fix measured on a copyJago Westerduin
Cover image for Postgres slow-query audit, every fix measured on a copy
Your app got slow and nobody knows which queries are to blame. I find the slowest queries, read each execution plan, name the cause with the numbers from the plan, and prove each fix on a copy of your database before anything touches production.
What you get. The slow queries ranked by the time they cost you. For each one, the cause in plain words, the index or rewrite that fixes it, and the time before and after. A check that every fixed query returns the same rows, and the indexes that are not worth adding.
Proof. On a test shop with 1 million orders, ten slow queries went from 13.4 s to 116 ms in total. On 15 queries written after the tool was built, it named 8 of 10 causes and left all 5 healthy queries alone.
Nothing changes on your live database without your go-ahead. 14 days of questions after delivery.
Starting at$350
Duration1 week
Tags
PostgreSQL
Python
Database Engineer
Service provided by
Jago Westerduin proThe Hague, Netherlands
Postgres slow-query audit, every fix measured on a copyJago Westerduin
Starting at$350
Duration1 week
Tags
PostgreSQL
Python
Database Engineer
Cover image for Postgres slow-query audit, every fix measured on a copy
Your app got slow and nobody knows which queries are to blame. I find the slowest queries, read each execution plan, name the cause with the numbers from the plan, and prove each fix on a copy of your database before anything touches production.
What you get. The slow queries ranked by the time they cost you. For each one, the cause in plain words, the index or rewrite that fixes it, and the time before and after. A check that every fixed query returns the same rows, and the indexes that are not worth adding.
Proof. On a test shop with 1 million orders, ten slow queries went from 13.4 s to 116 ms in total. On 15 queries written after the tool was built, it named 8 of 10 causes and left all 5 healthy queries alone.
Nothing changes on your live database without your go-ahead. 14 days of questions after delivery.
$350