Metadata-Version: 2.1
Name: pgperf
Version: 0.1.5
Summary: PostgreSQL Performance Tools
Home-page: https://github.com/aldovillagra/pgperf
License: GPL-3.0-or-later
Author: Aldo A. Villagra B.
Author-email: aldovillagra@gmail.com
Requires-Python: >=3.8,<4.0
Classifier: License :: OSI Approved :: GNU General Public License v3 or later (GPLv3+)
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Requires-Dist: Jinja2 (>=3.1.2,<4.0.0)
Requires-Dist: SQLAlchemy (>=1.4.36,<2.0.0)
Requires-Dist: XlsxWriter (>=3.0.3,<4.0.0)
Requires-Dist: fire (>=0.4.0,<0.5.0)
Requires-Dist: numpy (>=1.22.4,<2.0.0)
Requires-Dist: omegaconf (>=2.2.1,<3.0.0)
Requires-Dist: pandas (>=1.4.2,<2.0.0)
Requires-Dist: psycopg2 (>=2.9.3,<3.0.0)
Requires-Dist: rich (>=12.4.4,<13.0.0)
Requires-Dist: tabulate (>=0.8.9,<0.9.0)
Project-URL: Bug Tracker, https://github.com/aldovillagra/pgperf/issues
Project-URL: Documentation, https://github.com/aldovillagra/pgperf#readme
Project-URL: Repository, https://github.com/aldovillagra/pgperf
Description-Content-Type: text/markdown

# Python PostgreSQL Performance Tools

Python port of [Heroku PG Extras](https://github.com/heroku/heroku-pg-extras) with several additions and improvements. The goal of this project is to provide powerful insights into the PostgreSQL database for Python apps that are not using the Heroku PostgreSQL plugin.

Queries can be used to obtain information about a Postgres instance, that may be useful when analyzing performance issues. This includes information about locks, index usage, buffer cache hit ratios and vacuum statistics. Python API enables developers to easily integrate the tool into e.g. automatic monitoring tasks.

You can check out this blog post for detailed step by step tutorial on how to [optimize PostgreSQL using PG Extras library](https://pawelurbanek.com/postgresql-fix-performance).

Alternative versions:

- [Ruby](https://github.com/pawurb/ruby-pg-extras)

- [Ruby on Rails](https://github.com/pawurb/rails-pg-extras)

- [NodeJS](https://github.com/pawurb/node-postgres-extras)

- [Elixir](https://github.com/pawurb/ecto_psql_extras)

- [Haskell](https://github.com/pawurb/haskell-pg-extras)
