Get Compound Index Patterns

Identify compound index opportunities.

Finds metadata fields commonly used together in filters, suggesting opportunities for compound (multi-field) indexes.

Use Cases:

• Optimize multi-field queries
• Create compound indexes
• Understand query complexity
• Improve complex filter performance

Response Includes:

• Field combinations used together
• Frequency of combination usage
• Average and P95 latency
• Sorted by combination frequency

Compound Index Example: If brand + status appears frequently, create:

db.documents.createIndex({"metadata.brand": 1, "metadata.status": 1})

Example:

curl -X GET "https://api.mixpeek.com/v1/analytics/namespaces/indexes/compound-patterns" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "X-Namespace: your-namespace"

GET /v1/analytics/namespaces/indexes/compound-patterns

Get Compound Index Patterns

cURL

curl --request GET \
  --url https://api.mixpeek.com/v1/analytics/namespaces/indexes/compound-patterns \
  --header 'Authorization: Bearer <token>' \
  --header 'X-Namespace: <api-key>'

200

{
  "namespace_id": "<string>",
  "time_range_days": 123,
  "patterns": [
    {
      "field_combination": [
        "<string>"
      ],
      "combination_count": 123,
      "avg_latency_ms": 123,
      "p95_latency_ms": 123
    }
  ],
  "total_patterns": 123
}

Authorizations

Authorization · string · header · required

Mixpeek API key, sent as Authorization: Bearer mxp_sk_.... Create one in Studio under Settings → API Keys, or with an admin key via POST /v1/organizations/users/{user_email}/api-keys. A missing header returns 403; an invalid or revoked key returns 401.

X-Namespace · string · header · required

Namespace id (ns_...), not the namespace name. This scopes the request rather than authenticating it, and it is required on every operation marked x-mixpeek-namespace-scoped.

Query Parameters

days · integer · default: 30

Days of history to analyze

Required range: 1 <= x <= 90

limit · integer · default: 50

Maximum patterns to return

Required range: 1 <= x <= 1000

Response

200

application/json

Successful Response

Response for compound index patterns endpoint.

namespace_id · string · required

Namespace ID analyzed

time_range_days · integer · required

Number of days analyzed

patterns · CompoundIndexPattern · object[] · required

Compound field patterns

Show child attributes

total_patterns · integer · required

Total patterns found