While reading up about the various PostgreSQL EXPLAIN Plan nodes from multiple sources, I realized a clear lack of a consolidated grid / cheat-sheet, from which I could (in-one-view) cross-check how the plan nodes perform on a comparative basis. While at it, I also tried to attribute what their (good / bad) characteristics are.
Hope this (Work-In-Progress) lookup table helps others on the same path. Any additions / updates are more than welcome.
The image below is an old-snapshot of the document. The updated web document is available here.