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@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.