Closed Bug 825296 Opened 11 years ago Closed 11 years ago

query analysis for bugzilla query checksum 9041743092363122909

Categories

(Data & BI Services Team :: DB: MySQL, task)

x86
macOS
task
Not set
normal

Tracking

(Not tracked)

RESOLVED INVALID

People

(Reporter: scabral, Unassigned)

References

Details

checksum: 9041743092363122909
  sample: SELECT bugs.bug_id AS bug_id, bugs.bug_severity AS bug_severity, bugs.priority AS priority, bugs.bug_status AS bug_status, bugs.resolution AS resolution, map_products.name AS product, bugs.op_sys AS op_sys, map_assigned_to.login_name AS assigned_to, bugs.short_desc AS short_desc 

FROM bugs  
INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid)
INNER JOIN products AS map_products ON (bugs.product_id = map_products.id) 
LEFT JOIN bug_group_map  ON bug_group_map.bug_id = bugs.bug_id
  AND bug_group_map.group_id NOT IN (20,19,10,9,69,84,35,74,32,6,42,26,76)  
LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 432445 

WHERE (( bugs.bug_status IN ('NEW','ASSIGNED','REOPENED','UNCONFIRMED') ) 
AND (bugs.assigned_to IN
  (SELECT userid FROM profiles WHERE INSTR(profiles.login_name, 'xxxxxxx@mozilla.com') > 0))) 
AND bugs.creation_ts IS NOT NULL 
AND ((bug_group_map.group_id IS NULL)    
OR (bugs.reporter_accessible = 1 
AND bugs.reporter = 432445)     
OR (bugs.cclist_accessible = 1 
AND cc.who IS NOT NULL)     
OR (bugs.assigned_to = 432445) 
OR (bugs.qa_contact = 432445) ) 

GROUP BY bugs.bug_id ORDER BY bug_id LIMIT 10001
Similar to bug 825283 and bug 825261, although a bit less crazy:


*************************** 1. row ***************************
           id: 1
  select_type: PRIMARY
        table: map_products
         type: index
possible_keys: PRIMARY
          key: products_name_idx
      key_len: 194
          ref: NULL
         rows: 93
        Extra: Using index; Using temporary; Using filesort
*************************** 2. row ***************************
           id: 1
  select_type: PRIMARY
        table: bugs
         type: ref
possible_keys: bugs_reporter_idx,bugs_product_id_idx,bugs_creation_ts_idx,bugs_assigned_to_idx,bu
gs_qa_contact_idx,bugs_bug_status_idx
          key: bugs_product_id_idx
      key_len: 2
          ref: bugs.map_products.id
         rows: 1343
        Extra: Using where
*************************** 3. row ***************************
           id: 1
  select_type: PRIMARY
        table: bug_group_map
         type: ref
possible_keys: bug_group_map_bug_id_idx,bug_group_map_group_id_idx
          key: bug_group_map_bug_id_idx
      key_len: 3
          ref: bugs.bugs.bug_id
         rows: 1
        Extra: Using where; Using index
*************************** 4. row ***************************
           id: 1
  select_type: PRIMARY
        table: cc
         type: eq_ref
possible_keys: cc_bug_id_idx,cc_who_idx
          key: cc_bug_id_idx
      key_len: 6
          ref: bugs.bugs.bug_id,const
         rows: 1
        Extra: Using where; Using index
*************************** 5. row ***************************
           id: 1
  select_type: PRIMARY
        table: map_assigned_to
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 3
          ref: bugs.bugs.assigned_to
         rows: 1
        Extra: 
*************************** 6. row ***************************
           id: 2
  select_type: DEPENDENT SUBQUERY
        table: profiles
         type: unique_subquery
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 3
          ref: func
         rows: 1
        Extra: Using where
6 rows in set (0.08 sec)

See Also: https://bugzilla.mozilla.org/show_bug.cgi?id=825261, https://bugzilla.mozilla.org/show_bug.cgi?id=825283
See Also: → 825261, 825283
resolving invalid in bugzilla 4.2, which we upgraded to in March.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → INVALID
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.