View Source

h1. Performance Monitoring PostgreSQL on Solaris
\\

h2. What to Monitor?
\\

h2. Using PostgreSQL System Tables and view
\\

h2. Using Solaris tools

Using prstat with pargs to figure out session problems
Using iostat to figure out hot disks

h2. Using DTrace Probes

User-Level Statically Defined DTrace Probes in PostgreSQL
LWLock Probes
Transaction Probes
Other Useful DTrace scripts for PostgreSQL

h2. Using Sun Studio Performance Analyzer
\\

h2. Problem Determination
\\ \\

The individuals who post here are part of the extended Sun Microsystems community and they might not be employed or in any way formally affiliated with Sun Microsystems. The opinions expressed here are their own, are not necessarily reviewed in advance by anyone but the individual authors, and neither Sun nor any other party necessarily agrees with them.