I use pganalyze for monitoring our Postgres database daily for performance issues. It helps identify long-running queries and pinpoint queries that are constantly reading and writing to our database. I really like being able to see what's going on performance-wise with our database.

I like that pganalyze just works and they keep adding new features to really get into the nitty gritty of understanding how the system works. They give you expert insights, which feels like standing on the shoulders of PostgreSQL experts, allowing us to focus more on our application and business domain. I also enjoy the server log, query and auto-vacuum insights, table bloat, and query performance tuning via plan statistics and comparisons. The initial setup is quite easy, get the container, inject the database auth credentials, and set up some functions done.

I like the ease of setup with pganalyze; the setup process was smooth and straightforward. It has a significant impact on database support by identifying several missing indexes, which is super helpful for optimization. The customer support is excellent, with fast response times, typically within a few hours.