Pg_plan_alternatives – eBPF tracing of all plans the optimizer considers (opens in new tab)

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.