explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0I0k

Settings
# exclusive inclusive rows x rows loops node
1. 0.275 0.935 ↑ 1.2 61 1

Sort (cost=42.61..42.78 rows=71 width=13) (actual time=0.932..0.935 rows=61 loops=1)

  • Sort Key: tb_material.material_type, tb_material.material_name
  • Sort Method: quicksort Memory: 28kB
2. 0.120 0.660 ↑ 1.2 61 1

Seq Scan on tb_material (cost=36.65..40.42 rows=71 width=13) (actual time=0.590..0.660 rows=61 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 81
3.          

SubPlan (for Seq Scan)

4. 0.080 0.540 ↑ 1.5 81 1

HashAggregate (cost=35.14..36.35 rows=121 width=6) (actual time=0.527..0.540 rows=81 loops=1)

  • Group Key: tb_lot.lot_material_code
5. 0.240 0.460 ↑ 1.0 161 1

Hash Join (cost=5.62..34.73 rows=161 width=6) (actual time=0.102..0.460 rows=161 loops=1)

  • Hash Cond: (tb_lot.lot_number = tb_transaction.trans_lot_number)
6. 0.143 0.143 ↑ 1.0 1,000 1

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

7. 0.039 0.077 ↑ 1.0 161 1

Hash (cost=3.61..3.61 rows=161 width=11) (actual time=0.076..0.077 rows=161 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
8. 0.038 0.038 ↑ 1.0 161 1

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