# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.199 | 2,557.932 | ↑ 693.4 | 119 | 1 |
→
Unique (cost=411,743.77..431,135.03 rows=82,516 width=2,756) (actual time=2,557.683..2,557.932 rows=119 loops=1) |
2. | 0.526 | 2,557.733 | ↑ 693.4 | 119 | 1 |
→
Sort (cost=411,743.77..411,950.06 rows=82,516 width=2,756) (actual time=2,557.682..2,557.733 rows=119 loops=1)
|
3. | 168.609 | 2,557.207 | ↑ 693.4 | 119 | 1 |
→
GroupAggregate (cost=205,197.42..208,704.35 rows=82,516 width=2,756) (actual time=2,136.330..2,557.207 rows=119 loops=1)
|
4. | 2,056.138 | 2,388.598 | ↓ 3.7 | 302,604 | 1 |
→
Sort (cost=205,197.42..205,403.71 rows=82,516 width=2,748) (actual time=2,118.825..2,388.598 rows=302,604 loops=1)
|
5. | 309.639 | 332.460 | ↓ 3.7 | 302,604 | 1 |
→
Hash Right Join (cost=1,068.66..2,725.00 rows=82,516 width=2,748) (actual time=16.696..332.460 rows=302,604 loops=1)
|
6. | 6.168 | 6.168 | ↓ 1.0 | 25,389 | 1 |
→
Seq Scan on core_flow (cost=0.00..610.14 rows=25,214 width=8) (actual time=0.018..6.168 rows=25,389 loops=1) |
7. | 4.646 | 16.653 | ↓ 1.2 | 1,122 | 1 |
→
Hash (cost=1,056.87..1,056.87 rows=943 width=2,744) (actual time=16.653..16.653 rows=1,122 loops=1)
|
8. | 2.680 | 12.007 | ↓ 1.2 | 1,122 | 1 |
→
Hash Right Join (cost=1,020.63..1,056.87 rows=943 width=2,744) (actual time=9.071..12.007 rows=1,122 loops=1)
|
9. | 0.291 | 0.291 | ↑ 1.0 | 1,316 | 1 |
→
Seq Scan on core_channel_wm (cost=0.00..21.68 rows=1,368 width=8) (actual time=0.013..0.291 rows=1,316 loops=1) |
10. | 3.293 | 9.036 | ↓ 1.3 | 758 | 1 |
→
Hash (cost=1,013.33..1,013.33 rows=584 width=2,744) (actual time=9.036..9.036 rows=758 loops=1)
|
11. | 1.848 | 5.743 | ↓ 1.3 | 758 | 1 |
→
Hash Right Join (cost=989.05..1,013.33 rows=584 width=2,744) (actual time=3.743..5.743 rows=758 loops=1)
|
12. | 0.192 | 0.192 | ↓ 1.0 | 840 | 1 |
→
Seq Scan on core_channel (cost=0.00..15.32 rows=832 width=8) (actual time=0.016..0.192 rows=840 loops=1) |
13. | 1.134 | 3.703 | ↓ 1.1 | 213 | 1 |
→
Hash (cost=986.53..986.53 rows=202 width=2,740) (actual time=3.703..3.703 rows=213 loops=1)
|
14. | 0.157 | 2.569 | ↓ 1.1 | 213 | 1 |
→
Nested Loop (cost=5.31..986.53 rows=202 width=2,740) (actual time=0.213..2.569 rows=213 loops=1) |
15. | 0.200 | 1.347 | ↓ 1.1 | 213 | 1 |
→
Hash Left Join (cost=5.03..111.91 rows=202 width=2,273) (actual time=0.200..1.347 rows=213 loops=1)
|
16. | 0.213 | 1.079 | ↓ 1.1 | 213 | 1 |
→
Hash Left Join (cost=2.79..107.45 rows=202 width=1,733) (actual time=0.111..1.079 rows=213 loops=1)
|
17. | 0.808 | 0.808 | ↓ 1.1 | 213 | 1 |
→
Seq Scan on core_offer (cost=0.00..102.04 rows=202 width=1,626) (actual time=0.030..0.808 rows=213 loops=1)
|
18. | 0.030 | 0.058 | ↑ 1.0 | 35 | 1 |
→
Hash (cost=2.35..2.35 rows=35 width=107) (actual time=0.058..0.058 rows=35 loops=1)
|
19. | 0.028 | 0.028 | ↑ 1.0 | 35 | 1 |
→
Seq Scan on core_currency (cost=0.00..2.35 rows=35 width=107) (actual time=0.010..0.028 rows=35 loops=1) |
20. | 0.045 | 0.068 | ↓ 1.4 | 78 | 1 |
→
Hash (cost=1.55..1.55 rows=55 width=540) (actual time=0.068..0.068 rows=78 loops=1)
|
21. | 0.023 | 0.023 | ↓ 1.4 | 78 | 1 |
→
Seq Scan on core_publisher (cost=0.00..1.55 rows=55 width=540) (actual time=0.006..0.023 rows=78 loops=1) |
22. | 1.065 | 1.065 | ↑ 1.0 | 1 | 213 |
→
Index Scan using core_user_pkey on core_user t9 (cost=0.28..4.32 rows=1 width=467) (actual time=0.004..0.005 rows=1 loops=213)
|