Hattrick – The New Design VS PsicoTSI / Foxtrick
Since the design of hattrick is renewed recently, it is necessary (again) to upgrade to the latest version of psictsi and foxtrick. Since I am not a Certified Hattrick Product provider , I can only provide you with the url where you can find the latest Firefox extensions …
If you should have any questions regarding the installation of these extensions, don’t hesitate to leave a comment ….
Happy Holidays!
How to monitor PostgreSQL processes
pg_top is ‘top’ for PostgreSQL. It is derived from Unix Top. Similar to top, pg_top allows you to monitor PostgreSQL processes. It also allows you to:
- View currently running SQL statement of a process.
- View query plan of a currently running SQL statement.
- View locks held by a process.
- View user table statistics.
- View user index statistics.
You can download it here…
How to install it :
- tar xvzf pg_top-3.6.2.tar.gz
- yum install postgresql-devel
- yum install ncurses-devel
- ./configure
- make
A quick example :
- ./pg_top -U username-d database -h localhost -W
More information :
- ./pg_top –help
An interestesting slideshare :
December 2, 2008 | Filed Under IT | Leave a Comment