Discrepancy between revlog count in Optimize and Evaluate

Anki FSRS
5

I thought the same initially. But then, I realized that

  • the count shown there represents the total number of revlogs that match the search query before any filtering is applied (which means that those revlogs should not be filtered at that stage)
  • I don’t have 24k reviews in cards with incomplete revlogs. To confirm this, I ran the following in Debug Console and copied the output to the search field in the Stats page. It shows only 416 reviews.
from aqt.utils import showText

sql = "SELECT cid FROM revlog AS r1 WHERE type = 1 AND id IN ( SELECT id FROM revlog AS r2 WHERE r1.cid = r2.cid ORDER BY id LIMIT 1 )"

cids = (str(cid) for cid in mw.col.db.list(sql))

search_query = f'"cid:{",".join(cids)}"'

showText(search_query, copyBtn=True)

image
image981×873 51.8 KB