After being in beta for several months, Perfalytics is now generally available. You can check it out here.
Perfalytics is my attempt to bring a new approach to database performance analysis. Instead of relying on information directly exposed by Postgres, Perfalytics integrates directly with your Postgres instance to collect information that other performance analysis tools cannot.
At query time, Perfalytics records statistics such as:
- The query plan used by each query.
- How much time was spent in each part of the query.
- How many blocks were read by each part of the query.
Normally you would need to run EXPLAIN ANALYZE, to get this kind of information. Perfalytics automatically tracks this information for you so you can look it up at the click of a button.
Because Perfalytics tracks all this information up front, you can do analyses you normally wouldn’t be able to do by running EXPLAIN ANALYZE one-off. You can produce a list of every single query plan an individual query uses and see exactly which ones are the slow ones.
If you want to give Perfalytics a try, you can try out the 14-day free trial by signing up here.