psql-stat-optimizer 0.0.45

Description:

psqlstatoptimizer 0.0.45

query-plan-optimizer

Postgresql Statistics are vital for a good query plan. This library finds tables with large number of live tuples and tries to find related models with foreign key to the model and sets statistics for the field on destination model.
Installation
$ pip install psql-stat-optimizer

add psql_optimizer to your INSTALLED_APPS
usage:
Using full optimize command:
$ ./manage.py optimize_statistics

Valid Parameters:

set_all: if passed as True it sets for all founded models automatically
analyze_all: if passed as True it analyzes all models after their statistics is changed
live_tup_count: the minimum number of n_live_tup to consider as a big table. default is 100000
statistics: the statistics value you want to set to. default is 10000

Using statistics command:
$ ./manage.py set_statistics

Parameters:

table: the target table name
column: the target column
statistics: the target statistics

TODO:

remove time.sleep which is used for printing
add command for analyze a table manually