| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | João Paulo Zavanela <joao_zava(at)globo(dot)com> |
| Cc: | "Grupo PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Search connections created per day |
| Date: | 2008-01-11 18:11:59 |
| Message-ID: | dcc563d10801111011ma189480j7fb823151b1afcb3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jan 11, 2008 11:29 AM, João Paulo Zavanela <joao_zava(at)globo(dot)com> wrote:
> Hi there,
>
> I want to know how many connections is created simultaneously in data base
> per day.
Do you want to know the max simo connections at any given time, or the
total connections in a given day? Assuming you want to know the max
simo connections at any given time, I think you're going to have to
check pg_stat_activity every x minutes and store the number of rows
somewhere to retrieve later.
> Are there some table where i can search it?
pg_stat_activity, but it only has the info for "right now" in it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-01-11 18:14:59 | Re: Online Oracle to Postgresql data migration |
| Previous Message | Tom Hart | 2008-01-11 18:07:01 | Re: Online Oracle to Postgresql data migration |