pg_top

pg_top on CentOS

Installing pg_top on CentOS version 6.

Installing pg_top on CentOS is pretty straightforward, if you have setup the postgres yum repos, and then simply install the pg_top93 package with yum.

yum install http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

yum install -y pg_top93

Running pg_top

Run pg_top as the postgres user.

su - postgres
pg_top

You should see output similar to this:

last pid: 23715; load avg: 0.64, 0.23, 0.08; up 100+21:44:57 14:00:27
4 processes: 1 running, 3 sleeping
CPU states: 3.6% user, 0.0% nice, 3.0% system, 93.3% idle, 0.1% iowait
Memory: 6749M used, 257M free, 96M buffers, 550M cached
DB activity: 4 tps, 0 rollbs/s, 0 buffer r/s, 100 hit%, 341 row r/s, 0 row w/s
DB I/O: 0 reads/s, 0 KB/s, 0 writes/s, 0 KB/s
DB disk: 469.4 GB total, 223.6 GB free (40% used)
Swap:
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
9722 postgres 20 0 317M 4980K sleep 0:00 0.00% 0.00% postgres: dbuser dbname 10.10.10.13(59886) idle
24378 postgres 20 0 317M 5776K sleep 0:00 0.00% 0.00% postgres: dbuser dbname 10.10.10.13(38834) idle
23716 postgres 20 0 318M 5656K run 0:00 0.00% 0.00% postgres: postgres postgres [local] idle
(Comments)

Comments