search

openfoodfacts / openfoodfacts-query

This extracts key product data from MongoDB into a Postgres database to speed up OFF
GNU Affero General Public License v3.0
0 stars 0 forks source link

Add a simple way to launch pgtop #46

Open alexgarel opened 1 month ago

alexgarel commented 1 month ago

It's very handy to be able to use pgtop even on a production database to see what's going on.

Add a simple way to launch pgtop.

alexgarel commented 1 month ago

It can be a make pgtop target.

To launch it it can be a docker/tools.yaml docker file with tools to launch manually (it should be used along with base docker files defined in COMPOSE_FILE variable). (prefered one)

or a pgtop docker container in the right network and pointing at the right address.

alexgarel commented 1 month ago

An even simpler way is to publish docker ports so that it is accessible on localhost @john-gom, I did it in prod (with a small edit directly in prod), to let @cquest analyze requests.