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
30
31
32
33
34
35
36
37
|
# File 'lib/pghero/methods/connections.rb', line 4
def connections
if server_version_num >= 90500
select_all <<~SQL
SELECT
pg_stat_activity.pid,
datname AS database,
usename AS user,
application_name AS source,
client_addr AS ip,
state,
ssl
FROM
pg_stat_activity
LEFT JOIN
pg_stat_ssl ON pg_stat_activity.pid = pg_stat_ssl.pid
ORDER BY
pg_stat_activity.pid
SQL
else
select_all <<~SQL
SELECT
pid,
datname AS database,
usename AS user,
application_name AS source,
client_addr AS ip,
state
FROM
pg_stat_activity
ORDER BY
pid
SQL
end
end
|