explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZPg1 : 123123

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

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

2. 0.018 0.073 ↓ 19.0 19 1

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

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