Prepared statement: values and plans

Conceptual / forced modes for comparison; auto may choose either

Prepared statement: values and plans Conceptual / forced modes for comparison; auto may choose either PREPARE query(int): WHERE tenant_id = $1 Generic mode: EXECUTE query(99999) Plan independent of value; run with 99999 Generic mode: EXECUTE query(42) Reuse generic plan; run with 42 SET LOCAL force_custom_plan; EXECUTE query(42) Plan using value 42; then execute Application · Sequence participant Application PostgreSQL · Sequence participant PostgreSQL Legend return default message