Pg_plan_alternatives – eBPF tracing of all plans the optimizer considers
github.comThis 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.