Deep dive into postgres stats: pg_stat_activity and pg_locks
DBA’s best friends: pg_stat_activity and pg_locksToday, I would like to discuss another handy stats views – pg_stat_activity. This is really useful and powerful view the value of…
Filters
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…
Deep dive into postgres stats: pg_stat_replication
Everything you always wanted to know about Postgres stats Everyone who works with postgres, knows about postgres’ streaming replication. Every modern database has replication features and postgres…
PgCenter 0.2.0 Released.
What’s New in PgCenter 0.2.0. pgCenter is the top-like PostgreSQL statistics viewer. The pgCenter provides convenient interface for PostgreSQL statistics and allows viewing statistics changes in time…
Introduction to pg_stat_activity.
PostgreSQL RDBMS has a very informative built-in tools to track the state of the database. One such tool is pg_stat_activity. This is a system view that allows…