Tauren Mills wrote:
> I posted this message to the admin list, but just realized maybe it belongs
> in the general list. Sorry for double posting!
>
> I need to find a way to determine how many concurrent connections are being
> made to the database server at any given time. I'm coming from
> administering a MySQL database and am familiar with the following command:
>
> mysqladmin -uroot -p processlist
>
> This lists something like this:
>
> +-----+------+-----------+----+---------+------+------------------+
> | Id | User | Host | db | Command | Time | Info |
> +-----+------+-----------+----+---------+------+------------------+
> | 307 | root | localhost | | Sleep | 0 | |
> | 308 | root | localhost | | Sleep | 0 | |
> | 309 | root | localhost | | Query | 0 | show processlist |
> +-----+------+-----------+----+---------+------+------------------+
Among alot more statistics down to number of rows returned by
scans, this will be added in v7.2:
pgsql=# select * from pg_stat_database;
datid | datname | numbackends | xact_commit | xact_rollback | blks_read |
blks_hit
-------+-----------+-------------+-------------+---------------+-----------+----------
1 | template1 | 0 | 0 | 0 | 0 |
0
19030 | template0 | 0 | 0 | 0 | 0 |
0
19070 | pgsql | 3 | 0 | 0 | 0 |
0
19093 | wieck | 0 | 0 | 0 | 0 |
0
(4 rows)
pgsql=# select * from pg_stat_activity;
datid | datname | procpid | usesysid | usename | current_query
-------+---------+---------+----------+---------+---------------
19070 | pgsql | 1576 | 501 | pgsql |
19070 | pgsql | 1578 | 501 | pgsql |
19070 | pgsql | 1580 | 501 | pgsql |
(3 rows)
The numbers are mostly zero because I haven't activated the
collection of statistics in the config file.
Approximately what you're looking for?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== [EMAIL PROTECTED] #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
