explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qiAv : Optimization for: ///0; plan #lWEv

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.21..1547.50 rows=1230 width=72)-> Seq Scan on measurement m (cost=0.00..22.30 rows=1230 width=36)-> Limit (cost=1.21..1.22 rows=1 width=36)-> Sort (cost=1.21..1.22 rows=1 width=36)Sort Key: (abs((l.nominal_value - m.value)))-> Seq Scan on lookup l (cost=0.00..1.20 rows=1 width=36) (actual rows= loops=)