explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pWzV : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.125 ↓ 2.0 2 1

Nested Loop (cost=8.66..16.70 rows=1 width=846) (actual time=0.120..0.125 rows=2 loops=1)

2. 0.004 0.112 ↓ 2.0 2 1

HashAggregate (cost=8.39..8.40 rows=1 width=8) (actual time=0.111..0.112 rows=2 loops=1)

  • Group Key: a1.route_id
3. 0.005 0.108 ↓ 2.0 2 1

Sort (cost=8.37..8.38 rows=1 width=16) (actual time=0.107..0.108 rows=2 loops=1)

  • Sort Key: a1.mobject_id
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.103 ↓ 2.0 2 1

Subquery Scan on a1 (cost=8.34..8.36 rows=1 width=16) (actual time=0.099..0.103 rows=2 loops=1)

5. 0.002 0.103 ↓ 2.0 2 1

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

6. 0.014 0.101 ↓ 19.0 19 1

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

  • Sort Key: rtt.route_id
  • Sort Method: quicksort Memory: 25kB
7. 0.087 0.087 ↓ 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.076..0.087 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, (...)
8. 0.012 0.012 ↑ 1.0 1 2

Index Scan using uzgps_routing_route_pkey on uzgps_routing_route rr (cost=0.27..8.29 rows=1 width=846) (actual time=0.006..0.006 rows=1 loops=2)

  • Index Cond: (id = a1.route_id)