DBA Hub

📋Steps in this guide1/1

Find current sessions in postgres

Find sessions in the postgres:

postgresql configurationintermediate
by PostgreSQL
13 views
1

Find current sessions in postgres

Find sessions in the postgres: -- For specific database:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
select pid as process_id,
usename as username,
datname as database_name,
client_addr as client_address,
application_name,
backend_start,
state,
state_change,query
from pg_stat_activity;
select pid as process_id,
usename as username,
datname as database_name,
client_addr as client_address,
application_name,
backend_start,
state,
state_change,query
from pg_stat_activity where datname='dbaclass';
process_id | username | database_name | client_address | application_name |
backend_start
| state
|
state_change
------------+----------+---------------+----------------+------------------+----------------------------------+--------+----------------------------------
18970 | postgres | dbaclass
|
| psql
| 2020-07-03 20:27:42.225987+05:30 | active | 2020-07-03 23:19:12.023416+05:30
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!