explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qPwI

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

Sort (cost=42.61..42.78 rows=71 width=13) (actual rows= loops=)

  • Sort Key: tb_material.material_type, tb_material.material_name
2. 0.000 0.000 ↓ 0.0

Seq Scan on tb_material (cost=36.65..40.42 rows=71 width=13) (actual rows= loops=)

  • Filter: (NOT (hashed SubPlan 1))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=35.14..36.35 rows=121 width=6) (actual rows= loops=)

  • Group Key: tb_lot.lot_material_code
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.62..34.73 rows=161 width=6) (actual rows= loops=)

  • Hash Cond: (tb_lot.lot_number = tb_transaction.trans_lot_number)
6. 0.000 0.000 ↓ 0.0

Seq Scan on tb_lot (cost=0.00..20.00 rows=1,000 width=17) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=161 width=11) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on tb_transaction (cost=0.00..3.61 rows=161 width=11) (actual rows= loops=)