explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6hst

Settings
# exclusive inclusive rows x rows loops node
1. 210.166 2,471.213 ↑ 1.1 1,926 1

HashAggregate (cost=124,514.19..124,539.68 rows=2,039 width=18) (actual time=2,469.603..2,471.213 rows=1,926 loops=1)

  • Group Key: date(parcelas.dt_pagto), erp.tp_servico, erp.cod_emp
2. 400.493 2,261.047 ↓ 1.2 177,529 1

Hash Join (cost=100,248.75..123,367.28 rows=152,921 width=18) (actual time=1,548.122..2,261.047 rows=177,529 loops=1)

  • Hash Cond: (parcelas.t_cv_erp_id = erp.id)
3. 317.518 317.518 ↑ 1.8 189,664 1

Index Scan using t_parc_erp_t_arq_ret_baixa_idx on t_parcelas_erp parcelas (cost=0.43..19,956.13 rows=333,685 width=12) (actual time=0.018..317.518 rows=189,664 loops=1)

  • Index Cond: (t_arq_retorno_id_baixa IS NULL)
  • Filter: ((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text)
  • Rows Removed by Filter: 235977
4. 707.454 1,543.036 ↑ 1.0 673,109 1

Hash (cost=91,824.26..91,824.26 rows=673,925 width=14) (actual time=1,543.036..1,543.036 rows=673,109 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 39744kB
5. 835.582 835.582 ↑ 1.0 673,109 1

Index Scan using t_cv_erp_origem_id1 on t_cv_erp erp (cost=0.43..91,824.26 rows=673,925 width=14) (actual time=0.034..835.582 rows=673,109 loops=1)

  • Index Cond: ((origem)::text = 'CIELO'::text)
Planning time : 0.530 ms
Execution time : 2,472.864 ms