select count(1), pid from processes, file where file.directory = '/proc/' || pid || '/fd' group by pid;