Not super familiar with the internals of postgres, but what sort of performance would something like this have? SELECT person_id FROM person_l WHERE stat

Not super familiar with the internals of postgres, but what sort of performance would something like this have? SELECT person_id FROM person_l WHERE state_id = (SELECT id FROM state_l WHERE name = 'Burgenland');