Database bandwidth
I'm consuming a lot of database bandwidth as reads. How to figure out what is causing that?
7 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
Under team settings > project usage, scroll down to the bottom, the last graph has a dropdown. Select "Database bandwidth" to see bandwidth consumed by specific functions, with the highest consumers listed first.
How does Convex's "database bandwidth" pricing work?
Seeing 37GB/month usage on 3 query functions. Dashboard shows:
- videos.getMultipleAccountVideos: 20.15 GB
- videos.getTimeSeriesData: 11.9 GB
- videos.getHourlyTimeSeriesData: 5.54 GB Questions: 1. Is this measuring data read from storage internally, or data sent to client? 2. Does .collect() on 1000 documents charge for all 1000 even if I filter after? 3. Are there patterns to reduce bandwidth for aggregate queries (SUM/COUNT)? Currently ~$7.52/month in bandwidth charges, growing as usage scales.
- videos.getHourlyTimeSeriesData: 5.54 GB Questions: 1. Is this measuring data read from storage internally, or data sent to client? 2. Does .collect() on 1000 documents charge for all 1000 even if I filter after? 3. Are there patterns to reduce bandwidth for aggregate queries (SUM/COUNT)? Currently ~$7.52/month in bandwidth charges, growing as usage scales.
Does .collect() on 1000 documents charge for all 1000 even if I filter after?,Yes, you should use indexes to avoid that.
Are there patterns to reduce bandwidth for aggregate queries (SUM/COUNT)?Are you using the Aggregate component? If not, give it a try. It should significantly reduce bandwidth.
On mine I think I am querying my indexes, but its still racking up huge bandwith consumption and I'm not sure how...
For specific guidance, I recommend starting a new thread. When doing so, please share examples from your code.