Database query bottlenecks are the primary cause of high API latency. Fine-tuning PostgreSQL indexes and execution plans yields order-of-magnitude speedups.

Table Partitioning by Range

-- Create Partitioned Table for Large Log Data
CREATE TABLE telemetry_logs (
    log_id BIGSERIAL,
    created_at TIMESTAMPTZ NOT NULL,
    service_name VARCHAR(64),
    payload JSONB
) PARTITION BY RANGE (created_at);

-- Create Monthly Partition
CREATE TABLE telemetry_logs_y2026m08 PARTITION OF telemetry_logs
    FOR VALUES FROM ('2026-08-01') TO ('2026-09-01');

-- Create Composite Index
CREATE INDEX idx_telemetry_created_service 
ON telemetry_logs_y2026m08 (created_at DESC, service_name);