kostmo / circleci-failure-tracker

A log analyzer for CircleCI. Note that this project is now hosted at pytorch/dr-ci
https://github.com/pytorch/dr-ci
5 stars 2 forks source link

Use MATERIALIZED VIEW to speed up grid timeline display #45

Closed kostmo closed 5 years ago

kostmo commented 5 years ago

See documentation.

In particular, the computation of "contiguous regions" of breakages currently requires multiple table scans, for which the data is rarely updated.

The view can be periodically refreshed with:

REFRESH MATERIALIZED VIEW mymatview;