pgstat2
pgstat2 is a utility that shows various PostgreSQL statistics on the command line similar to other unix utilities like iostat. pgstat2 is hosted at pgfoundry.
mongostat
mongostat is a utility that shows various MongoDB statistics on the command line similar to other unix untilities like iostat. mongostat is hosted over at github.
Mongostat is now included in the core MongoDB distribution.
Is there an explanation of the meaning of the columns:
blkshit bkends seqscan seqtprd idxscn idxtrd ins upd del locks hit load
blkshit == blocks hit, or number of block requests serviced from cache.
bkends == backends, or number of postgres backend processes.
Fixed my download link. Sorry about that. I also changed over to using tar/gz vs zip. There is only one file there, but over time I may add more and want to keep the same file name.
nice one kenny
Perl version at http://www.loveandnature.co.za/~jamesw/pgd.pl requires DateTime, DBI, DBD::Pg from CPAN and Pod::Usage and Getopt::Long from a standard perl installation.
the version in pgd.zip:/ is still 0.5b, while the one in pgd.zip:/Volumes/kgorman/code/pgd is 0.7b
Change -n to -h and make -d optional.
It could be a contrib module. Very good.
Seems to run fine with Python 2.4.3 (tested on my RHEL5.2 box as “python pgd”, with python-psycopg2-2.0.5.1-3.el5.1 from EPEL)
Shame the output doesn’t fit in 80 columns, but am not sure that’s going to be possible
Hi,
I would suggest to add option such as below, so that the output is a bit less (can fit on the screen):
-x DETAILS –details= index, DDL, DML, load
Pingback: Unique identifier for a database without connecting to the database? | kennygorman.com