insights: [spike] scope work required to enable search aggregations on sourcegraph.com

Created by: chwarwick

Determine what work needs to be done and create issues for the work that would need to be completed to enable search aggregations to run on sourcegraph.com

Non exhaustive list of items to answer:

• Does sourcegraph.com have access to insights apis? If not does the work in https://github.com/sourcegraph/sourcegraph/issues/40368 resolve this?
• Will any of the search aggregation count:all queries complete in the allocated time?
• Any additional resource constrain issues/concerns?

/cc @joelkw @felixfbecker @vovakulikov @unclejustin