/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 vote287 views2 answers
Mysql SELECT
SQL
0 vote312 views1 answer
Mysql disable query caching
SQL
0 vote259 views1 answer
Copy table dbeaver
SQL
0 vote256 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote306 views1 answer
Oracle explain plan
SQL
0 vote314 views1 answer
Postgresql not in alternative
SQL
0 vote297 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
3 votes349 views3 answers
Mysql auto increment after delete
SQL
11 votes323 views1 answer
Get ddl materialized view oracle
SQL
3 votes279 views1 answer
How to get list of synonyms in oracle
SQL