explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nt8E

Settings
# exclusive inclusive rows x rows loops node
1. 1,640.180 3,839.738 ↓ 19.9 40,618 1

Nested Loop (cost=0.84..43,245.09 rows=2,040 width=848) (actual time=0.914..3,839.738 rows=40,618 loops=1)

2. 645.727 2,158.940 ↓ 40,618.0 40,618 1

Nested Loop Left Join (cost=0.84..41,643.89 rows=1 width=842) (actual time=0.132..2,158.940 rows=40,618 loops=1)

  • Join Filter: (x0601.pais = a00.pais_pedido)
  • Rows Removed by Join Filter: 5605526
3. 51.393 578.999 ↓ 40,618.0 40,618 1

Nested Loop Left Join (cost=0.84..41,638.76 rows=1 width=832) (actual time=0.099..578.999 rows=40,618 loops=1)

4. 67.601 405.752 ↓ 40,618.0 40,618 1

Nested Loop (cost=0.43..41,638.16 rows=1 width=828) (actual time=0.068..405.752 rows=40,618 loops=1)

5. 12.095 12.095 ↓ 3.2 40,757 1

Seq Scan on a00 (cost=0.00..1,735.56 rows=12,856 width=805) (actual time=0.011..12.095 rows=40,757 loops=1)

6. 326.056 326.056 ↑ 1.0 1 40,757

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

  • 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))
7. 121.854 121.854 ↑ 1.0 1 40,618

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

  • Index Cond: ((serie)::text = (a00.serie)::text)
  • Filter: ((alm_serie)::text = (a00.alm)::text)
8. 934.214 934.214 ↑ 1.0 139 40,618

Seq Scan on x0601 (cost=0.00..3.39 rows=139 width=12) (actual time=0.002..0.023 rows=139 loops=40,618)

9. 40.618 40.618 ↑ 2,040.0 1 40,618

Seq Scan on param_medidas (cost=0.00..30.40 rows=2,040 width=6) (actual time=0.000..0.001 rows=1 loops=40,618)

Planning time : 3.911 ms
Execution time : 3,845.250 ms