Releases · Azmodey/pg_dba_scripts

pg_database_information.sh - a script that provides a single tape with the current status of a group of PostgreSQL servers, allowing you to quickly find out what the servers are doing and see the exact data for logical replication and external tables.

Displays server time and lag time, hostname and IP address, PostgreSQL version and status (Master / Replica), data checksums.
Statistics are also displayed on databases, waits and locks, archive and replication statuses.
For logical replication, information about publications and subscriptions in the target databases is displayed.
Displays information about external servers, associated with them by users and tables.
Blocked sessions and a tree with their locks are displayed, as well as a list of long-running requests.
When activities occur in PostgreSQL, the progress of operations is displayed: vacuum, vacuum full or cluster, index creation, analyze, pg_basebackup.

pg_database_hugepages.sh - added display of Transparent Huge Pages (THP).

Assets 2