explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uf0

Settings

Optimization(s) for this plan:

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

HashAggregate (cost=102.89..102.97 rows=8 width=439) (actual rows= loops=)

  • Group Key: item.itemid, item.itemname, item.uomname, item.manufacture, item.hsnnumber, itemgroup.itemgroupname, uomgroups.baseunit, item.groupid, item.quantity, item.purhcaseunit, item.salesunit, item.openingstock, item.purchaseprice, COALESCE((((sum(((( (...)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=85.36..102.45 rows=8 width=439) (actual rows= loops=)

  • Hash Cond: (uomgroups.uomgroupid = item.uomgroupid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on uomgroups (cost=0.00..15.10 rows=510 width=34) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=85.32..85.32 rows=3 width=409) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=65.69..85.32 rows=3 width=409) (actual rows= loops=)

  • Hash Cond: ((uomlist.id = item.salesmeasuringunitid) AND (uomlist.groupid = item.uomgroupid))
6. 0.000 0.000 ↓ 0.0

Seq Scan on uomlist (cost=0.00..15.50 rows=550 width=36) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=65.64..65.64 rows=3 width=377) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=53.41..65.64 rows=3 width=377) (actual rows= loops=)

  • Hash Cond: (itemgroup.id = item.itemgroupid)
9. 0.000 0.000 ↓ 0.0

Seq Scan on itemgroup (cost=0.00..11.60 rows=160 width=34) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=53.38..53.38 rows=3 width=347) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=52.20..53.38 rows=3 width=347) (actual rows= loops=)

  • Hash Cond: (purchase_details.itemid = item.itemid)
12. 0.000 0.000 ↓ 0.0

HashAggregate (cost=12.40..13.00 rows=40 width=76) (actual rows= loops=)

  • Group Key: purchase_details.itemid
13. 0.000 0.000 ↓ 0.0

Seq Scan on purchase_details (cost=0.00..11.50 rows=40 width=76) (actual rows= loops=)

  • Filter: (availableqty > 0::double precision)
14. 0.000 0.000 ↓ 0.0

Hash (cost=39.76..39.76 rows=3 width=339) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Subquery Scan on item (cost=39.67..39.76 rows=3 width=339) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

HashAggregate (cost=39.67..39.73 rows=3 width=435) (actual rows= loops=)

  • Group Key: item_1.itemid, item_1.itemgroupid, item_1.itemname, item_1.manufacture, item_1.hsnnumber, item_1.itemuniquename, item_1.purchasemeasuringunitid, item_1.uomgroupid, item_1.salesmeasuri (...)
17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20.76..39.50 rows=3 width=435) (actual rows= loops=)

  • Join Filter: (item_1.sellerid = seller.sellerid)
18. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20.76..38.35 rows=3 width=435) (actual rows= loops=)

  • Hash Cond: (uomlist_2.id = item_1.purchasemeasuringunitid)
19. 0.000 0.000 ↓ 0.0

Seq Scan on uomlist uomlist_2 (cost=0.00..15.50 rows=550 width=2) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=20.75..20.75 rows=1 width=435) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.11..20.75 rows=1 width=435) (actual rows= loops=)

  • Hash Cond: ((uomlist_1.id = item_1.purchasemeasuringunitid) AND (uomlist_1.groupid = item_1.uomgroupid))
22. 0.000 0.000 ↓ 0.0

Seq Scan on uomlist uomlist_1 (cost=0.00..15.50 rows=550 width=36) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=1.05..1.05 rows=4 width=401) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on item item_1 (cost=0.00..1.05 rows=4 width=401) (actual rows= loops=)

  • Filter: (itemid ~~* '%%'::text)
25. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.03 rows=2 width=64) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on seller (cost=0.00..1.02 rows=2 width=64) (actual rows= loops=)