explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1EE

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

Update on docfiscalitem (cost=0.00..102568574.81 rows=443715 width=432) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Seq Scan on docfiscalitem (cost=0.00..102568574.81 rows=443715 width=432) (actual time=.. rows= loops=)

3.          

SubPlan (forSeq Scan)
4. 0.000 0.000 ↓ 0.0
→

Result (cost=114.89..230.98 rows=1 width=4) (actual time=.. rows= loops=)

  • One-Time Filter: ((docfiscalitem.flcategoria <> 2) AND (docfiscalitem.nrcfop >= 5000))
5. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=114.89..230.98 rows=1 width=4) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=114.89..230.69 rows=1 width=4) (actual time=.. rows= loops=)

  • Hash Cond: (prodempimposto.cdprodutoempresa = produtoempresa.cdprodutoempresa)
7. 0.000 0.000 ↓ 0.0
→

Seq Scan on prodempimposto (cost=0.00..95.94 rows=5294 width=8) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0
→

Hash (cost=114.88..114.88 rows=1 width=4) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Seq Scan on produtoempresa (cost=0.00..114.88 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: ((docfiscalitem.cdproduto = cdproduto) AND (docfiscalitem.cdempresa = cdempresa))
10. 0.000 0.000 ↓ 0.0
→

Index Scan using pkimposto on imposto (cost=0.00..0.27 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (cdimposto = prodempimposto.cdimpostoicms)