explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RVe

Settings
# exclusive inclusive rows x rows loops node
1. 259.030 218,021.213 ↑ 1.1 1,926 1

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

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

Hash Join (cost=100,248.75..123,367.28 rows=152,921 width=18) (actual time=53,600.967..217,762.183 rows=177,529 loops=1)

  • Hash Cond: (parcelas.t_cv_erp_id = erp.id)
3. 163,864.627 163,864.627 ↑ 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=198.480..163,864.627 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. 782.283 53,397.844 ↑ 1.0 673,109 1

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 39744kB
5. 52,615.561 52,615.561 ↑ 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=21.349..52,615.561 rows=673,109 loops=1)

  • Index Cond: ((origem)::text = 'CIELO'::text)
Planning time : 607.270 ms
Execution time : 218,024.143 ms