CYBERTEC pgwatch2, the best monitoring tool for PostgreSQL, is out now with the brand new Feature Pack 3 that has a focus on enterprise needs.
A more detailed look at Pgwatch2 PostgreSQL monitoring tool
Find out more about the pgwatch2 monitoring tool: we’ll look a bit deeper under the hood and provide more info on customization.
Announcing pgwatch2 – a simple but versatile PostgreSQL monitoring tool
Learn everything about pgwatch2, the brandnew, simple but versatile PostgreSQL monitoring tool made by Cybertec. Download for free!
Spying on slow statements with “auto_explain”
PostgreSQL "auto_explain" functionality is a useful debugging helper that many people don't know about. Describes setup and use cases.
pg_stat_statements: The way I like it
Finding slow queries using the PostgreSQL extension pg_stat_statements. Improve your database performance and monitoring.
Monitoring: Keeping an eye on old transactions
To handle transactions PostgreSQL uses a mechanism called MVCC (Multi Version Concurrency Control). The core idea of this machinery is to allow the storage engine to keep more than just one version of the row.
Detecting table bloat in PostgreSQL
If your PostgreSQL database is badly structured, you might face some table bloat. Figure out if a table is bloated or not.
