[CalendarServer-changes] [6891] CalendarServer/trunk/contrib/tools/pg_stats_analysis.py
source_changes at macosforge.org
source_changes at macosforge.org
Sat Feb 5 09:39:54 PST 2011
Revision: 6891
http://trac.macosforge.org/projects/calendarserver/changeset/6891
Author: cdaboo at apple.com
Date: 2011-02-05 09:39:52 -0800 (Sat, 05 Feb 2011)
Log Message:
-----------
Fix average time sorting table.
Modified Paths:
--------------
CalendarServer/trunk/contrib/tools/pg_stats_analysis.py
Modified: CalendarServer/trunk/contrib/tools/pg_stats_analysis.py
===================================================================
--- CalendarServer/trunk/contrib/tools/pg_stats_analysis.py 2011-02-05 03:43:13 UTC (rev 6890)
+++ CalendarServer/trunk/contrib/tools/pg_stats_analysis.py 2011-02-05 17:39:52 UTC (rev 6891)
@@ -72,7 +72,7 @@
COLUMN_temp_blks_read = 12
COLUMN_temp_blks_written = 13
-def sqlStatementsByAverageTime(entries):
+def sqlStatementsReport(entries):
dcount = collections.defaultdict(int)
dtime = collections.defaultdict(float)
@@ -91,7 +91,7 @@
for sorttype, sortedkeys in (
("count", [i[0] for i in sorted(dcount.iteritems(), key=lambda x:x[1], reverse=True)],),
("total time", [i[0] for i in sorted(dtime.iteritems(), key=lambda x:x[1], reverse=True)],),
- ("average time", [i[0] for i in sorted(dtime.iteritems(), key=lambda x:x[1], reverse=True)],),
+ ("average time", [i[0] for i in sorted(daverage.iteritems(), key=lambda x:x[1], reverse=True)],),
):
table = tables.Table()
table.addHeader(("Statement", "Count", "Count %", "Total Time", "Total Time %", "Av. Time", "Av. Time %",))
@@ -177,7 +177,7 @@
if verbose:
print "Read %d entries" % (len(entries,))
- sqlStatementsByAverageTime(entries)
+ sqlStatementsReport(entries)
def usage(error_msg=None):
if error_msg:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20110205/2fc6b1c9/attachment.html>
More information about the calendarserver-changes
mailing list