explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f15v : Optimization for: Teste; plan #6hC2

Settings

Optimization path:

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

Hash Right Join (cost=71.30..88.15 rows=453 width=16) (actual rows= loops=)

  • Hash Cond: (v.operator_id = o.id)
  • Filter: ""overlaps""(j.time_frame, j.time_frame, '2012-11-05 00:00:00'::timestamp without time zone, '2012-11-08 00:00:00'::timestamp without time zone)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=30.70..45.12 rows=920 width=24) (actual rows= loops=)

  • Hash Cond: (j.vehicle_id = v.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on journeys j (cost=0.00..13.50 rows=350 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=19.20..19.20 rows=920 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on vehicles v (cost=0.00..19.20 rows=920 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=23.60..23.60 rows=1,360 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on operators o (cost=0.00..23.60 rows=1,360 width=32) (actual rows= loops=)