db.l3.ai

Play

lessons

What Changed In 19

Upsert Drills

editor

engine: not started

results

Run a query to see rows here.

check

Prev Next

Generic and custom plan counters

pg_stat_statements counts how often a prepared statement ran with a generic plan and how often with a custom one.

Read-only lesson: nothing to run, read it through.

hints

No hints yet.

Read-only here: pg_stat_statements must be in shared_preload_libraries and this engine cannot preload it (CREATE EXTENSION fails at first use). It needs pg_stat_statements 1.13. The calls land on one entry because the query text is the same.