explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vaIK

Settings

Optimization(s) for this plan:

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

Aggregate (cost=50,740.70..50,740.71 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2,001.63..50,740.70 rows=1 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2,001.63..50,728.94 rows=1 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2,001.63..49,713.88 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (f.documento_chave = d.doc_id)
5. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.63..39,884.43 rows=1 width=20) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.63..38,884.33 rows=1 width=20) (actual rows= loops=)

  • Hash Cond: (f.identificador_chave = i.ide_id)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fatos_comercial f (cost=0.00..38,882.68 rows=6 width=24) (actual rows= loops=)

  • Filter: ((produto_chave = 202) AND (filial_chave = 1) AND (operador = 2))
8. 0.000 0.000 ↓ 0.0

Hash (cost=1.60..1.60 rows=2 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on identificador i (cost=0.00..1.60 rows=2 width=4) (actual rows= loops=)

  • Filter: ((ide_descricao)::text = 'Vendas'::text)
10. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..9,828.67 rows=62 width=4) (actual rows= loops=)

  • Workers Planned: 2
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on documento d (cost=0.00..8,822.47 rows=26 width=4) (actual rows= loops=)

  • Filter: ((dt_emissao >= '2019-04-01 00:00:00'::timestamp without time zone) AND (dt_emissao <= '2019-04-30 00:00:00'::timestamp without time zone) AND ((identificador)::text = 'DOC_NOTA_VENDA'::text) AND (situacao = 6))
12. 0.000 0.000 ↓ 0.0

Seq Scan on produto p (cost=0.00..1,015.05 rows=1 width=4) (actual rows= loops=)

  • Filter: (produto_id = 202)
13. 0.000 0.000 ↓ 0.0

Seq Scan on filial l (cost=0.00..11.75 rows=1 width=4) (actual rows= loops=)