On May 2, 2005, at 6:09 PM, Markus Schaber wrote:
1) is it possible to know Pg backend uptime with SQL queries? Or must I look at postmaster.pid file? or even something else?
In contrib, there's a function caled backend_pid() defined in misc_utils.sql, it may be helpful for you.
markus
I wrote a small util called "pgtop" that does a top style listing on PG in terms of cpu. I also have one called pgiomonitor (that is on pgfoundry and mostly done) that does the same but shows you which tables are producing the most IO)
http://postgresql.jefftrout.com/pgtop.pl
it only runs on linux and it must run on the same box as pg itself.
You may want to look at it and see if you can get anything good out of it.
queries / second is tricky. You could look at my pgspy utility but it is in C. It can give you queries / second data
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
