Closed Bug 825256 Opened 13 years ago Closed 13 years ago

query analysis for bugzilla query checksum 1500296193122249735

Categories

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

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: scabral, Unassigned)

References

Details

checksum: 1500296193122249735 sample: SELECT profiles.userid,profiles.login_name,profiles.realname,profiles.mybugslink AS showmybugslink,profiles.disabledtext,profiles.disable_mail,profiles.is_enabled,first_patch_approved_id,public_key,comment_count,creation_ts,first_patch_bug_id FROM profiles WHERE userid = '29811'
mysql> explain SELECT profiles.userid,profiles.login_name,profiles.realname,profiles.mybugslink AS showmybugslink,profiles.disabledtext,profiles.disable_mail,profiles.is_enabled,first_patch_approved_id,public_key,comment_count,creation_ts,first_patch_bug_id FROM profiles -> WHERE userid = '29811'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: profiles type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: 1 row in set (0.00 sec) This query is already optimized.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.