explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cdr : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.021 ↑ 1.0 1 1

Aggregate (cost=8.43..8.44 rows=1 width=8) (actual time=0.020..0.021 rows=1 loops=1)

2. 0.018 0.018 ↓ 0.0 0 1

Index Only Scan using uzgps_routing_trip_status_mobject_id_time_start_time_end_idx on uzgps_routing_trip (cost=0.41..8.43 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

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