Export or edit this event...

PDXPUG October Meetup: Terminal Tools & Database Statistics

PSU Business Accelerator
2828 SW Corbett Ave
Portland, OR 97201, US (map)

https://www.pdx.edu/accelerator/directions

Parking is open after 5pm. Room 208 (on the second floor)

Website

Description

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 with the PostgreSQL database you are connected to. Recently pg_systat was forked from systat to display additional database statistics.

These tools have can help do more such as explore query execution plans and create reports from system and database resources.

Come learn about the statistics PostgreSQL keeps and how to use these tools to view them.

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the USA. He is a long time Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.

Share

Tags