On Jan 11, 2008 11:29 AM, João Paulo Zavanela <joao_zava@xxxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
