Sorry, I should have included more information -- not for a select on the processes table, for a select in

process_open_sockets

in particular. Even in the case of doing a join where it could conceivably take the list of pids that match from processes and pass that as a constraint to process_open_sockets, it looks like it does a full table scan.