explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iSjI : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 11.665 ↑ 1.0 100 1

Limit (cost=121.77..549.58 rows=100 width=3,139) (actual time=11.132..11.665 rows=100 loops=1)

2. 0.062 11.651 ↑ 26.4 100 1

Nested Loop Left Join (cost=121.77..11,420.03 rows=2,641 width=3,139) (actual time=11.130..11.651 rows=100 loops=1)

3. 0.041 11.289 ↑ 26.4 100 1

Merge Left Join (cost=121.50..10,398.53 rows=2,641 width=1,544) (actual time=11.046..11.289 rows=100 loops=1)

  • Merge Cond: (t.id = uzgps_routing_notification.trip_id)
4. 0.114 10.906 ↑ 26.4 100 1

Merge Left Join (cost=0.70..10,270.48 rows=2,641 width=1,520) (actual time=10.700..10.906 rows=100 loops=1)

  • Merge Cond: (t.id = rtrs.trip_id)
5. 10.583 10.583 ↑ 660.2 4 1

Index Scan using uzgps_routing_trip_pkey on uzgps_routing_trip t (cost=0.28..6,683.89 rows=2,641 width=1,160) (actual time=10.582..10.583 rows=4 loops=1)

6. 0.209 0.209 ↑ 4.2 100 1

Index Scan using uzgps_routing_trip_route_station_trip_id_status_idx on uzgps_routing_trip_route_station rtrs (cost=0.42..3,574.80 rows=415 width=360) (actual time=0.106..0.209 rows=100 loops=1)

  • Index Cond: (status = 'A'::bpchar)
7. 0.035 0.342 ↑ 43.0 1 1

Sort (cost=120.80..120.91 rows=43 width=24) (actual time=0.342..0.342 rows=1 loops=1)

  • Sort Key: uzgps_routing_notification.trip_id
  • Sort Method: quicksort Memory: 25kB
8. 0.025 0.307 ↑ 3.6 12 1

HashAggregate (cost=118.77..119.20 rows=43 width=24) (actual time=0.302..0.307 rows=12 loops=1)

  • Group Key: uzgps_routing_notification.trip_id, uzgps_routing_notification.event_type_id
9. 0.221 0.282 ↑ 3.1 14 1

Bitmap Heap Scan on uzgps_routing_notification (cost=4.63..118.44 rows=44 width=16) (actual time=0.081..0.282 rows=14 loops=1)

  • Recheck Cond: (notification_type = 30)
  • Heap Blocks: exact=13
10. 0.061 0.061 ↑ 3.1 14 1

Bitmap Index Scan on uzgps_routing_notification_notification_type_ntime_idx (cost=0.00..4.62 rows=44 width=0) (actual time=0.061..0.061 rows=14 loops=1)

  • Index Cond: (notification_type = 30)
11. 0.300 0.300 ↑ 1.0 1 100

Index Scan using uzgps_mobject_pkey on uzgps_mobject m (cost=0.28..0.38 rows=1 width=1,595) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = t.mobject_id)