From: | Francisco Reyes <lists(at)natserv(dot)com> |
---|---|
To: | Pgsql Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Using output of pg_ctl for benchmarking? |
Date: | 2001-11-09 18:12:15 |
Message-ID: | 20011109130756.C32092-100000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I just discovered that pg_ctl/postmaster give out stats on the console.
I did a change to postgresql.conf and when I did pgctl restart, from there
on there were some stats. I restarted again and sent the output to
/var/log/pg.log.
QUERY STATISTICS
! system usage stats:
! 40.719759 elapsed 29.342567 user 8.903896 system sec
! [58.287837 user 18.724752 sys total]
! 6175/0 [12352/0] filesystem blocks in/out
! 0/1 [0/2725] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [3/3] messages rcvd/sent
! 322/672 [802/1410] voluntary/involuntary context switches
!postgres usage stats:
! Shared blocks: 95297 read, 0 written, buffer hit
rate = 0.01%
! Local blocks: 0 read, 0 written, buffer hit
rate = 0.00%
! Direct blocks: 0 read, 0 written
I am the only usr of this system. Any reason why I couldn't use this
output to benchmark?
Any docs online where I could read more on these stats displayed?
For instance whate is "shared blocks"? voluntary/involuntary context
switches?
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 2001-11-09 21:45:13 | Re: |
Previous Message | Isaac Sparrow | 2001-11-09 17:57:19 | Re: |