>> 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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
