explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fuEc : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.116 ↓ 2.0 2 1

Unique (cost=8.34..8.35 rows=1 width=16) (actual time=0.111..0.116 rows=2 loops=1)

2. 0.025 0.114 ↓ 19.0 19 1

Sort (cost=8.34..8.35 rows=1 width=16) (actual time=0.111..0.114 rows=19 loops=1)

  • Sort Key: route_id
  • Sort Method: quicksort Memory: 25kB
3. 0.089 0.089 ↓ 19.0 19 1

Index Scan using uzgps_routing_trip_template_mobject_id_time_start_idx on uzgps_routing_trip_template rtt (cost=0.31..8.33 rows=1 width=16) (actual time=0.066..0.089 rows=19 loops=1)

  • Index Cond: ((mobject_id = 1182) AND (time_start >= ((date_part('epoch'::text, date_trunc('day'::text, now())) * '1000'::double precision))::bigint) AND (time_start <= ((date_part('epoch'::text, date_trunc('day'::text, (now() + '1 day'::inter (...)