CODEWITHSUNDEEP
sqlmysqlcountsql-execution-plan
Alex Gordon
Alex Gordon

Reputation: 60751

EXPLAIN and COUNT returning two different values

i am doing:

explain select * from calibration;

it says 52133456345632 rows

when i do:

select count(*) from calibration;

i am getting 52134563456961

can someone explain whats going on here?

Upvotes: 3

Views: 556

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562368

Table statistics (used by EXPLAIN) are based on system-cached values that may not be accurate.

http://dev.mysql.com/doc/refman/5.1/en/using-explain.html says:

For InnoDB tables, this number is an estimate, and may not always be exact.

So the 'count()' version of the query will be accurate, as it will really 'count' existing rows. The 'explain' version does not necessarily count your rows, but might use an estimation/cache. Explain is not intended to be actually used in code or production - it is just a tool to help analysing your queries.

Upvotes: 7

Related Questions