# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.056 | 0.144 | ↑ 1.0 | 1 | 1 |
→
GroupAggregate (cost=14.26..14.31 rows=1 width=21) (actual time=0.142..0.144 rows=1 loops=1)
|
2. | 0.022 | 0.088 | ↓ 3.0 | 3 | 1 |
→
Sort (cost=14.26..14.27 rows=1 width=59) (actual time=0.085..0.088 rows=3 loops=1)
|
3. | 0.007 | 0.066 | ↓ 3.0 | 3 | 1 |
→
Nested Loop Left Join (cost=2.27..14.25 rows=1 width=59) (actual time=0.045..0.066 rows=3 loops=1)
|
4. | 0.007 | 0.050 | ↓ 3.0 | 3 | 1 |
→
Nested Loop Left Join (cost=1.83..11.59 rows=1 width=55) (actual time=0.035..0.050 rows=3 loops=1) |
5. | 0.004 | 0.034 | ↓ 3.0 | 3 | 1 |
→
Nested Loop Left Join (cost=1.41..8.94 rows=1 width=47) (actual time=0.029..0.034 rows=3 loops=1) |
6. | 0.001 | 0.020 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=1.12..5.57 rows=1 width=12) (actual time=0.019..0.020 rows=1 loops=1) |
7. | 0.012 | 0.012 | ↑ 1.0 | 1 | 1 |
→
Index Scan using orders_pkey on orders ord (cost=0.56..2.78 rows=1 width=8) (actual time=0.010..0.012 rows=1 loops=1)
|
8. | 0.007 | 0.007 | ↑ 1.0 | 1 | 1 |
→
Index Scan using orders_pkey on orders cio (cost=0.56..2.78 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)
|
9. | 0.010 | 0.010 | ↓ 1.5 | 3 | 1 |
→
Index Scan using delivery_conditions_conditionable_id_index on delivery_conditions dcn (cost=0.29..3.35 rows=2 width=43) (actual time=0.007..0.010 rows=3 loops=1)
|
10. | 0.009 | 0.009 | ↑ 1.0 | 1 | 3 |
→
Index Scan using storekeepers_pkey on storekeepers skp (cost=0.42..2.64 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3)
|
11. | 0.009 | 0.009 | ↑ 1.0 | 1 | 3 |
→
Index Only Scan using order_partner_order_id_unique on order_partner op (cost=0.43..2.65 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=3)
|