pgstat

Collects PostgreSQL statistics the same way as a vmstat tool

Install

All systems
curl cmd.cat/pgstat.sh
Debian Debian
apt-get install pgstat
Ubuntu
apt-get install pgstat
image/svg+xml Kali Linux
apt-get install pgstat
Windows (WSL2)
sudo apt-get update sudo apt-get install pgstat

pgstat

Collects PostgreSQL statistics the same way as a vmstat tool

pgstat is a client utility to gather statistical information from a PostgreSQL instance in real time, and acts like vmstat or sar. Supported statistics include archiver, bgwriter, connections, databases, tables, tables I/O, indexes, functions, archives wals, temporary files, and pgBouncer.