explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2tnj

Settings
# exclusive inclusive rows x rows loops node
1. 251.861 272,783.256 ↑ 1.1 1,926 1

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

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

Hash Join (cost=100,248.75..123,367.28 rows=152,921 width=18) (actual time=143,182.718..272,531.395 rows=177,529 loops=1)

  • Hash Cond: (parcelas.t_cv_erp_id = erp.id)
3. 128,953.532 128,953.532 ↑ 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=87.005..128,953.532 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. 849.392 143,091.016 ↑ 1.0 673,109 1

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

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

  • Index Cond: ((origem)::text = 'CIELO'::text)