2019 October 17 Meeting: Terminal Tools & Database Statistics

From: Mark Wong <mark(at)2ndQuadrant(dot)com>
To: pdxpug(at)lists(dot)postgresql(dot)org
Subject: 2019 October 17 Meeting: Terminal Tools & Database Statistics
Date: 2019-10-09 15:55:43
Message-ID: 20191009155543.GA28317@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

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
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.

--
Mark Wong
2ndQuadrant - PostgreSQL Solutions for the Enterprise
https://www.2ndQuadrant.com/

Browse pdxpug by date

  From Date Subject
Next Message Teresa Giacomini 2019-11-06 19:48:19 PgDay San Francisco - January 21, 2020
Previous Message Mark Wong 2019-09-17 03:21:51 2019 September 19 Meeting: Sharding large MySQL databases with Vitess