Episode 8 - X-Ray Vision for Your Queries | PgBadger
Listen now
Description
PgBadger is a PostgreSQL log analyzer with fully detailed reports and graphs. It is open source and is considered lightweight. While it doesn’t have the depth, probe capability or tool integration that EDB Postgres Enterprise Manager does, it’s particularly useful in helping you to analyze your slowest queries, and also does a good job of profiling Temporary Files, Connection Peak, Autovacuum/Autoanalyze, Checkpoints, etc which can help in demonstrating overall health of the database.
In this session, our Postgres experts discuss PgBadger and how it can help with Postgres query performance.
Learn more about this topic in this blog post: https://www.enterprisedb.com/blog/how-to-use-pgbadger-log-analyzer-postgresql-query-performance
Learn more about our Postgres Live Q&A here: https://www.enterprisedb.com/postgres-pulse
Subscribe to the Postgres Pulse podcast to listen to our sessions on-demand!
More Episodes
A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as errors reading tables due to a missing file—that is rather straightforward, of course. However, a corrupt index is not as...
Published 05/14/20
When it comes to dealing with poor database and query performance, it’s a daunting task to venture into the dark cavern of query planning and optimization, but fear not! EXPLAIN is our friend in those dark and lonely places.
This session covers EXPLAIN and how it is certainly one of the most...
Published 05/04/20
Planning is key to PostgreSQL backup and recovery. Every environment has its own challenge—and even if we have multiple database clusters in the same organizations, the backup requirements for those might also vary. Therefore, it is important to list down the situations we might need to recover...
Published 04/30/20
Links
Twitter
Facebook
Instagram
Patreon
Genres
Artwork or description wrong?
Request an update »
Updates may take a few minutes.
Do you host a podcast?
Track your ranks and reviews from Spotify, Apple Podcasts and more.
See hourly chart positions and more than 30 days of history.
Get Chartable Analytics »
See hourly chart positions and more than 30 days of history.
