Install pghero on Mac
A performance dashboard for Postgres – health checks, suggested indexes, and more. PgHero 2.0 provides, even more, insight into your database performance with two additional features: query details and space stats.
PgHero makes it easy to see the most time-consuming queries during a given time period, but it’s hard to follow an individual query’s performance over time. When you run into issues, it’s not always easy to uncover what happened. Are the top queries during an incident consistently the most time-consuming, or are they new? Did the number of calls increase or was it the average time?
Source: pghero
Prerequisites
- Docker must be installed
Starting Postgres Container
In this tutorial, I am installing pghero on docker. I am installing pghero for postgres docker container that is running on my Mac. You can install pghero for postgres server running on Mac without docker and you can use pghero docker for remote postgres servers also.
I am starting a new postgres container because I don’t have container running with postgres so I am starting a new container. In next step, I will show you how to install pghero for already running postgres container also.
Create a network for pghero
Firstly we will create a network so that postgres container and pghero container will be on the same network and reachable.
docker network create pghero
Start postgres Container
Now we will start postgres container in the pghero network.
docker run -itd -p 5433:5432 --network pghero --name postgres postgres:9.6.2
docker ps
Now we have postgres container running.
Start pghero container
Now we will start our pghero container with the following options.
docker run -ti --network pghero \
-e DATABASE_URL=postgres://postgres:postgres@postgres:5432/postgres \
-p 8080:8080 --name hero ankane/pghero
Now we have started pghero also let’s go to the browser to view the pghero dashboard.
View the pghero
Now go to any browser and go to localhost:8080 and you will see the dashboard.
Here you go. You can see the queries, connections, and lot of stuff here.
Pghero with already running postgres container
Now I will start postgres with an already running container. You need to start the pghero on the same network in order to connect to postgres container.
[root@installvirtual ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
c8ed89b65990 postgres:9.6.2 "docker-entrypoint.sh" 32 minutes ago Up 32 minutes 0.0.0.0:5433->5432/tcp postgres
Now you need to look up the network of the already running container. Just execute following command and replace the container id with yours.
[root@installvirtual ~]# docker network ls
NETWORK ID NAME DRIVER SCOPE
287eba0f724c bridge bridge local
c4d2699a51a3 host host local
8ca745341a40 installvirtual bridge local
d4ffb7d56071 none null local
Then inspect the docker container and grep Network ID.
[root@installvirtual ~]# docker inspect postgres | grep NetworkID
"NetworkID": "8ca745341a409298912c132dc13974f94f63c31059eaa9279d61357df7d4cbf4"
So now you need to look for first 12 digits of Network ID and match it with our networks. My first 12 digits are 8ca745341a40 and the network of Postgres container is installvirtual.
docker run -ti --network installvirtual \
-e DATABASE_URL=postgres://postgres:postgres@postgres:5432/postgres \
-p 8080:8080 \
--name hero ankane/pghero
Now my pghero is started and it is working and reachable to the Postgres container.
If you get any issues in installing pghero and resolving Postgres container please feel free to comment below.