ZhAgent/apps/application/sql/get_token_usage_ee.sql

SELECT SUM(application_chat_record.message_tokens + application_chat_record.answer_tokens) as "token_usage",
       MAX(COALESCE(chat_user.username, 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
         LEFT JOIN chat_user chat_user ON chat_user.id::varchar = application_chat.chat_user_id
    ${default_sql}
GROUP BY
    application_chat.chat_user_id
ORDER BY
    "token_usage" DESC