/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 vote346 views1 answer
When mysql server would not work in xampp
SQL
3 votes330 views4 answers
Mysql create table from select statement
SQL
2 votes360 views1 answer
Use cases condition in sql query laravel
SQL
39 votes415 views4 answers
Select duplicates in sql
SQL
0 vote325 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote320 views1 answer
Search db for table name
SQL
0 vote344 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote364 views1 answer
Alter table change default
SQL
0 vote341 views1 answer
Insert output identity
SQL
0 vote292 views1 answer
Sqlalchemy filter relationship
SQL