pgbadger PGSQLPhriday


This week, #PGSQLPhriday is hosted by Alicja Kucharczyk. Every month, one community member proposes a new subject to this monthly blogging event and let the world (or your family/friends/neighbors if you prefer) know all about pgBadger. It's a tool to analyze your PostgreSQL logs and present you a nice web report. If you like some history, it has been developed by Gilles Darold since more than 11 years, as v1.…
Read more ⟶

pg_stat_statements PGSQLPhriday


With Michael of pgMustard fame current host of #PGSQLPhriday, I could not resist revisiting this rather abondoned place of the interweb. As a short prelude, PGSQL Phriday is a blog event to talk of all things PostgreSQL and this week topic is about pg_stat_statements. pg_stat_statement is a module available since 2009 in Postgres 8.4. It tracks execution statistics on all SQL statements that have been executed. Since version 13, it also tracks planning statistics.…
Read more ⟶

psql and the .psqlrc configuration file


If you use PostgreSQL, do yourself a favor and try psql. GUI tools rightly deserve a place in the ecosystem and many developers might find them easier to tackle, especially if they lack familiarity with PostgreSQL. I have myself used PgAdmin, DBeaver, OmniDB, … If you’ve leveled up as a now power user, psql, with its scripting abilities, numerous options should be your tool of choice. In this short article, I will concentrate on a very tiny part of psql, its configuration file, usually located in the home directory (~/.…
Read more ⟶