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,
>