Maas-Agent/apps/application/sql/get_token_usage.sql

SELECT SUM(application_chat_record.message_tokens + application_chat_record.answer_tokens) as "token_usage",
       MAX(COALESCE(application_chat.asker ->>'username', '游客'))                         as "username"
FROM application_chat_record application_chat_record
         LEFT JOIN application_chat application_chat ON application_chat."id" = application_chat_record.chat_id
    ${default_sql}
GROUP BY
    application_chat.chat_user_id
ORDER BY
    "token_usage" DESC