From owner-freebsd-questions@FreeBSD.ORG Thu Feb 5 17:20:08 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id AD642106567A for ; Thu, 5 Feb 2009 17:20:08 +0000 (UTC) (envelope-from bruce@cran.org.uk) Received: from muon.cran.org.uk (brucec-1-pt.tunnel.tserv4.nyc4.ipv6.he.net [IPv6:2001:470:1f06:c09::2]) by mx1.freebsd.org (Postfix) with ESMTP id 69FDE8FC0A for ; Thu, 5 Feb 2009 17:20:08 +0000 (UTC) (envelope-from bruce@cran.org.uk) Received: from muon.cran.org.uk (localhost [127.0.0.1]) by muon.cran.org.uk (Postfix) with ESMTP id 712AE19014; Thu, 5 Feb 2009 12:20:06 -0500 (EST) X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on muon X-Spam-Level: X-Spam-Status: No, score=-2.5 required=8.0 tests=AWL,BAYES_00,NO_RELAYS autolearn=ham version=3.2.5 Received: from gluon (unknown [IPv6:2a01:348:10f:0:240:f4ff:fe57:9871]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by muon.cran.org.uk (Postfix) with ESMTPSA; Thu, 5 Feb 2009 12:20:06 -0500 (EST) Date: Thu, 5 Feb 2009 17:20:00 +0000 From: Bruce Cran To: Omer Faruk Sen Message-ID: <20090205172000.130a8079@gluon> In-Reply-To: <75a268720902041400p1db8057bn726907d102efe88c@mail.gmail.com> References: <75a268720902041400p1db8057bn726907d102efe88c@mail.gmail.com> X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.9; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: system time on top output X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Feb 2009 17:20:10 -0000 On Thu, 5 Feb 2009 00:00:35 +0200 Omer Faruk Sen wrote: > Hi, > > I have a running pgsql server but on heavy loads it consumes lots of > time in system (more than %50). I can see that > > CPU states: 15.4% user, 0.0% nice, 81.9% system, 1.5% interrupt, > 1.2% idle > > But how can I debug that kind of system. vmstat and other tools only > show most cpu is used by system. But how can I go deeper and debug > that kind of a problem? > Any tools that you can suggest me? I've not used it, but I believe DTrace is probably the best tool to find the cause of the problem. It's in 7.1 and later. -- Bruce