Upgrade: new pgCenter features are now available
The last time I’ve made changes in pgCenter was back in January, so I thought it was about time to make a few revisions and upgrade to…
Filters
Interactive new look for PostgreSQL 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…
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…
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_user_indexes
Everything you always wanted to know about Postgres stats One of the major strengths of PostgreSQL are indexes – they are flexible and cover almost all use…
Deep dive into postgres stats: pg_stat_all_tables
Everything you always wanted to know about Postgres stats Today’s post is about pg_stat_all_tables. This view contains various statistics about tables usage and may be useful in…