gistfile1.sql

+----+-------------+---------------------------+--------+--------------------------+---------+---------+-------------------------------------+--------+----------------------------------------------+
| id | select_type | table                     | type   | possible_keys            | key     | key_len | ref                                 | rows   | Extra                                        |
+----+-------------+---------------------------+--------+--------------------------+---------+---------+-------------------------------------+--------+----------------------------------------------+
|  1 | SIMPLE      | jobs                      | ALL    | state,state_id,accounted | NULL    | NULL    | NULL                                | 753098 | Using where; Using temporary; Using filesort | 
|  1 | SIMPLE      | moldable_job_descriptions | eq_ref | PRIMARY                  | PRIMARY | 4       | oar2.jobs.assigned_moldable_job     |      1 |                                              | 
|  1 | SIMPLE      | assigned_resources        | ref    | PRIMARY,mjob_id          | mjob_id | 4       | oar2.jobs.assigned_moldable_job     |      8 |                                              | 
|  1 | SIMPLE      | resources                 | eq_ref | PRIMARY,type             | PRIMARY | 4       | oar2.assigned_resources.resource_id |      1 | Using where                                  | 
+----+-------------+-----------------------