what is the best way to capture the usage of CPU and memory while running pgbench? The only way I can think of is to read the info from
what I do now
- I run
topcommand by print it out in a log file.
grepthe cpu and memory in another
- Later I download the txt file and import it in excel file to get the average value of Cpu usage and Memory usage
- The result of pgbench will be put together in the excel file
Is there any tips or standard of procedure to implement the TPC-B as well as monitor the resources.