PgHero

Software Screenshot:
PgHero
Software Details:
Version: 1.1.3 updated
Upload Date: 10 Dec 15
Developer: Andrew Kane
Distribution Type: Freeware
Downloads: 117

Rating: 5.0/5 (Total Votes: 1)

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

Similar Software

Edda
Edda

13 May 15

PgHero.sql
PgHero.sql

14 Apr 15

miniMySQLAdmin
miniMySQLAdmin

13 Apr 15

Other Software of Developer Andrew Kane

Blazer
Blazer

6 Mar 16

Postjoy
Postjoy

13 Apr 15

Barkick
Barkick

13 Apr 15

Chartkick.js
Chartkick.js

11 Mar 16

Comments to PgHero

Comments not found
Add Comment
Turn on images!