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