March 2nd, 2011 by depesz | Tags: , , , , , | Comments Off on Waiting for 9.1 – stats reset tracking

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

Every so often I need to find who exactly is damaging database performance. I mean - I have db connection which does something strange/wrong with the database, but what exactly is responsible? Switching to separate user for every program, script and ...