[PERFORM] PostgreSQL's Statspack?

2005-01-03 Thread Stan Y
Besides the tables pg_stat_xxx, are there any stronger tools for PostgreSQL as the counterpart of Oracle's Statspack? Is it possible at all to trace and log the cpu and io cost for each committed transaction? Thanks a lot! -Stan __ Do You Yahoo!? T

[PERFORM] Monitor CPU time per transaction?

2004-12-17 Thread Stan Y
Hi All, I notice that most stat Postgres provides are per table or per process. Is it possible to monitor CPU time per transaction and IO per transaction? If can't, is there any commercial capacity planning tools available? Thanks! __ Do you Ya

[PERFORM] Monitor CPU time per transaction?

2004-12-17 Thread Stan Y
Hi All, I notice that most stat Postgres provides are per table or per process. Is it possible to monitor CPU time per transaction and IO per transaction? If can't, is there any commercial capacity planning tools available? Thanks! __ Do you Y