Essential Queries for PostgreSQL Health Assessment
In this post, we’ll look at a few crucial queries that are helpful for exploring into PostgreSQL problems and evaluating the health of an existing instance. What is hit ratio of the database? SELECT datname, ( blks_hit * 100 /(blks_hit + blks_read) ):: numeric as hit_ratio from pg_stat_database WHERE datname not in ( ‘postgres’, ‘template0’,…