explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tnQl

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

GroupAggregate (cost=182,846.26..182,846.28 rows=1 width=24) (actual rows= loops=)

  • Group Key: dfi.fkproduto, dfi.fkmodificadorvalor
2. 0.000 0.000 ↓ 0.0

Sort (cost=182,846.26..182,846.26 rows=1 width=24) (actual rows= loops=)

  • Sort Key: dfi.fkproduto, dfi.fkmodificadorvalor
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,054.40..182,846.25 rows=1 width=24) (actual rows= loops=)

  • Join Filter: (df.pkdocumentofiscal = op.fkdocumentofiscal)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,054.40..176,773.21 rows=1 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,053.98..176,772.70 rows=1 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Gather (cost=1,053.55..176,771.87 rows=1 width=32) (actual rows= loops=)

  • Workers Planned: 2
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=53.55..175,771.77 rows=1 width=32) (actual rows= loops=)

  • Hash Cond: (dfi.pkdocumentofiscalitem = ofdfi.fkdocumentofiscalitem)
  • Filter: (ofdfi.pkordemfabricacaodocumentofiscalitem IS NULL)
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on documentofiscalitem dfi (cost=0.00..157,357.22 rows=667,456 width=40) (actual rows= loops=)

  • Filter: ((datafaturamento IS NULL) AND (status = 0))
9. 0.000 0.000 ↓ 0.0

Hash (cost=35.04..35.04 rows=1,481 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on ordemfabricacaodocumentofiscalitem ofdfi (cost=0.00..35.04 rows=1,481 width=16) (actual rows= loops=)

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

Index Scan using documentofiscalitem_pkey on documentofiscalitem dfipai (cost=0.43..0.83 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (pkdocumentofiscalitem = dfi.fkdocumentofiscalitemgrade)
  • Filter: ((datafaturamento IS NULL) AND (status = 0))
12. 0.000 0.000 ↓ 0.0

Index Scan using documentofiscal_pkey on documentofiscal df (cost=0.42..0.51 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (pkdocumentofiscal = dfipai.fkdocumentofiscal)
  • Filter: ((datafechamento IS NULL) AND (status = 0) AND (tipo = 2))
13. 0.000 0.000 ↓ 0.0

Seq Scan on ordempedido op (cost=0.00..3,772.46 rows=184,046 width=8) (actual rows= loops=)

  • Filter: (datatermino IS NULL)