Re: Finding connected users

---

• From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
• To: marcbastin(at)mindspring(dot)com
• Cc: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>, pgsql-novice-owner(at)postgresql(dot)org
• Subject: Re: Finding connected users
• Date: Fri, 12 Sep 2003 08:34:38 -0700
• Message-id: <OF5513081F.6656B5A4-ON88256D9F.005572D1-88256D9F.005638F2@fds.com> <text/plain>

---

Select * from pg_stat_activity

HTH
Patrick Hatcher



|--------+--------------------------------->
|        |          "M. Bastin"            |
|        |          <marcbastin(at)mindspring(dot)|
|        |          com>                   |
|        |          Sent by:               |
|        |          pgsql-novice-owner(at)post|
|        |          gresql.org             |
|        |                                 |
|        |                                 |
|        |          09/12/2003 03:10 AM    |
|--------+--------------------------------->
  >----------------------------------------------------------------------------------------------------------|
  |                                                                                                          |
  |      To:     PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>                                               |
  |      cc:                                                                                                 |
  |      Subject:     [NOVICE] Finding connected users                                                       |
  >----------------------------------------------------------------------------------------------------------|




Hi,

I posted this question before on this list but got no replies and
still didn't find the answer myself, so here's another attempt:

How can I find the currently connected users?  I.e. what query must I
use from a TCP/IP client?

Thanks,

Marc

----------------
Original question:

I would like to know what the best queries are to get system status info
like:

Number of connected users
List of connected user names with the database to which they are connected
List of used databases with number of currently connected users
Last startup date and time of PostgreSQL
IP address

etc. (If anybody can think of anything else)
I already know SELECT VERSION()  ;-)

(on version 7.3, on a client over TCP/IP)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
      message can get through to the mailing list cleanly

---

• References:
  • Finding connected users
    • From: M. Bastin

---

• Prev by Date: Re: operation logging
• Next by Date: Standard in must be a tty
• Previous by thread: Re: Finding connected users
• Next by thread: Slow VACUUM
• Indexes:
  • Main
  • Thread

Home | Main Index | Thread Index