On Wed, Mar 31, 2021 at 02:04:07PM +0000, Campbell, Lance wrote: > PostgreSQL 12 > > > > Is there a query that will tell us at any given time what amount of PostgreSQL > memory is being used for work_mem? Well, you can look at the process memory usage via 'ps', but I don't know a way to see current work_mem allocation. SHOW work_mem does show the current setting, but that isn't the allocated amount. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
