Investigate if the largest projects can be benefit from further partitioning

[imsdu]

Motivation
States and events tables are partitioned by org and project.

More information here

This allows to speed up most queries as they almost always include the org and project.
However when projects reach a certain size, we may want to further partition them to have faster queries

Acceptance criteria

1. Analyze the execution plans for the most common queries (including indexing related ones) for different projects from small to large, get the size of the partitions and of their indices
2. Depending on the results, investigate ways to further partition for the largest projects