Page MenuHomePhabricator
Paste P5389

(An Untitled Masterwork)
ActivePublic

Authored by akosiaris on May 5 2017, 2:51 PM.
Tags
None
Referenced Files
F7938515:
May 5 2017, 2:51 PM
Subscribers
explain UPDATE fact_values SET updated_at = '2017-05-05 14:14:28 +0000', value = 'debian' WHERE fact_name_id=60842 AND host_id=42456\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: fact_values
type: index_merge
possible_keys: index_fact_values_on_fact_name_id,index_fact_values_on_host_id
key: index_fact_values_on_host_id,index_fact_values_on_fact_name_id
key_len: 4,4
ref: NULL
rows: 1
Extra: Using intersect(index_fact_values_on_host_id,index_fact_values_on_fact_name_id); Using where

Event Timeline

root@db1016.eqiad.wmnet[puppet]> explain UPDATE fact_values_fixed SET                     updated_at = '2017-05-05 14:14:28 +0000',                     value = 'debian'                     WHERE fact_name_id=60842 AND host_id=42456\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: fact_values_fixed
         type: range
possible_keys: index_fact_values_on_fact_name_id,index_fact_values_on_host_id
          key: index_fact_values_on_host_id
      key_len: 8
          ref: NULL
         rows: 1
        Extra: Using where
1 row in set (0.00 sec)