codex_daily_usages

Daily Codex usage metrics per user

id

Primary key
Unique identifier for the row.

date

date
The date for which the usage metrics are recorded (UTC).

user_id

Foreign key
Foreign key referencing the parent codex_users record.

is_active

boolean
Indicates if the user had any Codex activity (threads or turns) on this date.

total_threads

number
Total number of Codex threads started by the user on this date.

total_turns

number
Total number of Codex turns taken by the user on this date.

total_credits

number
Total Codex credits consumed by the user on this date.

total_uncached_text_input_tokens

number
Total uncached text input tokens consumed by the user on this date.

total_cached_text_input_tokens

number
Total cached text input tokens consumed by the user on this date.

total_text_output_tokens

number
Total text output tokens produced for the user on this date.

total_text_total_tokens

number
Total text tokens (input + output) for the user on this date.