PostgreSQL is a highly customizable object-relational database system used in many high volume environments. With a very small amount of instrumentation, we can reliably track down the source(s) of any slowness or odd behavior in just a few clicks. For example: figuring out what the overall distribution of query latency is.
By consuming Postgres logs and parsing them into structured data, Honeycomb makes it possible to answer deep questions about database operation instantly.
With Postgres events in Honeycomb, you can ask questions like:
- What does the overall distribution of query latency look like?
- Which queries are responsible for the spikes in query volume that we’re seeing?
- How did our query workload change after the latest deploy?
- Which query families are most common?
- Are queries uniformly slow, or are there latency outliers?
- Is one client sending too much traffic?
- How is our workload changing over time?