Re: Memory context usage

On Fri, 28 Aug 2009, Tom Lane wrote:

> MemoryContextStats() might help.  It just dumps the info to stderr
> though.

Which means it ends up in the database log files in the common 
configuration where where the database's stderr is redirected to there. 
I even script running this regularly against stuff I'm suspicious of, 
using something like this passed the PID of the process I want to watch:

#!/bin/bash
gdb -p $1 <<EOF
p MemoryContextStats(TopMemoryContext)
detach
quit
EOF

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD