# help in interpreting explain command

**URL:** <https://forums.percona.com/t/help-in-interpreting-explain-command/4490>\
**Category:** Other MySQL® Questions\
**Created:** [November 3, 2015, 3:42am UTC](https://forums.percona.com/t/help-in-interpreting-explain-command/4490 "2015-11-03T03:42:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![siefu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/siefu/32/1096_2.png) [@siefu](https://forums.percona.com/u/siefu)\
**Post date:** [November 3, 2015, 3:42am UTC](https://forums.percona.com/t/help-in-interpreting-explain-command/4490/1 "2015-11-03T03:42:56Z")

</div>

hi,

suddenly our percona mysql db giving high cpu usage. although the query down here wasn’t in slow query log before.

‘1’, ‘SIMPLE’, ‘cw’, ‘index’, ‘PRIMARY’, ‘mdl\_coursect\_cousec\_uix’, ‘16’, NULL, ‘1’, ‘Using index’  
‘1’, ‘SIMPLE’, ‘md’, ‘ref’, ‘PRIMARY,mdl\_modu\_nam\_ix’, ‘mdl\_modu\_nam\_ix’, ‘62’, ‘const’, ‘1’, ‘Using where; Using index’  
‘1’, ‘SIMPLE’, ‘m’, ‘ALL’, ‘PRIMARY’, NULL, NULL, NULL, ‘23’, ‘Using join buffer (Block Nested Loop)’  
‘1’, ‘SIMPLE’, ‘cm’, ‘ref’, ‘mdl\_courmodu\_cou\_ix,mdl\_courmodu\_mod\_ix,mdl\_courmodu\_ins\_ix’, ‘mdl\_courmodu\_ins\_ix’, ‘8’, ‘moodle\_15161.m.id’, ‘1’, ‘Using where’

as i’m not an expert in db. someone can interpret for me?