--- a/analyzeall.py	Tue May 06 18:37:41 2014 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,51 +0,0 @@
-#!/usr/bin/env python3
-"""
-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
-
-
-class AnalyzeAllTool(toolbase.SimpleTool):
-    def __init__(self):
-        toolbase.SimpleTool.__init__(self, name='analyzeall', desc='Analyze all tables.')
-        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('--vacuum-full', action='store_true', help='Call VACUUM FULL ANALYZE')
-        self.parser.add_argument('--reindex', action='store_true', help='Call REINDEX TABLE')
-        self.target_isolation_level = 'autocommit'
-        self.init()
-
-    def main(self):
-        browser = pgbrowser.PgBrowser(self.pgm.get_conn('target'))
-
-        query_patterns = ['ANALYZE %s.%s;']
-        if self.args.vacuum:
-            query_patterns = ['VACUUM ANALYZE %s.%s;']
-        if self.args.vacuum_full:
-            query_patterns = ['VACUUM FULL ANALYZE %s.%s;']
-        if self.args.reindex:
-            query_patterns += ['REINDEX TABLE %s.%s;']
-
-        schema_list = self.args.schema
-        if not schema_list:
-            schema_list = [schema['name'] for schema in browser.list_schemas() if not schema['system']]
-
-        for schema in schema_list:
-            tables = browser.list_tables(schema=schema)
-            with self.pgm.cursor('target') as curs:
-                for table in tables:
-                    for query_pattern in query_patterns:
-                        query = query_pattern % (schema, table['name'])
-                        self.log.info(query)
-                        curs.execute(query, [])
-
-
-tool = AnalyzeAllTool()
-tool.main()
-