NAME

MySQL::Explain::Parser - Parser for result of EXPLAIN of MySQL

SYNOPSIS

use utf8;
use MySQL::Explain::Parser qw/parse/;

my $explain = <<'...';
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | filtered | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
|  1 | PRIMARY     | t1    | index | NULL          | PRIMARY | 4       | NULL | 4    | 100.00   |             |
|  2 | SUBQUERY    | t2    | index | a             | a       | 5       | NULL | 3    | 100.00   | Using index |
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
...

my $parsed = parse($explain);
# =>
#    [
#        {
#            'id'            => '1',
#            'select_type'   => 'PRIMARY',
#            'table'         => 't1',
#            'type'          => 'index',
#            'possible_keys' => undef,
#            'key'           => 'PRIMARY',
#            'key_len'       => '4',
#            'ref'           => undef
#            'rows'          => '4',
#            'filtered'      => '100.00',
#            'Extra'         => '',
#        },
#        {
#            'id'            => '2',
#            'select_type'   => 'SUBQUERY',
#            'table'         => 't2',
#            'type'          => 'index',
#            'possible_keys' => 'a',
#            'key'           => 'a',
#            'key_len'       => '5',
#            'ref'           => undef
#            'rows'          => '3',
#            'filtered'      => '100.00',
#            'Extra'         => 'Using index',
#        }
#    ]

DESCRIPTION

MySQL::Explain::Parser is the parser for result of EXPLAIN of MySQL.

This module provides parse() and parse_vertical() function. These function receive the result of EXPLAIN or EXPLAIN EXTENDED, and return the parsed result as array reference that contains hash reference.

This module treat SQL's NULL as Perl's undef.

Please refer to the following pages to get information about format of EXPLAIN;

• http://dev.mysql.com/doc/en/explain-output.html
• http://dev.mysql.com/doc/en/explain-extended.html

FUNCTIONS

• parse($explain : Str)

  Returns the parsed result of EXPLAIN as ArrayRef[HashRef]. This function can be exported.

• parse_vertical($explain : Str)

  Returns the parsed result of EXPLAIN which is formatted vertical as ArrayRef[HashRef]. This function can be exported.

  e.g.

    use utf8;
    use MySQL::Explain::Parser qw/parse_vertical/;
  
    my $explain = <<'...';
    *************************** 1. row ***************************
               id: 1
      select_type: PRIMARY
            table: t1
             type: index
    possible_keys: NULL
              key: PRIMARY
          key_len: 4
              ref: NULL
             rows: 4
         filtered: 100.00
            Extra:
    *************************** 2. row ***************************
               id: 2
      select_type: SUBQUERY
            table: t2
             type: index
    possible_keys: a
              key: a
          key_len: 5
              ref: NULL
             rows: 3
         filtered: 100.00
            Extra: Using index
    ...
  
    my $parsed = parse_vertical($explain);
  

LICENSE

Copyright (C) moznion.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHOR

moznion moznion@gmail.com