figure11

scorebot_production=# select s.name, count(*), count(*) * 19 as flags_lost
                      from availabilities a, instances i, services s
                      where a.instance_id = i.id and i.service_id = s.id and a.status != 0
                      group by s.name
                      order by s.name asc;
   name   | count | flags_lost 
----------+-------+------------
 atmail   |   607 |      11533
 avoir    |   216 |       4104
 bookworm |   177 |       3363
 lonetuna |  1564 |      29716
 reeses   |   328 |       6232
 trouver  |   215 |       4085
(6 rows)