Difference between revisions of "Bugzilla Analysis"

From CDOT Wiki
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 14: Line 14:
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
−
     <td>How many bugs are there?</td>
+
     <th>How many bugs are there?</th>
 
     <td>Select count(bug_id) from bugs;</td>
 
     <td>Select count(bug_id) from bugs;</td>
 
<td>425,992</td>
 
<td>425,992</td>
 
   </tr>
 
   </tr>
 
<tr>
 
<tr>
−
<td>How many bugs per year?</td>
+
<th>How many bugs per year?</th>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>1994</td>
 
<td>1994</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td>
−
<th>2</th>
+
<td>2</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>1995</td>
 
<td>1995</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1995%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1995%';</td>
−
<th>1</th>
+
<td>1</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>1996</td>
 
<td>1996</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1996%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1996%';</td>
−
<th>5</th>
+
<td>5</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>1997</td>
 
<td>1997</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1997%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1997%';</td>
−
<th>36</th>
+
<td>36</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>1998</td>
 
<td>1998</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1998%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1998%';</td>
−
<th>2020</th>
+
<td>2020</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>1999</td>
 
<td>1999</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1999%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '1999%';</td>
−
<th>20,411</th>
+
<td>20,411</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2000</td>
 
<td>2000</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2000%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2000%';</td>
−
<th>40298</th>
+
<td>40298</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2001</td>
 
<td>2001</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2001%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2001%';</td>
−
<th>2</th>
+
<td>53,468</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2002</td>
 
<td>2002</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2002%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2002%';</td>
−
<th>2</th>
+
<td>69,701</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2003</td>
 
<td>2003</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2003%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2003%';</td>
−
<th>2</th>
+
<td>42,371</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2004</td>
 
<td>2004</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2004%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2004%';</td>
−
<th>2</th>
+
<td>46,739</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2005</td>
 
<td>2005</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2005%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2005%';</td>
−
<th>2</th>
+
<td>45,173</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2006</td>
 
<td>2006</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2006%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2006%';</td>
−
<th>2</th>
+
<td>41,898</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2007</td>
 
<td>2007</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2007%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2007%';</td>
−
<th>2</th>
+
<td>41,872</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>2008</td>
 
<td>2008</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2008%';</td>
 
<td>Select count(distinct bug_id) from bugs where creation_ts like '2008%';</td>
−
<th>2</th>
+
<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>
 
</tr>
 
</table>
 
</table>

Latest revision as of 23:49, 25 June 2008

Students in BTR490 are working on analyzing historical Bugzilla data for Mozilla. This pages documents some of their findings and ideas.


Bugzilla Database Questions

By:Timothy Kwan, Rajiv Gagwani, Jasdeep Singh Goraya

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