How to find,total memory/ram using by the postgresql database in Linux machine?

Question

When I execute top -u postgres or ps -C postgres -o %cpu,%mem,cmd in linux machine I am getting the list of postgres processors in my database machine. I need a consolidated %cpu and %ram usage by postgres.

tikeman · Accepted Answer · 2017-06-16 13:26:21Z

0

Try and test:

top -b -n 1 -u tomcat | awk 'NR>7 { cpusum += $9; ramsum += $10; } END { print cpusum, ramsum; }'

edited Jun 16, 2017 at 13:26

user330315

answered Jun 16, 2017 at 12:58

tikeman

4910 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Laurenz Albe Over a year ago

If it uses top, it counts the shared memory segment multiple times.

Raghavendra Over a year ago

I have received output as "247.5 418.1 ". What it means could you explain, please?

Raghavendra Over a year ago

I have received output as below. 247.5 418.1 What it means could you explain, please?

Tamas Szasz Over a year ago

First number is the total CPU usage, second one is the total memory used

Collectives™ on Stack Overflow

How to find,total memory/ram using by the postgresql database in Linux machine?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related