This is a really interesting project I found which could be used to detect plan flips and introspect why the Postgres optimizer chose a certain path. Normally that is opaque to the user.