db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

First write after a checkpoint logs full pages

The first change to a page after a checkpoint writes the whole page into WAL (a full page image). The WAL line counts them.

task

Update every row of lab.w under EXPLAIN (ANALYZE, WAL) and read the WAL line.

hints