explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ZZO

Settings
# exclusive inclusive rows x rows loops node
1. 1,443.652 2,958.854 ↓ 19.8 40,317 1

Nested Loop (cost=0.84..37,562.21 rows=2,040 width=847) (actual time=1.254..2,958.854 rows=40,317 loops=1)

2. 27.454 1,515.202 ↓ 40,317.0 40,317 1

Nested Loop Left Join (cost=0.84..35,966.11 rows=1 width=841) (actual time=0.220..1,515.202 rows=40,317 loops=1)

3. 652.201 1,366.797 ↓ 40,317.0 40,317 1

Nested Loop Left Join (cost=0.43..35,965.61 rows=1 width=837) (actual time=0.194..1,366.797 rows=40,317 loops=1)

  • Join Filter: ((a02.cliente)::text = (a00.su)::text)
  • Rows Removed by Join Filter: 4376362
4. 59.518 311.426 ↓ 40,317.0 40,317 1

Nested Loop (cost=0.43..35,962.16 rows=1 width=837) (actual time=0.079..311.426 rows=40,317 loops=1)

5. 9.172 9.172 ↑ 1.0 40,456 1

Seq Scan on a00 (cost=0.00..1,999.56 rows=40,456 width=837) (actual time=0.008..9.172 rows=40,456 loops=1)

6. 242.736 242.736 ↑ 1.0 1 40,456

Index Only Scan using v0101_pkey on v0101 (cost=0.43..0.83 rows=1 width=11) (actual time=0.006..0.006 rows=1 loops=40,456)

  • Index Cond: ((empresa = a00.emp) AND (ejercicio = a00.eje) AND (almacen = (a00.alm)::text) AND (tipo_doc = 'PV'::text) AND (documento = a00.ped))
  • Heap Fetches: 24138
7. 403.170 403.170 ↑ 1.0 109 40,317

Seq Scan on a02 (cost=0.00..2.09 rows=109 width=13) (actual time=0.002..0.010 rows=109 loops=40,317)

8. 120.951 120.951 ↑ 1.0 1 40,317

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

  • Index Cond: ((serie)::text = (a00.serie)::text)
  • Filter: ((alm_serie)::text = (a00.alm)::text)
9. 0.000 0.000 ↑ 2,040.0 1 40,317

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

Planning time : 3.551 ms
Execution time : 2,963.268 ms