Skip to content

Never stop coding. Free MIT AI gateway: one endpoint, 375 providers (150+ free), 1,400+ models Kimi, Claude, GPT, Gemini, GLM, DeepSeek, MiniMax. Works with Claude Code, Codex, Cursor, OpenCode, Cline & Copilot. Quota-aware auto-fallback, RTK+Caveman compression saves 15-95% tokens, MCP/A2A, Desktop/PWA. Built by 900+ contributors

1.1 KB
Raw Blame
-- 048_summary_indexes.sql
-- Add composite indexes for efficient querying of summary tables

-- Composite indexes for daily_usage_summary
CREATE INDEX IF NOT EXISTS idx_daily_usage_provider_date
  ON daily_usage_summary(provider, date);

CREATE INDEX IF NOT EXISTS idx_daily_usage_model_date
  ON daily_usage_summary(model, date);

CREATE INDEX IF NOT EXISTS idx_daily_usage_provider_model_date_composite
  ON daily_usage_summary(provider, model, date);

-- Composite indexes for hourly_usage_summary
CREATE INDEX IF NOT EXISTS idx_hourly_usage_provider_date
  ON hourly_usage_summary(provider, date_hour);

CREATE INDEX IF NOT EXISTS idx_hourly_usage_model_date
  ON hourly_usage_summary(model, date_hour);

CREATE INDEX IF NOT EXISTS idx_hourly_usage_provider_model_date_composite
  ON hourly_usage_summary(provider, model, date_hour);

-- Add unique constraint to prevent duplicate aggregations
CREATE UNIQUE INDEX IF NOT EXISTS idx_daily_usage_unique
  ON daily_usage_summary(provider, model, date);

CREATE UNIQUE INDEX IF NOT EXISTS idx_hourly_usage_unique
  ON hourly_usage_summary(provider, model, date_hour);