/SQL/Postgresql print sessions using the database

Postgresql print sessions using the database

select pid as process_id, 
       usename as username, 
       datname as database_name, 
       client_addr as client_address, 
       application_name,
       backend_start,
       state,
       state_change
from pg_stat_activity;

Source: dataedo.com

Similar codes

7 votes202 views1 answer
Mysql remote connection command line
SQL
0 vote190 views1 answer
Sql date d'aujourd'hui
SQL
0 vote226 views1 answer
Sql delimiter to columns
SQL
0 vote237 views1 answer
Virtuoso sql query tutorial
SQL
0 vote202 views1 answer
SQL authentication error
SQL
0 vote204 views1 answer
Redudancy in SQL
SQL
0 vote302 views3 answers
Get count of null in column sql
SQL
4 votes197 views1 answer
SQL order random
SQL
0 vote192 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote207 views1 answer
Oracle synonym procedure dblink
SQL