Launchpad itself

  1. Bug #892820
  2. Comment #9

Comment 9 for bug 892820

Revision history for this message
Robert Collins (lifeless) wrote : Re: Timeout on Distribution:+bugs

examining the plan - the nested loop anti-join only kicks in at 177865ms, so not a problem

We get 12000 bugtasks from the bug supervisor clauses:
               -> Materialize (cost=16707.17..16949.10 rows=24193 width=4) (actual time=0.000..1.646 rows=12164 loops=44267)
none from product, 12K from structural subscriptions to distribution sourcepackages , none from distribution bug supervisor

however, it runs this subselect 44K times - though its materialized, its 1.6ms per time to consult it.

http://explain.depesz.com/s/4zx for a pretty view