Обсуждение: Monitoring postgresql

Hi,

I'm using 7.2.1.

Some of our folks are writing a bunch of stuff into
the a database, and occasionally having
problems with execution time - things aren't
executing as quickly as they would expect them
to, seemingly.  Some of it could be them
locking each other out on writes and so on.

Is there anyway to monitor that (locks, etc.)?

Any other suggestions?

Thanks for the help,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
A wiki we will go...

On Mon, Aug 26, 2002 at 01:03:25PM -0700, Laurette Cisneros wrote:

> executing as quickly as they would expect them
> to, seemingly.  Some of it could be them
> locking each other out on writes and so on.
>
> Is there anyway to monitor that (locks, etc.)?

Try pgmonitor:

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

Apparently this is being merged into pgaccess, BTW.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

Laurette Cisneros <laurette@nextbus.com> writes:
> Some of our folks are writing a bunch of stuff into the a database,
> and occasionally having problems with execution time - things aren't
> executing as quickly as they would expect them to, seemingly.

> Is there anyway to monitor that (locks, etc.)?

Try the statistics collector:
http://developer.postgresql.org/docs/postgres/monitoring-stats.html

Cheers,

Neil

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