Database Performance
Analyze PostgreSQL Cache-Hit Ratio with pg_stat_statements
May 18, 2025 / · 3 min read · PostgreSQL SQL database performance monitor running queries pg_stat_statements ·How to Analyze PostgreSQL Query Cache-Hit Ratio Using pg_stat_statements Purpose Measuring the cache-hit ratio of your PostgreSQL queries is essential for understanding and optimizing how efficiently your database serves data from memory versus disk. This article explains how to use the pg_stat_statements extension to …
Read Morepg_blocking_pids — Find Blocking Queries in PostgreSQL
Mar 25, 2024 / · 11 min read · pg_blocking_pids pg_stat_activity pg_locks postgresql locks database performance database administration sql queries deadlocks postgres dba ·Identifying Blocking PostgreSQL Queries: A Guide for Database Administrators This article explores a PostgreSQL query designed to identify currently blocked database queries and the processes (identified by PIDs) responsible for blocking them. This information is crucial for database administrators troubleshooting …
Read More