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

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

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

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

Hi, I read a lot about postgres tuning and did some of it. But one of the things, when you start tuning a system that is completely new to you, is checking which sql statement(s) cost most of the resources. cpu instensive sql seems easy to find. But how do I find i/o intensive sql as fast as