Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 753E3B5DBE1 for ; Sat, 21 May 2011 00:37:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 75867-03 for ; Sat, 21 May 2011 03:37:23 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f200.google.com (mail-gx0-f200.google.com [209.85.161.200]) by mail.postgresql.org (Postfix) with ESMTP id 1D60EB5D832 for ; Sat, 21 May 2011 00:37:22 -0300 (ADT) Received: by gxk22 with SMTP id 22so3026263gxk.7 for ; Fri, 20 May 2011 20:37:21 -0700 (PDT) MIME-Version: 1.0 Received: by 10.236.152.34 with SMTP id c22mr128199yhk.75.1305949041341; Fri, 20 May 2011 20:37:21 -0700 (PDT) In-Reply-To: <4DD6FC11.4000706@emolecules.com> Message-ID: <20cf303dd4f8b436b904a3c0f451@google.com> Date: Sat, 21 May 2011 03:37:21 +0000 Subject: Re: Who is causing all this i/o? From: vequalsitimesz@gmail.com To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=20cf303dd4f8b4369604a3c0f44e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.887 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/138 X-Sequence-Number: 37575 --20cf303dd4f8b4369604a3c0f44e Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes I am tracking down possibly similar behavior on a production server and a colleague introduced me to Dstat. I am using it right now to try and track down the root of my problem. May or may not be helpful in figuring out exactly whats causing this and then on to figuring out to fix it. http://dag.wieers.com/home-made/dstat/# then run something like: dstat -t -l --cpu24 --sys --tcp --vm --nocolor --top-io --top-latency-avg --output /tmp/dstat.csv sincerely --20cf303dd4f8b4369604a3c0f44e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I am tracking down possibly similar behavior on a production server and a c= olleague introduced me to Dstat. I am using it right now to try and track d= own the root of my problem. May or may not be helpful in figuring out exact= ly whats causing this and then on to figuring out to fix it.

ht= tp://dag.wieers.com/home-made/dstat/#

then run something like:dstat -t -l --cpu24 --sys --tcp --vm --nocolor --top-io --top-latency-a= vg --output /tmp/dstat.csv

sincerely --20cf303dd4f8b4369604a3c0f44e--