guides/Docker.md in pghero-1.5.2 vs guides/Docker.md in pghero-1.5.3
- old
+ new
@@ -1,5 +1,43 @@
# PgHero for Docker
-:fire: [Get it](https://github.com/bmorton/pghero_solo)
+PgHero is available as a [Docker image](https://hub.docker.com/r/ankane/pghero/).
-More instructions coming soon
+```sh
+docker run -ti -e DATABASE_URL=postgres://user:password@hostname:5432/dbname -p 8080:8080 ankane/pghero
+```
+
+And visit [http://localhost:8080](http://localhost:8080).
+
+## Query Stats
+
+Query stats can be enabled from the dashboard. If you run into issues, [view the guide](Query-Stats.md).
+
+## Historical Query Stats
+
+To track query stats over time, create a table to store them.
+
+```sql
+CREATE TABLE "pghero_query_stats" (
+ "id" serial primary key,
+ "database" text,
+ "user" text,
+ "query" text,
+ "query_hash" bigint,
+ "total_time" float,
+ "calls" bigint,
+ "captured_at" timestamp
+)
+CREATE INDEX ON "pghero_query_stats" ("database", "captured_at")
+```
+
+Schedule the task below to run every 5 minutes.
+
+```sh
+docker run -ti -e DATABASE_URL=... ankane/pghero bin/rake pghero:capture_query_stats
+```
+
+After this, a time range slider will appear on the Queries tab.
+
+## Credits
+
+Thanks to [Brian Morton](https://github.com/bmorton) for the [original Docker image](https://github.com/bmorton/pghero_solo).