explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8AqA

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 1.967 ↓ 3.8 38 1

Nested Loop Left Join (cost=5.99..63.84 rows=10 width=1,735) (actual time=0.133..1.967 rows=38 loops=1)

2. 0.019 1.929 ↓ 7.6 38 1

Nested Loop Left Join (cost=5.72..58.98 rows=5 width=1,443) (actual time=0.127..1.929 rows=38 loops=1)

3. 0.035 1.872 ↓ 38.0 38 1

Nested Loop Left Join (cost=1.41..40.14 rows=1 width=1,251) (actual time=0.122..1.872 rows=38 loops=1)

4. 0.042 1.837 ↓ 38.0 38 1

Nested Loop Left Join (cost=1.14..31.75 rows=1 width=1,099) (actual time=0.117..1.837 rows=38 loops=1)

5. 0.585 1.795 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.99..28.24 rows=1 width=939) (actual time=0.114..1.795 rows=38 loops=1)

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

Nested Loop Left Join (cost=0.99..26.11 rows=1 width=787) (actual time=0.094..0.792 rows=38 loops=1)

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

Nested Loop Left Join (cost=0.99..25.09 rows=1 width=635) (actual time=0.076..0.281 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 0.098 ↓ 38.0 38 1

Nested Loop Left Join (cost=0.71..16.77 rows=1 width=431) (actual time=0.059..0.098 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.026 0.026 ↑ 1.0 1 1

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

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

Index Scan using vendor_attribute_vendor_id_idx on vendor_attribute attributes1_ (cost=0.29..8.31 rows=1 width=136) (actual time=0.032..0.051 rows=38 loops=1)

  • Index Cond: (((vendor_id)::text = 's0ah'::text) AND ((global_entity_id)::text = 'FP_SG'::text))
11. 0.152 0.152 ↓ 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.004..0.004 rows=0 loops=38)

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

13. 0.418 0.418 ↓ 7.0 42 38

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

14. 0.000 0.000 ↓ 0.0 0 38

Index Scan using mov_configuration_row_configuration_id_idx on mov_configuration_row configurat6_ (cost=0.14..3.49 rows=1 width=160) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: (movconfigu5_.configuration_id = configuration_id)
15. 0.000 0.000 ↓ 0.0 0 38

Index Scan using pk_travel_time_configuration on travel_time_fee_configuration traveltime7_ (cost=0.27..8.29 rows=1 width=152) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: (vendorpric2_.travel_time_fee_config_id = configuration_id)
16. 0.038 0.038 ↓ 0.0 0 38

Bitmap Heap Scan on delay_fee_configuration_row configurat4_ (cost=4.31..18.79 rows=5 width=192) (actual time=0.001..0.001 rows=0 loops=38)

  • Recheck Cond: (delayfeeco3_.configuration_id = configuration_id)
17. 0.000 0.000 ↓ 0.0 0 38

Bitmap Index Scan on delay_fee_configuration_row_configuration_id_idx (cost=0.00..4.31 rows=5 width=0) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: (delayfeeco3_.configuration_id = configuration_id)
18. 0.000 0.000 ↓ 0.0 0 38

Index Scan using travel_time_fee_configuration_row_configuration_id_idx on travel_time_fee_configuration_row configurat8_ (cost=0.27..0.95 rows=2 width=160) (actual time=0.000..0.000 rows=0 loops=38)

  • Index Cond: (traveltime7_.configuration_id = configuration_id)
Planning time : 2.219 ms
Execution time : 2.218 ms