Texonom
Texonom
/
Engineering
Engineering
/Data Engineering/DataBase/Database Type/RDBMS/PostgreSQL/Postgres Structure/Postgre Table/
PG pg_stat_activity
Search

PG pg_stat_activity

Creator
Creator
Seonglae Cho
Created
Created
2021 Apr 7 1:35
Editor
Editor
Seonglae Cho
Edited
Edited
2021 Apr 7 1:35
Refs
Refs

check all connection

select * from pg_stat_activity where datname = 'mydatabasename';
 
How to see active connections and "current activity" in PostgreSQL 8.4
Thanks for contributing an answer to Server Fault! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To learn more, see our tips on writing great answers.
How to see active connections and "current activity" in PostgreSQL 8.4
https://serverfault.com/questions/128284/how-to-see-active-connections-and-current-activity-in-postgresql-8-4
How to see active connections and "current activity" in PostgreSQL 8.4
 
 
 
 
 
 
 
 
 
 

Recommendations

Texonom
Texonom
/
Engineering
Engineering
/Data Engineering/DataBase/Database Type/RDBMS/PostgreSQL/Postgres Structure/Postgre Table/
PG pg_stat_activity
Copyright Seonglae Cho