Answers for "postgresql select all sessions"

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;

Posted by: Guest on March-10-2020

Code answers related to "postgresql select all sessions"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql select all sessions"

Code answers related to "postgresql select all sessions"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql select all sessions"

Code answers related to "postgresql select all sessions"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us