# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
HashAggregate (cost=83.83..83.86 rows=3 width=439) (actual rows= loops=)
|
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Right Join (cost=64.03..83.66 rows=3 width=439) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on uomlist uomlist_1 (cost=0.00..15.50 rows=550 width=36) (actual rows= loops=) |
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=63.98..63.98 rows=3 width=409) (actual rows= loops=) |
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Right Join (cost=46.94..63.98 rows=3 width=409) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on uomgroups (cost=0.00..15.10 rows=510 width=34) (actual rows= loops=) |
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=46.92..46.92 rows=1 width=377) (actual rows= loops=) |
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=25.79..46.92 rows=1 width=377) (actual rows= loops=)
|
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=13.39..33.02 rows=1 width=369) (actual rows= loops=)
|
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on uomlist (cost=0.00..15.50 rows=550 width=36) (actual rows= loops=) |
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=13.33..13.33 rows=4 width=335) (actual rows= loops=) |
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Right Join (cost=1.09..13.33 rows=4 width=335) (actual rows= loops=)
|
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on itemgroup (cost=0.00..11.60 rows=160 width=34) (actual rows= loops=) |
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=1.04..1.04 rows=4 width=337) (actual rows= loops=) |
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on item (cost=0.00..1.04 rows=4 width=337) (actual rows= loops=) |
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
HashAggregate (cost=12.40..13.00 rows=40 width=76) (actual rows= loops=)
|
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on purchase_details (cost=0.00..11.50 rows=40 width=76) (actual rows= loops=)
|