Module: PgHero::Methods::Connections

Included in:
Database
Defined in:
lib/pghero/methods/connections.rb

Instance Method Summary collapse

Instance Method Details

#connection_sources(options = {}) ⇒ Object 



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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
 
# File 'lib/pghero/methods/connections.rb', line 8

def connection_sources(options = {})
  if options[:by_database_and_user]
    select_all "      SELECT\n        datname AS database,\n        usename AS user,\n        application_name AS source,\n        client_addr AS ip,\n        COUNT(*) AS total_connections\n      FROM\n        pg_stat_activity\n      WHERE\n        pid <> pg_backend_pid()\n      GROUP BY\n        1, 2, 3, 4\n      ORDER BY\n        5 DESC, 1, 2, 3, 4\n    SQL\n  elsif options[:by_database]\n    select_all <<-SQL\n      SELECT\n        application_name AS source,\n        client_addr AS ip,\n        datname AS database,\n        COUNT(*) AS total_connections\n      FROM\n        pg_stat_activity\n      WHERE\n        pid <> pg_backend_pid()\n      GROUP BY\n        1, 2, 3\n      ORDER BY\n        COUNT(*) DESC,\n        application_name ASC,\n        client_addr ASC\n    SQL\n  else\n    select_all <<-SQL\n      SELECT\n        application_name AS source,\n        client_addr AS ip,\n        COUNT(*) AS total_connections\n      FROM\n        pg_stat_activity\n      WHERE\n        pid <> pg_backend_pid()\n      GROUP BY\n        application_name,\n        ip\n      ORDER BY\n        COUNT(*) DESC,\n        application_name ASC,\n        client_addr ASC\n    SQL\n  end\nend\n"

#total_connections ⇒ Object 



4
5
6
 
# File 'lib/pghero/methods/connections.rb', line 4

def total_connections
  select_all("SELECT COUNT(*) FROM pg_stat_activity WHERE pid <> pg_backend_pid()").first["count"].to_i
end