Andrew Kane is announcing that PgHero with version number 1.1.0 is already available to download.
What is PgHero ?
PgHero is A Ruby application for providing insightful details and statistics about how a PostgreSQL database is currently running and how it’s being used by its owners .
PgHero can show a small status review for a desired PostgreSQL database.This is done via a Web-based interface where admins can go and check out how their database is being used.Admins can view a list of recent queries, current indexes, the disk space occupied by tables and indexes, and even run custom SQL queries.They can also view a list of slow queries that might hinder the database’s usage, and also kill current live queries if things go out of hand.An insight in the databases cache hit rate is also provided, a useful indicator that a database server might need more memory in the future. In case all your team needs access to PgHero you can create multiple user accounts, and even password-protect them to prevent unauthorized access.PgHero is written in Ruby and is also available as a GEM file.If you don’t like working with Ruby apps, PgHero is also available as an SQL stored procedure that you can run via a PostgreSQL database GUI or from the DB’s CLI. The project is named PgHero.sql.
This is changelog for PgHero version 1.1.0 :
- More platforms
- Support for multiple databases
- Added replica? method
- Added replication_lag method
You can read the complete changelog and also download this latest version on their homepage: github.com