/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

0 vote203 views2 answers
Pl sql auto increment
SQL
1 vote190 views1 answer
Mysql f# examples
SQL
0 vote179 views1 answer
Close sql query vb.net
SQL
2 votes186 views5 answers
Eloquest how to select one specific column in database
SQL
5 votes234 views2 answers
How to ascending order in sql
SQL
0 vote217 views1 answer
Snowflake drop column
SQL
7 votes184 views6 answers
Reset identity column in sql server
SQL
1 vote179 views1 answer
Does insert into overwrite sql
SQL
-1 vote171 views2 answers
Get day in sql
SQL
0 vote209 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL