pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
(no subject) 2+ messages / 2 participants [nested] [flat]
* (no subject) @ 2007-10-18 17:42 Sherrylyn(Work) <shines@datasof.com> 0 siblings, 1 reply; 2+ messages in thread From: Sherrylyn\(Work\) @ 2007-10-18 17:42 UTC (permalink / raw) To: pgsql-admin Hi , Does any one know how I would get a list of users currently connected to a postgres database? In Oracle, I could select from the vg$sessions table. Is there a corollary table in Postgres? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: @ 2007-10-18 22:22 Alex Kloss <alexkloss@att.net> parent: Sherrylyn(Work) <shines@datasof.com> 0 siblings, 0 replies; 2+ messages in thread From: Alex Kloss @ 2007-10-18 22:22 UTC (permalink / raw) To: Sherrylyn(Work) <shines@datasof.com>; pgsql-admin -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sherrylyn(Work) wrote: > Hi , > Does any one know how I would get a list of users currently connected to a > postgres database? In Oracle, I could select from the vg$sessions table. Is > there a corollary table in Postgres? > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > SELECT usename FROM pg_stat_activity WHERE datname='databasename' There's many other connection statistics in pg_stat_activity as well, such as IP address, current query... Alex Rowe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFHF9y3LGN3BhEHOicRAmOpAJ9ia+gYRRRJORBCXEvnwur3tIScEgCdHugX E4fzATbhmA0SxYtIQ986xyQ= =deCX -----END PGP SIGNATURE----- ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-10-18 22:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-10-18 17:42 Sherrylyn(Work) <shines@datasof.com> 2007-10-18 22:22 ` Re: Alex Kloss <alexkloss@att.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox