I'm not sure how to interpret the

explain query plan

results, but I was able to get some insight by adding print statements to the generation function. It does look like the pid constraint is passed in to the generation function for sockets. The table seems to be called once for each pid.