# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 833.329 | 12,650.149 | ↑ 1.0 | 6,177,269 | 1 |
→
Result (cost=0.00..999,288.91 rows=6,178,722 width=52) (actual time=0.484..12,650.149 rows=6,177,269 loops=1) |
2. | 579.622 | 11,816.820 | ↑ 1.0 | 6,177,269 | 1 |
→
Append (cost=0.00..937,501.69 rows=6,178,722 width=48) (actual time=0.484..11,816.820 rows=6,177,269 loops=1) |
3. | 0.054 | 0.054 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old (cost=0.00..1.27 rows=1 width=56) (actual time=0.054..0.054 rows=0 loops=1)
|
4. | 0.071 | 0.071 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201512 (cost=0.00..5.36 rows=1 width=56) (actual time=0.071..0.071 rows=0 loops=1)
|
5. | 0.023 | 0.023 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201602 (cost=0.00..1.03 rows=1 width=56) (actual time=0.023..0.023 rows=0 loops=1)
|
6. | 0.030 | 0.030 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201603 (cost=0.00..1.01 rows=1 width=56) (actual time=0.030..0.030 rows=0 loops=1)
|
7. | 0.006 | 0.006 | ↓ 0.0 | 0 | 1 |
→
Index Scan using units_old_201604_idx_answer_time on units_old_201604 (cost=0.27..8.29 rows=1 width=37) (actual time=0.006..0.006 rows=0 loops=1)
|
8. | 0.029 | 0.029 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201701 (cost=0.00..1.01 rows=1 width=56) (actual time=0.029..0.029 rows=0 loops=1)
|
9. | 0.021 | 0.021 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201704 (cost=0.00..1.03 rows=1 width=56) (actual time=0.021..0.021 rows=0 loops=1)
|
10. | 0.073 | 0.073 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201705 (cost=0.00..6.53 rows=1 width=56) (actual time=0.073..0.073 rows=0 loops=1)
|
11. | 0.019 | 0.019 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201706 (cost=0.00..1.01 rows=1 width=56) (actual time=0.019..0.019 rows=0 loops=1)
|
12. | 0.025 | 0.025 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201707 (cost=0.00..1.09 rows=1 width=56) (actual time=0.025..0.025 rows=0 loops=1)
|
13. | 0.021 | 0.021 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201709 (cost=0.00..1.03 rows=1 width=56) (actual time=0.021..0.021 rows=0 loops=1)
|
14. | 0.030 | 0.030 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201710 (cost=0.00..1.09 rows=1 width=56) (actual time=0.030..0.030 rows=0 loops=1)
|
15. | 0.018 | 0.018 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201711 (cost=0.00..2.12 rows=1 width=56) (actual time=0.018..0.018 rows=0 loops=1)
|
16. | 0.014 | 0.014 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201712 (cost=0.00..1.07 rows=1 width=56) (actual time=0.014..0.014 rows=0 loops=1)
|
17. | 0.010 | 0.010 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on units_old_201801 (cost=0.00..1.06 rows=1 width=56) (actual time=0.010..0.010 rows=0 loops=1)
|
18. | 0.015 | 0.015 | ↓ 0.0 | 0 | 1 |
→
Index Scan using units_old_201802_idx_answer_time on units_old_201802 (cost=0.28..8.30 rows=1 width=46) (actual time=0.015..0.015 rows=0 loops=1)
|
19. | 0.010 | 0.010 | ↓ 0.0 | 0 | 1 |
→
Index Scan using units_old_201803_idx_answer_time on units_old_201803 (cost=0.28..8.29 rows=1 width=49) (actual time=0.010..0.010 rows=0 loops=1)
|
20. | 0.059 | 0.059 | ↓ 34.0 | 34 | 1 |
→
Seq Scan on units_old_201804 (cost=0.00..4.51 rows=1 width=56) (actual time=0.014..0.059 rows=34 loops=1)
|
21. | 0.372 | 0.372 | ↑ 1.0 | 239 | 1 |
→
Seq Scan on units_old_201805 (cost=0.00..38.59 rows=239 width=43) (actual time=0.010..0.372 rows=239 loops=1)
|
22. | 5.053 | 5.053 | ↑ 1.0 | 4,363 | 1 |
→
Seq Scan on units_old_201806 (cost=0.00..525.44 rows=4,363 width=50) (actual time=0.017..5.053 rows=4,363 loops=1)
|
23. | 0.717 | 0.717 | ↑ 1.0 | 700 | 1 |
→
Seq Scan on units_old_201807 (cost=0.00..88.50 rows=700 width=52) (actual time=0.011..0.717 rows=700 loops=1)
|
24. | 0.197 | 0.197 | ↑ 1.0 | 194 | 1 |
→
Seq Scan on units_old_201808 (cost=0.00..26.91 rows=194 width=44) (actual time=0.012..0.197 rows=194 loops=1)
|
25. | 1.152 | 1.152 | ↑ 1.0 | 1,084 | 1 |
→
Seq Scan on units_old_201809 (cost=0.00..135.26 rows=1,084 width=55) (actual time=0.010..1.152 rows=1,084 loops=1)
|
26. | 2,550.184 | 2,550.184 | ↑ 1.0 | 1,376,622 | 1 |
→
Seq Scan on units_old_201810 (cost=0.00..187,619.61 rows=1,377,041 width=47) (actual time=0.377..2,550.184 rows=1,376,622 loops=1)
|
27. | 3,333.001 | 3,333.001 | ↑ 1.0 | 1,854,939 | 1 |
→
Seq Scan on units_old_201811 (cost=0.00..272,406.14 rows=1,855,609 width=46) (actual time=0.570..3,333.001 rows=1,854,939 loops=1)
|
28. | 1,651.360 | 1,651.360 | ↓ 1.0 | 1,029,908 | 1 |
→
Seq Scan on units_old_201812 (cost=0.00..162,007.29 rows=1,029,686 width=51) (actual time=1.549..1,651.360 rows=1,029,908 loops=1)
|
29. | 2,935.579 | 2,935.579 | ↑ 1.0 | 1,441,485 | 1 |
→
Seq Scan on units_old_201901 (cost=0.00..235,303.93 rows=1,442,129 width=49) (actual time=0.499..2,935.579 rows=1,441,485 loops=1)
|
30. | 759.055 | 759.055 | ↓ 1.0 | 467,701 | 1 |
→
Seq Scan on units_old_201902 (cost=0.00..79,294.88 rows=467,659 width=54) (actual time=0.449..759.055 rows=467,701 loops=1)
|