explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iGAT

Settings
# exclusive inclusive rows x rows loops node
1. 1,469.743 24,159.824 ↓ 1.8 40,317 1

Nested Loop (cost=0.84..58,898.50 rows=22,440 width=972) (actual time=1.460..24,159.824 rows=40,317 loops=1)

2. 0.006 0.006 ↑ 2,040.0 1 1

Seq Scan on param_medidas (cost=0.00..30.40 rows=2,040 width=6) (actual time=0.005..0.006 rows=1 loops=1)

3. 64.748 22,690.075 ↓ 3,665.2 40,317 1

Materialize (cost=0.84..41,533.23 rows=11 width=966) (actual time=0.765..22,690.075 rows=40,317 loops=1)

4. 5,831.243 22,625.327 ↓ 3,665.2 40,317 1

Nested Loop Left Join (cost=0.84..41,533.17 rows=11 width=966) (actual time=0.760..22,625.327 rows=40,317 loops=1)

  • Join Filter: ((a02.cliente)::text = (a00.su)::text)
  • Rows Removed by Join Filter: 45378751
5. 7,145.525 14,133.162 ↓ 13,439.0 40,317 1

Nested Loop Left Join (cost=0.84..41,481.20 rows=3 width=898) (actual time=0.260..14,133.162 rows=40,317 loops=1)

  • Join Filter: ((a01.vend)::text = (v0101.vendedor_1)::text)
  • Rows Removed by Join Filter: 59349077
6. 540.744 1,907.695 ↓ 40,317.0 40,317 1

Nested Loop Left Join (cost=0.84..41,447.33 rows=1 width=842) (actual time=0.107..1,907.695 rows=40,317 loops=1)

  • Join Filter: (x0601.pais = a00.pais_pedido)
  • Rows Removed by Join Filter: 5563988
7. 50.951 600.928 ↓ 40,317.0 40,317 1

Nested Loop Left Join (cost=0.84..41,442.20 rows=1 width=832) (actual time=0.078..600.928 rows=40,317 loops=1)

8. 92.447 388.709 ↓ 40,317.0 40,317 1

Nested Loop (cost=0.43..41,441.60 rows=1 width=828) (actual time=0.041..388.709 rows=40,317 loops=1)

9. 13.070 13.070 ↓ 3.2 40,456 1

Seq Scan on a00 (cost=0.00..1,722.60 rows=12,760 width=805) (actual time=0.005..13.070 rows=40,456 loops=1)

10. 283.192 283.192 ↑ 1.0 1 40,456

Index Scan using v0101_pkey on v0101 (cost=0.43..3.10 rows=1 width=34) (actual time=0.007..0.007 rows=1 loops=40,456)

  • Index Cond: ((empresa = a00.emp) AND (ejercicio = a00.eje) AND ((almacen)::text = (a00.alm)::text) AND ((tipo_doc)::text = 'PV'::text) AND (documento = a00.ped))
11. 161.268 161.268 ↑ 1.0 1 40,317

Index Scan using m_series_planificadas_idx01 on m_series_planificadas (cost=0.41..0.59 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=40,317)

  • Index Cond: ((serie)::text = (a00.serie)::text)
  • Filter: ((alm_serie)::text = (a00.alm)::text)
12. 766.023 766.023 ↑ 1.0 139 40,317

Seq Scan on x0601 (cost=0.00..3.39 rows=139 width=12) (actual time=0.001..0.019 rows=139 loops=40,317)

13. 5,079.942 5,079.942 ↓ 1.5 1,473 40,317

Seq Scan on a01 (cost=0.00..21.72 rows=972 width=70) (actual time=0.002..0.126 rows=1,473 loops=40,317)

14. 2,660.568 2,660.922 ↓ 1.5 1,126 40,317

Materialize (cost=0.00..20.95 rows=730 width=81) (actual time=0.000..0.066 rows=1,126 loops=40,317)

15. 0.354 0.354 ↓ 1.5 1,126 1

Seq Scan on a02 (cost=0.00..17.30 rows=730 width=81) (actual time=0.013..0.354 rows=1,126 loops=1)

Planning time : 5.113 ms
Execution time : 24,168.919 ms