From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
---|---|
To: | Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> |
Cc: | Bill Moran <wmoran(at)potentialtech(dot)com>, Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Average connections |
Date: | 2009-06-10 15:33:45 |
Message-ID: | 1244648025.29189.132.camel@bnicholson-desktop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2009-06-10 at 15:29 +0100, Pedro Doria Meunier wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Thank you Bill for your tip.
>
> As far as the table's name is concerned the only one I can find is
> 'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64.
>
> BR,
http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
pg_stat_database also has the number of active server processes
connected to a database.
>
>
> Bill Moran wrote:
> > In response to Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>:
> >
> >> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> >>
> >> Hi all
> >>
> >> I've googled for an answer but couldn't find one. Is there anyway
> >> to monitor the average connections to a database?
> >>
> >> Thank you in advance for any insights.
> >
> > The pg_stat_activity table holds 1 row for each connection with
> > information on what that connection is doing.
> >
> > It wouldn't be very difficult to write a passthrough script for
> > something like MRTG to graph this data.
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
>
> iD8DBQFKL8ND2FH5GXCfxAsRAu/XAJ43UGqlzv5gfzg1YgECbhvL2MaPzwCdEnt3
> GfewITsorV/t7cfpq3WxVqM=
> =84cI
> -----END PGP SIGNATURE-----
>
>
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2009-06-10 15:37:14 | Re: Average connections |
Previous Message | Pedro Doria Meunier | 2009-06-10 14:29:33 | Re: Average connections |