feat: Consider add Pagination and Date/Aggregations Filter to Stats and Metrics Queries #27
Description
In several of the queries to fetch performance metrics, and lists of SQL statements/GraphQL operations (with interval aggregation), the result set can be large -- large enough to 1) be impractical for a user to work through and 2) too fine/coarse grained to have meaning and 3) lots of rendering for the browser to do.
To improve the experience (both from performance and also usability/information overload) we could:
- set filters for date/time s (last 5 mins, 10 min, etc)
- set interval aggregation filters (group op/sql counts by 5 mins, 10, mins, etc)
- paginate the results
From a tech note, could be a great way to explore Apollo Client pagination caching and also fragments.