Question :
Where can I find an exhaustive list of possible nodes types(e.g. Seq scan, groupAggregate, Nested loop …) that a query plan could contain in PostgreSQL?
Answer :
If you are just looking for a comprehensive list of types, without any explanations, this piece of source code might be of help to you.