explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wog

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 17.165 ↓ 12.7 38 1

Sort (cost=2,106.27..2,106.28 rows=3 width=1,735) (actual time=17.164..17.165 rows=38 loops=1)

  • Sort Key: configurat4_.delay_threshold, configurat4_.travel_time_threshold, configurat6_.travel_time_threshold, configurat8_.travel_time_threshold
  • Sort Method: quicksort Memory: 44kB
2. 1.056 17.113 ↓ 12.7 38 1

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

  • Join Filter: (traveltime7_.configuration_id = configurat8_.configuration_id)
  • Rows Removed by Join Filter: 15,504
3. 0.242 15.107 ↓ 19.0 38 1

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

  • Join Filter: (movconfigu5_.configuration_id = configurat6_.configuration_id)
  • Rows Removed by Join Filter: 2,850
4. 0.267 14.523 ↓ 38.0 38 1

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

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

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

  • Join Filter: (vendorpric2_.mov_configuration_id = movconfigu5_.configuration_id)
  • Rows Removed by Join Filter: 1,596
6. 2.578 12.927 ↓ 38.0 38 1

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

  • Join Filter: (delayfeeco3_.configuration_id = configurat4_.configuration_id)
  • Rows Removed by Join Filter: 36,518
7. 0.100 7.043 ↓ 38.0 38 1

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

  • Join Filter: (vendorpric2_.delay_fee_config_id = delayfeeco3_.configuration_id)
  • Rows Removed by Join Filter: 1,520
8. 0.043 6.677 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..1,996.41 rows=1 width=635) (actual time=1.380..6.677 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))
9. 0.016 6.520 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.42..1,988.10 rows=1 width=431) (actual time=1.365..6.520 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))
10. 0.021 0.021 ↑ 1.0 1 1

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

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

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

  • Filter: (((global_entity_id)::text = 'FP_SG'::text) AND ((vendor_id)::text = 's0ah'::text))
  • Rows Removed by Filter: 47,992
12. 0.114 0.114 ↓ 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.003..0.003 rows=0 loops=38)

  • Index Cond: (((global_entity_id)::text = 'FP_SG'::text) AND ((vendor_id)::text = 's0ah'::text))
13. 0.266 0.266 ↓ 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.007 rows=40 loops=38)

14. 3.306 3.306 ↓ 3.3 961 38

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

15. 0.304 0.304 ↓ 7.0 42 38

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

16. 0.912 0.912 ↑ 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.024 rows=130 loops=38)

17. 0.342 0.342 ↑ 5.7 75 38

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

18. 0.853 0.950 ↓ 1.5 408 38

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

19. 0.097 0.097 ↓ 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.003..0.097 rows=408 loops=1)

Planning time : 1.438 ms
Execution time : 17.320 ms