explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MJtv : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 350.927 ↑ 1.0 100 1

Limit (cost=131.96..917.55 rows=100 width=3,139) (actual time=22.581..350.927 rows=100 loops=1)

2. 0.132 350.896 ↑ 26.4 100 1

Nested Loop Left Join (cost=131.96..20,879.38 rows=2,641 width=3,139) (actual time=22.579..350.896 rows=100 loops=1)

3. 30.776 350.464 ↑ 26.4 100 1

Nested Loop Left Join (cost=131.68..19,857.87 rows=2,641 width=1,544) (actual time=22.554..350.464 rows=100 loops=1)

  • Join Filter: (t.id = rtrs.trip_id)
  • Rows Removed by Join Filter: 214955
4. 0.065 0.408 ↑ 660.2 4 1

Hash Left Join (cost=120.17..1,770.91 rows=2,641 width=1,184) (actual time=0.338..0.408 rows=4 loops=1)

  • Hash Cond: (t.id = uzgps_routing_notification.trip_id)
5. 0.066 0.066 ↑ 660.2 4 1

Seq Scan on uzgps_routing_trip t (cost=0.00..1,640.41 rows=2,641 width=1,160) (actual time=0.045..0.066 rows=4 loops=1)

6. 0.008 0.277 ↑ 3.6 12 1

Hash (cost=119.63..119.63 rows=43 width=24) (actual time=0.277..0.277 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.035 0.269 ↑ 3.6 12 1

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

  • Group Key: uzgps_routing_notification.trip_id, uzgps_routing_notification.event_type_id
8. 0.147 0.234 ↑ 3.1 14 1

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

  • Recheck Cond: (notification_type = 30)
  • Heap Blocks: exact=13
9. 0.087 0.087 ↑ 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.087..0.087 rows=14 loops=1)

  • Index Cond: (notification_type = 30)
10. 118.755 319.280 ↓ 129.6 53,764 4

Materialize (cost=11.51..1,647.77 rows=415 width=360) (actual time=5.400..79.820 rows=53,764 loops=4)

11. 182.988 200.525 ↓ 172.7 71,669 1

Bitmap Heap Scan on uzgps_routing_trip_route_station rtrs (cost=11.51..1,645.69 rows=415 width=360) (actual time=21.573..200.525 rows=71,669 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=10822
12. 17.537 17.537 ↓ 172.7 71,669 1

Bitmap Index Scan on uzgps_routing_trip_route_station_status_idx (cost=0.00..11.41 rows=415 width=0) (actual time=17.537..17.537 rows=71,669 loops=1)

  • Index Cond: (status = 'A'::bpchar)
13. 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)