Page MenuHomePhabricator

phabricator_worker.worker_archivetask has unkeyed query on dateModified
Closed, ResolvedPublic

Description

The daemon status page issues this query:

SELECT * FROM `worker_archivetask` WHERE (dateModified > 1471462314) ORDER BY id DESC

There is no key on dateModified, and this table may be enormous.