Sign inSign up

repodb/insights-postgres

By repodb

•Updated 3 months ago

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

Image
Developer tools
Databases & storage
Monitoring & observability
0

324

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

3 months ago

docker pull repodb/insights-postgres