1
=== modified file 'utilities/report-database-stats.py'
2
--- utilities/report-database-stats.py	2010-05-20 10:34:29 +0000
3
+++ utilities/report-database-stats.py	2010-06-08 09:20:45 +0000
4
@@ -72,12 +72,22 @@
5
72
72
6
73
73
7
74
def get_cpu_stats(cur, options):
74
def get_cpu_stats(cur, options):
8
75
    # This query calculates the averate cpu utilization from the
9
76
    # samples. It assumes samples are taken at regular intervals over
10
77
    # the period.
11
75
    query = """
78
    query = """
13
76
        SELECT avg(cpu), username FROM DatabaseCpuStats
79
        SELECT (
14
80
            CAST(SUM(cpu) AS float) / (
15
81
                SELECT COUNT(DISTINCT date_created) FROM DatabaseCpuStats
16
82
                WHERE
17
83
                    date_created >= (CURRENT_TIMESTAMP AT TIME ZONE 'UTC')
18
84
                    - CAST (%s AS interval))
19
85
            ) AS avg_cpu, username
20
86
        FROM DatabaseCpuStats
21
77
        WHERE date_created >= (CURRENT_TIMESTAMP AT TIME ZONE 'UTC'
87
        WHERE date_created >= (CURRENT_TIMESTAMP AT TIME ZONE 'UTC'
22
78
            - CAST(%s AS interval))
88
            - CAST(%s AS interval))
23
79
        GROUP BY username
89
        GROUP BY username
25
80
        """ % sqlvalues(options.since_interval)
90
        """ % sqlvalues(options.since_interval, options.since_interval)
26
81
91
27
82
    cur.execute(query)
92
    cur.execute(query)
28
83
93
29
@@ -107,7 +117,7 @@
30
107
    tables = get_table_stats(cur, options)
117
    tables = get_table_stats(cur, options)
31
108
    arbitrary_table = list(tables)[0]
118
    arbitrary_table = list(tables)[0]
32
109
    interval = arbitrary_table.date_end - arbitrary_table.date_start
119
    interval = arbitrary_table.date_end - arbitrary_table.date_start
34
110
    per_minute = interval.days * 24 * 60 + interval.seconds / 60.0
120
    per_second = float(interval.days * 24 * 60 * 60 + interval.seconds)
35
111
121
36
112
    print "== Most Read Tables =="
122
    print "== Most Read Tables =="
37
113
    print
123
    print
38
@@ -119,8 +129,8 @@
39
119
    most_read_tables = sorted(
129
    most_read_tables = sorted(
40
120
        tables, key=attrgetter(*tables_sort), reverse=True)
130
        tables, key=attrgetter(*tables_sort), reverse=True)
41
121
    for table in most_read_tables[:options.limit]:
131
    for table in most_read_tables[:options.limit]:
44
122
        print "%40s || %10.2f tuples/min" % (
132
        print "%40s || %10.2f tuples/sec" % (
45
123
            table.relname, table.total_tup_read / per_minute)
133
            table.relname, table.total_tup_read / per_second)
46
124
    print
134
    print
47
125
135
48
126
    print "== Most Written Tables =="
136
    print "== Most Written Tables =="
49
@@ -130,15 +140,15 @@
50
130
    most_written_tables = sorted(
140
    most_written_tables = sorted(
51
131
        tables, key=attrgetter(*tables_sort), reverse=True)
141
        tables, key=attrgetter(*tables_sort), reverse=True)
52
132
    for table in most_written_tables[:options.limit]:
142
    for table in most_written_tables[:options.limit]:
55
133
        print "%40s || %10.2f tuples/min" % (
143
        print "%40s || %10.2f tuples/sec" % (
56
134
            table.relname, table.total_tup_written / per_minute)
144
            table.relname, table.total_tup_written / per_second)
57
135
    print
145
    print
58
136
146
59
137
    user_cpu = get_cpu_stats(cur, options)
147
    user_cpu = get_cpu_stats(cur, options)
60
138
    print "== Most Active Users =="
148
    print "== Most Active Users =="
61
139
    print
149
    print
62
140
    for cpu, username in sorted(user_cpu, reverse=True)[:options.limit]:
150
    for cpu, username in sorted(user_cpu, reverse=True)[:options.limit]:
64
141
        print "%40s || %6.2f%% CPU" % (username, float(cpu) / 100)
151
        print "%40s || %10.2f%% CPU" % (username, float(cpu) / 10)
65
142
152
66
143
153
67
144
if __name__ == '__main__':
154
if __name__ == '__main__':
Reviewer	Review Type	Date Requested	Status
Graham Binns (community)	code	2010-06-08	Approve on 2010-06-08
Review via email: mp+27026@code.launchpad.net