We can speed up the query that is used to generate the blocks report quite a lot by adding a condition on the post type to it, searching only through types post, page and campaign EDIT: so that it only searches types that could have blocks (NROs could have other types with blocks, we can get these types dynamically when doing the query).

Doing so the blocks report on test-deimos (which has data from international) went from around 20 seconds to load, to around 5. The speed improvement will differ for each NRO, depending on how many posts of other types are in the database.

branch: https://github.com/greenpeace/planet4-plugin-gutenberg-blocks/compare/faster-blocks-report