Re: [PERFORM] how to find the sql using most of the i/o in an oltp system

2008-06-15 Thread Gavin M. Roy
Check out pgFouine. Sent from my iPhone On Jun 15, 2008, at 10:41 AM, "Uwe Bartels" <[EMAIL PROTECTED]> wrote: Hi Alexander, thanks for you answer. What you wrote in terms of postgres I knew. I just tested to log all statements with statistics. This is a lot of unstructured data in a l

Re: [PERFORM] how to find the sql using most of the i/o in an oltp system

2008-06-15 Thread Uwe Bartels
Hi Alexander, thanks for you answer. What you wrote in terms of postgres I knew. I just tested to log all statements with statistics. This is a lot of unstructured data in a logfile. But this is the best I found as far. The database is running on a solaris box. So DTrace is no problem. I couldn't