db.l3.ai

Play

lessons

What Changed In 19

Upsert Drills

editor

engine: not started

results

Run a query to see rows here.

check

Generic or custom plan

A prepared statement is planned with the actual parameter for the first five runs; from the sixth the server may switch to a generic plan.

task

Execute q six times with different ids, then return generic_plans and custom_plans from pg_prepared_statements.

hints