mhicauber

# Java flight recording snapshot : 
docker exec  <containerID> jcmd <java PID inside container> JFR.start name=monitor30m maxage=30m maxsize=250M

# Dump will be stored in container app root path (/opt/jboss/***.jfr in my case) after 30m

# If you want to stop it before maxage time : 
docker exec <containerID> jcmd <java PID inside container> JFR.stop name=monitor30m filename=/tmp/debugrun1.jfr

# JFR file can be analyser with Oracle Java Mission Control

mhicauber

-- find missing indexes
SELECT
	conrelid::regclass, conname, reltuples::bigint
FROM
	pg_constraint
JOIN pg_class 
	ON conrelid = pg_class.oid
WHERE 
	contype = 'f'
	AND NOT EXISTS (

mhicauber

-- find missing indexes
SELECT
	conrelid::regclass, conname, reltuples::bigint
FROM
	pg_constraint
JOIN pg_class 
	ON conrelid = pg_class.oid
WHERE 
	contype = 'f'
	AND NOT EXISTS (

mhicauber

FROM osrm/osrm-backend:v5.20.0

RUN apk --no-cache add curl

RUN mkdir /data

RUN curl http://download.geofabrik.de/europe/bretagne-latest.osm.pbf > /data/bretagne-latest.osm.pbf

RUN osrm-extract -p /opt/car.lua /data/bretagne-latest.osm.pbf
RUN osrm-contract /data/bretagne-latest.osrm