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