explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IUgJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.946 15.166 ↓ 12.7 38 1

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

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

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

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

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

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

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

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

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

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

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

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

Nested Loop Left Join (cost=0.71..1,996.41 rows=1 width=635) (actual time=1.036..6.237 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.012 6.122 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.42..1,988.10 rows=1 width=431) (actual time=1.023..6.122 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.023 0.023 ↑ 1.0 1 1

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

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

Seq Scan on vendor_attribute attributes1_ (cost=0.00..1,979.63 rows=1 width=136) (actual time=0.999..6.087 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.076 0.076 ↓ 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.002..0.002 rows=0 loops=38)

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

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

13. 2.660 2.660 ↓ 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.070 rows=961 loops=38)

14. 0.266 0.266 ↓ 7.0 42 38

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

15. 0.760 0.760 ↑ 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.020 rows=130 loops=38)

16. 0.304 0.304 ↑ 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.008 rows=75 loops=38)

17. 0.742 0.836 ↓ 1.5 408 38

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

18. 0.094 0.094 ↓ 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.094 rows=408 loops=1)

Planning time : 1.382 ms
Execution time : 15.336 ms