explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IpC7

Settings
# exclusive inclusive rows x rows loops node
1. 270.861 309,399.872 ↑ 1.1 1,926 1

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

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

Hash Join (cost=100,248.75..123,367.28 rows=152,921 width=18) (actual time=71,603.147..309,129.011 rows=177,529 loops=1)

  • Hash Cond: (parcelas.t_cv_erp_id = erp.id)
3. 237,059.778 237,059.778 ↑ 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=45.975..237,059.778 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. 847.131 71,552.145 ↑ 1.0 673,109 1

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

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

  • Index Cond: ((origem)::text = 'CIELO'::text)
Planning time : 1,711.165 ms
Execution time : 309,402.892 ms