explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V3K0

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

Nested Loop (cost=0.15..31.13 rows=1 width=232) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on measurements_102072 measurements (cost=0.00..22.95 rows=1 width=22) (actual rows= loops=)

  • Filter: ((me_time >= '2017-03-15 08:13:00'::timestamp without time zone) AND (me_time <= '2017-03-15 09:18:00'::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Index Scan using loggers_pkey_102040 on loggers_102040 loggers (cost=0.15..8.17 rows=1 width=226) (actual rows= loops=)

  • Index Cond: ((lo_or_id = measurements.me_or_id) AND (lo_id = measurements.me_lo_id))