So it seems that while working on the PR to restore python tests I might've caught a regression. On macOS the query

SELECT * from signature WHERE path = 'Applications/Xcode.app' AND hash_resource=0

, before commit https://github.com/osquery/osquery/commit/08e0b9078b23e564d5f7585bc1797f4344d058b7, would return 2 results regarding only that specific path, and it was instant. After that commit instead it would take more than 5 minutes and return no result, which I believe it's because of the watchdog killing the worker.