explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QkYe

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

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

3. 0.000 0.000 ↓ 0.0

Merge Join (cost=0..0 rows=0 width=0) (never executed)

4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=0..0 rows=0 width=0) (never executed)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0

Index Scan using documentofiscal_pkey on documentofiscal df (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((emissao >= '2020-01-01 00:00:00'::timestamp without time zone) AND (tipo = 1) AND (status = 0))
12. 0.000 0.000 ↓ 0.0

Index Scan using filial_pkey on filial fili (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkfilial = df.fkfilial)
  • Filter: (df.fkemitente = fkpessoa)
13. 0.000 0.000 ↓ 0.0

Index Scan using documentofiscalproduto_pkey on documentofiscalproduto dfp (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkdocumentofiscalproduto = df.fkdocumentofiscalproduto)
  • Filter: (tipoentradasaida = 8086)
14. 0.000 0.000 ↓ 0.0

Index Scan using pessoa_pkey on pessoa pessoadestinatario (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkpessoa = df.fkdestinatario)
15. 0.000 0.000 ↓ 0.0

Index Scan using planoconta_pkey on planoconta pcfiscaldestinatario (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkplanoconta = pessoadestinatario.fkplanocontafornecedor)
16. 0.000 0.000 ↓ 0.0

Seq Scan on documentofiscalitem dfi (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (status = 0)
17. 0.000 0.000 ↓ 0.0

Index Scan using documentofiscalitem_pkey on documentofiscalitem dfidev (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkdocumentofiscalitem = dfi.fkdocumentofiscalitemdevolvido)
  • Filter: (status = 0)
18. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: nf.fkdocumentofiscal
19. 0.000 0.000 ↓ 0.0

Seq Scan on notafiscal nf (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (situacao = 6294)
20. 0.000 0.000 ↓ 0.0

Index Scan using documentofiscal_pkey on documentofiscal dfdev (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkdocumentofiscal = dfidev.fkdocumentofiscal)
  • Filter: (status = 0)
21. 0.000 0.000 ↓ 0.0

Index Scan using planoconta_pkey on planoconta pcpara (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (pkplanoconta = (SubPlan 1))
22.          

SubPlan (for Index Scan)

23. 0.000 0.000 ↓ 0.0

Limit (cost=0..0 rows=0 width=0) (never executed)

24. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: pcdp.fkcentrocustoorigem
25. 0.000 0.000 ↓ 0.0

Seq Scan on planocontadepara pcdp (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((fkcentrocustoorigem IS NULL) OR (fkcentrocustoorigem = dfi.fkcentrocusto)) AND (status = 0) AND (fkplanocontaorigem = dfi.fkplanocontacontabil))