explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4xWy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Resultaverick Comercio E Industria de Confeccoes Ltda 06/02/2020 09:40:18 pag 1Execution Plan Analysis joaofilho/HANDARA2012Operation Operation Hash Left Join (cost=20,216.37..2,906,237.20 rows=32,820,812 width=37) (actual rows= loops=)

  • Hash Cond: (m.deposito = em.chave)
2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=3,816.66..2,289,935.31 rows=32,820,812 width=33) (actual rows= loops=)

  • Hash Cond: ((m.chave)::numeric = "ANY_subquery".chave)
3. 0.000 0.000 ↓ 0.0

Seq Scan on movdepos m (cost=0.00..1,703,549.24 rows=65,641,624 width=37) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=3,815.67..3,815.67 rows=79 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=3,812.12..3,815.67 rows=79 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,812.12..3,814.88 rows=79 width=32) (actual rows= loops=)

  • Group Key: mm.recurso, mm.etapa, mm.lote, emm.locescritu
7. 0.000 0.000 ↓ 0.0

Sort (cost=3,812.12..3,812.31 rows=79 width=46) (actual rows= loops=)

  • Sort Key: mm.etapa, mm.lote, emm.locescritu
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.98..3,809.63 rows=79 width=46) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using movdepos000000034f on movdepos mm (cost=0.56..3,159.06 rows=79 width=46) (actual rows= loops=)

  • Index Cond: ((recurso = 624,499,867) AND (movimentac <= '2020-01-31'::date))
  • Filter: (((quantidade > 0.000001) OR (quantidade < '-0.000001'::numeric)) AND ((custo > 0.000001) OR (custo < '-0.000001'::numeric)))
10. 0.000 0.000 ↓ 0.0

Index Scan using entidade00000000d6 on entidade emm (cost=0.42..8.23 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (chave = mm.deposito)
11. 0.000 0.000 ↓ 0.0

Hash (cost=12,537.65..12,537.65 rows=235,365 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on entidade em (cost=0.00..12,537.65 rows=235,365 width=8) (actual rows= loops=)