*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: instances
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 846
        Extra:
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: virtual_interfaces_1
         type: ref
possible_keys: instance_id
          key: instance_id
      key_len: 4
          ref: nova.instances.id
         rows: 1
        Extra:
*************************** 3. row ***************************
           id: 1
  select_type: SIMPLE
        table: networks_1
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: nova.virtual_interfaces_1.network_id
         rows: 1
        Extra:
*************************** 4. row ***************************
           id: 1
  select_type: SIMPLE
        table: instances_1
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: nova.virtual_interfaces_1.instance_id
         rows: 1
        Extra:
*************************** 5. row ***************************
           id: 1
  select_type: SIMPLE
        table: fixed_ips_1
         type: ref
possible_keys: fixed_ips_virtual_interfaces_fkey
          key: fixed_ips_virtual_interfaces_fkey
      key_len: 5
          ref: nova.virtual_interfaces_1.id
         rows: 1
        Extra:
*************************** 6. row ***************************
           id: 1
  select_type: SIMPLE
        table: floating_ips_1
         type: ref
possible_keys: fixed_ip_id
          key: fixed_ip_id
      key_len: 5
          ref: nova.fixed_ips_1.id
         rows: 6
        Extra:
*************************** 7. row ***************************
           id: 1
  select_type: SIMPLE
        table: security_group_instance_association_1
         type: ref
possible_keys: instance_id
          key: instance_id
      key_len: 5
          ref: nova.instances.id
         rows: 1
        Extra:
*************************** 8. row ***************************
           id: 1
  select_type: SIMPLE
        table: security_groups_1
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: nova.security_group_instance_association_1.security_group_id
         rows: 1
        Extra:
*************************** 9. row ***************************
           id: 1
  select_type: SIMPLE
        table: instance_metadata_1
         type: ref
possible_keys: instance_id
          key: instance_id
      key_len: 4
          ref: nova.instances.id
         rows: 1
        Extra:
*************************** 10. row ***************************
           id: 1
  select_type: SIMPLE
        table: instance_types_1
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: nova.instances.instance_type_id
         rows: 1
        Extra:
*************************** 11. row ***************************
           id: 1
  select_type: SIMPLE
        table: fixed_ips_2
         type: ref
possible_keys: instance_id
          key: instance_id
      key_len: 5
          ref: nova.instances.id
         rows: 1
        Extra:
*************************** 12. row ***************************
           id: 1
  select_type: SIMPLE
        table: networks_2
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: nova.fixed_ips_2.network_id
         rows: 1
        Extra:
*************************** 13. row ***************************
           id: 1
  select_type: SIMPLE
        table: floating_ips_2
         type: ref
possible_keys: fixed_ip_id
          key: fixed_ip_id
      key_len: 5
          ref: nova.fixed_ips_2.id
         rows: 6
        Extra:
13 rows in set (0.00 sec)