Download the PHP package zvook/php-postgresql-stat without Composer
On this page you can find all versions of the php package zvook/php-postgresql-stat. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download zvook/php-postgresql-stat
More information about zvook/php-postgresql-stat
Files in zvook/php-postgresql-stat
Package php-postgresql-stat
Short Description PHP PostgreSQL statistic monitoring tool
License MIT
Homepage https://github.com/zvook/php-postgresql-stat
Informations about the package php-postgresql-stat
PHP tool for monitoring PostgreSQL statistic
Requirements
- PHP 5.6+
- PostgreSQL 9.2+ (9.5+ recommended)
Containing
- Database statistic
- Tables statistic
- Indexes statistic
- Functions statistic
- Statements
- Useless/Missing indexes analytic
Installation
-
Update your postgresql.conf
- Then connect to the database you want to track with user you will use to connect (not with postgres user!) and run:
!Please note that you should run SQL above exactly inside your database and exactly by your backend user
- Restart postgre server
-
Add to your composer.json
- Run
Demo
When package installed and postgreSQL configured you can build demo page to observe the situation. Go to the package root directory and edit demo.php with your database credentials. Then run:
Open demo.html with browser
Basic Usage
!Please not that pg_stat_statements needs a time for collecting statistic to provide you adequate information
Also you can find complete usage example in demo.php in the root dir of the package