explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n2Xb : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 1.085 ↑ 1.0 100 1

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

2. 0.156 1.073 ↑ 26.4 100 1

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

3. 0.056 0.717 ↑ 26.4 100 1

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

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

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

  • Merge Cond: (t.id = rtrs.trip_id)
5. 0.092 0.092 ↑ 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=0.090..0.092 rows=4 loops=1)

6. 0.246 0.246 ↑ 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.083..0.246 rows=100 loops=1)

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

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

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

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

  • Group Key: uzgps_routing_notification.trip_id, uzgps_routing_notification.event_type_id
9. 0.100 0.154 ↑ 3.1 14 1

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

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

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

  • Index Cond: (notification_type = 30)
11. 0.200 0.200 ↑ 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.002..0.002 rows=1 loops=100)

  • Index Cond: (id = t.mobject_id)