top for postgresql (ptop?)
От | Mark Wong |
---|---|
Тема | top for postgresql (ptop?) |
Дата | |
Msg-id | 70c01d1d0709250000m6dfe9f65p4ece768fa2e70107@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: top for postgresql (ptop?)
Re: top for postgresql (ptop?) Re: top for postgresql (ptop?) |
Список | pgsql-hackers |
Hi everyone, I was playing with converting unixtop (the version of top used in FreeBSD) to only show PostgreSQL processes pulled from the pg_stat_activity table. I have a version that kind of works here: http://pgfoundry.org/frs/download.php/1468/ptop-3.6.1-pre6.tar.gz I've tried it on FreeBSD and Linux, not sure about other platforms though. So it looks a lot like top and can currently do a few simple things like display the current_query from pg_stat_activity for a given process, show the locks held by a process and on which tables, and show the query plan for the current query. It is a ways from polished (not really documented, etc.) but I wanted to see what people thought of a text/curses sort of monitoring tool like this. Maybe something to distribute with PostgreSQL? :) Forgive me if I didn't try out pgtop (the CPAN module.) Regards, Mark
В списке pgsql-hackers по дате отправления: