X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E7628DA8CC for ; Thu, 20 Oct 2005 15:09:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52254-01 for ; Thu, 20 Oct 2005 18:09:10 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id B7C79DA8EA for ; Thu, 20 Oct 2005 15:09:10 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j9KI99lf063425 for ; Thu, 20 Oct 2005 18:09:09 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j9KI0bqx048400 for pgsql-admin@postgresql.org; Thu, 20 Oct 2005 18:00:37 GMT (envelope-from news) From: Ron Mayer X-Newsgroups: pgsql.admin Subject: OS monitoring tools I should be using? Date: Thu, 20 Oct 2005 11:02:54 -0700 Organization: Hub.Org Networking Services Lines: 18 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.67 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.150] X-Spam-Level: X-Archive-Number: 200510/232 X-Sequence-Number: 19304 Is there a good place that summarizes the OS tools I should be using to monitor postgresql servers on various machines? On *nix machines I have sar/sysstat stuff constantly logging stuff; but on Win* machines I don't know what the equivalent should be. Any recommendations? For interactive monitoring I have an OK feel for vmstat and top to watch memory & cpu use, and iostat to watch the quantity of disk/IO per drive. But there are still some things I can't find easily so any new advice wold be appreciated. For example, HPUX's iostat used to tell me number of disk-seeks/second but I don't see the equivalent for Linux. Rather than just ask that specific question; I'd be interested to know in general what OS-level monitoring tools you guys find most important for various platforms.