It's difficult to say whether the extended statistics could help with your schema, particularly in Pg10 where we only implemented two simple statistics types -

It's difficult to say whether the extended statistics could help with your schema, particularly in Pg10 where we only implemented two simple statistics types - functional dependencies and ndistinct (GROUP BY) coefficients. Maybe the changes in 9.6 that allow using foreign key constraints during estimation would help, though?