/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 vote329 views1 answer
Import big data to mysql
SQL
0 vote385 views1 answer
Wordpress make wp user in db
SQL
0 vote324 views1 answer
How to install mysql without admin rights
SQL
0 vote323 views1 answer
PSQL qith variables
SQL
0 vote331 views1 answer
Install sql server in ubuntu 20.04
SQL
22 votes404 views1 answer
Mysql workbench
SQL
0 vote337 views1 answer
Merge clause with inner join
SQL
0 vote300 views1 answer
Duplicate foreign key constraint name
SQL
10 votes344 views2 answers
Sql pagination offset
SQL
1 vote337 views3 answers
How to get date in sql
SQL