Lately at least two people on irc asked questions similar to "how do I know how many queries there are in database, per second?". So, let's see what we can find out.

On 15th of March, Robert Haas committed patch: Add simple VACUUM progress reporting. There's a lot more that could be done here yet - in particular, this reports only very coarse-grained information about the index vacuuming phase - but even as it stands, ...

On 26th of January, Magnus Hagander committed patch: Adds a counter that tracks number of deadlocks that occurred in each database to pg_stat_database. Magnus Hagander, reviewed by Jaime Casanova

On 26th of January, Magnus Hagander committed patch: Add counters for number and size of temporary files used for spill-to-disk queries for each database to the pg_stat_database view. Tomas Vondra, review by Magnus Hagander

As you perhaps know, explain.depesz.com has anonymization feature. Couple of days ago Filip contacted me and sent a patch that stopped anonymization of typecasts. I thought about the patch, and what it achieves, changed it's internals, but kept the effect. And today, ...

First of all, as of today, I added new feature, called anonymization. It is for all of the people who are afraid that their plans contain information that they don't want to (or can't) share on the internet. It works like this:

On 10th of February, Magnus Hagander committed patch: Track last time for statistics reset on databases and bgwriter   Tracks one counter for each database, which is reset whenever the statistics for any individual object inside the database is reset, and one counter for the ...

I just checked, and apparently explain.depesz.com is online for over a year now. First plans was added on 2008-12-04 13:20:43+01. Since then there have been 3602 plans added, 770 of them were set to be private (not displayed on previous explains ...

On 4th of January, Tom Lane committed patch by Takahiro Itagaki, which adds new contrib module - pg_stat_statements: Log Message: ----------- Add contrib/pg_stat_statements for server-wide tracking of statement execution statistics.   Takahiro Itagaki