Billing breakdown per db

Q&A
1

is it possible to get the billing breakdown per database in the pro plan?

2

Welcome to bit.io and thanks for posting!

At this time there is no way to get a rows queried breakdown on a per-database basis.

If you would like to see your row usage on a per-connection basis, you can append rows_queried to the username you use to connect to bit.io. This will instruct bit.io to send NOTICE messages containing row usage stats for that connection (and may help you understand which of your databases is triggering more row usage).

If you haven’t already, please review Rows Queried In-Depth for more information about rows queried tracking.

BTW, stay tuned for pricing updates in the coming weeks

3

thanks for the response . is it possible to do get the row queries through the rest api as well? and for the jdbc if you can send me a sample with rows_queried , it would be useful. i just want to know if their any seperator or anything after the username

thanks
Nuwan

4

Via our rest API you can find the total rows queried for all accessors against a specific database:

Click the “200 response” line to get a modal showing the response object.

And to answer your other question, here is a sample JDCB bit.io connection string with the rows_queried option enabled.

jdbc:postgresql://steve_rows_queried:<REDACTED>@db.bit.io:5432/steve/test-db

1 Like