From: | João Paulo Zavanela <joao_zava(at)globo(dot)com> |
---|---|
To: | "Grupo PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Search connections created per day |
Date: | 2008-01-16 12:09:13 |
Message-ID: | 476A825F000588C3@mail11.sc2.he.tucows.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> 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.
Thanks...
I want to know the max simo connections at any given time, but I only have
a backup of the database, so, I don't can use the pg_stat_activity.
This database is running in a client, and I should to know if he is creating
more connections of it is allowed.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2008-01-16 13:01:54 | Re: Segmentation fault with 8.3 FTS ISpell |
Previous Message | Stefan Schwarzer | 2008-01-16 11:26:00 | Re: Forgot to dump old data before re-installing machine |