# Как рассчитать использование токенов каждым пользователем в Discourse AI?

**URL:** https://meta.discourse.org/t/how-do-i-calculate-the-token-usage-of-every-user-in-discourse-ai/311706
**Category:** Data & reporting
**Tags:** ai
**Created:** [12.Июнь.2024 07:49:49 UTC](https://meta.discourse.org/t/how-do-i-calculate-the-token-usage-of-every-user-in-discourse-ai/311706 "2024-06-12T07:49:49Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [12.Июнь.2024 08:06:42 UTC](https://meta.discourse.org/t/how-do-i-calculate-the-token-usage-of-every-user-in-discourse-ai/311706/2 "2024-06-12T08:06:42Z")

</div>

```sql
-- [params]
-- date :start_date
-- date :end_date

WITH token_usage AS (
    SELECT
        user_id,
        SUM(request_tokens) AS total_request_tokens,
        SUM(response_tokens) AS total_response_tokens,
        SUM(request_tokens + response_tokens) AS total_tokens
    FROM
        ai_api_audit_logs
    WHERE
        created_at BETWEEN :start_date AND :end_date
    GROUP BY
        user_id
)
SELECT
    u.id user_id,
    tu.total_request_tokens,
    tu.total_response_tokens,
    tu.total_tokens
FROM
    token_usage tu
JOIN
    users u ON u.id = tu.user_id
ORDER BY
    tu.total_tokens DESC

```

Покажет топ использования по пользователям за указанный диапазон дат.

---

_[View the full topic](https://meta.discourse.org/t/how-do-i-calculate-the-token-usage-of-every-user-in-discourse-ai/311706)._