explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ee6P : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.015 ↑ 1.0 1 1

Aggregate (cost=8.35..8.36 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

2. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using uzgps_routing_trip_mobject_id_time_start_time_end_status_idx on uzgps_routing_trip (cost=0.28..8.35 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((mobject_id = 1181) AND (time_start > 1541323983) AND (status = 'A'::bpchar))
  • Filter: ((time_end <= 1547015183) OR (time_end = 0))
  • Heap Fetches: 0