explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fhe

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.695 ↓ 16.0 16 1

Sort (cost=30.42..30.42 rows=1 width=211) (actual time=0.693..0.695 rows=16 loops=1)

  • Sort Key: parametro.par_deslargo01, operador.ope_nrutoperador, operador.ope_sdigverificador
  • Sort Method: quicksort Memory: 27kB
2. 0.026 0.669 ↓ 16.0 16 1

GroupAggregate (cost=30.36..30.41 rows=1 width=211) (actual time=0.649..0.669 rows=16 loops=1)

  • Group Key: parametro.par_deslargo01, operador.ope_nrutoperador, (CASE lotes_fact_det_electronica.lfde_tipo_documento WHEN 'FACTU'::text THEN 'F'::text WHEN 'NOCRE'::text THEN 'NC'::text ELSE '0'::text END), (CASE lotes_fact_det_electronica.lfde_est (...)
3. 0.054 0.643 ↓ 16.0 16 1

Sort (cost=30.36..30.37 rows=1 width=145) (actual time=0.641..0.643 rows=16 loops=1)

  • Sort Key: parametro.par_deslargo01, operador.ope_nrutoperador, (CASE lotes_fact_det_electronica.lfde_tipo_documento WHEN 'FACTU'::text THEN 'F'::text WHEN 'NOCRE'::text THEN 'NC'::text ELSE '0'::text END), (CASE lotes_fact_det_electronica.lfd (...)
  • Sort Method: quicksort Memory: 26kB
4. 0.021 0.589 ↓ 16.0 16 1

Nested Loop Left Join (cost=5.76..30.35 rows=1 width=145) (actual time=0.089..0.589 rows=16 loops=1)

  • Join Filter: (agrupacion.lfde_rut_operador = operador.ope_nrutoperador)
5. 0.072 0.552 ↓ 16.0 16 1

Nested Loop Left Join (cost=0.72..25.25 rows=1 width=51) (actual time=0.068..0.552 rows=16 loops=1)

  • Join Filter: (operador.ope_nrutoperador = lotes_fact_det_electronica.lfde_rut_operador)
6. 0.167 0.432 ↓ 16.0 16 1

Nested Loop Left Join (cost=0.28..16.78 rows=1 width=37) (actual time=0.047..0.432 rows=16 loops=1)

  • Join Filter: (parametro.par_numero01 = operador.ope_nrutoperador)
  • Rows Removed by Join Filter: 449
7. 0.025 0.025 ↓ 16.0 16 1

Seq Scan on operador (cost=0.00..1.34 rows=1 width=24) (actual time=0.014..0.025 rows=16 loops=1)

  • Filter: ((ope_scodestado)::text = 'VIGEN'::text)
  • Rows Removed by Filter: 11
8. 0.240 0.240 ↓ 4.1 29 16

Index Scan using idx_param_numpar on parametro (cost=0.28..15.35 rows=7 width=19) (actual time=0.006..0.015 rows=29 loops=16)

  • Index Cond: (par_numparametro = '23'::numeric)
9. 0.048 0.048 ↓ 0.0 0 16

Index Scan using idx_extra_lfde_fecha_creacion on lotes_fact_det_electronica (cost=0.44..8.46 rows=1 width=21) (actual time=0.003..0.003 rows=0 loops=16)

  • Index Cond: ((lfde_fecha_creacion >= to_date('01/03/2005 00:00'::character varying, 'dd/mm/yyyy hh24:mi'::character varying)) AND (lfde_fecha_creacion <= to_date('01/12/2005 23:59'::character varying, 'dd/mm/yyyy hh24:mi'::c (...)
  • Filter: ((lfde_estado)::text = ANY ('{A,I}'::text[]))
10. 0.000 0.016 ↓ 0.0 0 16

GroupAggregate (cost=5.04..5.07 rows=1 width=45) (actual time=0.001..0.001 rows=0 loops=16)

  • Group Key: agrupacion.lfde_rut_operador, agrupacion.lfde_tipo_documento
11. 0.003 0.016 ↓ 0.0 0 16

Sort (cost=5.04..5.05 rows=1 width=21) (actual time=0.001..0.001 rows=0 loops=16)

  • Sort Key: agrupacion.lfde_rut_operador, agrupacion.lfde_tipo_documento
  • Sort Method: quicksort Memory: 25kB
12. 0.001 0.013 ↓ 0.0 0 1

Subquery Scan on agrupacion (cost=4.99..5.03 rows=1 width=21) (actual time=0.013..0.013 rows=0 loops=1)

13. 0.000 0.012 ↓ 0.0 0 1

GroupAggregate (cost=4.99..5.02 rows=1 width=29) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: (to_date(((lotes_fact_det_electronica_1.lfde_fecha_creacion)::text)::character varying, 'dd-mm-yyyy'::character varying)), lotes_fact_det_electronica_1.lfde_rut_operador, lotes_fact_det_electronica_1.l (...)
14. 0.006 0.012 ↓ 0.0 0 1

Sort (cost=4.99..4.99 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: (to_date(((lotes_fact_det_electronica_1.lfde_fecha_creacion)::text)::character varying, 'dd-mm-yyyy'::character varying)), lotes_fact_det_electronica_1.lfde_rut_operador, lotes_fact_det_electronic (...)
  • Sort Method: quicksort Memory: 25kB
15. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_extra_lfde_fecha_creacion on lotes_fact_det_electronica lotes_fact_det_electronica_1 (cost=0.43..4.98 rows=1 width=21) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (lfde_fecha_creacion < to_date('30/12/2000'::character varying, 'dd/mm/yyyy'::character varying))
  • Filter: (lfde_fecha_creacion > (sysdate - 30))