0

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 top header.

what I do now

  1. I run top command by print it out in a log file.
  2. Then grep the cpu and memory in another txt file
  3. Later I download the txt file and import it in excel file to get the average value of Cpu usage and Memory usage
  4. 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.

Improve this question

2 Answers 2

Reset to default
3

I show some tools I know.

pg_activity is a simple monitoring tool like top.

pg_statsinfo and pg_stats_reporter are high quality utilities that monitor statistics and the activity of PostgreSQL as well as Operating system.

There are some general purpose monitoring tools such as Cacti and Munin. Those support postgres by providing modules and they can easily be used.

BTW, I know a great book: The Art of Computer Systems Performance Analysis. This gives you some hints for benchmarking.

Improve this answer
3
  • how do you run this? concurrent monitor with pgbench? Commented Feb 23, 2016 at 10:58
  • pgbench is just a benchmark tool, it's not a practical system. If you want to know the result of pgbench, you can frequently run it and can run one of the monitoring tools together. There is no need to run those monitoring tools at same time (concurrently). Commented Feb 23, 2016 at 11:08
  • thanks @shx. I think I don't want to install extra tools to measure it Commented Feb 24, 2016 at 2:00
2

Greg Smith has pgbench-tools which does multiple runs of pgbench, with concurrent runs of vmstat and iostat during the pgbench runs. It also lets you graph results with gnuplot. It sounds like it would fit your needs well.

Improve this answer
1
  • thanks @Kassandry. I don't think I need extra tools. Perhaps you can elaborate steps to be taken without installing extra tools. Thanks again Commented Feb 24, 2016 at 1:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.