Re: Memory context usage - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Memory context usage
Date
Msg-id alpine.GSO.2.01.0908280413300.24929@westnet.com
Whole thread Raw
In response to Re: Memory context usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Memory context usage
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: 8.5 release timetable, again
Next
From: Paul Matthews
Date:
Subject: phypot - Pygmy Hippotause ?