db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

BUFFERS

EXPLAIN (ANALYZE, BUFFERS) counts the 8 kB pages each node touched. Pages are a stable cost measure; milliseconds are not.

task

Run EXPLAIN (ANALYZE, BUFFERS) SELECT count(*) FROM readings, then return the heap's page count (it equals the buffers the seq scan touched).

hints