Why the rows returns by “explain” is not equal to count()?

by

It is showing how many rows it ran through to get your result.

The reason for the wrong data is that EXPLAIN is not accurate, it makes guesses about your data based on information stored about your table.

This is very useful information, for example when doing JOINS on many tables and you want to be sure that you aren’t running through the entire joined table for one row of information for each row you have.

Here’s a test on a 608 row table.

SELECT COUNT(id) FROM table WHERE user_id = 1

Result:

COUNT(id)
512

And here’s the explain

EXPLAIN SELECT COUNT(id) FROM table WHERE user_id = 1

Result:

id  rows
1   608

More Related Contents:

  1. Complex Count in MySQL
  2. Most efficient way to get table row count
  3. MySql Count cannot show 0 values
  4. Speeding up row counting in MySQL
  5. Order by COUNT per value
  6. Mysql count instances of substring, then order by
  7. mysql: get record count between two date-time
  8. COUNT(*) from multiple tables in MySQL
  9. How to get the count of each distinct value in a column? [duplicate]
  10. MYSQL Left Join COUNTS from multiple tables
  11. Count with IF condition in MySQL query
  12. MySQL – Using COUNT(*) in the WHERE clause
  13. How do I add two count(*) results together on two different tables?
  14. Mysql Counting the consecutive rows that match
  15. When I want to install MySQL I faced this issue “root account password” I forgot it
  16. Restoring MySQL database from physical files
  17. MySQL Trigger after update only if row has changed
  18. select count(*) from table of mysql in php
  19. MySQL “WITH” clause
  20. MySQL Query – Records between Today and Last 30 Days
  21. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  22. MySQL ‘user_id’ in where clause is ambiguous problem
  23. What does it mean when MySQL is in the state “Sending data”?
  24. MySQL JSON: How to find object from key value
  25. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  26. Commit data in a mysql container
  27. How do I count columns of a table
  28. Mysqldump launched by cron and password security
  29. MySQL Trigger cannot update table – getting ERROR 1442
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment