Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Robert Lor <robert.lor@sun.com>
From: Robert Lor <Robert.Lor@Sun.COM>
To: Gregory Stark <stark@enterprisedb.com>
Cc: Decibel! <decibel@decibel.org>, Neil Conway <neilc@samurai.com>, pgsql-hackers list <pgsql-hackers@postgresql.org>
Date: 2008-01-03T16:08:12Z
Lists: pgsql-hackers
Greg, Gregory Stark wrote: > I don't think DTrace is overkill either. The programmatic interface is > undocumented (but I've gotten Sun people to admit it exists -- I just have to > reverse engineer it from the existing code samples) but should be more or less > exactly what we need. > > You probably know this already. There are existing commands that use the programmatic interface and would provide a good starting point. Here are a couple: http://cvs.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/cmd/lockstat/lockstat.c http://cvs.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/cmd/dtrace/dtrace.c One of my colleagues is in the process of putting a tutorial together for how to do this, so if you decided to pursue this approach and need assistance, please let me know. Regards, Robert