explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O0c

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 553,098.557 ↓ 0.0 0 1

HashAggregate (cost=104,634.14..104,723.51 rows=7,149 width=18) (actual time=553,098.557..553,098.557 rows=0 loops=1)

  • Group Key: date(parcelas.dt_pagto), erp.tp_servico, erp.cod_emp
2. 511.426 553,098.535 ↓ 0.0 0 1

Hash Join (cost=70,953.43..102,910.96 rows=229,758 width=18) (actual time=553,098.535..553,098.535 rows=0 loops=1)

  • Hash Cond: (parcelas.t_cv_erp_id = erp.id)
3. 160,088.398 160,088.398 ↑ 1.2 370,753 1

Index Scan using t_parc_erp_t_arq_ret_baixa_idx on t_parcelas_erp parcelas (cost=0.43..27,355.99 rows=461,331 width=12) (actual time=0.176..160,088.398 rows=370,753 loops=1)

  • Index Cond: (t_arq_retorno_id_baixa IS NULL)
  • Filter: ((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text)
  • Rows Removed by Filter: 178772
4. 864.203 392,498.711 ↓ 1.0 603,964 1

Hash (cost=63,417.98..63,417.98 rows=602,802 width=14) (actual time=392,498.711..392,498.711 rows=603,964 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 36503kB
5. 391,634.508 391,634.508 ↓ 1.0 603,964 1

Index Scan using t_cv_erp_origem_id1 on t_cv_erp erp (cost=0.43..63,417.98 rows=602,802 width=14) (actual time=0.042..391,634.508 rows=603,964 loops=1)

  • Index Cond: ((origem)::text = 'REDECARD'::text)
Planning time : 0.821 ms
Execution time : 553,098.908 ms