explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tV57

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

GroupAggregate (cost=8,434.06..8,875.45 rows=14,713 width=98) (actual rows= loops=)

  • Group Key: mst_item.mitm_code, mst_item.mitm_name, mst_lpn.mslp_price
2. 0.000 0.000 ↓ 0.0

Sort (cost=8,434.06..8,470.84 rows=14,713 width=74) (actual rows= loops=)

  • Sort Key: mst_item.mitm_code, mst_item.mitm_name, mst_lpn.mslp_price
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=6,715.99..7,415.56 rows=14,713 width=74) (actual rows= loops=)

  • Hash Cond: (mst_item_1.mitm_id = mst_item.mitm_id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,135.04..6,644.62 rows=11,429 width=8) (actual rows= loops=)

  • Hash Cond: (stock_movement.stmv_wo = trwo_hdr.trwo_id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,962.43..4,320.06 rows=7,529 width=8) (actual rows= loops=)

  • Hash Cond: (mst_lpn_1.mslp_mitm_id = mst_item_1.mitm_id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,798.89..4,053.00 rows=7,529 width=8) (actual rows= loops=)

  • Hash Cond: ((stock_movement.stmv_lpn)::text = (mst_lpn_1.mslp_no)::text)
7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,420.07..3,495.36 rows=7,529 width=23) (actual rows= loops=)

  • Group Key: stock_movement.stmv_lpn, stock_movement.stmv_wo, stock_movement.stmv_mitm_id
8. 0.000 0.000 ↓ 0.0

Seq Scan on stock_movement (cost=0.00..2,968.29 rows=60,238 width=23) (actual rows= loops=)

  • Filter: ((stmv_status = 2) AND ((stmv_job_type)::text = '5'::text))
9. 0.000 0.000 ↓ 0.0

Hash (cost=305.03..305.03 rows=5,903 width=20) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on mst_lpn mst_lpn_1 (cost=0.00..305.03 rows=5,903 width=20) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=127.13..127.13 rows=2,913 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on mst_item mst_item_1 (cost=0.00..127.13 rows=2,913 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=2,010.85..2,010.85 rows=12,940 width=12) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,034.54..2,010.85 rows=12,940 width=12) (actual rows= loops=)

  • Hash Cond: (trwo_dtl.tdwo_trwo_id = trwo_hdr.trwo_id)
15. 0.000 0.000 ↓ 0.0

Seq Scan on trwo_dtl (cost=0.00..738.39 rows=28,939 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=986.91..986.91 rows=3,811 width=4) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=554.08..986.91 rows=3,811 width=4) (actual rows= loops=)

  • Hash Cond: ((mst_to_id.msto_packing_list)::text = (trs_shipment_dtl.trsd_packing_list_no)::text)
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=211.40..575.53 rows=4,894 width=16) (actual rows= loops=)

  • Hash Cond: ((trwo_hdr.trwo_to_id)::text = (mst_to_id.msto_to_id)::text)
19. 0.000 0.000 ↓ 0.0

Seq Scan on trwo_hdr (cost=0.00..283.23 rows=8,523 width=17) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=150.62..150.62 rows=4,862 width=26) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on mst_to_id (cost=0.00..150.62 rows=4,862 width=26) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=299.52..299.52 rows=3,453 width=14) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash Join (cost=156.55..299.52 rows=3,453 width=14) (actual rows= loops=)

  • Hash Cond: (trs_shipment_dtl.trsd_trsh_id = trs_shipment_hdr.trsh_id)
24. 0.000 0.000 ↓ 0.0

Seq Scan on trs_shipment_dtl (cost=0.00..94.41 rows=3,741 width=18) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash (cost=125.09..125.09 rows=2,517 width=4) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on trs_shipment_hdr (cost=0.00..125.09 rows=2,517 width=4) (actual rows= loops=)

  • Filter: ((trsh_status)::text = '3'::text)
27. 0.000 0.000 ↓ 0.0

Hash (cost=534.08..534.08 rows=3,750 width=74) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash Join (cost=171.61..534.08 rows=3,750 width=74) (actual rows= loops=)

  • Hash Cond: (mst_lpn.mslp_mscl_id = mst_client.mscl_id)
29. 0.000 0.000 ↓ 0.0

Hash Join (cost=163.54..483.74 rows=30 width=78) (actual rows= loops=)

  • Hash Cond: (mst_lpn.mslp_mitm_id = mst_item.mitm_id)
30. 0.000 0.000 ↓ 0.0

Seq Scan on mst_lpn (cost=0.00..319.79 rows=30 width=34) (actual rows= loops=)

  • Filter: (mslp_trhd_id = mslp_trhd_id)
31. 0.000 0.000 ↓ 0.0

Hash (cost=127.13..127.13 rows=2,913 width=48) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on mst_item (cost=0.00..127.13 rows=2,913 width=48) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=6.51..6.51 rows=125 width=4) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..6.51 rows=125 width=4) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on mst_client (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on trs_rcv_hdr (cost=0.00..4.25 rows=125 width=0) (actual rows= loops=)