Technologies/Langfuse/langfuse.database.query.duration
LangfuseLangfuseMetric

langfuse.database.query.duration

Database query execution duration
Dimensions:None
Available on:PrometheusPrometheus (1)CloudWatchCloudWatch (1)
Interface Metrics (2)
PrometheusPrometheus
Database query execution duration in seconds
Dimensions:None
CloudWatchCloudWatch
Duration of database queries in milliseconds
Dimensions:None
Sources
langfuse_db_query_duration_secondsgithub.com
langfuse.database.query.durationlangfuse.com

Technical Annotations (38)

Configuration Parameters (11)
orderBy.columnrecommended: timestamp
enables LIMIT 1 BY optimization instead of expensive FINAL operator
orderBy.orderrecommended: DESC
required with column to skip FINAL deduplication in ClickHouse
web.startupProbe.initialDelaySecondsrecommended: 60
Allows time for initial migrations before first health check
web.livenessProbe.initialDelaySecondsrecommended: 120
Prevents premature restart during migration completion
web.readinessProbe.initialDelaySecondsrecommended: 120
Delays readiness check until migrations complete
web.startupProbe.periodSecondsrecommended: 15
Check interval during startup phase
web.livenessProbe.periodSecondsrecommended: 15
Check interval for liveness
web.startupProbe.failureThresholdrecommended: 5
Number of failures before pod restart
max_execution_time
ClickHouse setting to raise timeout limits for heavy queries
max_memory_usage
ClickHouse setting to allow more memory for analytical queries
memory_allocationrecommended: 16 GiB or more
Recommended ClickHouse memory for heavy analytical workloads
Error Signatures (5)
context deadline exceeded (Client.Timeout exceeded while awaiting headers)log pattern
read: connection reset by peerlog pattern
CrashLoopBackOfferror code
Backend Service Overloaded Database resource limit exceeded. Please use more specific filters or a shorter time rangeerror code
Path: dashboard.executeQuerylog pattern
CLI Commands (1)
helm upgrade -i langfuse -f langfuse/langfuse -n observability-backend-langfuse-dev --version 0.13.1remediation
Technical References (21)
ReplacingMergeTreecomponentFINALconceptLIMIT 1 BYconceptgetTracesTableGenericcomponentweb/src/server/api/routers/traces.tsfile pathtraces.metricscomponenttraces.allcomponentstartupProbecomponentlivenessProbecomponentreadinessProbecomponent/api/public/readyfile path/api/public/healthfile path_prisma_migrationscomponentPrismacomponenthigh cardinality dimensionsconceptobservations tablecomponenttraces tablecomponentTrace latency percentiles panelcomponentLEFT JOINconceptINNER JOINconceptpercentile calculationsconcept
Related Insights (6)
Missing orderBy parameter causes 20x slowdown in traces.metrics endpointcritical
▸
Langfuse web pod fails health checks during startupcritical
▸
Failed Prisma migrations prevent Langfuse web container from startingcritical
▸
High cardinality dimensions blocked from grouping in v2 Metrics APIwarning
▸
Dashboard query timeout on large observations table prevents trace latency panel loadingwarning
▸
LEFT JOIN in trace percentile queries causes performance degradation at scaleinfo
▸