Performance Monitoring PostgreSQL on Solaris
What to Monitor?
Using PostgreSQL System Tables and view
Using Solaris tools
Using prstat with pargs to figure out session problems
Using iostat to figure out hot disks
Using DTrace Probes
User-Level Statically Defined DTrace Probes in PostgreSQL
LWLock Probes
Transaction Probes
Other Useful DTrace scripts for PostgreSQL
Using Sun Studio Performance Analyzer
Problem Determination
Sign up or Log in to add a comment or watch this page.