Re: bgwriter, checkpoints, curious (seeing delays)

On Fri, Feb 26, 2010 at 6:24 PM, Tory M Blue  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