/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 vote139 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote152 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote148 views1 answer
How to find total working hour in sql
SQL
0 vote138 views1 answer
Cannot pip install mysqlclient
SQL
0 vote130 views1 answer
Mysql match in serialized data
SQL
0 vote131 views1 answer
Check index sql server
SQL
0 vote143 views1 answer
Sql include rows with 0 values
SQL
0 vote188 views1 answer
Postgres dump sql insert
SQL
0 vote130 views1 answer
Mysql convert charset
SQL
0 vote124 views2 answers
Mysql slave status
SQL