Monitor Neon with PgHero

PgHero is an open-source performance tool for Postgres that can help you find and fix data issues, using a dashboard interface.

A quick look at the interface gives you an idea of what you'll find in PgHero.

Among other things, you can use PgHero to:

• Identify long-running queries
• Identify tables that require vacuuming
• Identify duplicate or missing indexes
• View connections by database and user
• Explain, analyze, and visualize queries

PgHero supports installation with Docker, Linux, and Rails. Here, we'll show how to install PgHero with Docker and connect it to a Neon database.

Before you begin:

• Ensure that you have the pg_stat_statements extension installed. PgHero uses it for query stats.
• Ensure that you have Docker installed. See Install Docker Engine for instructions.

PgHero is available on DockerHub. To install it, run:

docker pull ankane/pghero

Find the connection string for your database by clicking the Connect button in the Console nav.

Finally, run this command, replacing $NEON_DB with your Neon database connection string.

docker run -ti -e DATABASE_URL='$NEON_DB' -p 8080:8080 ankane/pghero

Then visit http://localhost:8080 in your browser to open the PgHero Dashboard.

Join our Discord Server to ask questions or see what others are doing with Neon. For paid plan support options, see Support.