{ "query_block": { "select_id": 1, "cost_info": { "query_cost": "3174735.23" }, "nested_loop": [ { "table": { "table_name": "lt", "access_type": "const", "possible_keys": [ "PRIMARY" ], "key": "PRIMARY", "used_key_parts": [ "CONTENTID" ], "key_length": "8", "ref": [ "const" ], "rows_examined_per_scan": 1, "rows_produced_per_join": 1, "filtered": "100.00", "cost_info": { "read_cost": "0.00", "eval_cost": "0.20", "prefix_cost": "0.00", "data_read_per_join": "9K" }, "used_columns": [ "CONTENTID", "LASTMODDATE", "CONTENT_STATUS" ] } }, { "table": { "table_name": "c", "access_type": "index", "possible_keys": [ "tmp_contenttype_idx" ], "key": "c_si_ct_pv_cs_cd_idx", "used_key_parts": [ "CREATIONDATE", "PREVVER", "SPACEID", "CONTENTTYPE", "CONTENT_STATUS" ], "key_length": "1559", "rows_examined_per_scan": 9048299, "rows_produced_per_join": 921037, "filtered": "10.18", "using_index": true, "cost_info": { "read_cost": "1747692.39", "eval_cost": "184207.41", "prefix_cost": "1931899.80", "data_read_per_join": "8G" }, "used_columns": [ "CONTENTID", "CONTENTTYPE", "PREVVER", "CONTENT_STATUS" ], "attached_condition": "((570064898 = coalesce(`confluenceuat`.`c`.`PREVVER`,`confluenceuat`.`c`.`CONTENTID`)) and (`confluenceuat`.`c`.`CONTENTTYPE` in ('PAGE','BLOGPOST')) and (`confluenceuat`.`c`.`CONTENT_STATUS` in ('current','draft')))" } }, { "table": { "table_name": "ucr", "access_type": "ref", "possible_keys": [ "u2c_relation_unique", "relation_u2c_targetcontent_idx" ], "key": "u2c_relation_unique", "used_key_parts": [ "TARGETCONTENTID" ], "key_length": "8", "ref": [ "confluenceuat.c.CONTENTID" ], "rows_examined_per_scan": 1, "rows_produced_per_join": 46051, "filtered": "4.45", "cost_info": { "read_cost": "1035696.19", "eval_cost": "9210.37", "prefix_cost": "3174735.23", "data_read_per_join": "169M" }, "used_columns": [ "RELATIONID", "TARGETCONTENTID", "RELATIONNAME", "LASTMODDATE", "LASTMODIFIER" ], "attached_condition": "(found_match(ucr), ((`confluenceuat`.`ucr`.`LASTMODIFIER` = '2c900c3842b8b9290142b8bbd89f20ad') and (`confluenceuat`.`ucr`.`RELATIONNAME` = 'touched')), true)" } } ] } }