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
|
# File 'lib/pg_monitor/user_tables.rb', line 7
def fetch
query = " SELECT \n relname AS table_name,\n seq_scan,\n last_seq_scan,\n seq_tup_read,\n idx_scan,\n last_idx_scan,\n idx_tup_fetch,\n n_tup_ins,\n n_tup_upd,\n n_tup_del,\n n_live_tup,\n n_dead_tup,\n last_vacuum,\n last_autovacuum,\n last_analyze,\n last_autoanalyze,\n vacuum_count,\n autovacuum_count,\n analyze_count,\n autoanalyze_count\n FROM pg_stat_user_tables\n ORDER BY relname;\n SQL\n\n result = DBConnection.connection.exec(query)\n result.map { |row| row }\nend\n"
|