Обсуждение: Real time process monitor in Postgres

Is there one? I'm looking for something similar to MySQL's processlist or
Oracle's v$session.

Been rummaging through the docs with no success, but still looking...

Thanks,
--Walt Weaver
  Bozeman, Montana

Try pgmonitor:

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

Weaver, Walt wrote:
> Is there one? I'm looking for something similar to MySQL's processlist or
> Oracle's v$session.
>
> Been rummaging through the docs with no success, but still looking...
>
> Thanks,
> --Walt Weaver
>   Bozeman, Montana
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

I'll check it out. Thanks!

--Walt

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Monday, September 09, 2002 8:52 PM
To: Weaver, Walt
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Real time process monitor in Postgres



Try pgmonitor:

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

Weaver, Walt wrote:
> Is there one? I'm looking for something similar to MySQL's processlist or
> Oracle's v$session.
>
> Been rummaging through the docs with no success, but still looking...
>
> Thanks,
> --Walt Weaver
>   Bozeman, Montana
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

"Weaver, Walt" <wweaver@rightnow.com> writes:
> Is there one? I'm looking for something similar to MySQL's processlist or
> Oracle's v$session.

The statistics collector might also be useful (in addition or as a
complement to pgmonitor, as Bruce suggested).

http://developer.postgresql.org/docs/postgres/monitoring.html

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC