/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 vote286 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
4 votes389 views1 answer
Mysql query first character
SQL
0 vote320 views1 answer
How to drop columns with constraint from a table in sql script
SQL
11 votes341 views4 answers
Query DISTINCT
SQL
1 vote360 views3 answers
What is union in sql
SQL
0 vote360 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote350 views1 answer
OFFSET consulta mysql
SQL
0 vote345 views1 answer
Monthly Birthday SQL Query
SQL
0 vote393 views1 answer
Hashpass
SQL
1 vote351 views3 answers
Get all tables postgres
SQL