db.l3.ai

Play

lessons

What Changed In 19

Upsert Drills

editor

engine: not started

results

Run a query to see rows here.

check

Read-stream counters in EXPLAIN (IO)

With IO on, a scan node reports prefetch distance and I/O counts of its read stream. In text form the lines appear only if prefetching happened.

task

Run EXPLAIN (ANALYZE, IO) over a full count of sensors.readings and find the Prefetch line.

hints