/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

1 vote116 views1 answer
Set statiscis on in ssms
SQL
0 vote127 views1 answer
How to update sql server version
SQL
1 vote113 views1 answer
Tsql create unique index composite
SQL
2 votes130 views1 answer
Where clause for child record apex
SQL
4 votes110 views4 answers
Date less than in sql
SQL
0 vote104 views1 answer
Drop all tables in azure sql database
SQL
0 vote122 views1 answer
Mysql query to select the highest value
SQL
0 vote118 views1 answer
Postgresql where clause not working
SQL
0 vote115 views2 answers
Postgres show current role
SQL
0 vote121 views1 answer
Sql case sttement with set
SQL