pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Robert Haas <robertmhaas@gmail.com>
To: Tory M Blue <tmblue@gmail.com>
Cc: Jorge Montero <jorge_montero@homedecorators.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: bgwriter, checkpoints, curious (seeing delays)
Date: Wed, 3 Mar 2010 14:33:59 -0500
Message-ID: <603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com> (raw)
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>

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

view thread (17+ messages)

Message-ID: <603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com>
Permalink:  ../603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com/
Also on:    postgresql.org/message-id/603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: robertmhaas@gmail.com, tmblue@gmail.com, jorge_montero@homedecorators.com
  Subject: Re: bgwriter, checkpoints, curious (seeing delays)
  In-Reply-To: <603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox