Visualize Logs from OR

[csaba1651]

Hi, I'm looking for a method to vizualized this kind of data:

Do you have some recommendations, because OR Logs don't show these type of data and I want to somehow make an automation, that shows me how much has a specific user spent in a month let's say. This would be very useful.

Edit: forgot to mention, that this daata is shown in .csv exports from OR, I'm just looking for an automation instead of prompting a llm to read it for me

[rbb-dev]

@csaba1651 These are the ID's to send to OpenRouter, in case you need to investigate any abuse, check these docs

if you're after the billing, this requires the following valve:

This means that a Redis setup will be required.

There is an example script for dumping Redis data. This script saves the data to a database in a format required by another GitHub project, but you can modify it to dump into CSV files if necessary.
https://github.com/rbb-dev/Open-WebUI-OpenRouter-pipe/blob/main/scripts/update_usage_db.py

The project itself is here:

https://github.com/VariantConst/OpenWebUI-Monitor

[csaba1651]

Very cool, it seems like it could be very useful, therefore I've set it up. It needed and OWUI function, in order to make the statistics and it counts the cost based on values that I had to manually set for each model. It seems like it isn't that advanced since it counts only input and output tokens, not reasoning and cached tokens. I have a hard time understanding what does this valve you mentioned in your pipeline actually do, bacause switching it doesn't seem to do anything, or am I wrong?

Edit: I can't find any information in the docs for setting this script up, can you please help me

[csaba1651]

I have my OWUI and redis-valkey running and OWUI-Monitor running as well but in a separete compose file, I can see the pipeline outputing those cost "KEYS" to valkey, but how do I get them to the monitors db, I know the script is supossed to sync them to monitors postgres but how? I tried to make a docker container running the script like every 10 seconds, but the connections are difficullt to set up correctly, what am I missing?