Answers for "postgres see connections to database"

psql connections

SELECT * FROM pg_stat_activity;

Posted by: Guest on August-17-2020

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 "postgres see connections to database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres see connections to database"

Code answers related to "postgres see connections to database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres see connections to database"

Code answers related to "postgres see connections to database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us