Hi Clinton, Thank you for your response. I check the article (http://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/) and it seems to work with general process as well. However does it have anyway to calculate the memory used by single query, not the whole postgresql process? Thanks, Minh ________________________________________ From: Clinton Adams <clinton.adams@xxxxxxxxx> Sent: Thursday, May 8, 2014 4:04 PM To: Phan Công Minh Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] Check memory consumption of postgresql query On Thu, May 8, 2014 at 3:04 AM, Phan Công Minh <cphan@xxxxxx> wrote: > Hello PostgreSQL community , > > I'm doing benchmark between column store and traditional row-oriented store. > I would like to know if there is any way to measure memory consummed by a > query execution? In linux you can look at the memory usage for a particular backend in /proc/[pid]/smaps. Get the pid with pg_backend_pid() or from pg_stat_activity. For more info, check out http://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/ - Clinton > > Thanks > Minh, >
