Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feature: query aggregate data over RIB #112

Open
ties opened this issue Mar 12, 2025 · 0 comments
Open

feature: query aggregate data over RIB #112

ties opened this issue Mar 12, 2025 · 0 comments

Comments

@ties
Copy link

ties commented Mar 12, 2025

Hi,

I have a rotonda instance with a significant amount of data in it. I want to query simple aggregate statistics over the routing tables in there, and I think this may warrant an API endpoint that returns less data (it also does not necessarily need to be json, grpc, arrow flight, etc may be good alternatives).

$ time curl curl -s http://localhost:8080/prefixes/193.0.0.0/20?include=moreSpecifics > /dev/null
real    0m0.341s
user    0m0.004s
sys     0m0.008s
$ curl curl -s http://localhost:8080/prefixes/193.0.0.0/20?include=moreSpecifics | wc -l
388679
$ curl curl -s http://localhost:8080/prefixes/193.0.0.0/20?include=moreSpecifics | jq '.included.moreSpecifics[] | "\(.p
refix) \(.attributes[] | select(.asPath) | .asPath[-1])"' | sort | uniq -c
    386 "193.0.0.0/21 AS3333"
    386 "193.0.10.0/23 AS3333"
    386 "193.0.12.0/23 AS3333"
    430 "193.0.14.0/23 AS25152"
    485 "193.0.14.0/24 AS25152"
    453 "193.0.15.0/24 AS25152"
    419 "193.0.8.0/23 AS197000"
    431 "193.0.8.0/24 AS197000"
    441 "193.0.9.0/24 AS197000"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant