0

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?

Improve this question
1
  • 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

0

Reset to default

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.