Created
September 13, 2021 02:48
-
-
Save febridev/598a652bf11d3c6de538c469c818f1e1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"query_block": { | |
"select_id": 1, | |
"r_loops": 1, | |
"r_total_time_ms": 88634, | |
"filesort": { | |
"sort_key": "tgospfeed.modified_date desc", | |
"r_loops": 1, | |
"r_total_time_ms": 0.5509, | |
"r_limit": 10, | |
"r_used_priority_queue": true, | |
"r_output_rows": 11, | |
"temporary_table": { | |
"table": { | |
"table_name": "tgospfeed", | |
"access_type": "index_merge", | |
"possible_keys": [ | |
"idx_tgospfeed_company_id", | |
"idx_tgospfeed_company_code", | |
"idx_tgospfeed_receiver", | |
"idx_tgospfeed_flag" | |
], | |
"key_length": "203,203", | |
"index_merge": { | |
"intersect": { | |
"range": { | |
"key": "idx_tgospfeed_receiver", | |
"used_key_parts": ["receiver"] | |
}, | |
"range": { | |
"key": "idx_tgospfeed_flag", | |
"used_key_parts": ["flag"] | |
} | |
} | |
}, | |
"r_loops": 1, | |
"rows": 222, | |
"r_rows": 497, | |
"r_total_time_ms": 3.9686, | |
"filtered": 25.007, | |
"r_filtered": 100, | |
"attached_condition": "tgospfeed.company_id = '27246' and tgospfeed.company_code = 'siloam' and tgospfeed.receiver = 'DO210003' and tgospfeed.flag = 'INBOX'" | |
}, | |
"table": { | |
"table_name": "ps", | |
"access_type": "index", | |
"possible_keys": ["PRIMARY"], | |
"key": "ix_tuned_teodemppersonal_1", | |
"key_length": "1", | |
"used_key_parts": ["maritalstatus"], | |
"r_loops": 497, | |
"rows": 26249, | |
"r_rows": 28898, | |
"r_total_time_ms": 3839, | |
"filtered": 100, | |
"r_filtered": 100, | |
"attached_condition": "trigcond(ps.emp_id is not null and ps.emp_id is not null)", | |
"using_index": true | |
}, | |
"table": { | |
"table_name": "c", | |
"access_type": "ref", | |
"possible_keys": [ | |
"PRIMARY", | |
"IDX_Employee_all", | |
"idx_enddate", | |
"ix_tuned_teodempcompany_1" | |
], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.ps.emp_id"], | |
"r_loops": 14362306, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 30018, | |
"filtered": 100, | |
"r_filtered": 46.093, | |
"attached_condition": "trigcond(c.end_date + interval 1 day >= '2021-09-12 18:20:57' or c.end_date is null)" | |
}, | |
"table": { | |
"table_name": "p", | |
"access_type": "eq_ref", | |
"possible_keys": [ | |
"PRIMARY", | |
"fk_teomemppersonal_tclmuser", | |
"IDX_Employee_per" | |
], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.ps.emp_id"], | |
"r_loops": 6620040, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 10036, | |
"filtered": 100, | |
"r_filtered": 0.0075, | |
"attached_condition": "trigcond(tgospfeed.`owner` = convert(p.emp_id using utf8mb4) and p.user_id is not null)" | |
}, | |
"table": { | |
"table_name": "u", | |
"access_type": "eq_ref", | |
"possible_keys": ["PRIMARY"], | |
"key": "PRIMARY", | |
"key_length": "4", | |
"used_key_parts": ["user_id"], | |
"ref": ["dbsf_nbc_siloam.p.user_id"], | |
"r_loops": 496, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 2.0274, | |
"filtered": 100, | |
"r_filtered": 100, | |
"using_index": true | |
}, | |
"table": { | |
"table_name": "c", | |
"access_type": "ALL", | |
"possible_keys": [ | |
"PRIMARY", | |
"IDX_Employee_all", | |
"idx_enddate", | |
"ix_tuned_teodempcompany_1" | |
], | |
"r_loops": 497, | |
"rows": 27192, | |
"r_rows": 28898, | |
"r_total_time_ms": 7301.3, | |
"filtered": 100, | |
"r_filtered": 46.093, | |
"attached_condition": "trigcond((c.end_date + interval 1 day >= '2021-09-12 18:20:57' or c.end_date is null) and c.emp_id is not null)" | |
}, | |
"table": { | |
"table_name": "ps", | |
"access_type": "eq_ref", | |
"possible_keys": ["PRIMARY"], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.c.emp_id"], | |
"r_loops": 6620040, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 8480.7, | |
"filtered": 100, | |
"r_filtered": 100, | |
"attached_condition": "trigcond(ps.emp_id is not null)", | |
"using_index": true | |
}, | |
"table": { | |
"table_name": "p", | |
"access_type": "eq_ref", | |
"possible_keys": [ | |
"PRIMARY", | |
"fk_teomemppersonal_tclmuser", | |
"IDX_Employee_per" | |
], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.ps.emp_id"], | |
"r_loops": 6620040, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 9673.5, | |
"filtered": 100, | |
"r_filtered": 0.0075, | |
"attached_condition": "trigcond(p.emp_id = c.emp_id and tgospfeed.receiver = convert(p.emp_id using utf8mb4) and p.user_id is not null)" | |
}, | |
"table": { | |
"table_name": "u", | |
"access_type": "eq_ref", | |
"possible_keys": ["PRIMARY"], | |
"key": "PRIMARY", | |
"key_length": "4", | |
"used_key_parts": ["user_id"], | |
"ref": ["dbsf_nbc_siloam.p.user_id"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 0.0026, | |
"filtered": 100, | |
"r_filtered": 100, | |
"using_index": true | |
}, | |
"table": { | |
"table_name": "post", | |
"access_type": "ref", | |
"possible_keys": ["tgospfeedpost_feed_id_index"], | |
"key": "tgospfeedpost_feed_id_index", | |
"key_length": "4", | |
"used_key_parts": ["feed_id"], | |
"ref": ["dbsf_nbc_siloam.tgospfeed.id"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 0, | |
"r_total_time_ms": 3.7656, | |
"filtered": 100, | |
"r_filtered": 100 | |
}, | |
"block-nl-join": { | |
"table": { | |
"table_name": "images", | |
"access_type": "ALL", | |
"possible_keys": ["tgosppostimages_post_id_index"], | |
"r_loops": 249, | |
"rows": 1, | |
"r_rows": 5, | |
"r_total_time_ms": 1.6996, | |
"filtered": 100, | |
"r_filtered": 100 | |
}, | |
"buffer_type": "flat", | |
"buffer_size": "11Kb", | |
"join_type": "BNL", | |
"attached_condition": "trigcond(post.post_id = images.post_id)", | |
"r_filtered": 20 | |
}, | |
"table": { | |
"table_name": "ps", | |
"access_type": "eq_ref", | |
"possible_keys": ["PRIMARY"], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.post.shared_emp"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 0, | |
"filtered": 100, | |
"r_filtered": 100, | |
"attached_condition": "trigcond(ps.emp_id is not null and trigcond(post.shared_emp is not null and post.shared_emp is not null))", | |
"using_index": true | |
}, | |
"table": { | |
"table_name": "c", | |
"access_type": "ref", | |
"possible_keys": [ | |
"PRIMARY", | |
"IDX_Employee_all", | |
"idx_enddate", | |
"ix_tuned_teodempcompany_1" | |
], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.ps.emp_id"], | |
"r_loops": 0, | |
"rows": 1, | |
"r_rows": null, | |
"filtered": 100, | |
"r_filtered": null, | |
"attached_condition": "trigcond(c.emp_id = post.shared_emp and (c.end_date + interval 1 day >= <cache>(current_timestamp()) or c.end_date is null))" | |
}, | |
"table": { | |
"table_name": "p", | |
"access_type": "eq_ref", | |
"possible_keys": [ | |
"PRIMARY", | |
"fk_teomemppersonal_tclmuser", | |
"IDX_Employee_per" | |
], | |
"key": "PRIMARY", | |
"key_length": "52", | |
"used_key_parts": ["emp_id"], | |
"ref": ["dbsf_nbc_siloam.post.shared_emp"], | |
"r_loops": 0, | |
"rows": 1, | |
"r_rows": null, | |
"filtered": 100, | |
"r_filtered": null, | |
"attached_condition": "trigcond(p.user_id is not null)" | |
}, | |
"table": { | |
"table_name": "u", | |
"access_type": "eq_ref", | |
"possible_keys": ["PRIMARY"], | |
"key": "PRIMARY", | |
"key_length": "4", | |
"used_key_parts": ["user_id"], | |
"ref": ["dbsf_nbc_siloam.p.user_id"], | |
"r_loops": 0, | |
"rows": 1, | |
"r_rows": null, | |
"filtered": 100, | |
"r_filtered": null, | |
"using_index": true | |
}, | |
"table": { | |
"table_name": "request", | |
"access_type": "ref", | |
"possible_keys": ["tgospfeedrequest_feed_id_index"], | |
"key": "tgospfeedrequest_feed_id_index", | |
"key_length": "4", | |
"used_key_parts": ["feed_id"], | |
"ref": ["dbsf_nbc_siloam.tgospfeed.id"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 5.3452, | |
"filtered": 100, | |
"r_filtered": 100 | |
}, | |
"table": { | |
"table_name": "alert", | |
"access_type": "ref", | |
"possible_keys": ["tgospfeedalert_feed_id_index"], | |
"key": "tgospfeedalert_feed_id_index", | |
"key_length": "4", | |
"used_key_parts": ["feed_id"], | |
"ref": ["dbsf_nbc_siloam.tgospfeed.id"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 1, | |
"r_total_time_ms": 4.2644, | |
"filtered": 100, | |
"r_filtered": 100 | |
}, | |
"block-nl-join": { | |
"table": { | |
"table_name": "calendar", | |
"access_type": "ALL", | |
"possible_keys": ["tgospfeedcalendar_feed_id_index"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 0, | |
"r_total_time_ms": 0.5922, | |
"filtered": 100, | |
"r_filtered": 100 | |
}, | |
"buffer_type": "flat", | |
"buffer_size": "12Kb", | |
"join_type": "BNL", | |
"attached_condition": "trigcond(calendar.feed_id = tgospfeed.`id`)", | |
"r_filtered": null | |
}, | |
"block-nl-join": { | |
"table": { | |
"table_name": "newEmployee", | |
"access_type": "ALL", | |
"possible_keys": ["tgospfeednewemployee_feed_id_index"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 0, | |
"r_total_time_ms": 0.5653, | |
"filtered": 100, | |
"r_filtered": 100 | |
}, | |
"buffer_type": "incremental", | |
"buffer_size": "2023Kb", | |
"join_type": "BNL", | |
"attached_condition": "trigcond(newemployee.feed_id = tgospfeed.`id`)", | |
"r_filtered": null | |
}, | |
"table": { | |
"table_name": "smartFeed", | |
"access_type": "ALL", | |
"possible_keys": ["tgospfeedsmart_feed_id_index"], | |
"r_loops": 497, | |
"rows": 1, | |
"r_rows": 0, | |
"r_total_time_ms": 0.5875, | |
"filtered": 100, | |
"r_filtered": 100, | |
"attached_condition": "trigcond(smartfeed.feed_id = tgospfeed.`id`)" | |
} | |
} | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment