Backend web developer here with possibly a naive question (in the title).
I recently started diving into the inner workings of Postgres query optimization and I find the query execution plan concept fascinating. As I understand it, the execution plan for an unchanged query can change over time.
Is it possible to configure a Postgres database server to send a notification of some kind(email perhaps?) when an execution plan for a particular query changes?
auto_explainmodule as a starting point for your own system.