PostgreSQL, RED, Golden Signals: getting started
Golden Signals and RED methods are the monitoring templates which define key metrics required for monitoring services. Earlier these methods were known only to monitoring administrators and…
Filters
Postgres 13 Observability Updates
New shiny Postgres 13 has been released and now it’s the time for making some updates to “Postgres Observability” diagram. New release includes many improvements related to…
pgCenter’s wait events profiler
As you might know, in the last pgCenter release the new tool has been added – wait events profiler. In this post, I’d like to explore this…
Deep dive into postgres stats: pg_stat_activity and pg_locks
DBA’s best friends: pg_stat_activity and pg_locks Today, I would like to discuss another handy stats views – pg_stat_activity. This is really useful and powerful view the value…
Deep dive into postgres stats: pg_stat_bgwriter reports
Everything you always wanted to know about Postgres stats Today, I would like to make a little detour from the main series and will dive into pg_stat_bgwriter….
Deep dive into postgres stats: pg_stat_bgwriter
Everything you always wanted to know about Postgres stats This post is about pg_stat_bgwriter view. In my experience, this view is not used very often, however, I…