Cost of the old endpoint
The star table holds the current state, so removing a star deletes its row. Each page request counted all current stars to compute the page count, although it returned at most 100 rows. A full curve for react/react, with about 251,000 stars, needed about 2,511 requests. In the week before the restriction, about 37,000 count queries ran slowly, averaging nearly 3 seconds.
Database safeguards killed more than 1,000 of them.