Get Compound Index Patterns

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

{
  "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
}

Namespace

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

analytics

namespaces

indexes

compound-patterns

Get Compound Index Patterns

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

{
  "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

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

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

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

Get Most Queried Fields Get Index Recommendations