How to check whether constraint_exclusion is enabled or not in my database?

Question

As per official Postgres documents default value of constraint_exclusion is "partition". How can I ensure this? Is there any way to check current value from PgAdmin?

Answer 1

SHOW will display the current setting of run-time parameters.

Show constraint_exclusion;