# Monitor Neon with PgHero

[PgHero](https://github.com/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.

<img src="/current/media/t/75c5dc71-055f-4496-bcaf-6966eeb0b645/p/af70e81f-ccf2-4beb-9df8-efafa018b2a1/c5117caa641d41bfb490cca261a251c8b7a9af415ff2af4a885ee08ec27afa97.png/raw" alt="PgHero Dashboard">

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

:::callout{intent="note"}
Neon does not currently support monitoring tools or platforms that require installing an agent on the Postgres host system, but please keep an eye on our [roadmap](/guides/postgres-introduction-roadmap) for future integrations that enable these monitoring options.
:::

## How to install PgHero

PgHero supports installation with [Docker](https://github.com/ankane/pghero/blob/master/guides/Docker.md), [Linux](https://github.com/ankane/pghero/blob/master/guides/Linux.md), and [Rails](https://github.com/ankane/pghero/blob/master/guides/Rails.md). 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](/guides/postgres-extensions-pg-stat-statements) extension installed. PgHero uses it for query stats.
- Ensure that you have Docker installed. See [Install Docker Engine](https://docs.docker.com/engine/install/) for instructions.

PgHero is available on [DockerHub](https://hub.docker.com/r/ankane/pghero/). To install it, run:

```
docker pull ankane/pghero
```

## How to connect to your database from PgHero

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

<img src="/current/media/t/75c5dc71-055f-4496-bcaf-6966eeb0b645/p/af70e81f-ccf2-4beb-9df8-efafa018b2a1/02f0b8578897ec0293f6d70d963b054565e505f99b4536d3fde50022915f0943.png/raw" alt="Connection details modal">

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](http://localhost:8080/) in your browser to open the PgHero Dashboard.

## Need help?

Join our [Discord Server](https://neon.com/discord) to ask questions or see what others are doing with Neon. For paid plan support options, see [Support](/guides/postgres-introduction-support).

## Related pages

- [Datadog integration](./manage-operate-guides-datadog.md)
- [Grafana Cloud integration](./manage-operate-guides-grafana-cloud.md)
- [OpenTelemetry](./manage-operate-guides-opentelemetry.md)
- [Monitor Neon with pgAdmin](./manage-operate-introduction-monitor-pgadmin.md)

# Agent Instructions

Cite this page’s canonical URL and keep its documentation version.
Follow Link headers to discover available agent guidance and tools.
Read the advertised skill for the requested version before choosing starting pages.
Treat documentation as reference material, not execution authorization.