# django-pgstats
`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](http://www.celeryproject.org/).
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.
## Compatibility
`django-pgstats` is compatible with Python 3.8 - 3.12, Django 3.2 - 5.0, Psycopg 2 - 3, and Postgres 12 - 16.
## Documentation
[View the django-pgstats docs here](https://django-pgstats.readthedocs.io/)
## Installation
Install `django-pgstats` with:
pip3 install django-pgstats
After this, add `pgstats` to the `INSTALLED_APPS` setting of your Django project.
## Contributing Guide
For information on setting up django-pgstats for development and contributing changes, view [CONTRIBUTING.md](CONTRIBUTING.md).
## Primary Authors
- @wesleykendall (Wes Kendall)
- @tomage (Tómas Árni Jónasson)
Raw data
{
"_id": null,
"home_page": "https://github.com/Opus10/django-pgstats",
"name": "django-pgstats",
"maintainer": null,
"docs_url": null,
"requires_python": "<4,>=3.8.0",
"maintainer_email": null,
"keywords": null,
"author": "Wes Kendall",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/3b/5d/cedbf0466cb025beae61fd52b0121ef4b2170dfcc5f876528675ab0a0705/django_pgstats-1.3.1.tar.gz",
"platform": null,
"description": "# django-pgstats\n\n`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.\n\nPostgres 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](http://www.celeryproject.org/).\n\nStats 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.\n\n## Compatibility\n\n`django-pgstats` is compatible with Python 3.8 - 3.12, Django 3.2 - 5.0, Psycopg 2 - 3, and Postgres 12 - 16.\n\n## Documentation\n\n[View the django-pgstats docs here](https://django-pgstats.readthedocs.io/)\n\n## Installation\n\nInstall `django-pgstats` with:\n\n pip3 install django-pgstats\n\nAfter this, add `pgstats` to the `INSTALLED_APPS` setting of your Django project.\n\n## Contributing Guide\n\nFor information on setting up django-pgstats for development and contributing changes, view [CONTRIBUTING.md](CONTRIBUTING.md).\n\n## Primary Authors\n\n- @wesleykendall (Wes Kendall)\n- @tomage (T\u00f3mas \u00c1rni J\u00f3nasson)\n\n",
"bugtrack_url": null,
"license": "BSD-3-Clause",
"summary": "Commands and models for tracking internal postgres stats.",
"version": "1.3.1",
"project_urls": {
"Documentation": "https://django-pgstats.readthedocs.io",
"Homepage": "https://github.com/Opus10/django-pgstats",
"Repository": "https://github.com/Opus10/django-pgstats"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "400d68470add176faa7526a149513e4d88102d85483bedba88e39cd9f787ea5c",
"md5": "f77591a40596767fa8f57504b9d6e0ed",
"sha256": "d81b76de83a6fd44bb0e652ea1e848e8a741609ad4ed30c8447314a70e73b7b2"
},
"downloads": -1,
"filename": "django_pgstats-1.3.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "f77591a40596767fa8f57504b9d6e0ed",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4,>=3.8.0",
"size": 5430,
"upload_time": "2024-04-06T16:51:40",
"upload_time_iso_8601": "2024-04-06T16:51:40.338906Z",
"url": "https://files.pythonhosted.org/packages/40/0d/68470add176faa7526a149513e4d88102d85483bedba88e39cd9f787ea5c/django_pgstats-1.3.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "3b5dcedbf0466cb025beae61fd52b0121ef4b2170dfcc5f876528675ab0a0705",
"md5": "59e8bc0545cc08c12338562f7b25b416",
"sha256": "04e3baccdd411801671d29b3737d8d4a1a4e38651362f22dc339ac66787002f8"
},
"downloads": -1,
"filename": "django_pgstats-1.3.1.tar.gz",
"has_sig": false,
"md5_digest": "59e8bc0545cc08c12338562f7b25b416",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4,>=3.8.0",
"size": 4249,
"upload_time": "2024-04-06T16:51:41",
"upload_time_iso_8601": "2024-04-06T16:51:41.302645Z",
"url": "https://files.pythonhosted.org/packages/3b/5d/cedbf0466cb025beae61fd52b0121ef4b2170dfcc5f876528675ab0a0705/django_pgstats-1.3.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-06 16:51:41",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Opus10",
"github_project": "django-pgstats",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"circle": true,
"tox": true,
"lcname": "django-pgstats"
}
JSON
