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?

  • 1
    Nothing built-in. Take a look at theauto_explain module as a starting point for your own system.
    – dwhitemv
    Oct 5, 2022 at 2:01


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.