Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 14342632CF3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  3 Mar 2010 15:34:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 79017-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  3 Mar 2010 19:34:02 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com
	[209.85.218.216])
	by mail.postgresql.org (Postfix) with ESMTP id 0909F632B8A
	for <pgsql-performance@postgresql.org>;
	Wed,  3 Mar 2010 15:34:01 -0400 (AST)
Received: by bwz8 with SMTP id 8so1496831bwz.3
	for <pgsql-performance@postgresql.org>;
	Wed, 03 Mar 2010 11:34:00 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=Iqi70tqxeaV30ziu3RDtJEN7AOah7NSneyMUGRzchOY=;
	b=HPaGeHAQDIXMW/wZL/QFUXS3cEeXWYJswNcsonIXW1W4Gkj8ei4wyMRDsqtJSanbFN
	mNCqnvuKawrrYHs8cYpptXbscFMjVdeFYkEI8fIlRugRy9ugOvpUmMn5af25B7WoVKIs
	VBOALRke44QnIf8+u2ZcmY/ejCUn6VDrc3w10=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=UcDVyXhEwF0j/0NRREADfOojH31gTM/swK8y6HgiI5xD9ITia8kh4nTMVr3jMj8Pid
	6vw3eDow8WnB4gMF5puBq20JWm5a6QpFu0eFXRA7d+ScalEW1axeDxv8b+/f2jHmkzOg
	C0lvY9mSENWiobTQ5dWrJEP6BXuDam7EpYaY0=
MIME-Version: 1.0
Received: by 10.102.235.8 with SMTP id i8mr23690muh.31.1267644840160; Wed, 03
	Mar 2010 11:34:00 -0800 (PST)
In-Reply-To: <8a547c841002261524y138eb983oa4fb4d691c85ca0c@mail.gmail.com>
References: <8a547c841002252212t382cfeb4pde3e668a9d3f2f10@mail.gmail.com>
	<1267166541.2094.52.camel@hp-laptop2.gunduz.org>
	<8a547c841002261052r3bff71f2v6759859abce72710@mail.gmail.com>
	<4B87D16B.2E1C.0042.0@homedecorators.com>
	<8a547c841002261524y138eb983oa4fb4d691c85ca0c@mail.gmail.com>
Date: Wed, 3 Mar 2010 14:33:59 -0500
Message-ID: <603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com>
Subject: Re: bgwriter, checkpoints, curious (seeing delays)
From: Robert Haas <robertmhaas@gmail.com>
To: Tory M Blue <tmblue@gmail.com>
Cc: Jorge Montero <jorge_montero@homedecorators.com>,
	pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74
X-Spam-Level: 
X-Archive-Number: 201003/64
X-Sequence-Number: 37889

On Fri, Feb 26, 2010 at 6:24 PM, Tory M Blue <tmblue@gmail.com> wrote:
> Ya my boxes are pretty well stacked, but a question. How does one get
> the memory usage of a query. You state to look at explain analyze but
> this gives timing and costs, but is one of the numbers memory or do I
> have to take values and do some math?

There's really not good instrumentation on memory usage, except for
sorts.  9.0 will add a bit of instrumentation for hashes.

I might try 'top'.

...Robert