db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Physical correlation

pg_stats.correlation says how well the physical order follows the column order. readings is stored in time order.

task

For sensors.readings return attname and whether correlation exceeds 0.9 (as in_order) for ts and device_id, ordered by attname.

hints