Database Administration
pg_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 MorePostgreSQL query to find columns containing only NULL values
Mar 24, 2024 / · 3 min read · postgresql database optimization database schema design database administration pg_class pg_namespace pg_attribute pg_type pg_statistic information_schema ·Identifying Null-Only Columns in PostgreSQL This article explores a valuable PostgreSQL query for database administrators. It helps identify columns within your database tables that exclusively contain NULL values. Uncovering these "null-only" columns can be a key step in optimizing storage usage and streamlining your …
Read MorePostgreSQL Backend Connections via pg_stat_database
Mar 20, 2024 / · 3 min read · postgresql database administration performance optimization pg_stat_database ·Database Connections: A Look at PostgreSQL Backends This article delves into a PostgreSQL code snippet that sheds light on the number of backend connections established for each database within a PostgreSQL instance. We'll dissect the code, explore its purpose, and glean valuable insights for database administrators …
Read More