Sign inSign up

repodb/insights-postgres

By repodb

Updated 2 months ago

A PGSQL schema for repodb_insights database used by all RepoDB Insights services.

Image
Developer tools
Databases & storage
Monitoring & observability
0

289

repodb/insights-postgres repository overview

RepoDB Insights Database for PostgreSQL

The PostgreSQL-based schema and Docker assets for the repodb_insights database used by all RepoDB Insights services (Collector, Query, Purger, FileDataSinker and Visualization).

Running with Docker

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.

Connection

Services connect via CONNECTION_STRING:

postgresql://postgres:RepoDB2026@repodb-insights-postgres:5432/repodb_insights

Schema

A table DefaultTelemetry is created by default and is used to store telemetry records emitted by RepoDB libraries. See the structure as follow.

ColumnTypeNotes
Group, Application, SessionId, OperationVARCHARIdentify the source of the telemetry event.
StartTimeTIMESTAMPIndexed; primary time-range filter used by all query paths.
StatementTEXTThe executed statement/operation text.
ElapsedFLOATDuration in milliseconds.
IsCancelledBOOLEANWhether the operation was cancelled.
Client, Source, VersionVARCHARClient/environment metadata.
CreatedAt, UpdatedAtTIMESTAMPDefaults to CURRENT_TIMESTAMP.

Tag summary

Content type

Image

Digest

sha256:2c7d7b15e

Size

109.9 MB

Last updated

2 months ago

docker pull repodb/insights-postgres