Download Source Code PgHero 1.1.0

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:

PgHero - PgHero can provide insightful details about a PostgreSQL databasePgHero - Details about ran queries can be logged and presentedPgHero - Index usage reports are also availablePgHero - PgHero also keeps a track of the space used by tables and indexesPgHero - Admins can also run SQL queries when they wantPgHero - A live query features lets admins see current running operations

Wagiman Wiryosukiro

Petani Sistem Informasi, tukang las plugin & themes Wordpress. Co-Founder Saat ini aktif sebagai Developer & kontributor di OpenMandriva Linux.

You may also like...

%d bloggers like this: