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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026