Terminal Tools for Displaying PostgreSQL Statistics: pg_top, pg_proctab, and pgstat

Date: 2019-09-13
Time: 21:00 - 21:50
Room: Junior Ballroom G
Level: Beginner

pg_top was born in 2007 from a fork of the unixtop, a terminal program displaying top processes on the system, where pg_top focuses on the processes of the PostgreSQL database you connected to. pg_proctab is a PostgreSQL extension created shortly after to allow pg_top to connect to a remote PostgreSQL databases and display operating system statistics. Recently pgstat was forked from systat to displaying other system and database statistics.

These tools have grown to help do more such as explore query execution plans and create reports on resources used per query.

Come learn about how to use these tools and the information that is available with PostgreSQL.


The following slides have been made available for this session:


Mark Wong