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...

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...

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...