---
title: "Optimized version of fetch_graph using database-level aggregation."
method: GET
path: "/tracer/charts/fetch_graph/"
tags: ["tracer"]
---

# Optimized version of fetch_graph using database-level aggregation.

`GET /tracer/charts/fetch_graph/`

## Request

- Base URL: `http://localhost:8000`
- URL: `http://localhost:8000/tracer/charts/fetch_graph/`
- Auth: one of:
  - API key in header `X-Api-Key`
  - API key in header `X-Secret-Key`

Handles 1M+ datapoints efficiently with:
- Database-level time bucketing and aggregation
- Subquery-based filtering (no large IN clauses)
- Query result caching
- Minimal memory footprint

Performance targets:
- 20-30k datapoints: <100ms
- 100k datapoints: <500ms
- 1M datapoints: 2-3s

Query parameters same as fetch_graph.

## Query parameters

- `interval` string, required
- `filters` string
- `property` string
- `req_data_config` string, required
- `project_id` string, uuid, required
- `allow_sampled` boolean
- `refresh` boolean

## Response `200`

OK

- FetchGraphResponse
  - `status` boolean
  - `result` object, required: A single system-metric series, an all-system-metrics bundle, or an array of evaluation series.
    - `metric_name` string
    - `id` string
    - `name` string
    - `metric_statistic` 'count' | 'sum' | 'mean' | 'percentage'
    - `data` object[], required
      - `timestamp` string, required
      - `value` number, required
      - `primary_traffic` number
    - `query_complete` boolean, required
    - `query_status` 'complete' | 'pending' | 'sampled' | 'degraded', required
    - `query_sampled` boolean, required
    - `query_refreshing` boolean
    - `query_exact` boolean
    - `query_provenance` string
    - `query_count` integer
    - `query_elapsed_ms` number
    - `query_rows_returned` integer

## Other responses

- `400`: Bad Request
- `500`: Internal Server Error
- `503`: Service Unavailable
- `default`: Default error response

---

[API](https://skmtc.dev/futureagi/apis/future-agi-management-api.md) · [All operations](https://skmtc.dev/futureagi/apis/future-agi-management-api/llms.txt) · [OpenAPI document](https://skmtc.dev/futureagi/apis/future-agi-management-api/revisions/c8684118e142?raw)