<div style="text-align: left;">Hello All,<br /><br />Recently, I have been involved in some work that requires me to
monitorlow level performance counters for pgsql. Specifically, when I execute a particular query I want to be able to
tellhow many system calls get executed on behalf of that query and time of each sys call. The idea is to provide a
breakdown of the total query running time in terms of CPU time (user+system) and IO (wait time + service time) and any
othercontributing factors.<br /><br />I have been using various performance monitoring tool in linux including vmstat,
mpstat,iostat and strace(to monitor system calls). Surprisingly, no matter what type of query I execute, when I use
straceto monitor the system calls generated they turn out to be the same for ALL sorts of queries. Now this could
happenbecause (a) the tool (strace) is not robust (b) something the pgsql code is doing that eludes strace. At this
pointI have been unable to narrow it down. Any help in this regard will be greatly appreciated. Also if somebody knows
abetter way of achieving the same goal please let me know.<br /><br />Thanks for reading.<br />-Umar<br /></div><br
/><hr/>Live Earth is coming. Learn more about the hottest summer event - only on MSN. <a
href="http://liveearth.msn.com?source=msntaglineliveearthwlm"target="_new">Check it out!</a>
