explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YpB

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on docfiscalitem (cost=0.00..95094259.65 rows=411356 width=432) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

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

  • Filter: ((flcategoria <> 2) AND (nrcfop >= 5000))
3.          

SubPlan (forSeq Scan)

4. 0.000 0.000 ↓ 0.0

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

5. 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)
6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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

8. 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 (cdempresa = docfiscalitem.cdempresa))
9. 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)