explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rAOA

Settings
# exclusive inclusive rows x rows loops node
1. 1.397 25.289 ↓ 12.7 38 1

Nested Loop Left Join (cost=0.71..2,106.24 rows=3 width=1,735) (actual time=2.308..25.289 rows=38 loops=1)

  • Join Filter: (traveltime7_.configuration_id = configurat8_.configuration_id)
  • Rows Removed by Join Filter: 15,504
2. 0.318 22.638 ↓ 19.0 38 1

Nested Loop Left Join (cost=0.71..2,075.94 rows=2 width=1,443) (actual time=1.972..22.638 rows=38 loops=1)

  • Join Filter: (movconfigu5_.configuration_id = configurat6_.configuration_id)
  • Rows Removed by Join Filter: 2,850
3. 0.390 21.864 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..2,056.26 rows=1 width=1,283) (actual time=1.944..21.864 rows=38 loops=1)

  • Join Filter: (vendorpric2_.travel_time_fee_config_id = traveltime7_.configuration_id)
  • Rows Removed by Join Filter: 4,940
4. 0.143 20.144 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..2,042.05 rows=1 width=1,131) (actual time=1.887..20.144 rows=38 loops=1)

  • Join Filter: (vendorpric2_.mov_configuration_id = movconfigu5_.configuration_id)
  • Rows Removed by Join Filter: 1,596
5. 3.661 19.545 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..2,039.91 rows=1 width=979) (actual time=1.866..19.545 rows=38 loops=1)

  • Join Filter: (delayfeeco3_.configuration_id = configurat4_.configuration_id)
  • Rows Removed by Join Filter: 36,518
6. 0.151 11.514 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..1,997.43 rows=1 width=787) (actual time=1.614..11.514 rows=38 loops=1)

  • Join Filter: (vendorpric2_.delay_fee_config_id = delayfeeco3_.configuration_id)
  • Rows Removed by Join Filter: 1,520
7. 0.021 11.021 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..1,996.41 rows=1 width=635) (actual time=1.597..11.021 rows=38 loops=1)

  • Join Filter: (((vendor0_.global_entity_id)::text = (vendorpric2_.global_entity_id)::text) AND ((vendor0_.vendor_id)::text = (vendorpric2_.vendor_id)::text))
8. 0.021 10.810 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.42..1,988.10 rows=1 width=431) (actual time=1.580..10.810 rows=38 loops=1)

  • Join Filter: (((vendor0_.global_entity_id)::text = (attributes1_.global_entity_id)::text) AND ((vendor0_.vendor_id)::text = (attributes1_.vendor_id)::text))
9. 0.028 0.028 ↑ 1.0 1 1

Index Scan using pk_vendor on vendor vendor0_ (cost=0.42..8.45 rows=1 width=295) (actual time=0.026..0.028 rows=1 loops=1)

  • Index Cond: (((global_entity_id)::text = 'FP_SG'::text) AND ((vendor_id)::text = 's0ah'::text))
10. 10.761 10.761 ↓ 38.0 38 1

Seq Scan on vendor_attribute attributes1_ (cost=0.00..1,979.63 rows=1 width=136) (actual time=1.552..10.761 rows=38 loops=1)

  • Filter: (((global_entity_id)::text = 'FP_SG'::text) AND ((vendor_id)::text = 's0ah'::text))
  • Rows Removed by Filter: 47,992
11. 0.190 0.190 ↓ 0.0 0 38

Index Scan using pk_vendor_price_config on vendor_price_config vendorpric2_ (cost=0.28..8.30 rows=1 width=204) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (((global_entity_id)::text = 'FP_SG'::text) AND ((vendor_id)::text = 's0ah'::text))
12. 0.342 0.342 ↓ 40.0 40 38

Seq Scan on delay_fee_configuration delayfeeco3_ (cost=0.00..1.01 rows=1 width=152) (actual time=0.002..0.009 rows=40 loops=38)

13. 4.370 4.370 ↓ 3.3 961 38

Seq Scan on delay_fee_configuration_row configurat4_ (cost=0.00..38.88 rows=288 width=192) (actual time=0.002..0.115 rows=961 loops=38)

14. 0.456 0.456 ↓ 7.0 42 38

Seq Scan on mov_configuration movconfigu5_ (cost=0.00..2.06 rows=6 width=152) (actual time=0.002..0.012 rows=42 loops=38)

15. 1.330 1.330 ↑ 1.1 130 38

Seq Scan on travel_time_fee_configuration traveltime7_ (cost=0.00..12.43 rows=143 width=152) (actual time=0.001..0.035 rows=130 loops=38)

16. 0.456 0.456 ↑ 5.7 75 38

Seq Scan on mov_configuration_row configurat6_ (cost=0.00..14.30 rows=430 width=160) (actual time=0.002..0.012 rows=75 loops=38)

17. 1.110 1.254 ↓ 1.5 408 38

Materialize (cost=0.00..22.99 rows=266 width=160) (actual time=0.000..0.033 rows=408 loops=38)

18. 0.144 0.144 ↓ 1.5 408 1

Seq Scan on travel_time_fee_configuration_row configurat8_ (cost=0.00..21.66 rows=266 width=160) (actual time=0.005..0.144 rows=408 loops=1)

Planning time : 1.768 ms
Execution time : 25.522 ms