explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NDe6

Settings
# 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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 24
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 2
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 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)

  • Index Cond: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 2
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 35
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 6
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 2
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 6
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 8
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 5
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
  • Rows Removed by Filter: 4
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)

  • Index Cond: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Index Cond: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))
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)

  • Filter: ((answer_time >= 1522479788) AND (answer_time <= 1549893654))