explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8CQB

Settings
# exclusive inclusive rows x rows loops node
1. 80.722 35,696.892 ↑ 9,099.4 12 1

Nested Loop (cost=5.37..29,667,416.85 rows=109,193 width=181) (actual time=11.923..35,696.892 rows=12 loops=1)

2. 19.252 19.252 ↑ 1.0 109,193 1

Seq Scan on stock_check_actions sca (cost=0.00..4,502.93 rows=109,193 width=38) (actual time=0.005..19.252 rows=109,193 loops=1)

3. 0.000 35,596.918 ↓ 0.0 0 109,193

GroupAggregate (cost=5.37..271.64 rows=1 width=152) (actual time=0.326..0.326 rows=0 loops=109,193)

  • Group Key: ord.delivery_executive_email
4. 49.299 35,596.918 ↓ 0.0 0 109,193

Nested Loop (cost=5.37..271.59 rows=1 width=42) (actual time=0.326..0.326 rows=0 loops=109,193)

5. 1,372.599 35,050.953 ↓ 2.0 2 109,193

Nested Loop (cost=5.08..263.28 rows=1 width=39) (actual time=0.167..0.321 rows=2 loops=109,193)

6. 4,149.334 4,586.106 ↓ 2.1 33 109,193

Bitmap Heap Scan on customer_delivery_data cdd (cost=4.66..127.76 rows=16 width=32) (actual time=0.007..0.042 rows=33 loops=109,193)

  • Recheck Cond: (route_id = sca.route_id)
  • Filter: ((delivery_type)::text = (sca.route_type)::text)
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=3,622,031
7. 436.772 436.772 ↓ 1.0 33 109,193

Bitmap Index Scan on customer_delivery_data_route_id_idx (cost=0.00..4.66 rows=32 width=0) (actual time=0.004..0.004 rows=33 loops=109,193)

  • Index Cond: (route_id = sca.route_id)
8. 29,092.248 29,092.248 ↓ 0.0 0 3,636,531

Index Scan using deliveries_customer_id_delivery_dat_cf440022_uniq on deliveries d (cost=0.42..8.46 rows=1 width=46) (actual time=0.008..0.008 rows=0 loops=3,636,531)

  • Index Cond: (((customer_id)::text = (cdd.cid)::text) AND ((delivery_type)::text = (sca.route_type)::text) AND ((item_type)::text = (sca.item_type)::text) AND ((item_id)::text = (sca.item_id)::text))
9. 496.666 496.666 ↓ 0.0 0 248,333

Index Scan using operations_routedemap_route_id_route_type_1e8a9214_uniq on operations_routedemap ord (cost=0.29..8.31 rows=1 width=246) (actual time=0.002..0.002 rows=0 loops=248,333)

  • Index Cond: ((route_id = sca.route_id) AND ((route_type)::text = (sca.route_type)::text))
  • Filter: ((delivery_executive_email)::text = 'partheepandksgi@gmail.com'::text)
  • Rows Removed by Filter: 1
Planning time : 2.518 ms
Execution time : 35,697.043 ms