db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

One INSERT in the WAL

Every change is first written to the write-ahead log. pg_walinspect reads records between two LSNs. lab.mark.l1 is the LSN taken before your work.

task

Insert one row into lab.t, then count the Heap INSERT records for lab.t between lab.mark.l1 and the current flush LSN.

hints