analyzeall.py
changeset 30 a8b7cd92f39f
parent 28 27fc0504663d
child 52 26121a8fe78b
--- a/analyzeall.py	Tue Feb 14 18:15:56 2012 +0100
+++ b/analyzeall.py	Mon Feb 27 15:12:40 2012 +0100
@@ -1,4 +1,12 @@
 #!/usr/bin/env python3.2
+"""
+analyzeall
+
+Analyze/vacuum all tables in selected schemas.
+See also "VACUUM ANALYZE VERBOSE;" query.
+Unlike that, this program skips pg_catalog etc.
+
+"""
 
 from pgtoolkit import pgbrowser, toolbase
 from pgtoolkit.highlight import highlight
@@ -10,6 +18,7 @@
         self.parser.add_argument('-s', dest='schema', nargs='*', help='Schema filter')
         self.parser.add_argument('--vacuum', action='store_true', help='Call VACUUM ANALYZE')
         self.parser.add_argument('--full', action='store_true', help='Call VACUUM FULL ANALYZE')
+        self.target_isolation_level = 'autocommit'
         self.init()
 
     def main(self):