Re: Check memory consumption of postgresql query

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(dot)adams(at)gmail(dot)com>
Sent: Thursday, May 8, 2014 4:04 PM
To: Phan Công Minh
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Check memory consumption of postgresql query

On Thu, May 8, 2014 at 3:04 AM, Phan Công Minh <cphan(at)hsr(dot)ch> 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,
>