feat(metrics): add user_stats table that tracks more granular usage information per user#177
Merged
Conversation
|
The latest updates on your projects. Learn more about Vercel for Git ↗︎
|
…oute to fetch all user stats for the dashboard we'll eventually create
waleedlatif1
force-pushed
the
feat/metrics
branch
from
March 24, 2025 21:35
0264693 to
5f40f84
Compare
waleedlatif1
marked this pull request as ready for review
March 24, 2025 21:49
RadoBoiii
pushed a commit
to RadoBoiii/sim-fork
that referenced
this pull request
Apr 13, 2025
…nformation per user (simstudioai#177) * added user_stats table to track total number of workflow runs * added metrics for different types of triggers and runs * add total_tokens_used and total_cost metrics * ran migrations for new table, fixed build issue. added a user/stats route to fetch all user stats for the dashboard we'll eventually create * fix bug with api deployment status not appearing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1 participant
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Description
In this PR, we added a user_stats table to postgres that includes information about totalWorkflowRuns, totalApiCalls, totalWebhookTriggers, totalScheduledExecutions, totalTokensUsed, totalCost, workflowsCreated, lastActive. This information will help inform us on how much each of the triggers is being used, as well as see the power users by tracking how many executions they've ran. Also, when we launch we'll need to limit the number of executions for free users, and this will be an easy way to do that.
Fixes #176
Type of change
How Has This Been Tested?
I ran the migrations and tested to ensure all fields of this table were getting updated.
Checklist:
Security Considerations: