explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lQmb : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.132 ↓ 2.0 2 1

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

2. 0.025 0.128 ↓ 19.0 19 1

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

  • Sort Key: route_id
  • Sort Method: quicksort Memory: 25kB
3. 0.103 0.103 ↓ 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.087..0.103 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 (...)