db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Correlation

pg_stats.correlation is how well a column's order matches the physical row order: 1 is perfect, 0 is random. BRIN and range scans on the index depend on it.

task

Read the physical correlation of readings.ts (rounded to 1 decimal: ANALYZE samples rows, so more digits change between runs) and see why BRIN works.

hints