On Fri, Feb 26, 2010 at 6:24 PM, Tory M Blue <tmb...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
