explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mpaF : Why is this query using A LOT (> 20 * work_mem) of ram?

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on mytab (cost=1,758,584.12..220,267,632.85 rows=15,572,827 width=38) (actual rows= loops=)

  • Delete on mytab_p_pre_2011
  • Delete on mytab_p_2011
  • Delete on mytab_p_2012
  • Delete on mytab_p_2013
  • Delete on mytab_p_2014q1
  • Delete on mytab_p_2014q2
  • Delete on mytab_p_2014q3
  • Delete on mytab_p_2014q4
  • Delete on mytab_p_2015q1
  • Delete on mytab_p_2015q2
  • Delete on mytab_p_2015q3
  • Delete on mytab_p_2015q4
  • Delete on mytab_p_20161
  • Delete on mytab_p_20162
  • Delete on mytab_p_20163
  • Delete on mytab_p_20164
  • Delete on mytab_p_20165
  • Delete on mytab_p_20166
  • Delete on mytab_p_20167
  • Delete on mytab_p_20168
  • Delete on mytab_p_20169
  • Delete on mytab_p_201610
  • Delete on mytab_p_201611
  • Delete on mytab_p_201612
  • Delete on mytab_p_20171
  • Delete on mytab_p_20172
  • Delete on mytab_p_20173
  • Delete on mytab_p_20174
  • Delete on mytab_p_20175
  • Delete on mytab_p_20176
  • Delete on mytab_p_20177
  • Delete on mytab_p_20178
  • Delete on mytab_p_20179
  • Delete on mytab_p_201710
  • Delete on mytab_p_201711
  • Delete on mytab_p_201712
  • Delete on mytab_p_20181
  • Delete on mytab_p_20182
  • Delete on mytab_p_20183
  • Delete on mytab_p_20184
  • Delete on mytab_p_20185
  • Delete on mytab_p_20186
  • Delete on mytab_p_20187
  • Delete on mytab_p_20188
  • Delete on mytab_p_20189
  • Delete on mytab_p_201810
  • Delete on mytab_p_201811
  • Delete on mytab_p_201812
  • Delete on mytab_p_20191
  • Delete on mytab_p_20192
  • Delete on mytab_p_20193
  • Delete on mytab_p_20194
  • Delete on mytab_p_20195
  • Delete on mytab_p_20196
  • Delete on mytab_p_20197
  • Delete on mytab_p_20198
  • Delete on mytab_p_20199
  • Delete on mytab_p_201910
  • Delete on mytab_p_201911
  • Delete on mytab_p_201912
  • Delete on mytab_p_20201
  • Delete on mytab_p_20202
  • Delete on mytab_p_20203
  • Delete on mytab_p_20204
  • Delete on mytab_p_20205
  • Delete on mytab_p_20206
  • Delete on mytab_p_20207
  • Delete on mytab_p_20208
  • Delete on mytab_p_20209
  • Delete on mytab_p_202010
  • Delete on mytab_p_202011
  • Delete on mytab_p_202012
  • Delete on mytab_p_pre_2013_fr
  • Delete on mytab_p_2013_fr
  • Delete on mytab_p_2014_fr
  • Delete on mytab_p_2015q1_fr
  • Delete on mytab_p_2015q2_fr
  • Delete on mytab_p_2015q3_fr
  • Delete on mytab_p_2015q4_fr
  • Delete on mytab_p_2016q1_fr
  • Delete on mytab_p_2016q2_fr
  • Delete on mytab_p_2016q3_fr
  • Delete on mytab_p_2016q4_fr
  • Delete on mytab_p_2017q1_fr
  • Delete on mytab_p_2017q2_fr
  • Delete on mytab_p_2017q3_fr
  • Delete on mytab_p_2017q4_fr
  • Delete on mytab_p_2018q1_fr
  • Delete on mytab_p_2018q2_fr
  • Delete on mytab_p_2018q3_fr
  • Delete on mytab_p_2018q4_fr
  • Delete on mytab_p_20191_fr
  • Delete on mytab_p_20192_fr
  • Delete on mytab_p_20193_fr
  • Delete on mytab_p_20194_fr
  • Delete on mytab_p_20195_fr
  • Delete on mytab_p_20196_fr
  • Delete on mytab_p_20197_fr
  • Delete on mytab_p_20198_fr
  • Delete on mytab_p_20199_fr
  • Delete on mytab_p_201910_fr
  • Delete on mytab_p_201911_fr
  • Delete on mytab_p_201912_fr
  • Delete on mytab_p_20201_fr
  • Delete on mytab_p_20202_fr
  • Delete on mytab_p_20203_fr
  • Delete on mytab_p_20204_fr
  • Delete on mytab_p_20205_fr
  • Delete on mytab_p_20206_fr
  • Delete on mytab_p_20207_fr
  • Delete on mytab_p_20208_fr
  • Delete on mytab_p_20209_fr
  • Delete on mytab_p_202010_fr
  • Delete on mytab_p_202011_fr
  • Delete on mytab_p_202012_fr
  • Delete on mytab_p_pre_2013_de
  • Delete on mytab_p_2013_de
  • Delete on mytab_p_2014_de
  • Delete on mytab_p_2015_de
  • Delete on mytab_p_2016_de
  • Delete on mytab_p_2017_de
  • Delete on mytab_p_2018_de
  • Delete on mytab_p_2019_de
  • Delete on mytab_p_2020_de
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..1,818,317.12 rows=422,544 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_pre_2011.id = "ANY_subquery".min)
3. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 (cost=0.00..40,137.52 rows=845,088 width=14) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery".min
6. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_1.numb, mytab_p_pre_2011_1.sid
  • Filter: (count(*) > 1)
8. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_1 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
10. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_1 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
11. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_1 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
12. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_1 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
13. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
14. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
15. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
16. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
17. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
18. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
20. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
21. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
22. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
23. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
24. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
25. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
26. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
27. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
28. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
29. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
30. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
32. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
33. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
34. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
35. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
36. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
37. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
38. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
39. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
40. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
41. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
42. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
43. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
44. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
45. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
46. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
47. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
48. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
49. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
50. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
51. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
52. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
53. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
54. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
55. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
57. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
58. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
59. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
60. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
61. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
62. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
63. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
64. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
65. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
66. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
67. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
68. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
69. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
70. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
71. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
72. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
73. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
74. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
75. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
76. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
77. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_1 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
78. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
79. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_1 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
80. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_1 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
81. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_1 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
82. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_1 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
83. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_1 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
84. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_1 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
85. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_1 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
86. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_1 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
87. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_1 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
88. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_1 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
89. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_1 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
90. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
91. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
92. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
93. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
94. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
95. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
96. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
97. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
98. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
99. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
100. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_1 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
102. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..1,963,609.32 rows=1,453,240 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2011.id = "ANY_subquery_1".min)
103. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 (cost=0.00..137,631.20 rows=2,906,480 width=14) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_1".min
106. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_1 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_2.numb, mytab_p_pre_2011_2.sid
  • Filter: (count(*) > 1)
108. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_2 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
110. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_2 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
111. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_2 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
112. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_2 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
113. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
114. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
115. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
116. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
117. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
118. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
119. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
120. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
121. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
122. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
123. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
124. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
125. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
126. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
127. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
128. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
129. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
130. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
131. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
132. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
133. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
134. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
135. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
136. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
137. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
138. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
139. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
140. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
141. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
142. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
143. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
144. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
145. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
146. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
147. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
148. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
149. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
150. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
151. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
152. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
153. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
154. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
155. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
156. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
157. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
158. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
159. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
160. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
161. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
162. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
163. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
164. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
165. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
166. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
167. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
168. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
169. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
170. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
171. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
172. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
173. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
174. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
175. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
176. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
177. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_2 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
178. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
179. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_2 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
180. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_2 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
181. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_2 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
182. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_2 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
183. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_2 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
184. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_2 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
185. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_2 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
186. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_2 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
187. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_2 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
188. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_2 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
189. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_2 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
190. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
191. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
192. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
193. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
194. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
195. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
196. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
197. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
198. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
199. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
200. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_2 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
201. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
202. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..2,128,558.19 rows=2,622,418 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2012.id = "ANY_subquery_2".min)
203. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 (cost=0.00..248,359.44 rows=5,244,836 width=14) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_2".min
206. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_2 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_3.numb, mytab_p_pre_2011_3.sid
  • Filter: (count(*) > 1)
208. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_3 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
210. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_3 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
211. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_3 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
212. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_3 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
213. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
214. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
215. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
216. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
217. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
218. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
219. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
220. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
221. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
222. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
223. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
224. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
225. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
226. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
227. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
228. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
229. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
230. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
231. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
232. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
233. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
234. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
235. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
236. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
237. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
238. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
239. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
240. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
241. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
242. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
243. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
244. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
245. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
246. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
247. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
248. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
249. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
250. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
251. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
252. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
253. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
254. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
255. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
256. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
257. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
258. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
259. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
260. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
261. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
262. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
263. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
264. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
265. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
266. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
267. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
268. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
269. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
270. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
271. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
272. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
273. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
274. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
275. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
276. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
277. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_3 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
278. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
279. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_3 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
280. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_3 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
281. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_3 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
282. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_3 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
283. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_3 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
284. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_3 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
285. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_3 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
286. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_3 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
287. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_3 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
288. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_3 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
289. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_3 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
290. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
291. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
292. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
293. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
294. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
295. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
296. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
297. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
298. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
299. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
300. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_3 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
301. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
302. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..2,030,441.47 rows=1,894,468 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2013.id = "ANY_subquery_3".min)
303. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 (cost=0.00..184,001.40 rows=3,788,935 width=14) (actual rows= loops=)

304. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

305. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_3".min
306. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_3 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

307. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_4.numb, mytab_p_pre_2011_4.sid
  • Filter: (count(*) > 1)
308. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

309. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_4 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
310. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_4 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
311. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_4 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
312. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_4 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
313. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
314. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
315. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
316. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
317. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
318. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
319. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
320. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
321. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
322. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
323. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
324. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
325. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
326. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
327. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
328. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
329. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
330. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
331. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
332. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
333. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
334. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
335. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
336. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
337. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
338. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
339. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
340. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
341. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
342. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
343. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
344. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
345. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
346. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
347. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
348. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
349. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
350. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
351. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
352. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
353. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
354. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
355. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
356. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
357. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
358. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
359. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
360. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
361. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
362. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
363. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
364. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
365. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
366. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
367. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
368. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
369. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
370. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
371. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
372. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
373. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
374. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
375. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
376. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
377. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_4 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
378. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
379. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_4 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
380. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_4 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
381. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_4 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
382. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_4 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
383. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_4 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
384. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_4 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
385. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_4 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
386. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_4 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
387. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_4 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
388. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_4 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
389. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_4 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
390. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
391. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
392. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
393. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
394. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
395. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
396. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
397. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
398. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
399. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
400. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_4 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
401. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
402. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..1,758,689.53 rows=755 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2014q1.id = "ANY_subquery_4".min)
403. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 (cost=0.00..70.40 rows=1,510 width=14) (actual rows= loops=)

404. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

405. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_4".min
406. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_4 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

407. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_5.numb, mytab_p_pre_2011_5.sid
  • Filter: (count(*) > 1)
408. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

409. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_5 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
410. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_5 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
411. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_5 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
412. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_5 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
413. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
414. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
415. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
416. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
417. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
418. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
419. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
420. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
421. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
422. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
423. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
424. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
425. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
426. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
427. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
428. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
429. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
430. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
431. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
432. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
433. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
434. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
435. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
436. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
437. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
438. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
439. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
440. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
441. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
442. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
443. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
444. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
445. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
446. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
447. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
448. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
449. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
450. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
451. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
452. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
453. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
454. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
455. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
456. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
457. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
458. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
459. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
460. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
461. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
462. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
463. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
464. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
465. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
466. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
467. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
468. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
469. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
470. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
471. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
472. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
473. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
474. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
475. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
476. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
477. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_5 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
478. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
479. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_5 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
480. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_5 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
481. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_5 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
482. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_5 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
483. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_5 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
484. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_5 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
485. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_5 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
486. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_5 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
487. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_5 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
488. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_5 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
489. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_5 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
490. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
491. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
492. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
493. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
494. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
495. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
496. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
497. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
498. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
499. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
500. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_5 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
501. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
502. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..1,758,689.53 rows=755 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2014q2.id = "ANY_subquery_5".min)
503. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 (cost=0.00..70.40 rows=1,510 width=14) (actual rows= loops=)

504. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

505. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_5".min
506. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_5 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

507. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_6.numb, mytab_p_pre_2011_6.sid
  • Filter: (count(*) > 1)
508. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

509. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_6 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
510. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_6 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
511. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_6 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
512. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_6 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
513. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
514. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
515. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
516. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
517. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
518. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
519. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
520. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
521. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
522. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
523. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
524. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
525. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
526. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
527. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
528. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
529. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
530. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
531. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
532. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
533. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
534. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
535. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
536. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
537. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
538. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
539. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
540. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
541. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
542. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
543. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
544. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
545. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
546. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
547. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
548. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
549. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
550. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
551. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
552. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
553. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
554. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
555. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
556. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
557. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
558. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
559. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
560. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
561. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
562. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
563. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
564. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
565. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
566. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
567. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
568. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
569. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
570. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
571. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
572. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
573. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
574. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
575. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
576. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
577. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_6 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
578. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
579. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_6 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
580. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_6 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
581. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_6 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
582. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_6 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
583. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_6 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
584. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_6 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
585. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_6 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
586. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_6 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
587. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_6 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
588. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_6 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
589. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_6 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
590. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
591. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
592. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
593. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
594. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
595. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
596. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
597. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
598. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
599. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
600. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_6 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
601. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
602. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..1,758,689.53 rows=755 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2014q3.id = "ANY_subquery_6".min)
603. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 (cost=0.00..70.40 rows=1,510 width=14) (actual rows= loops=)

604. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

605. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_6".min
606. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_6 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

607. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_7.numb, mytab_p_pre_2011_7.sid
  • Filter: (count(*) > 1)
608. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

609. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_7 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
610. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_7 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
611. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_7 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
612. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_7 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
613. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
614. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
615. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q3 mytab_p_2014q3_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
616. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 mytab_p_2014q4_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
617. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q1 mytab_p_2015q1_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
618. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_2015q2 mytab_p_2015q2_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
619. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_2015q2_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
620. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q3 mytab_p_2015q3_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
621. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2015q4 mytab_p_2015q4_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
622. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20161 mytab_p_20161_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
623. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20162 mytab_p_20162_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
624. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20163 mytab_p_20163_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
625. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20164 mytab_p_20164_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
626. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20165 mytab_p_20165_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
627. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20166 mytab_p_20166_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
628. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20167 mytab_p_20167_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
629. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20168 mytab_p_20168_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
630. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20169 mytab_p_20169_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
631. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201610 mytab_p_201610_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
632. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201610_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
633. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201611 mytab_p_201611_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
634. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201611_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
635. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201612 mytab_p_201612_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
636. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201612_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
637. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20171 mytab_p_20171_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
638. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20171_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
639. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20172 mytab_p_20172_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
640. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20172_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
641. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20173 mytab_p_20173_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
642. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20173_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
643. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20174 mytab_p_20174_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
644. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20174_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
645. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20175 mytab_p_20175_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
646. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20175_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
647. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20176 mytab_p_20176_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
648. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20176_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
649. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20177 mytab_p_20177_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
650. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20177_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
651. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20178 mytab_p_20178_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
652. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20178_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
653. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20179 mytab_p_20179_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
654. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20179_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
655. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201710 mytab_p_201710_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
656. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201710_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
657. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_201711 mytab_p_201711_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
658. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_201711_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
659. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201712 mytab_p_201712_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
660. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20181 mytab_p_20181_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
661. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20182 mytab_p_20182_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
662. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20183 mytab_p_20183_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
663. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20184 mytab_p_20184_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
664. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20185 mytab_p_20185_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
665. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20186 mytab_p_20186_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
666. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20187 mytab_p_20187_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
667. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20188 mytab_p_20188_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
668. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20189 mytab_p_20189_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
669. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201810 mytab_p_201810_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
670. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201811 mytab_p_201811_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
671. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201812 mytab_p_201812_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
672. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20191 mytab_p_20191_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
673. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20192 mytab_p_20192_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
674. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20193 mytab_p_20193_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
675. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20194 mytab_p_20194_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
676. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20195 mytab_p_20195_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
677. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20196 mytab_p_20196_7 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
678. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20197 mytab_p_20197_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
679. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20198 mytab_p_20198_7 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
680. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20199 mytab_p_20199_7 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
681. 0.000 0.000 ↓ 0.0

