explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bbSj : Optimization for: plan #KgIa

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,394.28..72,098.19 rows=7,809 width=121) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,393.86..72,057.00 rows=1 width=1,195) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,393.30..72,054.19 rows=1 width=1,203) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,392.88..72,051.68 rows=1 width=36) (actual rows= loops=)

  • Join Filter: (orderitemcomercial.id = srcoiref.reference_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,392.32..72,042.82 rows=1 width=44) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,391.89..72,015.74 rows=11 width=16) (actual rows= loops=)

  • Join Filter: (productspeccatalogue.id = oitoprodspec.reference_id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,391.34..71,033.42 rows=34 width=24) (actual rows= loops=)

  • Hash Cond: (productspeccatalogue.id = productspecvlocobject.id)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,000.42..65,499.02 rows=54,663 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.42..61,679.38 rows=7,809 width=8) (actual rows= loops=)

  • Workers Planned: 2
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..59,898.48 rows=3,254 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on vloc_objects orderitemtecnicoobject (cost=0.00..47,264.29 rows=5,348 width=8) (actual rows= loops=)

  • Filter: (id = id)
12. 0.000 0.000 ↓ 0.0

Index Only Scan using vloc_storage_order_items_pkey on vloc_storage_order_items oihuawei (cost=0.42..2.36 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = orderitemtecnicoobject.parent_id)
13. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..3,136.38 rows=7 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on vloc_storage_catalogue productspeccatalogue (cost=0.00..3,136.34 rows=7 width=8) (actual rows= loops=)

  • Filter: (((properties ->> '2913547483939640321'::text) ~~* 'FAN_%'::text) AND ((properties ->> '4274760471304743945'::text) = 'true'::text))
15. 0.000 0.000 ↓ 0.0

Hash (cost=5,370.71..5,370.71 rows=1,616 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on vloc_objects productspecvlocobject (cost=56.95..5,370.71 rows=1,616 width=8) (actual rows= loops=)

  • Recheck Cond: (object_type_id = '4412964684871296634'::bigint)
17. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on vloc_objects_idx1 (cost=0.00..56.55 rows=1,616 width=0) (actual rows= loops=)

  • Index Cond: (object_type_id = '4412964684871296634'::bigint)
18. 0.000 0.000 ↓ 0.0

Index Only Scan using vloc_references_idx2 on vloc_references oitoprodspec (cost=0.56..28.78 rows=9 width=16) (actual rows= loops=)

  • Index Cond: ((reference_id = productspecvlocobject.id) AND (attribute_id = '4412964684871296635'::bigint))
19. 0.000 0.000 ↓ 0.0

Index Scan using vloc_storage_order_items_pkey on vloc_storage_order_items orderitemcomercial (cost=0.42..2.46 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (id = oitoprodspec.object_id)
  • Filter: ((properties ->> '4412964684871996059'::text) = 'Add'::text)
20. 0.000 0.000 ↓ 0.0

Index Only Scan using vloc_references_idx2 on vloc_references srcoiref (cost=0.56..8.75 rows=8 width=16) (actual rows= loops=)

  • Index Cond: ((reference_id = oitoprodspec.object_id) AND (attribute_id = '6434687505122213218'::bigint))
21. 0.000 0.000 ↓ 0.0

Index Scan using vloc_storage_order_items_pkey on vloc_storage_order_items orderitemtecnico (cost=0.42..2.51 rows=1 width=1,167) (actual rows= loops=)

  • Index Cond: (id = srcoiref.object_id)
22. 0.000 0.000 ↓ 0.0

Index Only Scan using vloc_references_idx1 on vloc_references invitemref (cost=0.56..2.80 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((object_id = orderitemtecnico.id) AND (attribute_id = '976718169186102322'::bigint))
23. 0.000 0.000 ↓ 0.0

Index Scan using vloc_storage_inventory_items_pkey on vloc_storage_inventory_items invitem (cost=0.42..2.15 rows=1 width=738) (actual rows= loops=)

  • Index Cond: (id = invitemref.reference_id)
  • Filter: (name <> 'Huawei CBS RFS'::text)