1
edit
Changes
no edit summary
</tr>
<tr>
<tdth>How many bugs are there?</tdth>
<td>Select count(bug_id) from bugs;</td>
<td>425,992</td>
</tr>
<tr>
<tdth>How many bugs per year?</tdth>
</tr>
<tr>
<td>1994</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td>
<thtd>2</thtd>
</tr>
<tr>
<td>1995</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1995%';</td>
<thtd>1</thtd>
</tr>
<tr>
<td>1996</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1996%';</td>
<thtd>5</thtd>
</tr>
<tr>
<td>1997</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1997%';</td>
<thtd>36</thtd>
</tr>
<tr>
<td>1998</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1998%';</td>
<thtd>2020</thtd>
</tr>
<tr>
<td>1999</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1999%';</td>
<thtd>20,411</thtd>
</tr>
<tr>
<td>2000</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2000%';</td>
<thtd>40298</thtd>
</tr>
<tr>
<td>2001</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2001%';</td>
<thtd>253,468</thtd>
</tr>
<tr>
<td>2002</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2002%';</td>
<thtd>269,701</thtd>
</tr>
<tr>
<td>2003</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2003%';</td>
<thtd>242,371</thtd>
</tr>
<tr>
<td>2004</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2004%';</td>
<thtd>246,739</thtd>
</tr>
<tr>
<td>2005</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2005%';</td>
<thtd>245,173</thtd>
</tr>
<tr>
<td>2006</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2006%';</td>
<thtd>241,898</thtd>
</tr>
<tr>
<td>2007</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2007%';</td>
<thtd>241,872</thtd>
</tr>
<tr>
<td>2008</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '2008%';</td>
<td>21,997</td></tr><tr><th>How many bugs for just Firefox (vs. Thunderbird, Calendar, and other products)</th></tr><tr><td>Core</td><td>select count(*) from bugs where product_id=1;</td><td>176,713</td></tr><tr><td>Calendar</td><td>select count(*) from bugs where product_id=2;</td><td>8,059</td></tr><tr><td>CCK</td><td>select count(*) from bugs where product_id=3;</td><td>694</td></tr><tr><td>Directory</td><td>select count(*) from bugs where product_id=4;</td><td>630</td></tr><tr><td>Grendel</td><td>select count(*) from bugs where product_id=5;</td><td>87</td></tr><tr><td>MozillaClassic</td><td>select count(*) from bugs where product_id=7;</td><td>480</td></tr><tr><td>Webtools</td><td>select count(*) from bugs where product_id=8;</td><td>2,207</td></tr><tr><td>NSPR</td><td>select count(*) from bugs where product_id=9;</td><td>1,299</td></tr><tr><td>mozilla.org</td><td>select count(*) from bugs where product_id=10;</td><td>11,086</td></tr><tr><td>Rhino</td><td>select count(*) from bugs where product_id=11;</td><td>697</td></tr><tr><td>Derivatives</td><td>select count(*) from bugs where product_id=12;</td><td>28</td></tr><tr><td>Documentation</td><td>select count(*) from bugs where product_id=13;</td><td>651</td></tr><tr><td>Tech Evangelism</td><td>select count(*) from bugs where product_id=15;</td><td>9,461</td></tr><tr><td>NSS</td><td>select count(*) from bugs where product_id=16;</td><td>3,761</td></tr><tr><td>Mozilla Localizations</td><td>select count(*) from bugs where product_id=17;</td><td>3,250</td></tr><tr><td>JSS</td><td>select count(*) from bugs where product_id=18;</td><td>316</td></tr><tr><td>Bugzilla</td><td>select count(*) from bugs where product_id=19;</td><td>12,957</td></tr><tr><td>Camino</td><td>select count(*) from bugs where product_id=20;</td><td>8,239</td></tr><tr><td>Firefox</td><td>select count(*) from bugs where product_id=21;</td><td>71,596</td></tr><tr><td>Other Applications</td><td>select count(*) from bugs where product_id=28;</td><td>3,003</td></tr><tr><td>addons.mozilla.org</td><td>select count(*) from bugs where product_id=31;</td><td>3,743</td></tr><tr><td>Composer</td><td>select count(*) from bugs where product_id=27;</td><td>37</td></tr><tr><td>Marketing</td><td>select count(*) from bugs where product_id=22;</td><td>316</td></tr><tr><td>Thunderbird</td><td>select count(*) from bugs where product_id=23;</td><td>19,955</td></tr><tr><td>Minimo</td><td>select count(*) from bugs where product_id=24;</td><td>445</td></tr><tr><td>Mozilla Application Suite</td><td>select count(*) from bugs where product_id=25;</td><td>79,698</td></tr><tr><td>Toolkit</td><td>select count(*) from bugs where product_id=30;</td><td>2,181</td></tr><tr><td>AUS</td><td>select count(*) from bugs where product_id=34;</td><td>83</td></tr><tr><td>Websites</td><td>select count(*) from bugs where product_id=36;</td><td>1,331</td></tr><tr><td>Mozilla Developer Center</td><td>select count(*) from bugs where product_id=37;</td><td>572</td></tr><tr><td>Testopia</td><td>select count(*) from bugs where product_id=38;</td><td>423</td></tr><tr><td>Penelope</td><td>select count(*) from bugs where product_id=39;</td><td>375</td></tr><tr><td>Mozilla Labs</td><td>select count(*) from bugs where product_id=40;</td><td>588</td></tr><tr><td>Sumo</td><td>select count(*) from bugs where product_id=42;</td><td>570</td></tr><tr><td>Tamarin</td><td>select count(*) from bugs where product_id=43;</td><td>426</td></tr><tr><td>Extend Firefox</td><td>select count(*) from bugs where product_id=44;</td><td>5</td></tr><tr><td>Fennec</td><td>select count(*) from bugs where product_id=46;</td><td>27</td></tr><tr><th>How many bugs are currently NEW vs. ASSIGNED vs. RESOLVED, etc.</th></tr><tr><td>New</td><td>select count(*) from bugs where bug_status='NEW';</td><td>44,568</td></tr><tr><td>Assigned</td><td>select count(*) from bugs where bug_status='ASSIGNED';</td><td>4,697</td></tr><tr><td>Resolved</td><td>select count(*) from bugs where bug_status='RESOLVED';</td><td>207,496</td></tr><tr><td>Verified</td><td>select count(*) from bugs where bug_status='VERIFIED';</td><td>148,747</td></tr><tr><td>Closed</td><td>select count(*) from bugs where bug_status='CLOSED';</td><td>1,496</td></tr><tr><td>Reopened</td><td>select count(*) from bugs where bug_status=REOPENED';</td><td>962</td></tr><tr><td>Unconfirmed</td><td>select count(*) from bugs where bug_status='UNCONFIRMED';</td><td>18,026</td>
</tr>
</table>
