Re: bgwriter, checkpoints, curious (seeing delays) - Mailing list pgsql-performance

From Robert Haas
Subject Re: bgwriter, checkpoints, curious (seeing delays)
Date
Msg-id 603c8f071003031133i7c9f08dbgaaac65f45f0ddf50@mail.gmail.com
Whole thread Raw
In response to Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue <tmblue@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: 10K vs 15k rpm for analytics
Next
From: Josh Berkus
Date:
Subject: Re: Estimation issue with partitioned tables