This is the Linux app named PgHero whose latest release can be downloaded as pgherov4.1.0sourcecode.zip. It can be run online in the free hosting provider OnWorks for workstations.
Download and run online this app named PgHero with OnWorks for free.
Follow these instructions in order to run this app:
- 1. Downloaded this application in your PC.
- 2. Enter in our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 3. Upload this application in such filemanager.
- 4. Start the OnWorks Linux online or Windows online emulator or MACOS online emulator from this website.
- 5. From the OnWorks Linux OS you have just started, goto our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 6. Download the application, install it and run it.
SCREENSHOTS:
PgHero
DESCRIPTION:
PGHero (ankane/pghero) is an open-source tool for monitoring and analyzing PostgreSQL database performance, built to provide insights into query behavior, index usage, replication lag, and resource bottlenecks. It runs alongside your application (often as a Rails engine, but usable standalone) and collects metrics from PostgreSQL system views, logging slow queries, long-running transactions, and missing indexes. The web interface presents dashboards with charts and tables that help you understand trends, spot inefficient queries, and identify opportunities for optimization. PGHero supports customizable thresholds and notifications, so you can be alerted when slowness or index problems emerge. It also includes views of replication and connection statistics, helping teams monitor operational health without deploying external monitoring tools.
Features
- Overview dashboard showing slowest queries, query count, database load
- Ability to inspect query details over time (total time, average time, number of calls)
- Space statistics: table/index growth, unused indexes, tracking storage usage over time
- Suggested indexes to improve performance, and alerts/checks for things like transaction ID wraparound or integer overflow
- Supports multiple installation modes: run as Docker, Linux package, or integrated within a Rails app
- Basic security/access control via simple authentication (password or credentials) for the dashboard
Programming Language
Ruby
Categories
This is an application that can also be fetched from https://sourceforge.net/projects/pghero.mirror/. It has been hosted in OnWorks in order to be run online in an easiest way from one of our free Operative Systems.