Thread: Check memory consumption of postgresql query

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

Hi Clinton,

Thank you for your response. I check the article (http://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/)
andit 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@gmail.com>
Sent: Thursday, May 8, 2014 4:04 PM
To: Phan Công Minh
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Check memory consumption of postgresql query

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