How can you get the active users connected to a postgreSQL database via SQL

Question

How can you get the active users connected to a postgreSQL database via SQL  This could be the userid s or number of users

User · Answer

Using balexandre s info   SELECT usesysid  usename FROM pg stat activity

User · Answer

Using balexandre s info   SELECT usesysid  usename FROM pg stat activity

User · Answer

question  Don t you get that info in     select   from pg user    or using the view pg stat activity   select   from pg stat activity    Added   the view says      One row per server process  showing database OID  database name  process ID  user OID  user name  current query  query s waiting status  time at which the current query began execution  time at which the process was started  and client s address and port number  The columns that report data on the current query are available unless the parameter stats command string has been turned off  Furthermore  these columns are only visible if the user examining the view is a superuser or the same as the user owning the process being reported on    can t you filter and get that information  that will be the current users on the Database  you can use began execution time to get all queries from last 5 minutes for example     something like that

User · Answer

OP asked for users connected to a particular database   -- Who s currently connected to my great database  SELECT   FROM pg stat activity    WHERE datname    my great database     This gets you all sorts of juicy info  as others have mentioned  such as   userid  column usesysid  username  usename  client application name  appname   if it bothers to set that variable -- psql does  -  IP address  client addr  what state it s in  a couple columns related to state and wait status  and everybody s favorite  the current SQL command being run  query

User · Answer

question  Don t you get that info in     select   from pg user    or using the view pg stat activity   select   from pg stat activity    Added   the view says      One row per server process  showing database OID  database name  process ID  user OID  user name  current query  query s waiting status  time at which the current query began execution  time at which the process was started  and client s address and port number  The columns that report data on the current query are available unless the parameter stats command string has been turned off  Furthermore  these columns are only visible if the user examining the view is a superuser or the same as the user owning the process being reported on    can t you filter and get that information  that will be the current users on the Database  you can use began execution time to get all queries from last 5 minutes for example     something like that

User · Answer

question  Don t you get that info in     select   from pg user    or using the view pg stat activity   select   from pg stat activity    Added   the view says      One row per server process  showing database OID  database name  process ID  user OID  user name  current query  query s waiting status  time at which the current query began execution  time at which the process was started  and client s address and port number  The columns that report data on the current query are available unless the parameter stats command string has been turned off  Furthermore  these columns are only visible if the user examining the view is a superuser or the same as the user owning the process being reported on    can t you filter and get that information  that will be the current users on the Database  you can use began execution time to get all queries from last 5 minutes for example     something like that

User · Answer

question  Don t you get that info in     select   from pg user    or using the view pg stat activity   select   from pg stat activity    Added   the view says      One row per server process  showing database OID  database name  process ID  user OID  user name  current query  query s waiting status  time at which the current query began execution  time at which the process was started  and client s address and port number  The columns that report data on the current query are available unless the parameter stats command string has been turned off  Furthermore  these columns are only visible if the user examining the view is a superuser or the same as the user owning the process being reported on    can t you filter and get that information  that will be the current users on the Database  you can use began execution time to get all queries from last 5 minutes for example     something like that

User · Answer

Using balexandre s info   SELECT usesysid  usename FROM pg stat activity

User · Answer

OP asked for users connected to a particular database   -- Who s currently connected to my great database  SELECT   FROM pg stat activity    WHERE datname    my great database     This gets you all sorts of juicy info  as others have mentioned  such as   userid  column usesysid  username  usename  client application name  appname   if it bothers to set that variable -- psql does  -  IP address  client addr  what state it s in  a couple columns related to state and wait status  and everybody s favorite  the current SQL command being run  query

User · Answer

Using balexandre s info   SELECT usesysid  usename FROM pg stat activity

[sql] How can you get the active users connected to a postgreSQL database via SQL?

Examples related to sql

Examples related to postgresql

Examples related to active-users