How to correctly calculate how much memory PostgreSQL takes?

Question

linux

The article describes that PostgreSQL uses shared memory
Why does PostgreSQL use so much memory?
And it also says that top and other utilities incorrectly calculate how much memory PostgreSQL takes.
Maybe there are some utilities that correctly calculate how much memory PostgreSQL takes?

Answer 1

sudo curl -L https://raw.githubusercontent.com/pixelb/ps_mem/master/ps_mem.py --output /usr/local/bin/psmem

will return a detailed table (Shared, private) of used memory for each running daemon

Answer 2

It is necessary not to count how much memory the DBMS takes, but to configure it in accordance with the desired amount of consumption, see for example - http://pgtune.leopard.in.ua . The reason for this is simple - with active use, postgres will sooner or later take up all the memory available to it, and this is completely normal.