Enabling automatic query execution plans via auto_explain

postgresql.conf

# Prereq: auto_explain added to shared_preload_libraries 

# Compute the Query Identifier
compute_query_id = on

# Logging duration
log_duration = on

# Logging Query Identifier (%Q)
log_line_prefix = 'pid=%p query_id=%Q: '

# slow query logging, all queries for demo (don't do this in prod)
log_min_duration_statement = 0

# auto_explain (ms), > 10ms for demo
auto_explain.log_min_duration = 10

# Equivalent to VERBOSE when using EXPLAIN
# https://www.postgresql.org/docs/current/auto-explain.html
auto_explain.log_verbose = on