PgHero

Software screenshot:
PgHero
Rincian Software:
Versi: 1.1.3 Diperbarui
Tanggal Upload: 10 Dec 15
Pengembang: Andrew Kane
Lisensi: Gratis
Popularitas: 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

Software yang serupa

ToroDB
ToroDB

9 Apr 16

drive-db
drive-db

10 Dec 15

PL/JSON
PL/JSON

13 Apr 15

Knex.js
Knex.js

10 Feb 16

Perangkat lunak lain dari pengembang Andrew Kane

Mailkick
Mailkick

1 Oct 15

Searchjoy
Searchjoy

13 Apr 15

Postjoy
Postjoy

13 Apr 15

Komentar untuk PgHero

Komentar tidak ditemukan
Tambahkan komentar
Aktifkan gambar!