Re: Postgresql monitoring question

Georgy Zhukov wrote:
> I inherited a postgresql database which has queries run against it
> from perl scripts. I need to determine which query from the scripts
> is taking an extremely long time, but do not know how to monitor or
> identify queries as they are run against the database.
>
> I know little of postgresql, but quite a bit about SQL and databases
> in general.
>
> Are there tools I can use to monitor or log (*not* transaction log)
> what is going on inside the database. Once I can identify the query,
> I can go into the perl code (several thousand lines) and figure out
> the part I need to modify (assuming that I need to change the perl),
> or which tables/indexes to optimize.

ps will show processes, and pgmonitor shows queries too:

http://gborg.postgresql.org/project/pgmonitor

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026