2019 October 17 Meeting: Terminal Tools & Database Statistics

Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

2019 October 17 Meeting: Terminal Tools & Database Statistics

Mark Wong
Time: 6pm-8pm
Location: https://www.pdx.edu/accelerator/directions

PSU Business Accelerator
2828 SW Corbett Ave
Portland, OR
Parking is open after 5pm.
Room 208 (on the second floor)

Speaker: Mark Wong

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

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.

Mark Wong
2ndQuadrant - PostgreSQL Solutions for the Enterprise