[mirrorbrain-commits] r7928 - /trunk/mirrordoctor/mb/dbmaint.py

Author: poeml
Date: Tue Dec 15 01:40:14 2009
New Revision: 7928

URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain?rev=7928&view=rev
Log:
mb db sizes:
- a table columns wasn't named correctly anymore, after we changed units
- include sizes of tables from mod_stats

Modified:
    trunk/mirrordoctor/mb/dbmaint.py

Modified: trunk/mirrordoctor/mb/dbmaint.py
URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain/trunk/mirrordoctor/mb/dbmaint.py?rev=7928&r1=7927&r2=7928&view=diff
==============================================================================
--- trunk/mirrordoctor/mb/dbmaint.py (original)
+++ trunk/mirrordoctor/mb/dbmaint.py Tue Dec 15 01:40:14 2009
_at_@ -26,10 +26,10 @@
     """show statistics about stale files in the database"""
 
     query = """SELECT relname, relkind, relfilenode, reltuples, relpages, 
-                      relpages*8 AS relMB 
+                      relpages*8 AS relKB 
                FROM pg_class 
                WHERE relkind IN ('r', 'i') 
-                      AND relname ~ '^.*(file|server|pfx|temp1).*' 
+                      AND relname ~ '^.*(file|server|pfx|temp1|stats).*' 
                ORDER BY 1"""
     rows = conn.Filearr._connection.queryAll(query)
 




_______________________________________________
mirrorbrain-commits mailing list
Archive: http://mirrorbrain.org/archive/mirrorbrain-commits/

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org