A PGSQL schema for repodb_insights database used by all RepoDB Insights services.
289
The PostgreSQL-based schema and Docker assets for the repodb_insights database used by all RepoDB Insights services (Collector, Query, Purger, FileDataSinker and Visualization).
Bakes the schema into the image itself — no volume mounts required.
Create the network (skip if it already exists):
docker network create repodb
Run the image.
docker run -d --name repodb-insights-postgres \
-p 5432:5432 \
-e POSTGRES_PASSWORD=RepoDB2026 \
--network=repodb \
repodb/insights-postgres:latest
The POSTGRES_PASSWORD is required at docker run time — the image does not set one at build time, so credentials never end up baked into the image layers. Omitting it prevents the container from starting.
Services connect via CONNECTION_STRING:
postgresql://postgres:RepoDB2026@repodb-insights-postgres:5432/repodb_insights
A table DefaultTelemetry is created by default and is used to store telemetry records emitted by RepoDB libraries. See the structure as follow.
| Column | Type | Notes |
|---|---|---|
Group, Application, SessionId, Operation | VARCHAR | Identify the source of the telemetry event. |
StartTime | TIMESTAMP | Indexed; primary time-range filter used by all query paths. |
Statement | TEXT | The executed statement/operation text. |
Elapsed | FLOAT | Duration in milliseconds. |
IsCancelled | BOOLEAN | Whether the operation was cancelled. |
Client, Source, Version | VARCHAR | Client/environment metadata. |
CreatedAt, UpdatedAt | TIMESTAMP | Defaults to CURRENT_TIMESTAMP. |
Content type
Image
Digest
sha256:2c7d7b15e…
Size
109.9 MB
Last updated
2 months ago
docker pull repodb/insights-postgres