explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WAm8 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.147 ↓ 2.0 2 1

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

2. 0.048 0.138 ↓ 19.0 19 1

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

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