Postgres Observability

A few years ago I was preparing my talk for a conference and couldn’t find a good illustration of Postgres internals. This is how Postgres Observability was created – a diagram that gives a simplified view of all system views and functions for Postgres monitoring and tracking statistics. I’ve been updating the static version after each release and it got busier and busier overtime, so I decided that it is time to create a more in depth version of it. So here is the updated for PostgreSQL 13 interactive version of PostgreSQL Observability. It now has additional information about each internal and each stat. Just follow the links and you can discover more about each one of Postgres components and ways they interact.