explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k69D

Settings
# exclusive inclusive rows x rows loops node
1. 239.533 1,071.692 ↓ 31.9 235,965 1

Nested Loop (cost=14,226.39..891,518.48 rows=7,408 width=236) (actual time=63.605..1,071.692 rows=235,965 loops=1)

  • Execution time: 1,092.371 ms(32 registros)
2. 95.728 596.194 ↓ 31.9 235,965 1

Hash Join (cost=14,226.10..889,263.99 rows=7,408 width=229) (actual time=63.584..596.194 rows=235,965 loops=1)

  • Hash Cond: (lancamento0_.banco_id = banco1_.id)
3. 104.979 500.426 ↓ 31.9 235,965 1

Hash Join (cost=14,223.17..889,240.65 rows=7,408 width=234) (actual time=63.535..500.426 rows=235,965 loops=1)

  • Hash Cond: (descricaol3_.categoria_lancamento_id = categorial4_.id)
4. 177.154 394.488 ↓ 31.0 239,921 1

Hash Join (cost=14,158.28..889,155.44 rows=7,743 width=219) (actual time=62.559..394.488 rows=239,921 loops=1)

  • Hash Cond: (lancamento0_.descricao_id = descricaol3_.id)
5. 163.333 187.574 ↑ 1.1 349,180 1

Bitmap Heap Scan on lancamento_new lancamento0_ (cost=7,058.88..881,066.21 rows=377,073 width=210) (actual time=32.776..187.574 rows=349,180 loops=1)

  • Recheck Cond: (empresa_id = 648)
  • Heap Blocks: exact=43,396
6. 24.241 24.241 ↑ 1.1 349,203 1

Bitmap Index Scan on lancamento_new_empresa_id (cost=0.00..6,964.61 rows=377,073 width=0) (actual time=24.241..24.241 rows=349,203 loops=1)

  • Index Cond: (empresa_id = 648)
7. 1.646 29.760 ↓ 1.0 6,724 1

Hash (cost=7,016.00..7,016.00 rows=6,672 width=17) (actual time=29.760..29.760 rows=6,724 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 392kB
8. 4.644 28.114 ↓ 1.0 6,724 1

Gather (cost=1,000.00..7,016.00 rows=6,672 width=17) (actual time=0.374..28.114 rows=6,724 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 23.470 23.470 ↑ 1.2 2,241 3 / 3

Parallel Seq Scan on descricao_lancamento_new descricaol3_ (cost=0.00..5,348.80 rows=2,780 width=17) (actual time=0.052..23.470 rows=2,241 loops=3)

  • Filter: (tratado OR (tratado IS NULL))
  • Rows Removed by Filter: 106,036
10. 0.432 0.959 ↓ 1.0 1,604 1

Hash (cost=44.97..44.97 rows=1,593 width=23) (actual time=0.959..0.959 rows=1,604 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 102kB
11. 0.527 0.527 ↓ 1.0 1,604 1

Seq Scan on categoria_lancamento_new categorial4_ (cost=0.00..44.97 rows=1,593 width=23) (actual time=0.007..0.527 rows=1,604 loops=1)

  • Filter: (concilia AND ((tipo_conciliacao = 2) OR (tipo_conciliacao = 0)))
  • Rows Removed by Filter: 70
12. 0.018 0.040 ↑ 1.0 86 1

Hash (cost=1.86..1.86 rows=86 width=11) (actual time=0.040..0.040 rows=86 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
13. 0.022 0.022 ↑ 1.0 86 1

Seq Scan on banco banco1_ (cost=0.00..1.86 rows=86 width=11) (actual time=0.006..0.022 rows=86 loops=1)

14. 235.965 235.965 ↑ 1.0 1 235,965

Index Scan using pk_conta on conta conta2_ (cost=0.29..0.30 rows=1 width=19) (actual time=0.001..0.001 rows=1 loops=235,965)

  • Index Cond: (id = lancamento0_.conta_id)
Planning time : 0.805 ms