Postgresql Set Statistics
Project description
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
TODO:
- remove time.sleep which is used for printing
- add command for set statistics manually
- add command for analyze a table manually
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for psql_stat_optimizer-0.0.42-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 855d0c0a0a4923f1e49cfacb5292b99a83396561bc118b8d5addf76f6f75d69f |
|
MD5 | 4041e7e19c9c983a399705c8d8d7c295 |
|
BLAKE2b-256 | 3172ec59b96dc170421bf09906761dfa410d8b44e972e5e6496b214ee7fc70de |