explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRon : 234

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

Limit (cost=136.38..921.97 rows=100 width=3,139) (actual time=12.209..177.756 rows=100 loops=1)

2. 0.103 177.742 ↑ 26.4 100 1

Nested Loop Left Join (cost=136.38..20,883.83 rows=2,641 width=3,139) (actual time=12.208..177.742 rows=100 loops=1)

3. 24.119 177.439 ↑ 26.4 100 1

Nested Loop Left Join (cost=136.10..19,862.32 rows=2,641 width=1,544) (actual time=12.189..177.439 rows=100 loops=1)

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

Hash Left Join (cost=124.59..1,775.37 rows=2,641 width=1,184) (actual time=0.125..0.148 rows=4 loops=1)

  • Hash Cond: (t.id = uzgps_routing_notification.trip_id)
5. 0.020 0.020 ↑ 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.012..0.020 rows=4 loops=1)

6. 0.008 0.102 ↑ 3.8 12 1

Hash (cost=124.02..124.02 rows=46 width=24) (actual time=0.102..0.102 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.036 0.094 ↑ 3.8 12 1

HashAggregate (cost=123.10..123.56 rows=46 width=24) (actual time=0.086..0.094 rows=12 loops=1)

  • Group Key: uzgps_routing_notification.trip_id, uzgps_routing_notification.event_type_id
8. 0.039 0.058 ↑ 3.4 14 1

Bitmap Heap Scan on uzgps_routing_notification (cost=4.65..122.75 rows=47 width=16) (actual time=0.025..0.058 rows=14 loops=1)

  • Recheck Cond: (notification_type = 30)
  • Heap Blocks: exact=13
9. 0.019 0.019 ↑ 3.4 14 1

Bitmap Index Scan on uzgps_routing_notification_notification_type_ntime_idx (cost=0.00..4.64 rows=47 width=0) (actual time=0.019..0.019 rows=14 loops=1)

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

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

11. 39.608 48.845 ↓ 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=11.716..48.845 rows=71,669 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=10822
12. 9.237 9.237 ↓ 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=9.237..9.237 rows=71,669 loops=1)

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