PostgreSQL and Greenplum Database Monitoring and Administration Queries
This guide provieds a comprehensive collection of SQL queries for monitoring and managing PostgreSQL and Greenlpum databases, covering session analysis, lock investigation, resource management, and metadata operations.
Active Connection Analysis
Monitor current client connections and their status:
-- Count active connections excluding curren ...
Posted on Mon, 28 Sep 2026 16:41:53 +0000 by boogybren