db.l3.ai

Play

lessons

what-changed-in-19

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