Search connections created per day

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 11 Jan 2008 14:29:32 -0300
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.

Entirely depends on your machine. I wouldn't suggest having more than a
1000 open at any given time though. Also take a look at connection
pooling.

Are there some table where i can search it?

pg_stat_activity

All users is connected in the database with postgres user.

Sincerely,

Joshua D. Drake

Thanks.
João Paulo Zavanela

---------------------------(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

- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHh6yOATb/zqfZUUQRAuqCAKCFHs1tp6Zar+2FIEhipJaSWskEowCbBp9y
TmFyoOPqqYajvLQqy36EB0k=
=v8pM
-----END PGP SIGNATURE-----

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.

On Jan 11, 2008, at 11:51 AM, Joshua D. Drake wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 11 Jan 2008 14:29:32 -0300
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.

Entirely depends on your machine. I wouldn't suggest having more
than a
1000 open at any given time though. Also take a look at connection
pooling.

Are there some table where i can search it?

pg_stat_activity

All users is connected in the database with postgres user.

I think he was looking for some kind of logging/reporting of how many
connections have actually been made for a given day. He should be
looking at turning on log_connections and then parsing his logs for
connection entries.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

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.