Function loadTraceSummary

modules/sentry/api_exceptions.go:367–399

(db *sql.DB, traceID string)

}

func loadTraceSummary(db *sql.DB, traceID string) map[string]any {
	// Load transaction for this trace.
	var (
		txnName    sql.NullString
		op         sql.NullString
		durationMS sql.NullInt64
		startTS    sql.NullString
	)

	err := db.QueryRow(
		`SELECT transaction_name, op, duration_ms, start_ts
		FROM sentry_transactions WHERE trace_id = ? ORDER BY start_ts LIMIT 1`, traceID,
	).Scan(&txnName, &op, &durationMS, &startTS)
	if err != nil {
		return nil
	}

	// Get span count.
	var spanCount int
	db.QueryRow(`SELECT COUNT(*) FROM sentry_spans WHERE trace_id = ?`, traceID).Scan(&spanCount)

	// Load top 3 spans by duration for preview.
	previewSpans := loadPreviewSpans(db, traceID, startTS, 3)

	return map[string]any{
		"trace_id":         traceID,
		"transaction_name": scanNullString(txnName),
		"op":               scanNullString(op),
		"duration_ms":      scanNullInt(durationMS),
		"span_count":       spanCount,
		"preview_spans":    previewSpans,
	}
}

// loadPreviewSpans loads the top N spans by duration for mini-waterfall preview.
func loadPreviewSpans(db *sql.DB, traceID string, txnStartTS sql.NullString, limit int) []map[string]any {