sub2api/backend/migrations/226_add_usage_log_effective_model_indexes_notx.sql

CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_usage_logs_effective_requested_model_created
    ON usage_logs (
        (COALESCE(NULLIF(BTRIM(requested_model), ''), model)),
        created_at DESC,
        id DESC
    );

CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_usage_logs_effective_upstream_model_created
    ON usage_logs (
        (COALESCE(NULLIF(BTRIM(upstream_model), ''), model)),
        created_at DESC,
        id DESC
    );