explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rgOI : 13

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.024 ↑ 1.0 1 1

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

2. 0.020 0.020 ↓ 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.020..0.020 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