explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kHB6 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.099 ↓ 2.0 2 1

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

2. 0.036 0.093 ↓ 19.0 19 1

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

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