Thread: Postgresql monitoring question

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.

Thanks for any help.

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