pgBadger is a well-known and widely used tool for identifying performance bottlenecks when using PostgreSQL. But there is even more you can do. Using the newly added “raw output” feature, we built new tools for even deeper insight analysis of the root causes of performance degradation.
Henrietta Dombrovskaya (currently a Database Architect at DRW) is a database researcher and developer with 40 years of academic and industrial experience. Henrietta is very active in the PostgreSQL community. She is a founder of Prairie Postgres NFP, an organization supporting Postgres education in the Midwest states of the US. She regularly talks at the PostgreSQL conferences. Her contributions to the community include the pg_bitemporal project, which supports two-dimensional time in PostgreSQL, postgres_air training database (the largest open-source PostgreSQL training database), and the NORM technology - the novel way of communications between applications and databases. She authored, together with B. Novikov and A. Bailliekova, the book "PostgreSQL Query Optimization," Apress, 2024.
Registration includes free 30-day access to O’Reilly’s ebook library.