django-pgstats provides commands and models for tracking internal postgres stats. Specifically, the IndexStats model stores stats about postgres indices and the TableStats model stores stats about postgres tables.
Postgres stat tables contain global statistical information. django-pgstats is meant to be executed periodically so that one can later analyze table and index usage. This is done by periodically calling python manage.py snapshot_pgstats using a task runner such as Celery.
Stats are stored as JSON fields in the respective IndexStats and TableStats models. Each key in the JSON field is in the format of {schema}.{table} for table stats or {schema}.{table}.{index} for index stats.
django-pgstats is compatible with Python 3.9 - 3.13, Django 4.2 - 5.1, Psycopg 2 - 3, and Postgres 13 - 17.
View the django-pgstats docs here
Install django-pgstats with:
pip3 install django-pgstats
After this, add pgstats to the INSTALLED_APPS setting of your Django project.
For information on setting up django-pgstats for development and contributing changes, view CONTRIBUTING.md.
- @wesleykendall (Wes Kendall)
- @tomage (Tómas Árni Jónasson)