explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dRSk

Settings
# exclusive inclusive rows x rows loops node
1. 0.220 132.071 ↓ 3.6 952 1

Hash Left Join (cost=55,237.94..62,403.79 rows=267 width=338) (actual time=131.351..132.071 rows=952 loops=1)

  • Hash Cond: (((p.em_opxpatr_valor_atributos_id)::text = (stock.m_attributesetinstance_id)::text) AND ((p.m_product_id)::text = (stock.m_product_id)::text))
2. 0.213 16.795 ↓ 3.6 952 1

Nested Loop (cost=41.78..7,206.22 rows=267 width=240) (actual time=16.280..16.795 rows=952 loops=1)

3. 0.002 16.216 ↑ 1.0 1 1

Nested Loop (cost=6.04..3,546.94 rows=1 width=31) (actual time=16.192..16.216 rows=1 loops=1)

  • Join Filter: ((prod.m_product_category_id)::text = (pc.m_product_category_id)::text)
4. 0.026 0.026 ↑ 1.0 1 1

Seq Scan on m_product_category pc (cost=0.00..3.74 rows=1 width=33) (actual time=0.015..0.026 rows=1 loops=1)

  • Filter: (em_opxdes_categoria_vehiculo = 'Y'::bpchar)
  • Rows Removed by Filter: 58
5. 0.001 16.188 ↑ 17.0 1 1

Nested Loop (cost=6.04..3,542.99 rows=17 width=64) (actual time=16.175..16.188 rows=1 loops=1)

6. 0.005 16.178 ↑ 17.0 1 1

Nested Loop (cost=5.76..3,495.48 rows=17 width=64) (actual time=16.165..16.178 rows=1 loops=1)

7. 0.002 16.150 ↑ 1.0 1 1

Nested Loop (cost=0.42..3,033.31 rows=1 width=64) (actual time=16.139..16.150 rows=1 loops=1)

8. 0.024 0.024 ↑ 1.0 1 1

Index Only Scan using opxdes_vehiculo_pkey on opxdes_vehiculo veh (cost=0.42..8.44 rows=1 width=31) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: (opxdes_vehiculo_id = 'E3E19AD7BC1642CA8880B33E5DC28993'::text)
  • Heap Fetches: 1
9. 16.124 16.124 ↑ 1.0 1 1

Seq Scan on m_refinventory box (cost=0.00..3,024.86 rows=1 width=66) (actual time=16.115..16.124 rows=1 loops=1)

  • Filter: (((em_opxawo_vehiculo)::text = 'E3E19AD7BC1642CA8880B33E5DC28993'::text) AND (em_awobg_contenedor = 'N'::bpchar))
  • Rows Removed by Filter: 64,590
10. 0.006 0.023 ↑ 118.0 1 1

Bitmap Heap Scan on m_storage_detail sd (cost=5.34..460.99 rows=118 width=66) (actual time=0.023..0.023 rows=1 loops=1)

  • Recheck Cond: ((m_refinventory_id)::text = (box.m_refinventory_id)::text)
  • Filter: (qtyonhand > '0'::numeric)
  • Heap Blocks: exact=1
11. 0.017 0.017 ↑ 118.0 1 1

Bitmap Index Scan on m_storagedet_refinventory (cost=0.00..5.31 rows=118 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((m_refinventory_id)::text = (box.m_refinventory_id)::text)
12. 0.009 0.009 ↑ 1.0 1 1

Index Scan using m_product_key on m_product prod (cost=0.28..2.79 rows=1 width=66) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((m_product_id)::text = (sd.m_product_id)::text)
13. 0.292 0.366 ↓ 1.0 952 1

Bitmap Heap Scan on opxdes_vehiculo_pieza p (cost=35.74..3,650.02 rows=926 width=240) (actual time=0.084..0.366 rows=952 loops=1)

  • Recheck Cond: ((opxdes_vehiculo_id)::text = 'E3E19AD7BC1642CA8880B33E5DC28993'::text)
  • Heap Blocks: exact=54
14. 0.074 0.074 ↓ 1.0 952 1

Bitmap Index Scan on opxdes_vehiculo_pieza_idx (cost=0.00..35.51 rows=926 width=0) (actual time=0.074..0.074 rows=952 loops=1)

  • Index Cond: ((opxdes_vehiculo_id)::text = 'E3E19AD7BC1642CA8880B33E5DC28993'::text)
15. 0.001 115.056 ↓ 0.0 0 1

Hash (cost=55,196.15..55,196.15 rows=1 width=98) (actual time=115.056..115.056 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
16. 0.000 115.055 ↓ 0.0 0 1

GroupAggregate (cost=55,196.12..55,196.14 rows=1 width=98) (actual time=115.055..115.055 rows=0 loops=1)

  • Group Key: stock.m_product_id, stock.m_attributesetinstance_id
17. 0.000 115.055 ↓ 0.0 0 1

Sort (cost=55,196.12..55,196.12 rows=1 width=70) (actual time=115.055..115.055 rows=0 loops=1)

  • Sort Key: stock.m_product_id, stock.m_attributesetinstance_id
  • Sort Method: quicksort Memory: 25kB
18. 5.859 115.682 ↓ 0.0 0 1

Gather (cost=1,000.00..55,196.11 rows=1 width=70) (actual time=115.050..115.682 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
19. 109.823 109.823 ↓ 0.0 0 3 / 3

Parallel Seq Scan on m_storage_detail stock (cost=0.00..54,196.01 rows=1 width=70) (actual time=109.823..109.823 rows=0 loops=3)

  • Filter: ((qtyonhand > '0'::numeric) AND (qtyorderonhand <> '0'::numeric) AND (reservedqty <> '0'::numeric) AND (allocatedqty <> '0'::numeric))
  • Rows Removed by Filter: 366,400
Planning time : 1.555 ms
Execution time : 132.832 ms