Ever wanted a command-line tool for monitoring PostgreSQL? ptop is the answer! Derived from the UNIX utility top, ptop automates some of the most common troubleshooting queries. This talk will provide an introduction to PostgreSQL monitoring, supported features in ptop, and plans for future development.
Features include:
- List of currently running queries
- Viewing query plans
- Viewing locks
- View current user table and index statistics
- Deltas on statistics at configurable intervals
Development is active, and the tool is currently supported on *BSD and Linux, with a Mac OS X port on the way.
The project's home page is at:
http://pgfoundry.org/projects/ptop
Selena Deckelmann bikes herself to work everyday at Chris King Precision Components, a bicycle parts manufacturer in Portland, OR, where she is Information Systems Manager. She is User Group Liaison for the PostgreSQL Global Development Group. She currently leads PDXPUG - http://pugs.postgresql.org/pdx, a PostgreSQL Users Group, and is helping start a programming group, Code-n-Splode - http://pdx.codensplode.org, whose goal is to get more women involved in open source. In her spare time, she collects eggs from her chickens, gardens and occasionally mixes drinks for her local Perl Mongers group.