Index Scan using mytab_p_201910_pkey on mytab_p_201910 mytab_p_201910_7 (cost=0.15..8.20 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (sid = 1)
682. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201911 mytab_p_201911_7 (cost=0.00..1.08 rows=2 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
683. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_201912 mytab_p_201912_7 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
684. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20201 mytab_p_20201_7 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
685. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20202 mytab_p_20202_7 (cost=0.00..1.04 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
686. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20203 mytab_p_20203_7 (cost=0.00..1.00 rows=1 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
687. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20204 mytab_p_20204_7 (cost=0.00..1.13 rows=3 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
688. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20205 mytab_p_20205_7 (cost=0.00..6.21 rows=5 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
689. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_20206 mytab_p_20206_7 (cost=0.00..294.42 rows=4,504 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
690. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20207 mytab_p_20207_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
691. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20207_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
692. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20208 mytab_p_20208_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
693. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20208_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
694. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_20209 mytab_p_20209_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
695. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_20209_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
696. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202010 mytab_p_202010_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
697. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202010_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
698. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202011 mytab_p_202011_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
699. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202011_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
700. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mytab_p_202012 mytab_p_202012_7 (cost=4.21..14.61 rows=8 width=18) (actual rows= loops=)

  • Recheck Cond: (sid = 1)
701. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mytab_p_202012_pkey (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (sid = 1)
702. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,758,584.12..1,758,689.53 rows=755 width=38) (actual rows= loops=)

  • Hash Cond: (mytab_p_2014q4.id = "ANY_subquery_7".min)
703. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q4 (cost=0.00..70.40 rows=1,510 width=14) (actual rows= loops=)

704. 0.000 0.000 ↓ 0.0

Hash (cost=1,758,575.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

705. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,758,567.62..1,758,575.62 rows=200 width=40) (actual rows= loops=)

  • Group Key: "ANY_subquery_7".min
706. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_7 (cost=1,030,718.95..1,747,863.96 rows=4,281,463 width=40) (actual rows= loops=)

707. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,030,718.95..1,576,605.44 rows=4,281,463 width=18) (actual rows= loops=)

  • Group Key: mytab_p_pre_2011_8.numb, mytab_p_pre_2011_8.sid
  • Filter: (count(*) > 1)
708. 0.000 0.000 ↓ 0.0

Append (cost=0.00..902,275.07 rows=12,844,388 width=18) (actual rows= loops=)

709. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_pre_2011 mytab_p_pre_2011_8 (cost=0.00..42,250.24 rows=845,088 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
710. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2011 mytab_p_2011_8 (cost=0.00..144,897.40 rows=2,906,480 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
711. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2012 mytab_p_2012_8 (cost=0.00..261,471.53 rows=5,244,836 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
712. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2013 mytab_p_2013_8 (cost=0.00..193,473.74 rows=3,788,935 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
713. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q1 mytab_p_2014q1_8 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)
714. 0.000 0.000 ↓ 0.0

Seq Scan on mytab_p_2014q2 mytab_p_2014q2_8 (cost=0.00..74.18 rows=1,510 width=18) (actual rows= loops=)

  • Filter: (sid = 1)