On Jan 11, 2008 11:29 AM, João Paulo Zavanela <joao_zava@globo.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.