PgHero

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.

What is new in this release:

• More platforms
• Support for multiple databases
• Added replica method
• Added replication_lag method
• Added ssl_used method
• Added kill_long_running_queries method
• Added env vars for settings

What is new in version 1.1.1:

• More platforms
• Support for multiple databases
• Added replica method
• Added replication_lag method
• Added ssl_used method
• Added kill_long_running_queries method
• Added env vars for settings

What is new in version 1.1.0:

• More platforms
• Support for multiple databases
• Added replica method
• Added replication_lag method
• Added ssl_used method
• Added kill_long_running_queries method
• Added env vars for settings

What is new in version 1.0.1:

• More platforms
• Support for multiple databases
• Added replica method
• Added replication_lag method
• Added ssl_used method
• Added kill_long_running_queries method
• Added env vars for settings

What is new in version 0.1.9:

• Added total_percent to query_stats
• Added total_connections
• Added connection_stats for Amazon RDS

What is new in version 0.1.7:

• Added support for pg_stat_statments on Amazon RDS.
• Added long_running_query_sec, slow_query_ms and slow_query_calls options.

Requirements:

• PostgreSQL 9.2 or higher