^h6@SSKJr SSKJr \rS\4SjrS\S\4Sjrg))Any)verbose_loggerdbc# URS5IShvN [S5 URS5IShvN [S5 URS 5IShvN [S 5 URS5IShvN [S5 URS5IShvN [S5 URS5IShvN [S5 URS5IShvN [S5 URS5IShvN [S 5 gGN![a) URS5IShvN [S5 GN9f=fGN(![a) SnURUS 9IShvN [S 5 GNMf=fGN= (CURRENT_DATE - INTERVAL '30 days') GROUP BY DATE("startTime"); queryzMonthlyGlobalSpend Created!z*SELECT 1 FROM "Last30dKeysBySpend" LIMIT 1zLast30dKeysBySpend Exists!a CREATE OR REPLACE VIEW "Last30dKeysBySpend" AS SELECT L."api_key", V."key_alias", V."key_name", SUM(L."spend") AS total_spend FROM "LiteLLM_SpendLogs" L LEFT JOIN "LiteLLM_VerificationToken" V ON L."api_key" = V."token" WHERE L."startTime" >= (CURRENT_DATE - INTERVAL '30 days') GROUP BY L."api_key", V."key_alias", V."key_name" ORDER BY total_spend DESC; zLast30dKeysBySpend Created!z,SELECT 1 FROM "Last30dModelsBySpend" LIMIT 1zLast30dModelsBySpend Exists!a^ CREATE OR REPLACE VIEW "Last30dModelsBySpend" AS SELECT "model", SUM("spend") AS total_spend FROM "LiteLLM_SpendLogs" WHERE "startTime" >= (CURRENT_DATE - INTERVAL '30 days') AND "model" != '' GROUP BY "model" ORDER BY total_spend DESC; zLast30dModelsBySpend Created!z0SELECT 1 FROM "MonthlyGlobalSpendPerKey" LIMIT 1z MonthlyGlobalSpendPerKey Exists!a CREATE OR REPLACE VIEW "MonthlyGlobalSpendPerKey" AS SELECT DATE("startTime") AS date, SUM("spend") AS spend, api_key as api_key FROM "LiteLLM_SpendLogs" WHERE "startTime" >= (CURRENT_DATE - INTERVAL '30 days') GROUP BY DATE("startTime"), api_key; z!MonthlyGlobalSpendPerKey Created!z7SELECT 1 FROM "MonthlyGlobalSpendPerUserPerKey" LIMIT 1z'MonthlyGlobalSpendPerUserPerKey Exists!a CREATE OR REPLACE VIEW "MonthlyGlobalSpendPerUserPerKey" AS SELECT DATE("startTime") AS date, SUM("spend") AS spend, api_key as api_key, "user" as "user" FROM "LiteLLM_SpendLogs" WHERE "startTime" >= (CURRENT_DATE - INTERVAL '30 days') GROUP BY DATE("startTime"), "user", api_key; z(MonthlyGlobalSpendPerUserPerKey Created!z#SELECT 1 FROM DailyTagSpend LIMIT 1zDailyTagSpend Exists!ap CREATE OR REPLACE VIEW DailyTagSpend AS SELECT jsonb_array_elements_text(request_tags) AS individual_request_tag, DATE(s."startTime") AS spend_date, COUNT(*) AS log_count, SUM(spend) AS total_spend FROM "LiteLLM_SpendLogs" s GROUP BY individual_request_tag, DATE(s."startTime"); zDailyTagSpend Created!z/SELECT 1 FROM "Last30dTopEndUsersSpend" LIMIT 1zLast30dTopEndUsersSpend Exists!af CREATE VIEW "Last30dTopEndUsersSpend" AS SELECT end_user, COUNT(*) AS total_events, SUM(spend) AS total_spend FROM "LiteLLM_SpendLogs" WHERE end_user <> '' AND end_user <> user AND "startTime" >= CURRENT_DATE - INTERVAL '30 days' GROUP BY end_user ORDER BY total_spend DESC LIMIT 100; z Last30dTopEndUsersSpend Created!) query_rawprint Exception execute_raw)r sql_querys W/home/james-whalen/.local/lib/python3.13/site-packages/litellm/proxy/db/create_views.pycreate_missing_viewsrs8llVWWW 56&-llKLLL *+$-llKLLL *+4/llMNNN ,-(3llQRRR 01&:ll I    78,(llDEEE %& 2llPQQQ /0  [ X 8nn    67!8& M -  nn9n--- +,-$ M - (nn9n--- +,/-4 O / nn9n--- -.%/( S 3  nn9n--- 12#3&  : nn9n--- 89':, F  (  nn9n--- &' ( R  2  nn9n--- 01  2sK3D/D,D/E(E%E(F!"F#F!3GGGH,H-H=I I I "J6J7JJ>J;J>+K3,D//E" EE"K3!E""K3%E((FF FK3FK3F!!G?GGK3GK3GH 8G;9H  K3 H  K3HI1H42IK3IK3 I I?*I-+I?;K3>I??K3JJ8#J&$J84K37J88K3;J>>K0KK0-K3/K00K3returnc# SnURUS9IShvN n[R"SRU55 U(a[ U[ 5(al[ U5S:a][ US[5(aESUS;a<USS(a/USSS:Xd USSS:Xa[R"S5 g g N7f) zm Run only on first time startup. If SpendLogs table already has values, then don't create views on startup. ze SELECT reltuples::BIGINT FROM pg_class WHERE oid = '"LiteLLM_SpendLogs"'::regclass; rNz-Estimated Row count of LiteLLM_SpendLogs = {}r reltupleszShould create viewsTF)r rdebugformat isinstancelistlendict)rr results rshould_create_missing_viewsrsI <r"s2" | 3| ~#$r!