PgHero.sql is the project that inspired the PgHero Ruby Web app. This app provides the same functionality as PgHero.sql, only from a Web-based GUI.
PgHero.sql does practically the same thing, only using SQL commands and working from the user's database terminal.
Support is included for viewing all active queries, getting a list of long-running operations (five minutes and more), and killing problematic queries that are hindering the database server.
Index usage, missing and unused indexes can also be consulted, along with a list of disk space usage for all indexes and individual tables.
All these details are presented using neatly spaced tables inside your console, so you can easily get a grasp of the displayed data and continue debugging your PostgreSQL database's usage.
Requirements:
- PostgreSQL 9.2 or higher
Comments not found