# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.006 | 1.978 | ↑ 1.0 | 30 | 1 |
→
Limit (cost=1,432.18..1,432.25 rows=30 width=92) (actual time=1.971..1.978 rows=30 loops=1)
|
2. | 0.031 | 1.972 | ↑ 5.1 | 30 | 1 |
→
Sort (cost=1,432.18..1,432.56 rows=152 width=92) (actual time=1.971..1.972 rows=30 loops=1)
|
3. | 0.022 | 1.941 | ↑ 2.5 | 60 | 1 |
→
GroupAggregate (cost=1,423.13..1,427.69 rows=152 width=92) (actual time=1.919..1.941 rows=60 loops=1)
|
4. | 0.033 | 1.919 | ↑ 2.5 | 60 | 1 |
→
Sort (cost=1,423.13..1,423.51 rows=152 width=84) (actual time=1.916..1.919 rows=60 loops=1)
|
5. | 0.032 | 1.886 | ↑ 2.5 | 60 | 1 |
→
Hash Join (cost=1,275.30..1,417.62 rows=152 width=84) (actual time=1.174..1.886 rows=60 loops=1)
|
6. | 0.042 | 1.841 | ↓ 1.1 | 174 | 1 |
→
Hash Join (cost=1,273.74..1,415.63 rows=152 width=75) (actual time=1.132..1.841 rows=174 loops=1)
|
7. | 0.160 | 1.794 | ↓ 1.1 | 174 | 1 |
→
Nested Loop (cost=1,272.60..1,413.82 rows=152 width=66) (actual time=1.121..1.794 rows=174 loops=1)
|
8. | 0.205 | 1.460 | ↑ 1.3 | 174 | 1 |
→
Hash Join (cost=1,272.32..1,318.64 rows=219 width=62) (actual time=1.110..1.460 rows=174 loops=1)
|
9. | 0.160 | 0.160 | ↑ 1.0 | 2,058 | 1 |
→
Seq Scan on public.product_category (cost=0.00..36.18 rows=2,118 width=8) (actual time=0.004..0.160 rows=2,058 loops=1)
|
10. | 0.041 | 1.095 | ↑ 1.3 | 174 | 1 |
→
Hash (cost=1,269.59..1,269.59 rows=219 width=54) (actual time=1.095..1.095 rows=174 loops=1)
|
11. | 0.048 | 1.054 | ↑ 1.3 | 174 | 1 |
→
Hash Join (cost=74.26..1,269.59 rows=219 width=54) (actual time=0.547..1.054 rows=174 loops=1)
|
12. | 0.503 | 0.576 | ↑ 1.3 | 174 | 1 |
→
Bitmap Heap Scan on public.inventory_item (cost=26.00..1,220.75 rows=219 width=12) (actual time=0.111..0.576 rows=174 loops=1)
|
13. | 0.073 | 0.073 | ↓ 1.1 | 811 | 1 |
→
Bitmap Index Scan on poc_product_variant (cost=0.00..25.95 rows=737 width=0) (actual time=0.073..0.073 rows=811 loops=1)
|
14. | 0.220 | 0.430 | ↓ 1.0 | 1,176 | 1 |
→
Hash (cost=33.67..33.67 rows=1,167 width=42) (actual time=0.430..0.430 rows=1,176 loops=1)
|
15. | 0.210 | 0.210 | ↓ 1.0 | 1,176 | 1 |
→
Seq Scan on public.product_variant (cost=0.00..33.67 rows=1,167 width=42) (actual time=0.004..0.210 rows=1,176 loops=1)
|
16. | 0.174 | 0.174 | ↑ 1.0 | 1 | 174 |
→
Index Scan using product_pkey on public.product (cost=0.28..0.42 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=174)
|
17. | 0.003 | 0.005 | ↑ 1.0 | 6 | 1 |
→
Hash (cost=1.06..1.06 rows=6 width=13) (actual time=0.005..0.005 rows=6 loops=1)
|
18. | 0.002 | 0.002 | ↑ 1.0 | 6 | 1 |
→
Seq Scan on public.category (cost=0.00..1.06 rows=6 width=13) (actual time=0.001..0.002 rows=6 loops=1)
|
19. | 0.007 | 0.013 | ↑ 1.0 | 25 | 1 |
→
Hash (cost=1.25..1.25 rows=25 width=13) (actual time=0.013..0.013 rows=25 loops=1)
|
20. | 0.006 | 0.006 | ↑ 1.0 | 25 | 1 |
→
Seq Scan on public.brand (cost=0.00..1.25 rows=25 width=13) (actual time=0.004..0.006 rows=25 loops=1)
|
Planning time | : | 2.150 ms |
---|---|---|
Execution time | : | 2.101 ms |