# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 2,477.789 | ↑ 1.3 | 76 | 1 |
→
Limit (cost=4,939.32..7,583.93 rows=100 width=386) (actual time=268.377..2,477.789 rows=76 loops=1) |
2. |
Initplan (forLimit) |
|||||
3. | 0.035 | 0.175 | ↑ 1,478,142.0 | 1 | 1 |
→
Nested Loop Anti Join (cost=0.28..942,815.73 rows=1,478,142 width=0) (actual time=0.175..0.175 rows=1 loops=1) |
4. | 0.023 | 0.023 | ↑ 75,802.1 | 39 | 1 |
→
Seq Scan on deal_row (cost=0.00..76,837.83 rows=2,956,283 width=32) (actual time=0.020..0.023 rows=39 loops=1) |
5. | 0.117 | 0.117 | ↑ 1.0 | 1 | 39 |
→
Index Only Scan using product_article_code_pk on product_article (cost=0.28..0.29 rows=1 width=9) (actual time=0.003..0.003 rows=1 loops=39)
|
6. | 24.247 | 79.279 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=4,933.50..4,933.51 rows=1 width=32) (actual time=79.279..79.279 rows=1 loops=1) |
7. | 55.032 | 55.032 | ↑ 1.1 | 173,574 | 1 |
→
Seq Scan on deal_customer deal_customer_1 (cost=0.00..4,439.98 rows=197,406 width=4) (actual time=0.013..55.032 rows=173,574 loops=1)
|
8. | 0.353 | 2,477.747 | ↑ 1,048.6 | 76 | 1 |
→
Nested Loop Left Join (cost=4.90..2,107,631.30 rows=79,695 width=386) (actual time=268.376..2,477.747 rows=76 loops=1) |
9. | 0.118 | 2,477.242 | ↑ 1,048.6 | 76 | 1 |
→
Nested Loop Left Join (cost=4.46..1,763,366.23 rows=79,695 width=381) (actual time=268.196..2,477.242 rows=76 loops=1) |
10. | 0.361 | 2,476.896 | ↑ 1,048.6 | 76 | 1 |
→
Nested Loop Left Join (cost=4.03..1,197,436.44 rows=79,695 width=377) (actual time=268.193..2,476.896 rows=76 loops=1) |
11. | 0.417 | 2,475.699 | ↑ 1,048.6 | 76 | 1 |
→
Nested Loop Left Join (cost=3.60..631,506.65 rows=79,695 width=373) (actual time=268.175..2,475.699 rows=76 loops=1) |
12. | 0.169 | 1,578.558 | ↑ 209.7 | 76 | 1 |
→
Nested Loop Left Join (cost=2.15..410,750.06 rows=15,939 width=273) (actual time=0.236..1,578.558 rows=76 loops=1) |
13. | 0.151 | 1,578.237 | ↑ 209.7 | 76 | 1 |
→
Nested Loop Left Join (cost=1.72..297,564.10 rows=15,939 width=269) (actual time=0.233..1,578.237 rows=76 loops=1) |
14. | 0.159 | 1,577.858 | ↑ 209.7 | 76 | 1 |
→
Nested Loop Left Join (cost=1.29..228,711.09 rows=15,939 width=265) (actual time=0.229..1,577.858 rows=76 loops=1) |
15. | 0.138 | 1,575.799 | ↑ 209.7 | 76 | 1 |
→
Nested Loop Left Join (cost=0.85..159,858.07 rows=15,939 width=261) (actual time=0.195..1,575.799 rows=76 loops=1)
|
16. | 86.025 | 1,575.585 | ↑ 209.7 | 76 | 1 |
→
Nested Loop (cost=0.85..159,617.70 rows=15,939 width=257) (actual time=0.177..1,575.585 rows=76 loops=1) |
17. | 1,012.484 | 1,012.484 | ↓ 7.4 | 119,269 | 1 |
→
Index Scan Backward using deal_pkey on deal (cost=0.43..99,796.70 rows=16,100 width=96) (actual time=0.077..1,012.484 rows=119,269 loops=1)
|
18. | 477.076 | 477.076 | ↓ 0.0 | 0 | 119,269 |
→
Index Scan using deal_state_pkey on deal_state (cost=0.43..3.72 rows=1 width=165) (actual time=0.004..0.004 rows=0 loops=119,269)
|
19. | 0.061 | 0.076 | ↑ 1.0 | 1 | 76 |
→
Materialize (cost=0.00..1.29 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=76) |
20. | 0.015 | 0.015 | ↑ 1.0 | 1 | 1 |
→
Seq Scan on unhandled_deals (cost=0.00..1.29 rows=1 width=4) (actual time=0.014..0.015 rows=1 loops=1)
|
21. | 1.900 | 1.900 | ↑ 2.0 | 1 | 76 |
→
Index Scan using deal_actions_deal_id_action_uindex on deal_actions action_offer_sent_table (cost=0.43..8.21 rows=2 width=8) (actual time=0.025..0.025 rows=1 loops=76)
|
22. | 0.228 | 0.228 | ↓ 0.0 | 0 | 76 |
→
Index Scan using deal_actions_deal_id_action_uindex on deal_actions action_paid_table (cost=0.43..8.21 rows=2 width=8) (actual time=0.003..0.003 rows=0 loops=76)
|
23. | 0.152 | 0.152 | ↓ 0.0 | 0 | 76 |
→
Index Scan using deal_actions_deal_id_action_uindex on deal_actions action_buy_sent_table (cost=0.43..7.10 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=76)
|
24. | 353.931 | 896.724 | ↑ 5.0 | 1 | 76 |
→
Hash Right Join (cost=1.45..15.25 rows=5 width=104) (actual time=10.067..11.799 rows=1 loops=76)
|
25. | 541.425 | 541.425 | ↓ 43.1 | 43,091 | 75 |
→
Function Scan on list_customer_by_id (cost=0.25..10.25 rows=1,000 width=68) (actual time=3.468..7.219 rows=43,091 loops=75) |
26. | 0.228 | 1.368 | ↑ 1.0 | 1 | 76 |
→
Hash (cost=1.18..1.18 rows=1 width=40) (actual time=0.018..0.018 rows=1 loops=76)
|
27. | 1.140 | 1.140 | ↑ 1.0 | 1 | 76 |
→
Index Scan using deal_customer_deal_id_ndx on deal_customer (cost=0.42..1.18 rows=1 width=40) (actual time=0.015..0.015 rows=1 loops=76)
|
28. | 0.836 | 0.836 | ↓ 0.0 | 0 | 76 |
→
Index Scan using deal_actions_deal_id_action_uindex on deal_actions action_buy_received_table (cost=0.43..7.10 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=76)
|
29. | 0.228 | 0.228 | ↓ 0.0 | 0 | 76 |
→
Index Scan using deal_actions_deal_id_action_uindex on deal_actions action_sell_sent_table (cost=0.43..7.10 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=76)
|
30. | 0.152 | 0.152 | ↓ 0.0 | 0 | 76 |
→
Index Scan using deal_actions_deal_id_action_uindex on deal_actions action_sell_received_table (cost=0.43..8.21 rows=2 width=8) (actual time=0.002..0.002 rows=0 loops=76)
|