This tool allows you to run EXPLAIN on Toolforge queries, and will suggest improvements if common issues are detected.
Resources:
Database access
•
Help:MySQL queries
•
Run query online
Results
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1.1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1.2 | SIMPLE | pr_index | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1.3 | SIMPLE | page | range | PRIMARY, page_name_title | page_name_title | 261 | 334388 | Using where; Using index | |
| 1.4 | SIMPLE | page_props | eq_ref | PRIMARY, pp_propname_page, pp_propname_sortkey_page | PRIMARY | 66 | frwikisource.page.page_id,const | 1 | Using where |
Tips