queries.out
application/octet-stream
Filename: queries.out
Type: application/octet-stream
Part: 0
count | tableoid
--------+----------
693027 | prt_p1
471395 | prt_p2
387541 | prt_p3
333435 | prt_p4
292237 | prt_p5
495522 | prt_p6
210213 | prt_p7
364424 | prt_p8
157389 | prt_p9
141686 | prt_p10
129090 | prt_p11
116767 | prt_p12
105258 | prt_p13
94719 | prt_p14
84292 | prt_p21
75372 | prt_p15
66508 | prt_p22
58131 | prt_p16
49757 | prt_p23
42158 | prt_p17
35139 | prt_p18
27985 | prt_p24
21259 | prt_p19
23878 | prt_p25
2882 | prt_p20
(25 rows)
count | tableoid
--------+----------
692550 | prt2_p1
471678 | prt2_p2
387260 | prt2_p3
332673 | prt2_p4
293104 | prt2_p5
495443 | prt2_p6
211690 | prt2_p7
363489 | prt2_p8
157180 | prt2_p9
142816 | prt2_p10
128759 | prt2_p11
116707 | prt2_p12
105633 | prt2_p13
94233 | prt2_p14
84579 | prt2_p21
75123 | prt2_p15
57968 | prt2_p16
41935 | prt2_p17
34759 | prt2_p18
21278 | prt2_p19
2787 | prt2_p20
66449 | prt2_p22
50328 | prt2_p23
27867 | prt2_p24
23776 | prt2_p25
(25 rows)
SET
SET
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Merge Join (cost=56528.93..5764588.12 rows=357011304 width=16) (actual time=388.949..117071.435 rows=359419719 loops=1)
Merge Cond: (t2.b = t1.a)
-> Merge Append (cost=22123.03..184845.50 rows=3257656 width=8) (actual time=133.681..8163.744 rows=3258009 loops=1)
Sort Key: t2.b
-> Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)
Sort Key: t2.b
Sort Method: quicksort Memory: 25kB
-> Seq Scan on prt2 t2 (cost=0.00..0.00 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)
Filter: (a > 8000)
-> Index Scan using np221_idx on prt2_p1 t2_1 (cost=0.42..12616.76 rows=313782 width=8) (actual time=0.108..1196.800 rows=314494 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 378056
-> Index Scan using np222_idx on prt2_p2 t2_2 (cost=0.42..8593.25 rows=293627 width=8) (actual time=0.057..824.810 rows=293729 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 177949
-> Index Scan using np223_idx on prt2_p3 t2_3 (cost=0.42..7055.39 rows=265279 width=8) (actual time=0.056..702.934 rows=266162 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 121098
-> Index Scan using np224_idx on prt2_p4 t2_4 (cost=0.42..6061.02 rows=242640 width=8) (actual time=0.025..643.121 rows=242756 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 89917
-> Index Scan using np225_idx on prt2_p5 t2_5 (cost=0.42..5340.06 rows=222789 width=8) (actual time=0.025..475.627 rows=221372 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 71732
-> Index Scan using np26_idx on prt2_p6 t2_6 (cost=0.42..9026.17 rows=388005 width=8) (actual time=0.074..998.186 rows=388880 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 106563
-> Index Scan using np27_idx on prt2_p7 t2_7 (cost=0.42..3857.10 rows=171019 width=8) (actual time=0.027..483.418 rows=171000 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 40690
-> Index Scan using np28_idx on prt2_p8 t2_8 (cost=0.42..6622.39 rows=300013 width=8) (actual time=0.280..623.299 rows=299361 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 64128
-> Index Scan using np29_idx on prt2_p9 t2_9 (cost=0.42..2864.07 rows=131012 width=8) (actual time=0.045..223.252 rows=131315 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 25865
-> Index Scan using np210_idx on prt2_p10 t2_10 (cost=0.42..2602.44 rows=120568 width=8) (actual time=0.089..200.962 rows=120330 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 22486
-> Index Scan using np211_idx on prt2_p11 t2_11 (cost=0.42..2346.33 rows=109560 width=8) (actual time=0.076..176.083 rows=109297 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 19462
-> Index Scan using np212_idx on prt2_p12 t2_12 (cost=0.42..2126.79 rows=99635 width=8) (actual time=0.054..162.462 rows=99686 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 17021
-> Index Scan using np213_idx on prt2_p13 t2_13 (cost=0.42..1925.10 rows=90585 width=8) (actual time=0.033..138.003 rows=90710 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 14923
-> Index Scan using np214_idx on prt2_p14 t2_14 (cost=0.29..1717.09 rows=81355 width=8) (actual time=0.022..123.117 rows=81339 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 12894
-> Sort (cost=7367.85..7551.45 rows=73441 width=8) (actual time=41.584..61.706 rows=73352 loops=1)
Sort Key: t2_15.b
Sort Method: quicksort Memory: 7084kB
-> Seq Scan on prt2_p21 t2_15 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.010..16.435 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Index Scan using np215_idx on prt2_p15 t2_16 (cost=0.29..1369.05 rows=65327 width=8) (actual time=0.066..92.423 rows=65345 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 9778
-> Index Scan using np216_idx on prt2_p16 t2_17 (cost=0.29..1056.53 rows=51070 width=8) (actual time=0.083..70.021 rows=51004 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6964
-> Index Scan using np217_idx on prt2_p17 t2_18 (cost=0.29..764.48 rows=37061 width=8) (actual time=0.028..47.142 rows=37063 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 4872
-> Index Scan using np218_idx on prt2_p18 t2_19 (cost=0.29..633.67 rows=30879 width=8) (actual time=2.259..41.325 rows=30844 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3915
-> Index Scan using np219_idx on prt2_p19 t2_20 (cost=0.29..388.25 rows=18997 width=8) (actual time=0.076..26.283 rows=18995 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2283
-> Index Scan using np220_idx on prt2_p20 t2_21 (cost=0.28..51.36 rows=2499 width=8) (actual time=0.105..2.812 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Sort (cost=5743.00..5888.83 rows=58330 width=8) (actual time=45.230..61.395 rows=58244 loops=1)
Sort Key: t2_22.b
Sort Method: quicksort Memory: 4722kB
-> Seq Scan on prt2_p22 t2_22 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.018..15.810 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Sort (cost=4268.59..4379.27 rows=44272 width=8) (actual time=27.531..38.812 rows=44320 loops=1)
Sort Key: t2_23.b
Sort Method: quicksort Memory: 3960kB
-> Seq Scan on prt2_p23 t2_23 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.021..9.526 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
-> Sort (cost=2276.48..2338.29 rows=24725 width=8) (actual time=15.638..21.374 rows=24731 loops=1)
Sort Key: t2_24.b
Sort Method: quicksort Memory: 2121kB
-> Seq Scan on prt2_p24 t2_24 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.016..5.217 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Index Scan using np235_idx on prt2_p25 t2_25 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.070..22.960 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=34300.59..227684.00 rows=4480065 width=8) (actual time=255.262..28356.243 rows=359421112 loops=1)
-> Merge Append (cost=34300.59..216483.83 rows=4480065 width=8) (actual time=255.254..7448.063 rows=4480064 loops=1)
Sort Key: t1.a
-> Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)
Sort Key: t1.a
Sort Method: quicksort Memory: 25kB
-> Seq Scan on prt t1 (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)
-> Index Scan using p1_idx on prt_p1 t1_1 (cost=0.42..10892.83 rows=693027 width=8) (actual time=0.034..1060.683 rows=693027 loops=1)
-> Index Scan using p2_idx on prt_p2 t1_2 (cost=0.42..7409.45 rows=471395 width=8) (actual time=0.284..703.270 rows=471395 loops=1)
-> Index Scan using p3_idx on prt_p3 t1_3 (cost=0.42..6091.59 rows=387541 width=8) (actual time=0.031..599.513 rows=387541 loops=1)
-> Index Scan using p4_idx on prt_p4 t1_4 (cost=0.42..5241.38 rows=333435 width=8) (actual time=0.027..535.784 rows=333435 loops=1)
-> Index Scan using p5_idx on prt_p5 t1_5 (cost=0.42..4593.79 rows=292237 width=8) (actual time=0.255..417.194 rows=292237 loops=1)
-> Index Scan using p6_idx on prt_p6 t1_6 (cost=0.42..7788.65 rows=495522 width=8) (actual time=0.055..861.433 rows=495522 loops=1)
-> Index Scan using p7_idx on prt_p7 t1_7 (cost=0.42..3304.72 rows=210213 width=8) (actual time=0.337..417.037 rows=210213 loops=1)
-> Index Scan using p8_idx on prt_p8 t1_8 (cost=0.42..5728.35 rows=364424 width=8) (actual time=0.346..537.505 rows=364424 loops=1)
-> Index Scan using p9_idx on prt_p9 t1_9 (cost=0.42..2474.48 rows=157389 width=8) (actual time=0.034..191.347 rows=157389 loops=1)
-> Index Scan using p10_idx on prt_p10 t1_10 (cost=0.42..2227.66 rows=141686 width=8) (actual time=0.027..184.826 rows=141686 loops=1)
-> Sort (cost=12821.36..13144.09 rows=129090 width=8) (actual time=87.003..123.682 rows=129090 loops=1)
Sort Key: t1_11.a
Sort Method: quicksort Memory: 10132kB
-> Seq Scan on prt_p11 t1_11 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.011..14.546 rows=129090 loops=1)
-> Index Scan using p12_idx on prt_p12 t1_12 (cost=0.42..1836.05 rows=116767 width=8) (actual time=0.108..138.350 rows=116767 loops=1)
-> Index Scan using p13_idx on prt_p13 t1_13 (cost=0.42..1655.09 rows=105258 width=8) (actual time=0.066..126.158 rows=105258 loops=1)
-> Index Scan using p14_idx on prt_p14 t1_14 (cost=0.29..1489.18 rows=94719 width=8) (actual time=0.025..108.899 rows=94719 loops=1)
-> Sort (cost=8112.32..8323.05 rows=84292 width=8) (actual time=81.960..103.639 rows=84292 loops=1)
Sort Key: t1_15.a
Sort Method: quicksort Memory: 7682kB
-> Seq Scan on prt_p21 t1_15 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.012..10.976 rows=84292 loops=1)
-> Index Scan using p15_idx on prt_p15 t1_16 (cost=0.29..1185.09 rows=75372 width=8) (actual time=0.057..83.373 rows=75372 loops=1)
-> Sort (cost=6287.78..6454.05 rows=66508 width=8) (actual time=40.739..57.855 rows=66508 loops=1)
Sort Key: t1_17.a
Sort Method: quicksort Memory: 6710kB
-> Seq Scan on prt_p22 t1_17 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.010..8.040 rows=66508 loops=1)
-> Index Scan using p16_idx on prt_p16 t1_18 (cost=0.29..914.16 rows=58131 width=8) (actual time=0.041..67.136 rows=58131 loops=1)
-> Sort (cost=4600.27..4724.66 rows=49757 width=8) (actual time=28.480..40.765 rows=49757 loops=1)
Sort Key: t1_19.a
Sort Method: quicksort Memory: 4258kB
-> Seq Scan on prt_p23 t1_19 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.014..6.480 rows=49757 loops=1)
-> Index Scan using p17_idx on prt_p17 t1_20 (cost=0.29..663.16 rows=42158 width=8) (actual time=0.077..44.707 rows=42158 loops=1)
-> Index Scan using p18_idx on prt_p18 t1_21 (cost=0.29..552.88 rows=35139 width=8) (actual time=0.031..33.219 rows=35139 loops=1)
-> Sort (cost=2470.87..2540.84 rows=27985 width=8) (actual time=15.058..21.609 rows=27985 loops=1)
Sort Key: t1_22.a
Sort Method: quicksort Memory: 2299kB
-> Seq Scan on prt_p24 t1_22 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.015..3.331 rows=27985 loops=1)
-> Index Scan using p19_idx on prt_p19 t1_23 (cost=0.29..334.77 rows=21259 width=8) (actual time=0.049..25.850 rows=21259 loops=1)
-> Index Scan using p21_idx on prt_p25 t1_24 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.071..22.003 rows=23878 loops=1)
-> Index Scan using p20_idx on prt_p20 t1_25 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.021..2.455 rows=2882 loops=1)
Planning time: 4.791 ms
Execution time: 130855.637 ms
(145 rows)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Merge Join (cost=56528.93..5764588.12 rows=357011304 width=16) (actual time=295.149..120297.664 rows=359419719 loops=1)
Merge Cond: (t2.b = t1.a)
-> Merge Append (cost=22123.03..184845.50 rows=3257656 width=8) (actual time=106.137..7935.943 rows=3258009 loops=1)
Sort Key: t2.b
-> Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)
Sort Key: t2.b
Sort Method: quicksort Memory: 25kB
-> Seq Scan on prt2 t2 (cost=0.00..0.00 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)
Filter: (a > 8000)
-> Index Scan using np221_idx on prt2_p1 t2_1 (cost=0.42..12616.76 rows=313782 width=8) (actual time=0.051..1249.345 rows=314494 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 378056
-> Index Scan using np222_idx on prt2_p2 t2_2 (cost=0.42..8593.25 rows=293627 width=8) (actual time=0.024..989.644 rows=293729 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 177949
-> Index Scan using np223_idx on prt2_p3 t2_3 (cost=0.42..7055.39 rows=265279 width=8) (actual time=0.030..739.657 rows=266162 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 121098
-> Index Scan using np224_idx on prt2_p4 t2_4 (cost=0.42..6061.02 rows=242640 width=8) (actual time=0.022..623.097 rows=242756 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 89917
-> Index Scan using np225_idx on prt2_p5 t2_5 (cost=0.42..5340.06 rows=222789 width=8) (actual time=0.022..439.555 rows=221372 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 71732
-> Index Scan using np26_idx on prt2_p6 t2_6 (cost=0.42..9026.17 rows=388005 width=8) (actual time=0.022..768.311 rows=388880 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 106563
-> Index Scan using np27_idx on prt2_p7 t2_7 (cost=0.42..3857.10 rows=171019 width=8) (actual time=0.021..378.900 rows=171000 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 40690
-> Index Scan using np28_idx on prt2_p8 t2_8 (cost=0.42..6622.39 rows=300013 width=8) (actual time=0.020..593.974 rows=299361 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 64128
-> Index Scan using np29_idx on prt2_p9 t2_9 (cost=0.42..2864.07 rows=131012 width=8) (actual time=0.021..205.166 rows=131315 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 25865
-> Index Scan using np210_idx on prt2_p10 t2_10 (cost=0.42..2602.44 rows=120568 width=8) (actual time=0.028..183.228 rows=120330 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 22486
-> Index Scan using np211_idx on prt2_p11 t2_11 (cost=0.42..2346.33 rows=109560 width=8) (actual time=0.030..178.565 rows=109297 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 19462
-> Index Scan using np212_idx on prt2_p12 t2_12 (cost=0.42..2126.79 rows=99635 width=8) (actual time=0.019..177.582 rows=99686 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 17021
-> Index Scan using np213_idx on prt2_p13 t2_13 (cost=0.42..1925.10 rows=90585 width=8) (actual time=0.028..145.126 rows=90710 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 14923
-> Index Scan using np214_idx on prt2_p14 t2_14 (cost=0.29..1717.09 rows=81355 width=8) (actual time=0.015..115.302 rows=81339 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 12894
-> Sort (cost=7367.85..7551.45 rows=73441 width=8) (actual time=38.919..58.901 rows=73352 loops=1)
Sort Key: t2_15.b
Sort Method: quicksort Memory: 7084kB
-> Seq Scan on prt2_p21 t2_15 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.009..16.331 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Index Scan using np215_idx on prt2_p15 t2_16 (cost=0.29..1369.05 rows=65327 width=8) (actual time=0.041..85.796 rows=65345 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 9778
-> Index Scan using np216_idx on prt2_p16 t2_17 (cost=0.29..1056.53 rows=51070 width=8) (actual time=0.019..64.396 rows=51004 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6964
-> Index Scan using np217_idx on prt2_p17 t2_18 (cost=0.29..764.48 rows=37061 width=8) (actual time=0.023..43.577 rows=37063 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 4872
-> Index Scan using np218_idx on prt2_p18 t2_19 (cost=0.29..633.67 rows=30879 width=8) (actual time=0.073..33.304 rows=30844 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3915
-> Index Scan using np219_idx on prt2_p19 t2_20 (cost=0.29..388.25 rows=18997 width=8) (actual time=0.058..19.801 rows=18995 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2283
-> Index Scan using np220_idx on prt2_p20 t2_21 (cost=0.28..51.36 rows=2499 width=8) (actual time=0.027..2.159 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Sort (cost=5743.00..5888.83 rows=58330 width=8) (actual time=31.057..46.899 rows=58244 loops=1)
Sort Key: t2_22.b
Sort Method: quicksort Memory: 4722kB
-> Seq Scan on prt2_p22 t2_22 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.014..12.709 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Sort (cost=4268.59..4379.27 rows=44272 width=8) (actual time=22.951..34.215 rows=44320 loops=1)
Sort Key: t2_23.b
Sort Method: quicksort Memory: 3960kB
-> Seq Scan on prt2_p23 t2_23 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.018..9.135 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
-> Sort (cost=2276.48..2338.29 rows=24725 width=8) (actual time=12.553..18.611 rows=24731 loops=1)
Sort Key: t2_24.b
Sort Method: quicksort Memory: 2121kB
-> Seq Scan on prt2_p24 t2_24 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.017..5.123 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Index Scan using np235_idx on prt2_p25 t2_25 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.034..21.661 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=34300.59..227684.00 rows=4480065 width=8) (actual time=189.006..28652.626 rows=359421112 loops=1)
-> Merge Append (cost=34300.59..216483.83 rows=4480065 width=8) (actual time=189.002..7081.027 rows=4480064 loops=1)
Sort Key: t1.a
-> Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)
Sort Key: t1.a
Sort Method: quicksort Memory: 25kB
-> Seq Scan on prt t1 (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)
-> Index Scan using p1_idx on prt_p1 t1_1 (cost=0.42..10892.83 rows=693027 width=8) (actual time=0.026..1054.665 rows=693027 loops=1)
-> Index Scan using p2_idx on prt_p2 t1_2 (cost=0.42..7409.45 rows=471395 width=8) (actual time=0.026..800.209 rows=471395 loops=1)
-> Index Scan using p3_idx on prt_p3 t1_3 (cost=0.42..6091.59 rows=387541 width=8) (actual time=0.023..604.692 rows=387541 loops=1)
-> Index Scan using p4_idx on prt_p4 t1_4 (cost=0.42..5241.38 rows=333435 width=8) (actual time=0.024..519.289 rows=333435 loops=1)
-> Index Scan using p5_idx on prt_p5 t1_5 (cost=0.42..4593.79 rows=292237 width=8) (actual time=0.030..382.537 rows=292237 loops=1)
-> Index Scan using p6_idx on prt_p6 t1_6 (cost=0.42..7788.65 rows=495522 width=8) (actual time=0.024..677.963 rows=495522 loops=1)
-> Index Scan using p7_idx on prt_p7 t1_7 (cost=0.42..3304.72 rows=210213 width=8) (actual time=0.023..321.471 rows=210213 loops=1)
-> Index Scan using p8_idx on prt_p8 t1_8 (cost=0.42..5728.35 rows=364424 width=8) (actual time=0.022..517.736 rows=364424 loops=1)
-> Index Scan using p9_idx on prt_p9 t1_9 (cost=0.42..2474.48 rows=157389 width=8) (actual time=0.020..179.980 rows=157389 loops=1)
-> Index Scan using p10_idx on prt_p10 t1_10 (cost=0.42..2227.66 rows=141686 width=8) (actual time=0.019..161.419 rows=141686 loops=1)
-> Sort (cost=12821.36..13144.09 rows=129090 width=8) (actual time=54.773..95.128 rows=129090 loops=1)
Sort Key: t1_11.a
Sort Method: quicksort Memory: 10132kB
-> Seq Scan on prt_p11 t1_11 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.009..13.857 rows=129090 loops=1)
-> Index Scan using p12_idx on prt_p12 t1_12 (cost=0.42..1836.05 rows=116767 width=8) (actual time=0.059..153.674 rows=116767 loops=1)
-> Index Scan using p13_idx on prt_p13 t1_13 (cost=0.42..1655.09 rows=105258 width=8) (actual time=0.034..127.442 rows=105258 loops=1)
-> Index Scan using p14_idx on prt_p14 t1_14 (cost=0.29..1489.18 rows=94719 width=8) (actual time=0.021..102.739 rows=94719 loops=1)
-> Sort (cost=8112.32..8323.05 rows=84292 width=8) (actual time=58.118..80.692 rows=84292 loops=1)
Sort Key: t1_15.a
Sort Method: quicksort Memory: 7682kB
-> Seq Scan on prt_p21 t1_15 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.022..8.975 rows=84292 loops=1)
-> Index Scan using p15_idx on prt_p15 t1_16 (cost=0.29..1185.09 rows=75372 width=8) (actual time=0.040..76.764 rows=75372 loops=1)
-> Sort (cost=6287.78..6454.05 rows=66508 width=8) (actual time=43.989..61.796 rows=66508 loops=1)
Sort Key: t1_17.a
Sort Method: quicksort Memory: 6710kB
-> Seq Scan on prt_p22 t1_17 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.012..7.323 rows=66508 loops=1)
-> Index Scan using p16_idx on prt_p16 t1_18 (cost=0.29..914.16 rows=58131 width=8) (actual time=0.040..57.578 rows=58131 loops=1)
-> Sort (cost=4600.27..4724.66 rows=49757 width=8) (actual time=19.812..32.409 rows=49757 loops=1)
Sort Key: t1_19.a
Sort Method: quicksort Memory: 4258kB
-> Seq Scan on prt_p23 t1_19 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.012..5.114 rows=49757 loops=1)
-> Index Scan using p17_idx on prt_p17 t1_20 (cost=0.29..663.16 rows=42158 width=8) (actual time=0.034..39.740 rows=42158 loops=1)
-> Index Scan using p18_idx on prt_p18 t1_21 (cost=0.29..552.88 rows=35139 width=8) (actual time=0.018..29.862 rows=35139 loops=1)
-> Sort (cost=2470.87..2540.84 rows=27985 width=8) (actual time=11.720..18.605 rows=27985 loops=1)
Sort Key: t1_22.a
Sort Method: quicksort Memory: 2299kB
-> Seq Scan on prt_p24 t1_22 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.010..2.901 rows=27985 loops=1)
-> Index Scan using p19_idx on prt_p19 t1_23 (cost=0.29..334.77 rows=21259 width=8) (actual time=0.032..18.150 rows=21259 loops=1)
-> Index Scan using p21_idx on prt_p25 t1_24 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.019..19.940 rows=23878 loops=1)
-> Index Scan using p20_idx on prt_p20 t1_25 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.019..1.998 rows=2882 loops=1)
Planning time: 2.863 ms
Execution time: 134365.716 ms
(145 rows)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Merge Join (cost=56528.93..5764588.12 rows=357011304 width=16) (actual time=288.345..116716.252 rows=359419719 loops=1)
Merge Cond: (t2.b = t1.a)
-> Merge Append (cost=22123.03..184845.50 rows=3257656 width=8) (actual time=108.360..7331.214 rows=3258009 loops=1)
Sort Key: t2.b
-> Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)
Sort Key: t2.b
Sort Method: quicksort Memory: 25kB
-> Seq Scan on prt2 t2 (cost=0.00..0.00 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)
Filter: (a > 8000)
-> Index Scan using np221_idx on prt2_p1 t2_1 (cost=0.42..12616.76 rows=313782 width=8) (actual time=0.091..1418.730 rows=314494 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 378056
-> Index Scan using np222_idx on prt2_p2 t2_2 (cost=0.42..8593.25 rows=293627 width=8) (actual time=0.046..822.105 rows=293729 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 177949
-> Index Scan using np223_idx on prt2_p3 t2_3 (cost=0.42..7055.39 rows=265279 width=8) (actual time=0.056..608.431 rows=266162 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 121098
-> Index Scan using np224_idx on prt2_p4 t2_4 (cost=0.42..6061.02 rows=242640 width=8) (actual time=0.044..494.793 rows=242756 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 89917
-> Index Scan using np225_idx on prt2_p5 t2_5 (cost=0.42..5340.06 rows=222789 width=8) (actual time=0.043..432.212 rows=221372 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 71732
-> Index Scan using np26_idx on prt2_p6 t2_6 (cost=0.42..9026.17 rows=388005 width=8) (actual time=0.044..732.068 rows=388880 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 106563
-> Index Scan using np27_idx on prt2_p7 t2_7 (cost=0.42..3857.10 rows=171019 width=8) (actual time=0.049..287.680 rows=171000 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 40690
-> Index Scan using np28_idx on prt2_p8 t2_8 (cost=0.42..6622.39 rows=300013 width=8) (actual time=0.036..514.218 rows=299361 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 64128
-> Index Scan using np29_idx on prt2_p9 t2_9 (cost=0.42..2864.07 rows=131012 width=8) (actual time=0.036..196.569 rows=131315 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 25865
-> Index Scan using np210_idx on prt2_p10 t2_10 (cost=0.42..2602.44 rows=120568 width=8) (actual time=0.036..179.386 rows=120330 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 22486
-> Index Scan using np211_idx on prt2_p11 t2_11 (cost=0.42..2346.33 rows=109560 width=8) (actual time=0.035..156.820 rows=109297 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 19462
-> Index Scan using np212_idx on prt2_p12 t2_12 (cost=0.42..2126.79 rows=99635 width=8) (actual time=0.035..137.505 rows=99686 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 17021
-> Index Scan using np213_idx on prt2_p13 t2_13 (cost=0.42..1925.10 rows=90585 width=8) (actual time=0.041..125.345 rows=90710 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 14923
-> Index Scan using np214_idx on prt2_p14 t2_14 (cost=0.29..1717.09 rows=81355 width=8) (actual time=0.028..106.646 rows=81339 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 12894
-> Sort (cost=7367.85..7551.45 rows=73441 width=8) (actual time=40.422..62.494 rows=73352 loops=1)
Sort Key: t2_15.b
Sort Method: quicksort Memory: 7084kB
-> Seq Scan on prt2_p21 t2_15 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.011..15.801 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Index Scan using np215_idx on prt2_p15 t2_16 (cost=0.29..1369.05 rows=65327 width=8) (actual time=0.044..82.557 rows=65345 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 9778
-> Index Scan using np216_idx on prt2_p16 t2_17 (cost=0.29..1056.53 rows=51070 width=8) (actual time=0.019..60.236 rows=51004 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6964
-> Index Scan using np217_idx on prt2_p17 t2_18 (cost=0.29..764.48 rows=37061 width=8) (actual time=0.020..43.181 rows=37063 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 4872
-> Index Scan using np218_idx on prt2_p18 t2_19 (cost=0.29..633.67 rows=30879 width=8) (actual time=0.018..34.641 rows=30844 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3915
-> Index Scan using np219_idx on prt2_p19 t2_20 (cost=0.29..388.25 rows=18997 width=8) (actual time=0.018..19.286 rows=18995 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2283
-> Index Scan using np220_idx on prt2_p20 t2_21 (cost=0.28..51.36 rows=2499 width=8) (actual time=0.017..2.080 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Sort (cost=5743.00..5888.83 rows=58330 width=8) (actual time=31.342..47.336 rows=58244 loops=1)
Sort Key: t2_22.b
Sort Method: quicksort Memory: 4722kB
-> Seq Scan on prt2_p22 t2_22 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.011..12.829 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Sort (cost=4268.59..4379.27 rows=44272 width=8) (actual time=23.229..35.142 rows=44320 loops=1)
Sort Key: t2_23.b
Sort Method: quicksort Memory: 3960kB
-> Seq Scan on prt2_p23 t2_23 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.024..9.219 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
-> Sort (cost=2276.48..2338.29 rows=24725 width=8) (actual time=12.542..19.107 rows=24731 loops=1)
Sort Key: t2_24.b
Sort Method: quicksort Memory: 2121kB
-> Seq Scan on prt2_p24 t2_24 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.029..5.054 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Index Scan using np235_idx on prt2_p25 t2_25 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.033..24.517 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=34300.59..227684.00 rows=4480065 width=8) (actual time=179.979..27635.861 rows=359421112 loops=1)
-> Merge Append (cost=34300.59..216483.83 rows=4480065 width=8) (actual time=179.975..6561.189 rows=4480064 loops=1)
Sort Key: t1.a
-> Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)
Sort Key: t1.a
Sort Method: quicksort Memory: 25kB
-> Seq Scan on prt t1 (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)
-> Index Scan using p1_idx on prt_p1 t1_1 (cost=0.42..10892.83 rows=693027 width=8) (actual time=0.029..1123.476 rows=693027 loops=1)
-> Index Scan using p2_idx on prt_p2 t1_2 (cost=0.42..7409.45 rows=471395 width=8) (actual time=0.027..683.423 rows=471395 loops=1)
-> Index Scan using p3_idx on prt_p3 t1_3 (cost=0.42..6091.59 rows=387541 width=8) (actual time=0.026..522.438 rows=387541 loops=1)
-> Index Scan using p4_idx on prt_p4 t1_4 (cost=0.42..5241.38 rows=333435 width=8) (actual time=0.025..433.524 rows=333435 loops=1)
-> Index Scan using p5_idx on prt_p5 t1_5 (cost=0.42..4593.79 rows=292237 width=8) (actual time=0.027..374.267 rows=292237 loops=1)
-> Index Scan using p6_idx on prt_p6 t1_6 (cost=0.42..7788.65 rows=495522 width=8) (actual time=0.025..646.312 rows=495522 loops=1)
-> Index Scan using p7_idx on prt_p7 t1_7 (cost=0.42..3304.72 rows=210213 width=8) (actual time=0.025..250.407 rows=210213 loops=1)
-> Index Scan using p8_idx on prt_p8 t1_8 (cost=0.42..5728.35 rows=364424 width=8) (actual time=0.061..458.500 rows=364424 loops=1)
-> Index Scan using p9_idx on prt_p9 t1_9 (cost=0.42..2474.48 rows=157389 width=8) (actual time=0.022..171.550 rows=157389 loops=1)
-> Index Scan using p10_idx on prt_p10 t1_10 (cost=0.42..2227.66 rows=141686 width=8) (actual time=0.021..154.740 rows=141686 loops=1)
-> Sort (cost=12821.36..13144.09 rows=129090 width=8) (actual time=83.805..121.203 rows=129090 loops=1)
Sort Key: t1_11.a
Sort Method: quicksort Memory: 10132kB
-> Seq Scan on prt_p11 t1_11 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.009..13.936 rows=129090 loops=1)
-> Index Scan using p12_idx on prt_p12 t1_12 (cost=0.42..1836.05 rows=116767 width=8) (actual time=0.050..120.081 rows=116767 loops=1)
-> Index Scan using p13_idx on prt_p13 t1_13 (cost=0.42..1655.09 rows=105258 width=8) (actual time=0.027..110.096 rows=105258 loops=1)
-> Index Scan using p14_idx on prt_p14 t1_14 (cost=0.29..1489.18 rows=94719 width=8) (actual time=0.018..93.727 rows=94719 loops=1)
-> Sort (cost=8112.32..8323.05 rows=84292 width=8) (actual time=35.533..58.852 rows=84292 loops=1)
Sort Key: t1_15.a
Sort Method: quicksort Memory: 7682kB
-> Seq Scan on prt_p21 t1_15 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.012..9.169 rows=84292 loops=1)
-> Index Scan using p15_idx on prt_p15 t1_16 (cost=0.29..1185.09 rows=75372 width=8) (actual time=0.040..72.536 rows=75372 loops=1)
-> Sort (cost=6287.78..6454.05 rows=66508 width=8) (actual time=28.883..46.387 rows=66508 loops=1)
Sort Key: t1_17.a
Sort Method: quicksort Memory: 6710kB
-> Seq Scan on prt_p22 t1_17 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.012..7.491 rows=66508 loops=1)
-> Index Scan using p16_idx on prt_p16 t1_18 (cost=0.29..914.16 rows=58131 width=8) (actual time=0.044..52.853 rows=58131 loops=1)
-> Sort (cost=4600.27..4724.66 rows=49757 width=8) (actual time=19.545..32.830 rows=49757 loops=1)
Sort Key: t1_19.a
Sort Method: quicksort Memory: 4258kB
-> Seq Scan on prt_p23 t1_19 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.012..5.169 rows=49757 loops=1)
-> Index Scan using p17_idx on prt_p17 t1_20 (cost=0.29..663.16 rows=42158 width=8) (actual time=0.038..38.539 rows=42158 loops=1)
-> Index Scan using p18_idx on prt_p18 t1_21 (cost=0.29..552.88 rows=35139 width=8) (actual time=0.018..31.471 rows=35139 loops=1)
-> Sort (cost=2470.87..2540.84 rows=27985 width=8) (actual time=11.580..18.907 rows=27985 loops=1)
Sort Key: t1_22.a
Sort Method: quicksort Memory: 2299kB
-> Seq Scan on prt_p24 t1_22 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.011..2.957 rows=27985 loops=1)
-> Index Scan using p19_idx on prt_p19 t1_23 (cost=0.29..334.77 rows=21259 width=8) (actual time=0.031..17.873 rows=21259 loops=1)
-> Index Scan using p21_idx on prt_p25 t1_24 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.019..22.264 rows=23878 loops=1)
-> Index Scan using p20_idx on prt_p20 t1_25 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.019..1.969 rows=2882 loops=1)
Planning time: 2.711 ms
Execution time: 130427.048 ms
(145 rows)
SET
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=18660.53..4953710.21 rows=360163968 width=16) (actual time=251.802..161469.293 rows=359419719 loops=1)
-> Hash Join (cost=18660.53..1240187.40 rows=88852511 width=16) (actual time=251.801..35274.941 rows=87358315 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p221_idx on prt2_p1 t2 (cost=0.42..5884.45 rows=313782 width=8) (actual time=0.042..856.665 rows=314494 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=9997.27..9997.27 rows=693027 width=8) (actual time=249.930..249.930 rows=693027 loops=1)
Buckets: 1048576 Batches: 1 Memory Usage: 35264kB
-> Seq Scan on prt_p1 t1 (cost=0.00..9997.27 rows=693027 width=8) (actual time=0.010..100.073 rows=693027 loops=1)
-> Hash Join (cost=12692.81..722229.46 rows=55325775 width=16) (actual time=195.998..21646.061 rows=55504542 loops=1)
Hash Cond: (t2_1.b = t1_1.a)
-> Index Scan using p222_idx on prt2_p2 t2_1 (cost=0.42..5428.45 rows=293627 width=8) (actual time=0.143..776.853 rows=293729 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=6799.95..6799.95 rows=471395 width=8) (actual time=160.896..160.896 rows=471395 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 22510kB
-> Seq Scan on prt_p2 t1_1 (cost=0.00..6799.95 rows=471395 width=8) (actual time=0.063..65.367 rows=471395 loops=1)
-> Hash Join (cost=10435.09..555276.33 rows=41063064 width=16) (actual time=132.847..15042.692 rows=41314245 loops=1)
Hash Cond: (t2_2.b = t1_2.a)
-> Index Scan using p223_idx on prt2_p3 t2_2 (cost=0.42..4887.51 rows=265279 width=8) (actual time=0.186..596.976 rows=266162 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5590.41..5590.41 rows=387541 width=8) (actual time=131.654..131.654 rows=387541 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19235kB
-> Seq Scan on prt_p3 t1_2 (cost=0.00..5590.41 rows=387541 width=8) (actual time=0.021..53.803 rows=387541 loops=1)
-> Hash Join (cost=8978.71..428551.82 rows=32351597 width=16) (actual time=153.282..11427.784 rows=32409109 loops=1)
Hash Cond: (t2_3.b = t1_3.a)
-> Index Scan using p224_idx on prt2_p4 t2_3 (cost=0.42..4460.96 rows=242640 width=8) (actual time=2.049..492.631 rows=242756 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4810.35..4810.35 rows=333435 width=8) (actual time=124.255..124.255 rows=333435 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 17121kB
-> Seq Scan on prt_p4 t1_3 (cost=0.00..4810.35 rows=333435 width=8) (actual time=0.041..47.154 rows=333435 loops=1)
-> Hash Join (cost=7869.75..346197.94 rows=26043950 width=16) (actual time=164.032..9655.719 rows=25898163 loops=1)
Hash Cond: (t2_4.b = t1_4.a)
-> Index Scan using p225_idx on prt2_p5 t2_4 (cost=0.42..4090.26 rows=222789 width=8) (actual time=2.228..480.961 rows=221372 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4216.37..4216.37 rows=292237 width=8) (actual time=125.774..125.774 rows=292237 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 15512kB
-> Seq Scan on prt_p5 t1_4 (cost=0.00..4216.37 rows=292237 width=8) (actual time=0.042..48.059 rows=292237 loops=1)
-> Hash Join (cost=11966.50..568150.92 rows=38427514 width=16) (actual time=593.425..12917.076 rows=38668180 loops=1)
Hash Cond: (t1_5.a = t2_5.b)
-> Seq Scan on prt_p6 t1_5 (cost=0.00..7148.22 rows=495522 width=8) (actual time=0.022..87.943 rows=495522 loops=1)
-> Hash (cost=7116.44..7116.44 rows=388005 width=8) (actual time=558.357..558.357 rows=388880 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19287kB
-> Index Scan using p26_idx on prt2_p6 t2_5 (cost=0.42..7116.44 rows=388005 width=8) (actual time=0.081..426.949 rows=388880 loops=1)
Index Cond: (a > 8000)
-> Hash Join (cost=5661.21..188902.16 rows=14376555 width=16) (actual time=72.132..4911.016 rows=14395708 loops=1)
Hash Cond: (t2_6.b = t1_6.a)
-> Index Scan using p27_idx on prt2_p7 t2_6 (cost=0.42..3134.28 rows=171019 width=8) (actual time=0.170..293.342 rows=171000 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=3033.13..3033.13 rows=210213 width=8) (actual time=71.260..71.260 rows=210213 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 10260kB
-> Seq Scan on prt_p7 t1_6 (cost=0.00..3033.13 rows=210213 width=8) (actual time=0.015..29.160 rows=210213 loops=1)
-> Hash Join (cost=9812.96..316264.89 rows=21807961 width=16) (actual time=206.696..8061.683 rows=21873895 loops=1)
Hash Cond: (t2_7.b = t1_7.a)
-> Index Scan using p28_idx on prt2_p8 t2_7 (cost=0.42..5494.15 rows=300013 width=8) (actual time=0.124..514.851 rows=299361 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5257.24..5257.24 rows=364424 width=8) (actual time=174.803..174.803 rows=364424 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 18332kB
-> Seq Scan on prt_p8 t1_7 (cost=0.00..5257.24 rows=364424 width=8) (actual time=0.038..59.793 rows=364424 loops=1)
-> Hash Join (cost=4238.67..113428.51 rows=8239032 width=16) (actual time=80.766..3021.769 rows=8269995 loops=1)
Hash Cond: (t2_8.b = t1_8.a)
-> Index Scan using p29_idx on prt2_p9 t2_8 (cost=0.42..2398.95 rows=131012 width=8) (actual time=0.088..229.177 rows=131315 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2270.89..2270.89 rows=157389 width=8) (actual time=74.652..74.652 rows=157389 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 8197kB
-> Seq Scan on prt_p9 t1_8 (cost=0.00..2270.89 rows=157389 width=8) (actual time=0.043..26.948 rows=157389 loops=1)
-> Hash Join (cost=3815.36..91570.17 rows=6821662 width=16) (actual time=92.549..2776.740 rows=6821467 loops=1)
Hash Cond: (t2_9.b = t1_9.a)
-> Index Scan using p210_idx on prt2_p10 t2_9 (cost=0.42..2206.96 rows=120568 width=8) (actual time=0.058..243.150 rows=120330 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2043.86..2043.86 rows=141686 width=8) (actual time=86.533..86.533 rows=141686 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 7583kB
-> Seq Scan on prt_p10 t1_9 (cost=0.00..2043.86 rows=141686 width=8) (actual time=0.066..27.234 rows=141686 loops=1)
-> Hash Join (cost=3476.94..76351.82 rows=5649049 width=16) (actual time=51.279..2168.916 rows=5648150 loops=1)
Hash Cond: (t2_10.b = t1_10.a)
-> Index Scan using p211_idx on prt2_p11 t2_10 (cost=0.42..2005.05 rows=109560 width=8) (actual time=0.064..202.408 rows=109297 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1862.90..1862.90 rows=129090 width=8) (actual time=48.738..48.738 rows=129090 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 6067kB
-> Seq Scan on prt_p11 t1_10 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.029..20.289 rows=129090 loops=1)
-> Hash Join (cost=3144.68..64789.16 rows=4649539 width=16) (actual time=55.989..1783.048 rows=4658920 loops=1)
Hash Cond: (t2_11.b = t1_11.a)
-> Index Scan using p212_idx on prt2_p12 t2_11 (cost=0.42..1823.33 rows=99635 width=8) (actual time=0.108..177.685 rows=99686 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1684.67..1684.67 rows=116767 width=8) (actual time=51.083..51.083 rows=116767 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5586kB
-> Seq Scan on prt_p12 t1_11 (cost=0.00..1684.67 rows=116767 width=8) (actual time=0.070..19.999 rows=116767 loops=1)
-> Hash Join (cost=2834.72..53113.10 rows=3809063 width=16) (actual time=70.078..1526.819 rows=3824163 loops=1)
Hash Cond: (t2_12.b = t1_12.a)
-> Index Scan using p213_idx on prt2_p13 t2_12 (cost=0.42..1657.66 rows=90585 width=8) (actual time=0.107..156.107 rows=90710 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1518.58..1518.58 rows=105258 width=8) (actual time=67.471..67.471 rows=105258 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5136kB
-> Seq Scan on prt_p13 t1_12 (cost=0.00..1518.58 rows=105258 width=8) (actual time=0.043..20.371 rows=105258 loops=1)
-> Hash Join (cost=2551.47..43708.38 rows=3082164 width=16) (actual time=33.535..1131.062 rows=3083879 loops=1)
Hash Cond: (t2_13.b = t1_13.a)
-> Index Scan using p214_idx on prt2_p14 t2_13 (cost=0.29..1488.21 rows=81355 width=8) (actual time=0.106..117.571 rows=81339 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1367.19..1367.19 rows=94719 width=8) (actual time=32.958..32.958 rows=94719 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4724kB
-> Seq Scan on prt_p14 t1_13 (cost=0.00..1367.19 rows=94719 width=8) (actual time=0.017..13.126 rows=94719 loops=1)
-> Hash Join (cost=2269.57..35319.68 rows=2473278 width=16) (actual time=55.605..903.275 rows=2474533 loops=1)
Hash Cond: (t2_14.b = t1_14.a)
-> Seq Scan on prt2_p21 t2_14 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.023..27.492 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Hash (cost=1215.92..1215.92 rows=84292 width=8) (actual time=34.214..34.214 rows=84292 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4317kB
-> Seq Scan on prt_p21 t1_14 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.064..13.239 rows=84292 loops=1)
-> Hash Join (cost=2030.16..28371.49 rows=1967557 width=16) (actual time=27.311..794.917 rows=1973518 loops=1)
Hash Cond: (t2_15.b = t1_15.a)
-> Index Scan using p215_idx on prt2_p15 t2_15 (cost=0.29..1194.92 rows=65327 width=8) (actual time=0.054..109.894 rows=65345 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1087.72..1087.72 rows=75372 width=8) (actual time=26.490..26.490 rows=75372 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3969kB
-> Seq Scan on prt_p15 t1_15 (cost=0.00..1087.72 rows=75372 width=8) (actual time=0.016..10.576 rows=75372 loops=1)
-> Hash Join (cost=1791.43..22600.42 rows=1552736 width=16) (actual time=41.076..589.705 rows=1552364 loops=1)
Hash Cond: (t2_21.b = t1_16.a)
-> Seq Scan on prt2_p22 t2_21 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.026..25.258 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Hash (cost=960.08..960.08 rows=66508 width=8) (actual time=34.635..34.635 rows=66508 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3622kB
-> Seq Scan on prt_p22 t1_16 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.085..12.529 rows=66508 loops=1)
-> Hash Join (cost=1566.24..17679.57 rows=1186015 width=16) (actual time=39.329..558.974 rows=1186911 loops=1)
Hash Cond: (t2_16.b = t1_17.a)
-> Index Scan using p216_idx on prt2_p16 t2_16 (cost=0.29..933.92 rows=51070 width=8) (actual time=0.129..98.598 rows=51004 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=839.31..839.31 rows=58131 width=8) (actual time=35.384..35.384 rows=58131 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2783kB
-> Seq Scan on prt_p16 t1_17 (cost=0.00..839.31 rows=58131 width=8) (actual time=0.089..12.959 rows=58131 loops=1)
-> Hash Join (cost=1405.50..13539.51 rows=880320 width=16) (actual time=43.285..278.115 rows=885535 loops=1)
Hash Cond: (t1_18.a = t2_22.b)
-> Seq Scan on prt_p23 t1_18 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.017..7.352 rows=49757 loops=1)
-> Hash (cost=852.10..852.10 rows=44272 width=8) (actual time=42.296..42.296 rows=44320 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2244kB
-> Seq Scan on prt2_p23 t2_22 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.027..13.517 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
-> Hash Join (cost=1135.84..9774.24 rows=624675 width=16) (actual time=25.269..273.710 rows=628123 loops=1)
Hash Cond: (t2_17.b = t1_19.a)
-> Index Scan using p217_idx on prt2_p17 t2_17 (cost=0.29..677.86 rows=37061 width=8) (actual time=0.118..46.499 rows=37063 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=608.58..608.58 rows=42158 width=8) (actual time=22.259..22.259 rows=42158 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2159kB
-> Seq Scan on prt_p17 t1_19 (cost=0.00..608.58 rows=42158 width=8) (actual time=0.064..7.910 rows=42158 loops=1)
-> Hash Join (cost=946.92..7198.15 rows=433579 width=16) (actual time=17.113..215.763 rows=435011 loops=1)
Hash Cond: (t2_18.b = t1_20.a)
-> Index Scan using p218_idx on prt2_p18 t2_18 (cost=0.29..564.77 rows=30879 width=8) (actual time=0.330..44.271 rows=30844 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=507.39..507.39 rows=35139 width=8) (actual time=16.064..16.064 rows=35139 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 1885kB
-> Seq Scan on prt_p18 t1_20 (cost=0.00..507.39 rows=35139 width=8) (actual time=0.019..5.693 rows=35139 loops=1)
-> Hash Join (cost=753.66..4859.50 rows=276812 width=16) (actual time=19.792..103.634 rows=278020 loops=1)
Hash Cond: (t2_23.b = t1_21.a)
-> Seq Scan on prt2_p24 t2_23 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.032..6.700 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Hash (cost=403.85..403.85 rows=27985 width=8) (actual time=17.522..17.522 rows=27985 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1350kB
-> Seq Scan on prt_p24 t1_21 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.031..5.064 rows=27985 loops=1)
-> Hash Join (cost=573.62..3057.67 rows=161419 width=16) (actual time=33.268..119.546 rows=163200 loops=1)
Hash Cond: (t2_19.b = t1_22.a)
-> Index Scan using p219_idx on prt2_p19 t2_19 (cost=0.29..347.74 rows=18997 width=8) (actual time=2.479..29.640 rows=18995 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=307.59..307.59 rows=21259 width=8) (actual time=24.962..24.962 rows=21259 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1087kB
-> Seq Scan on prt_p19 t1_22 (cost=0.00..307.59 rows=21259 width=8) (actual time=0.026..3.988 rows=21259 loops=1)
-> Merge Join (cost=0.57..2413.81 rows=103419 width=16) (actual time=0.130..109.054 rows=110092 loops=1)
Merge Cond: (t2_24.b = t1_23.a)
-> Index Scan using np235_idx on prt2_p25 t2_24 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.072..30.355 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=0.29..435.59 rows=23878 width=8) (actual time=0.051..39.419 rows=110599 loops=1)
-> Index Scan using p21_idx on prt_p25 t1_23 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.040..27.578 rows=23878 loops=1)
-> Merge Join (cost=0.56..174.11 rows=4722 width=16) (actual time=0.074..9.963 rows=3681 loops=1)
Merge Cond: (t2_20.b = t1_24.a)
-> Index Scan using np220_idx on prt2_p20 t2_20 (cost=0.28..51.36 rows=2499 width=8) (actual time=0.044..3.405 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Materialize (cost=0.28..53.02 rows=2882 width=8) (actual time=0.027..3.957 rows=4553 loops=1)
-> Index Scan using p20_idx on prt_p20 t1_24 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.024..3.077 rows=2882 loops=1)
Planning time: 13.555 ms
Execution time: 175664.802 ms
(182 rows)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=18660.53..4953710.21 rows=360163968 width=16) (actual time=317.920..174545.808 rows=359419719 loops=1)
-> Hash Join (cost=18660.53..1240187.40 rows=88852511 width=16) (actual time=317.919..37524.262 rows=87358315 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p221_idx on prt2_p1 t2 (cost=0.42..5884.45 rows=313782 width=8) (actual time=0.066..934.255 rows=314494 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=9997.27..9997.27 rows=693027 width=8) (actual time=315.282..315.282 rows=693027 loops=1)
Buckets: 1048576 Batches: 1 Memory Usage: 35264kB
-> Seq Scan on prt_p1 t1 (cost=0.00..9997.27 rows=693027 width=8) (actual time=0.018..126.234 rows=693027 loops=1)
-> Hash Join (cost=12692.81..722229.46 rows=55325775 width=16) (actual time=175.765..22063.584 rows=55504542 loops=1)
Hash Cond: (t2_1.b = t1_1.a)
-> Index Scan using p222_idx on prt2_p2 t2_1 (cost=0.42..5428.45 rows=293627 width=8) (actual time=0.061..691.735 rows=293729 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=6799.95..6799.95 rows=471395 width=8) (actual time=174.563..174.563 rows=471395 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 22510kB
-> Seq Scan on prt_p2 t1_1 (cost=0.00..6799.95 rows=471395 width=8) (actual time=0.020..70.539 rows=471395 loops=1)
-> Hash Join (cost=10435.09..555276.33 rows=41063064 width=16) (actual time=198.010..17111.768 rows=41314245 loops=1)
Hash Cond: (t2_2.b = t1_2.a)
-> Index Scan using p223_idx on prt2_p3 t2_2 (cost=0.42..4887.51 rows=265279 width=8) (actual time=0.097..616.403 rows=266162 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5590.41..5590.41 rows=387541 width=8) (actual time=163.304..163.304 rows=387541 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19235kB
-> Seq Scan on prt_p3 t1_2 (cost=0.00..5590.41 rows=387541 width=8) (actual time=0.057..63.658 rows=387541 loops=1)
-> Hash Join (cost=8978.71..428551.82 rows=32351597 width=16) (actual time=162.694..13972.090 rows=32409109 loops=1)
Hash Cond: (t2_3.b = t1_3.a)
-> Index Scan using p224_idx on prt2_p4 t2_3 (cost=0.42..4460.96 rows=242640 width=8) (actual time=0.169..592.161 rows=242756 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4810.35..4810.35 rows=333435 width=8) (actual time=161.378..161.378 rows=333435 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 17121kB
-> Seq Scan on prt_p4 t1_3 (cost=0.00..4810.35 rows=333435 width=8) (actual time=0.019..66.906 rows=333435 loops=1)
-> Hash Join (cost=7869.75..346197.94 rows=26043950 width=16) (actual time=99.360..10976.867 rows=25898163 loops=1)
Hash Cond: (t2_4.b = t1_4.a)
-> Index Scan using p225_idx on prt2_p5 t2_4 (cost=0.42..4090.26 rows=222789 width=8) (actual time=0.063..529.429 rows=221372 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4216.37..4216.37 rows=292237 width=8) (actual time=98.408..98.408 rows=292237 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 15512kB
-> Seq Scan on prt_p5 t1_4 (cost=0.00..4216.37 rows=292237 width=8) (actual time=0.017..40.360 rows=292237 loops=1)
-> Hash Join (cost=11966.50..568150.92 rows=38427514 width=16) (actual time=629.515..14088.511 rows=38668180 loops=1)
Hash Cond: (t1_5.a = t2_5.b)
-> Seq Scan on prt_p6 t1_5 (cost=0.00..7148.22 rows=495522 width=8) (actual time=0.025..109.451 rows=495522 loops=1)
-> Hash (cost=7116.44..7116.44 rows=388005 width=8) (actual time=628.483..628.483 rows=388880 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19287kB
-> Index Scan using p26_idx on prt2_p6 t2_5 (cost=0.42..7116.44 rows=388005 width=8) (actual time=0.064..492.851 rows=388880 loops=1)
Index Cond: (a > 8000)
-> Hash Join (cost=5661.21..188902.16 rows=14376555 width=16) (actual time=80.732..5444.348 rows=14395708 loops=1)
Hash Cond: (t2_6.b = t1_6.a)
-> Index Scan using p27_idx on prt2_p7 t2_6 (cost=0.42..3134.28 rows=171019 width=8) (actual time=0.070..312.692 rows=171000 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=3033.13..3033.13 rows=210213 width=8) (actual time=80.058..80.058 rows=210213 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 10260kB
-> Seq Scan on prt_p7 t1_6 (cost=0.00..3033.13 rows=210213 width=8) (actual time=0.014..33.330 rows=210213 loops=1)
-> Hash Join (cost=9812.96..316264.89 rows=21807961 width=16) (actual time=170.204..9039.580 rows=21873895 loops=1)
Hash Cond: (t2_7.b = t1_7.a)
-> Index Scan using p28_idx on prt2_p8 t2_7 (cost=0.42..5494.15 rows=300013 width=8) (actual time=0.069..579.082 rows=299361 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5257.24..5257.24 rows=364424 width=8) (actual time=142.713..142.713 rows=364424 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 18332kB
-> Seq Scan on prt_p8 t1_7 (cost=0.00..5257.24 rows=364424 width=8) (actual time=0.074..57.900 rows=364424 loops=1)
-> Hash Join (cost=4238.67..113428.51 rows=8239032 width=16) (actual time=65.221..3320.655 rows=8269995 loops=1)
Hash Cond: (t2_8.b = t1_8.a)
-> Index Scan using p29_idx on prt2_p9 t2_8 (cost=0.42..2398.95 rows=131012 width=8) (actual time=0.056..231.915 rows=131315 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2270.89..2270.89 rows=157389 width=8) (actual time=64.485..64.485 rows=157389 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 8197kB
-> Seq Scan on prt_p9 t1_8 (cost=0.00..2270.89 rows=157389 width=8) (actual time=0.019..26.632 rows=157389 loops=1)
-> Hash Join (cost=3815.36..91570.17 rows=6821662 width=16) (actual time=56.685..2819.337 rows=6821467 loops=1)
Hash Cond: (t2_9.b = t1_9.a)
-> Index Scan using p210_idx on prt2_p10 t2_9 (cost=0.42..2206.96 rows=120568 width=8) (actual time=0.066..215.492 rows=120330 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2043.86..2043.86 rows=141686 width=8) (actual time=55.864..55.864 rows=141686 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 7583kB
-> Seq Scan on prt_p10 t1_9 (cost=0.00..2043.86 rows=141686 width=8) (actual time=0.020..23.107 rows=141686 loops=1)
-> Hash Join (cost=3476.94..76351.82 rows=5649049 width=16) (actual time=49.430..2340.281 rows=5648150 loops=1)
Hash Cond: (t2_10.b = t1_10.a)
-> Index Scan using p211_idx on prt2_p11 t2_10 (cost=0.42..2005.05 rows=109560 width=8) (actual time=0.079..194.784 rows=109297 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1862.90..1862.90 rows=129090 width=8) (actual time=48.878..48.878 rows=129090 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 6067kB
-> Seq Scan on prt_p11 t1_10 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.039..20.231 rows=129090 loops=1)
-> Hash Join (cost=3144.68..64789.16 rows=4649539 width=16) (actual time=45.200..1955.378 rows=4658920 loops=1)
Hash Cond: (t2_11.b = t1_11.a)
-> Index Scan using p212_idx on prt2_p12 t2_11 (cost=0.42..1823.33 rows=99635 width=8) (actual time=0.058..178.714 rows=99686 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1684.67..1684.67 rows=116767 width=8) (actual time=44.807..44.807 rows=116767 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5586kB
-> Seq Scan on prt_p12 t1_11 (cost=0.00..1684.67 rows=116767 width=8) (actual time=0.020..18.568 rows=116767 loops=1)
-> Hash Join (cost=2834.72..53113.10 rows=3809063 width=16) (actual time=40.172..1347.919 rows=3824163 loops=1)
Hash Cond: (t2_12.b = t1_12.a)
-> Index Scan using p213_idx on prt2_p13 t2_12 (cost=0.42..1657.66 rows=90585 width=8) (actual time=0.066..115.270 rows=90710 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1518.58..1518.58 rows=105258 width=8) (actual time=39.775..39.775 rows=105258 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5136kB
-> Seq Scan on prt_p13 t1_12 (cost=0.00..1518.58 rows=105258 width=8) (actual time=0.017..15.990 rows=105258 loops=1)
-> Hash Join (cost=2551.47..43708.38 rows=3082164 width=16) (actual time=31.980..1056.526 rows=3083879 loops=1)
Hash Cond: (t2_13.b = t1_13.a)
-> Index Scan using p214_idx on prt2_p14 t2_13 (cost=0.29..1488.21 rows=81355 width=8) (actual time=0.056..95.317 rows=81339 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1367.19..1367.19 rows=94719 width=8) (actual time=31.536..31.536 rows=94719 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4724kB
-> Seq Scan on prt_p14 t1_13 (cost=0.00..1367.19 rows=94719 width=8) (actual time=0.019..13.090 rows=94719 loops=1)
-> Hash Join (cost=2269.57..35319.68 rows=2473278 width=16) (actual time=113.207..834.038 rows=2474533 loops=1)
Hash Cond: (t2_14.b = t1_14.a)
-> Seq Scan on prt2_p21 t2_14 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.022..19.964 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Hash (cost=1215.92..1215.92 rows=84292 width=8) (actual time=105.301..105.301 rows=84292 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4317kB
-> Seq Scan on prt_p21 t1_14 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.044..16.199 rows=84292 loops=1)
-> Hash Join (cost=2030.16..28371.49 rows=1967557 width=16) (actual time=84.517..761.671 rows=1973518 loops=1)
Hash Cond: (t2_15.b = t1_15.a)
-> Index Scan using p215_idx on prt2_p15 t2_15 (cost=0.29..1194.92 rows=65327 width=8) (actual time=0.195..75.516 rows=65345 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1087.72..1087.72 rows=75372 width=8) (actual time=83.956..83.956 rows=75372 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3969kB
-> Seq Scan on prt_p15 t1_15 (cost=0.00..1087.72 rows=75372 width=8) (actual time=0.019..14.164 rows=75372 loops=1)
-> Hash Join (cost=1791.43..22600.42 rows=1552736 width=16) (actual time=22.532..461.814 rows=1552364 loops=1)
Hash Cond: (t2_21.b = t1_16.a)
-> Seq Scan on prt2_p22 t2_21 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.021..15.162 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Hash (cost=960.08..960.08 rows=66508 width=8) (actual time=22.142..22.142 rows=66508 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3622kB
-> Seq Scan on prt_p22 t1_16 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.016..9.321 rows=66508 loops=1)
-> Hash Join (cost=1566.24..17679.57 rows=1186015 width=16) (actual time=52.511..448.909 rows=1186911 loops=1)
Hash Cond: (t2_16.b = t1_17.a)
-> Index Scan using p216_idx on prt2_p16 t2_16 (cost=0.29..933.92 rows=51070 width=8) (actual time=0.059..54.422 rows=51004 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=839.31..839.31 rows=58131 width=8) (actual time=52.275..52.275 rows=58131 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2783kB
-> Seq Scan on prt_p16 t1_17 (cost=0.00..839.31 rows=58131 width=8) (actual time=0.013..10.060 rows=58131 loops=1)
-> Hash Join (cost=1405.50..13539.51 rows=880320 width=16) (actual time=50.332..276.160 rows=885535 loops=1)
Hash Cond: (t1_18.a = t2_22.b)
-> Seq Scan on prt_p23 t1_18 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.018..6.663 rows=49757 loops=1)
-> Hash (cost=852.10..852.10 rows=44272 width=8) (actual time=50.084..50.084 rows=44320 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2244kB
-> Seq Scan on prt2_p23 t2_22 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.019..13.533 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
-> Hash Join (cost=1135.84..9774.24 rows=624675 width=16) (actual time=14.229..210.572 rows=628123 loops=1)
Hash Cond: (t2_17.b = t1_19.a)
-> Index Scan using p217_idx on prt2_p17 t2_17 (cost=0.29..677.86 rows=37061 width=8) (actual time=0.059..32.338 rows=37063 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=608.58..608.58 rows=42158 width=8) (actual time=13.923..13.923 rows=42158 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2159kB
-> Seq Scan on prt_p17 t1_19 (cost=0.00..608.58 rows=42158 width=8) (actual time=0.019..5.852 rows=42158 loops=1)
-> Hash Join (cost=946.92..7198.15 rows=433579 width=16) (actual time=28.787..171.833 rows=435011 loops=1)
Hash Cond: (t2_18.b = t1_20.a)
-> Index Scan using p218_idx on prt2_p18 t2_18 (cost=0.29..564.77 rows=30879 width=8) (actual time=2.145..29.588 rows=30844 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=507.39..507.39 rows=35139 width=8) (actual time=17.621..17.621 rows=35139 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 1885kB
-> Seq Scan on prt_p18 t1_20 (cost=0.00..507.39 rows=35139 width=8) (actual time=0.042..6.194 rows=35139 loops=1)
-> Hash Join (cost=753.66..4859.50 rows=276812 width=16) (actual time=9.631..82.184 rows=278020 loops=1)
Hash Cond: (t2_23.b = t1_21.a)
-> Seq Scan on prt2_p24 t2_23 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.021..5.722 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Hash (cost=403.85..403.85 rows=27985 width=8) (actual time=9.504..9.504 rows=27985 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1350kB
-> Seq Scan on prt_p24 t1_21 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.011..4.016 rows=27985 loops=1)
-> Hash Join (cost=573.62..3057.67 rows=161419 width=16) (actual time=7.193..67.341 rows=163200 loops=1)
Hash Cond: (t2_19.b = t1_22.a)
-> Index Scan using p219_idx on prt2_p19 t2_19 (cost=0.29..347.74 rows=18997 width=8) (actual time=0.057..15.587 rows=18995 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=307.59..307.59 rows=21259 width=8) (actual time=7.035..7.035 rows=21259 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1087kB
-> Seq Scan on prt_p19 t1_22 (cost=0.00..307.59 rows=21259 width=8) (actual time=0.013..2.952 rows=21259 loops=1)
-> Merge Join (cost=0.57..2413.81 rows=103419 width=16) (actual time=0.226..88.763 rows=110092 loops=1)
Merge Cond: (t2_24.b = t1_23.a)
-> Index Scan using np235_idx on prt2_p25 t2_24 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.123..22.614 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=0.29..435.59 rows=23878 width=8) (actual time=0.098..30.762 rows=110599 loops=1)
-> Index Scan using p21_idx on prt_p25 t1_23 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.069..20.333 rows=23878 loops=1)
-> Merge Join (cost=0.56..174.11 rows=4722 width=16) (actual time=2.285..9.286 rows=3681 loops=1)
Merge Cond: (t2_20.b = t1_24.a)
-> Index Scan using np220_idx on prt2_p20 t2_20 (cost=0.28..51.36 rows=2499 width=8) (actual time=2.198..4.429 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Materialize (cost=0.28..53.02 rows=2882 width=8) (actual time=0.080..2.898 rows=4553 loops=1)
-> Index Scan using p20_idx on prt_p20 t1_24 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.040..2.190 rows=2882 loops=1)
Planning time: 16.155 ms
Execution time: 189801.599 ms
(182 rows)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=18660.53..4953710.21 rows=360163968 width=16) (actual time=283.106..157872.753 rows=359419719 loops=1)
-> Hash Join (cost=18660.53..1240187.40 rows=88852511 width=16) (actual time=283.106..34472.510 rows=87358315 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p221_idx on prt2_p1 t2 (cost=0.42..5884.45 rows=313782 width=8) (actual time=0.034..764.270 rows=314494 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=9997.27..9997.27 rows=693027 width=8) (actual time=281.112..281.112 rows=693027 loops=1)
Buckets: 1048576 Batches: 1 Memory Usage: 35264kB
-> Seq Scan on prt_p1 t1 (cost=0.00..9997.27 rows=693027 width=8) (actual time=0.014..113.273 rows=693027 loops=1)
-> Hash Join (cost=12692.81..722229.46 rows=55325775 width=16) (actual time=164.077..20600.028 rows=55504542 loops=1)
Hash Cond: (t2_1.b = t1_1.a)
-> Index Scan using p222_idx on prt2_p2 t2_1 (cost=0.42..5428.45 rows=293627 width=8) (actual time=0.065..593.303 rows=293729 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=6799.95..6799.95 rows=471395 width=8) (actual time=162.858..162.858 rows=471395 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 22510kB
-> Seq Scan on prt_p2 t1_1 (cost=0.00..6799.95 rows=471395 width=8) (actual time=0.024..66.371 rows=471395 loops=1)
-> Hash Join (cost=10435.09..555276.33 rows=41063064 width=16) (actual time=133.343..14804.416 rows=41314245 loops=1)
Hash Cond: (t2_2.b = t1_2.a)
-> Index Scan using p223_idx on prt2_p3 t2_2 (cost=0.42..4887.51 rows=265279 width=8) (actual time=0.057..482.791 rows=266162 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5590.41..5590.41 rows=387541 width=8) (actual time=132.267..132.267 rows=387541 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19235kB
-> Seq Scan on prt_p3 t1_2 (cost=0.00..5590.41 rows=387541 width=8) (actual time=0.022..54.658 rows=387541 loops=1)
-> Hash Join (cost=8978.71..428551.82 rows=32351597 width=16) (actual time=123.166..11411.563 rows=32409109 loops=1)
Hash Cond: (t2_3.b = t1_3.a)
-> Index Scan using p224_idx on prt2_p4 t2_3 (cost=0.42..4460.96 rows=242640 width=8) (actual time=0.048..415.639 rows=242756 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4810.35..4810.35 rows=333435 width=8) (actual time=122.083..122.083 rows=333435 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 17121kB
-> Seq Scan on prt_p4 t1_3 (cost=0.00..4810.35 rows=333435 width=8) (actual time=0.025..50.649 rows=333435 loops=1)
-> Hash Join (cost=7869.75..346197.94 rows=26043950 width=16) (actual time=104.714..9339.016 rows=25898163 loops=1)
Hash Cond: (t2_4.b = t1_4.a)
-> Index Scan using p225_idx on prt2_p5 t2_4 (cost=0.42..4090.26 rows=222789 width=8) (actual time=0.071..397.736 rows=221372 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4216.37..4216.37 rows=292237 width=8) (actual time=103.645..103.645 rows=292237 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 15512kB
-> Seq Scan on prt_p5 t1_4 (cost=0.00..4216.37 rows=292237 width=8) (actual time=0.025..42.593 rows=292237 loops=1)
-> Hash Join (cost=11966.50..568150.92 rows=38427514 width=16) (actual time=575.669..13192.879 rows=38668180 loops=1)
Hash Cond: (t1_5.a = t2_5.b)
-> Seq Scan on prt_p6 t1_5 (cost=0.00..7148.22 rows=495522 width=8) (actual time=0.029..94.708 rows=495522 loops=1)
-> Hash (cost=7116.44..7116.44 rows=388005 width=8) (actual time=554.932..554.932 rows=388880 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19287kB
-> Index Scan using p26_idx on prt2_p6 t2_5 (cost=0.42..7116.44 rows=388005 width=8) (actual time=0.116..433.145 rows=388880 loops=1)
Index Cond: (a > 8000)
-> Hash Join (cost=5661.21..188902.16 rows=14376555 width=16) (actual time=71.405..5016.190 rows=14395708 loops=1)
Hash Cond: (t2_6.b = t1_6.a)
-> Index Scan using p27_idx on prt2_p7 t2_6 (cost=0.42..3134.28 rows=171019 width=8) (actual time=0.073..246.946 rows=171000 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=3033.13..3033.13 rows=210213 width=8) (actual time=70.519..70.519 rows=210213 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 10260kB
-> Seq Scan on prt_p7 t1_6 (cost=0.00..3033.13 rows=210213 width=8) (actual time=0.017..28.824 rows=210213 loops=1)
-> Hash Join (cost=9812.96..316264.89 rows=21807961 width=16) (actual time=163.218..8751.476 rows=21873895 loops=1)
Hash Cond: (t2_7.b = t1_7.a)
-> Index Scan using p28_idx on prt2_p8 t2_7 (cost=0.42..5494.15 rows=300013 width=8) (actual time=0.091..497.462 rows=299361 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5257.24..5257.24 rows=364424 width=8) (actual time=130.196..130.196 rows=364424 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 18332kB
-> Seq Scan on prt_p8 t1_7 (cost=0.00..5257.24 rows=364424 width=8) (actual time=0.044..52.417 rows=364424 loops=1)
-> Hash Join (cost=4238.67..113428.51 rows=8239032 width=16) (actual time=61.998..3013.868 rows=8269995 loops=1)
Hash Cond: (t2_8.b = t1_8.a)
-> Index Scan using p29_idx on prt2_p9 t2_8 (cost=0.42..2398.95 rows=131012 width=8) (actual time=0.053..189.713 rows=131315 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2270.89..2270.89 rows=157389 width=8) (actual time=61.146..61.146 rows=157389 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 8197kB
-> Seq Scan on prt_p9 t1_8 (cost=0.00..2270.89 rows=157389 width=8) (actual time=0.021..24.708 rows=157389 loops=1)
-> Hash Join (cost=3815.36..91570.17 rows=6821662 width=16) (actual time=52.278..2460.061 rows=6821467 loops=1)
Hash Cond: (t2_9.b = t1_9.a)
-> Index Scan using p210_idx on prt2_p10 t2_9 (cost=0.42..2206.96 rows=120568 width=8) (actual time=0.062..167.499 rows=120330 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2043.86..2043.86 rows=141686 width=8) (actual time=51.522..51.522 rows=141686 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 7583kB
-> Seq Scan on prt_p10 t1_9 (cost=0.00..2043.86 rows=141686 width=8) (actual time=0.026..20.405 rows=141686 loops=1)
-> Hash Join (cost=3476.94..76351.82 rows=5649049 width=16) (actual time=44.454..1998.464 rows=5648150 loops=1)
Hash Cond: (t2_10.b = t1_10.a)
-> Index Scan using p211_idx on prt2_p11 t2_10 (cost=0.42..2005.05 rows=109560 width=8) (actual time=0.058..150.887 rows=109297 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1862.90..1862.90 rows=129090 width=8) (actual time=44.032..44.032 rows=129090 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 6067kB
-> Seq Scan on prt_p11 t1_10 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.017..18.144 rows=129090 loops=1)
-> Hash Join (cost=3144.68..64789.16 rows=4649539 width=16) (actual time=39.489..1602.234 rows=4658920 loops=1)
Hash Cond: (t2_11.b = t1_11.a)
-> Index Scan using p212_idx on prt2_p12 t2_11 (cost=0.42..1823.33 rows=99635 width=8) (actual time=0.104..127.661 rows=99686 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1684.67..1684.67 rows=116767 width=8) (actual time=39.015..39.015 rows=116767 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5586kB
-> Seq Scan on prt_p12 t1_11 (cost=0.00..1684.67 rows=116767 width=8) (actual time=0.019..16.230 rows=116767 loops=1)
-> Hash Join (cost=2834.72..53113.10 rows=3809063 width=16) (actual time=36.704..1303.619 rows=3824163 loops=1)
Hash Cond: (t2_12.b = t1_12.a)
-> Index Scan using p213_idx on prt2_p13 t2_12 (cost=0.42..1657.66 rows=90585 width=8) (actual time=0.077..109.438 rows=90710 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1518.58..1518.58 rows=105258 width=8) (actual time=36.196..36.196 rows=105258 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5136kB
-> Seq Scan on prt_p13 t1_12 (cost=0.00..1518.58 rows=105258 width=8) (actual time=0.023..15.156 rows=105258 loops=1)
-> Hash Join (cost=2551.47..43708.38 rows=3082164 width=16) (actual time=31.854..1019.718 rows=3083879 loops=1)
Hash Cond: (t2_13.b = t1_13.a)
-> Index Scan using p214_idx on prt2_p14 t2_13 (cost=0.29..1488.21 rows=81355 width=8) (actual time=0.054..93.624 rows=81339 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1367.19..1367.19 rows=94719 width=8) (actual time=31.413..31.413 rows=94719 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4724kB
-> Seq Scan on prt_p14 t1_13 (cost=0.00..1367.19 rows=94719 width=8) (actual time=0.018..13.012 rows=94719 loops=1)
-> Hash Join (cost=2269.57..35319.68 rows=2473278 width=16) (actual time=27.872..726.746 rows=2474533 loops=1)
Hash Cond: (t2_14.b = t1_14.a)
-> Seq Scan on prt2_p21 t2_14 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.021..19.829 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Hash (cost=1215.92..1215.92 rows=84292 width=8) (actual time=27.524..27.524 rows=84292 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4317kB
-> Seq Scan on prt_p21 t1_14 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.013..11.214 rows=84292 loops=1)
-> Hash Join (cost=2030.16..28371.49 rows=1967557 width=16) (actual time=26.307..652.479 rows=1973518 loops=1)
Hash Cond: (t2_15.b = t1_15.a)
-> Index Scan using p215_idx on prt2_p15 t2_15 (cost=0.29..1194.92 rows=65327 width=8) (actual time=0.100..67.971 rows=65345 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1087.72..1087.72 rows=75372 width=8) (actual time=25.897..25.897 rows=75372 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3969kB
-> Seq Scan on prt_p15 t1_15 (cost=0.00..1087.72 rows=75372 width=8) (actual time=0.014..10.779 rows=75372 loops=1)
-> Hash Join (cost=1791.43..22600.42 rows=1552736 width=16) (actual time=26.934..455.218 rows=1552364 loops=1)
Hash Cond: (t2_21.b = t1_16.a)
-> Seq Scan on prt2_p22 t2_21 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.020..15.358 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Hash (cost=960.08..960.08 rows=66508 width=8) (actual time=26.581..26.581 rows=66508 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3622kB
-> Seq Scan on prt_p22 t1_16 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.013..11.059 rows=66508 loops=1)
-> Hash Join (cost=1566.24..17679.57 rows=1186015 width=16) (actual time=19.194..409.473 rows=1186911 loops=1)
Hash Cond: (t2_16.b = t1_17.a)
-> Index Scan using p216_idx on prt2_p16 t2_16 (cost=0.29..933.92 rows=51070 width=8) (actual time=0.057..52.300 rows=51004 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=839.31..839.31 rows=58131 width=8) (actual time=18.958..18.958 rows=58131 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2783kB
-> Seq Scan on prt_p16 t1_17 (cost=0.00..839.31 rows=58131 width=8) (actual time=0.014..7.924 rows=58131 loops=1)
-> Hash Join (cost=1405.50..13539.51 rows=880320 width=16) (actual time=155.063..381.074 rows=885535 loops=1)
Hash Cond: (t1_18.a = t2_22.b)
-> Seq Scan on prt_p23 t1_18 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.017..6.654 rows=49757 loops=1)
-> Hash (cost=852.10..852.10 rows=44272 width=8) (actual time=111.851..111.851 rows=44320 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2244kB
-> Seq Scan on prt2_p23 t2_22 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.062..11.136 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
-> Hash Join (cost=1135.84..9774.24 rows=624675 width=16) (actual time=15.019..208.676 rows=628123 loops=1)
Hash Cond: (t2_17.b = t1_19.a)
-> Index Scan using p217_idx on prt2_p17 t2_17 (cost=0.29..677.86 rows=37061 width=8) (actual time=0.057..32.455 rows=37063 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=608.58..608.58 rows=42158 width=8) (actual time=14.791..14.791 rows=42158 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2159kB
-> Seq Scan on prt_p17 t1_19 (cost=0.00..608.58 rows=42158 width=8) (actual time=0.013..6.219 rows=42158 loops=1)
-> Hash Join (cost=946.92..7198.15 rows=433579 width=16) (actual time=11.682..160.845 rows=435011 loops=1)
Hash Cond: (t2_18.b = t1_20.a)
-> Index Scan using p218_idx on prt2_p18 t2_18 (cost=0.29..564.77 rows=30879 width=8) (actual time=0.050..28.667 rows=30844 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=507.39..507.39 rows=35139 width=8) (actual time=11.468..11.468 rows=35139 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 1885kB
-> Seq Scan on prt_p18 t1_20 (cost=0.00..507.39 rows=35139 width=8) (actual time=0.014..4.830 rows=35139 loops=1)
-> Hash Join (cost=753.66..4859.50 rows=276812 width=16) (actual time=10.073..84.817 rows=278020 loops=1)
Hash Cond: (t2_23.b = t1_21.a)
-> Seq Scan on prt2_p24 t2_23 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.027..5.883 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Hash (cost=403.85..403.85 rows=27985 width=8) (actual time=9.937..9.937 rows=27985 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1350kB
-> Seq Scan on prt_p24 t1_21 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.012..4.159 rows=27985 loops=1)
-> Hash Join (cost=573.62..3057.67 rows=161419 width=16) (actual time=7.324..66.235 rows=163200 loops=1)
Hash Cond: (t2_19.b = t1_22.a)
-> Index Scan using p219_idx on prt2_p19 t2_19 (cost=0.29..347.74 rows=18997 width=8) (actual time=0.055..15.267 rows=18995 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=307.59..307.59 rows=21259 width=8) (actual time=7.169..7.169 rows=21259 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1087kB
-> Seq Scan on prt_p19 t1_22 (cost=0.00..307.59 rows=21259 width=8) (actual time=0.013..3.019 rows=21259 loops=1)
-> Merge Join (cost=0.57..2413.81 rows=103419 width=16) (actual time=0.080..80.105 rows=110092 loops=1)
Merge Cond: (t2_24.b = t1_23.a)
-> Index Scan using np235_idx on prt2_p25 t2_24 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.044..20.499 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=0.29..435.59 rows=23878 width=8) (actual time=0.031..27.864 rows=110599 loops=1)
-> Index Scan using p21_idx on prt_p25 t1_23 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.027..18.476 rows=23878 loops=1)
-> Merge Join (cost=0.56..174.11 rows=4722 width=16) (actual time=0.071..6.309 rows=3681 loops=1)
Merge Cond: (t2_20.b = t1_24.a)
-> Index Scan using np220_idx on prt2_p20 t2_20 (cost=0.28..51.36 rows=2499 width=8) (actual time=0.043..2.031 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Materialize (cost=0.28..53.02 rows=2882 width=8) (actual time=0.025..2.477 rows=4553 loops=1)
-> Index Scan using p20_idx on prt_p20 t1_24 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.022..1.850 rows=2882 loops=1)
Planning time: 10.039 ms
Execution time: 171725.266 ms
(182 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=18660.53..1240187.40 rows=88852511 width=16) (actual time=247.824..32858.864 rows=87358315 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p221_idx on prt2_p1 t2 (cost=0.42..5884.45 rows=313782 width=8) (actual time=0.024..674.252 rows=314494 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=9997.27..9997.27 rows=693027 width=8) (actual time=245.966..245.966 rows=693027 loops=1)
Buckets: 1048576 Batches: 1 Memory Usage: 35264kB
-> Seq Scan on prt_p1 t1 (cost=0.00..9997.27 rows=693027 width=8) (actual time=0.010..100.439 rows=693027 loops=1)
Planning time: 0.409 ms
Execution time: 36166.129 ms
(9 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=12692.81..722229.46 rows=55325775 width=16) (actual time=164.929..20203.478 rows=55504542 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p222_idx on prt2_p2 t2 (cost=0.42..5428.45 rows=293627 width=8) (actual time=0.033..537.413 rows=293729 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=6799.95..6799.95 rows=471395 width=8) (actual time=164.004..164.004 rows=471395 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 22510kB
-> Seq Scan on prt_p2 t1 (cost=0.00..6799.95 rows=471395 width=8) (actual time=0.016..67.598 rows=471395 loops=1)
Planning time: 0.467 ms
Execution time: 22286.889 ms
(9 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=10435.09..555276.33 rows=41063064 width=16) (actual time=133.566..14898.330 rows=41314245 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p223_idx on prt2_p3 t2 (cost=0.42..4887.51 rows=265279 width=8) (actual time=0.042..463.795 rows=266162 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5590.41..5590.41 rows=387541 width=8) (actual time=133.136..133.136 rows=387541 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19235kB
-> Seq Scan on prt_p3 t1 (cost=0.00..5590.41 rows=387541 width=8) (actual time=0.015..54.926 rows=387541 loops=1)
Planning time: 0.591 ms
Execution time: 16427.094 ms
(9 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=8978.71..428551.82 rows=32351597 width=16) (actual time=127.055..11577.800 rows=32409109 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p224_idx on prt2_p4 t2 (cost=0.42..4460.96 rows=242640 width=8) (actual time=0.027..405.365 rows=242756 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4810.35..4810.35 rows=333435 width=8) (actual time=126.178..126.178 rows=333435 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 17121kB
-> Seq Scan on prt_p4 t1 (cost=0.00..4810.35 rows=333435 width=8) (actual time=0.013..51.620 rows=333435 loops=1)
Planning time: 0.462 ms
Execution time: 12759.956 ms
(9 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=7869.75..346197.94 rows=26043950 width=16) (actual time=97.364..8933.962 rows=25898163 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p225_idx on prt2_p5 t2 (cost=0.42..4090.26 rows=222789 width=8) (actual time=0.023..338.840 rows=221372 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=4216.37..4216.37 rows=292237 width=8) (actual time=96.997..96.997 rows=292237 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 15512kB
-> Seq Scan on prt_p5 t1 (cost=0.00..4216.37 rows=292237 width=8) (actual time=0.013..41.886 rows=292237 loops=1)
Planning time: 0.524 ms
Execution time: 9871.598 ms
(9 rows)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=11966.50..568150.92 rows=38427514 width=16) (actual time=474.510..15686.528 rows=38668180 loops=1)
Hash Cond: (t1.a = t2.b)
-> Seq Scan on prt_p6 t1 (cost=0.00..7148.22 rows=495522 width=8) (actual time=0.011..148.443 rows=495522 loops=1)
-> Hash (cost=7116.44..7116.44 rows=388005 width=8) (actual time=474.130..474.130 rows=388880 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 19287kB
-> Index Scan using p26_idx on prt2_p6 t2 (cost=0.42..7116.44 rows=388005 width=8) (actual time=0.037..376.341 rows=388880 loops=1)
Index Cond: (a > 8000)
Planning time: 0.470 ms
Execution time: 17417.343 ms
(9 rows)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=5661.21..188902.16 rows=14376555 width=16) (actual time=96.019..6341.438 rows=14395708 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p27_idx on prt2_p7 t2 (cost=0.42..3134.28 rows=171019 width=8) (actual time=0.050..350.977 rows=171000 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=3033.13..3033.13 rows=210213 width=8) (actual time=95.167..95.167 rows=210213 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 10260kB
-> Seq Scan on prt_p7 t1 (cost=0.00..3033.13 rows=210213 width=8) (actual time=0.019..39.473 rows=210213 loops=1)
Planning time: 0.668 ms
Execution time: 7020.316 ms
(9 rows)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=9812.96..316264.89 rows=21807961 width=16) (actual time=139.323..9699.334 rows=21873895 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p28_idx on prt2_p8 t2 (cost=0.42..5494.15 rows=300013 width=8) (actual time=0.037..607.618 rows=299361 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=5257.24..5257.24 rows=364424 width=8) (actual time=138.855..138.855 rows=364424 loops=1)
Buckets: 524288 Batches: 1 Memory Usage: 18332kB
-> Seq Scan on prt_p8 t1 (cost=0.00..5257.24 rows=364424 width=8) (actual time=0.014..55.194 rows=364424 loops=1)
Planning time: 0.482 ms
Execution time: 10671.136 ms
(9 rows)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=4238.67..113428.51 rows=8239032 width=16) (actual time=56.379..3379.201 rows=8269995 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p29_idx on prt2_p9 t2 (cost=0.42..2398.95 rows=131012 width=8) (actual time=0.028..236.042 rows=131315 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2270.89..2270.89 rows=157389 width=8) (actual time=55.755..55.755 rows=157389 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 8197kB
-> Seq Scan on prt_p9 t1 (cost=0.00..2270.89 rows=157389 width=8) (actual time=0.009..22.987 rows=157389 loops=1)
Planning time: 0.437 ms
Execution time: 3733.582 ms
(9 rows)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=3815.36..91570.17 rows=6821662 width=16) (actual time=49.557..2476.111 rows=6821467 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p210_idx on prt2_p10 t2 (cost=0.42..2206.96 rows=120568 width=8) (actual time=0.030..168.141 rows=120330 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=2043.86..2043.86 rows=141686 width=8) (actual time=49.304..49.304 rows=141686 loops=1)
Buckets: 262144 Batches: 1 Memory Usage: 7583kB
-> Seq Scan on prt_p10 t1 (cost=0.00..2043.86 rows=141686 width=8) (actual time=0.007..21.494 rows=141686 loops=1)
Planning time: 0.502 ms
Execution time: 2743.935 ms
(9 rows)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=3476.94..76351.82 rows=5649049 width=16) (actual time=42.699..2253.144 rows=5648150 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p211_idx on prt2_p11 t2 (cost=0.42..2005.05 rows=109560 width=8) (actual time=0.057..177.263 rows=109297 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1862.90..1862.90 rows=129090 width=8) (actual time=42.540..42.540 rows=129090 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 6067kB
-> Seq Scan on prt_p11 t1 (cost=0.00..1862.90 rows=129090 width=8) (actual time=0.016..18.840 rows=129090 loops=1)
Planning time: 0.457 ms
Execution time: 2501.422 ms
(9 rows)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=3144.68..64789.16 rows=4649539 width=16) (actual time=40.269..1667.263 rows=4658920 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p212_idx on prt2_p12 t2 (cost=0.42..1823.33 rows=99635 width=8) (actual time=0.031..126.356 rows=99686 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1684.67..1684.67 rows=116767 width=8) (actual time=40.144..40.144 rows=116767 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5586kB
-> Seq Scan on prt_p12 t1 (cost=0.00..1684.67 rows=116767 width=8) (actual time=0.007..17.559 rows=116767 loops=1)
Planning time: 0.521 ms
Execution time: 1849.357 ms
(9 rows)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=2834.72..53113.10 rows=3809063 width=16) (actual time=35.445..1417.103 rows=3824163 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p213_idx on prt2_p13 t2 (cost=0.42..1657.66 rows=90585 width=8) (actual time=0.026..116.280 rows=90710 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1518.58..1518.58 rows=105258 width=8) (actual time=35.318..35.318 rows=105258 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 5136kB
-> Seq Scan on prt_p13 t1 (cost=0.00..1518.58 rows=105258 width=8) (actual time=0.011..15.587 rows=105258 loops=1)
Planning time: 0.441 ms
Execution time: 1568.539 ms
(9 rows)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=2551.47..43708.38 rows=3082164 width=16) (actual time=33.774..1085.829 rows=3083879 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p214_idx on prt2_p14 t2 (cost=0.29..1488.21 rows=81355 width=8) (actual time=0.029..96.891 rows=81339 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1367.19..1367.19 rows=94719 width=8) (actual time=33.637..33.637 rows=94719 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4724kB
-> Seq Scan on prt_p14 t1 (cost=0.00..1367.19 rows=94719 width=8) (actual time=0.007..14.716 rows=94719 loops=1)
Planning time: 0.458 ms
Execution time: 1206.220 ms
(9 rows)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=2030.16..28371.49 rows=1967557 width=16) (actual time=28.568..679.734 rows=1973518 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p215_idx on prt2_p15 t2 (cost=0.29..1194.92 rows=65327 width=8) (actual time=0.023..69.662 rows=65345 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=1087.72..1087.72 rows=75372 width=8) (actual time=28.424..28.424 rows=75372 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3969kB
-> Seq Scan on prt_p15 t1 (cost=0.00..1087.72 rows=75372 width=8) (actual time=0.012..12.589 rows=75372 loops=1)
Planning time: 0.445 ms
Execution time: 755.473 ms
(9 rows)
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=1566.24..17679.57 rows=1186015 width=16) (actual time=18.932..407.435 rows=1186911 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p216_idx on prt2_p16 t2 (cost=0.29..933.92 rows=51070 width=8) (actual time=0.032..52.875 rows=51004 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=839.31..839.31 rows=58131 width=8) (actual time=18.828..18.828 rows=58131 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2783kB
-> Seq Scan on prt_p16 t1 (cost=0.00..839.31 rows=58131 width=8) (actual time=0.011..8.342 rows=58131 loops=1)
Planning time: 0.444 ms
Execution time: 452.931 ms
(9 rows)
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=1135.84..9774.24 rows=624675 width=16) (actual time=13.792..224.987 rows=628123 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p217_idx on prt2_p17 t2 (cost=0.29..677.86 rows=37061 width=8) (actual time=0.027..35.088 rows=37063 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=608.58..608.58 rows=42158 width=8) (actual time=13.714..13.714 rows=42158 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2159kB
-> Seq Scan on prt_p17 t1 (cost=0.00..608.58 rows=42158 width=8) (actual time=0.010..6.005 rows=42158 loops=1)
Planning time: 0.404 ms
Execution time: 249.812 ms
(9 rows)
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=946.92..7198.15 rows=433579 width=16) (actual time=11.548..153.121 rows=435011 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p218_idx on prt2_p18 t2 (cost=0.29..564.77 rows=30879 width=8) (actual time=0.022..26.647 rows=30844 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=507.39..507.39 rows=35139 width=8) (actual time=11.469..11.469 rows=35139 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 1885kB
-> Seq Scan on prt_p18 t1 (cost=0.00..507.39 rows=35139 width=8) (actual time=0.011..5.058 rows=35139 loops=1)
Planning time: 0.418 ms
Execution time: 169.427 ms
(9 rows)
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=573.62..3057.67 rows=161419 width=16) (actual time=6.642..65.249 rows=163200 loops=1)
Hash Cond: (t2.b = t1.a)
-> Index Scan using p219_idx on prt2_p19 t2 (cost=0.29..347.74 rows=18997 width=8) (actual time=0.030..15.048 rows=18995 loops=1)
Index Cond: (a > 8000)
-> Hash (cost=307.59..307.59 rows=21259 width=8) (actual time=6.580..6.580 rows=21259 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1087kB
-> Seq Scan on prt_p19 t1 (cost=0.00..307.59 rows=21259 width=8) (actual time=0.012..2.896 rows=21259 loops=1)
Planning time: 0.509 ms
Execution time: 71.776 ms
(9 rows)
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------
Merge Join (cost=0.56..174.11 rows=4722 width=16) (actual time=0.022..6.187 rows=3681 loops=1)
Merge Cond: (t2.b = t1.a)
-> Index Scan using np220_idx on prt2_p20 t2 (cost=0.28..51.36 rows=2499 width=8) (actual time=0.011..1.983 rows=2492 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 292
-> Materialize (cost=0.28..53.02 rows=2882 width=8) (actual time=0.009..2.428 rows=4553 loops=1)
-> Index Scan using p20_idx on prt_p20 t1 (cost=0.28..45.81 rows=2882 width=8) (actual time=0.007..1.819 rows=2882 loops=1)
Planning time: 0.401 ms
Execution time: 6.380 ms
(9 rows)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=2269.57..35319.68 rows=2473278 width=16) (actual time=34.979..768.116 rows=2474533 loops=1)
Hash Cond: (t2.b = t1.a)
-> Seq Scan on prt2_p21 t2 (cost=0.00..1432.24 rows=73441 width=8) (actual time=0.015..20.504 rows=73352 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 11227
-> Hash (cost=1215.92..1215.92 rows=84292 width=8) (actual time=34.859..34.859 rows=84292 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 4317kB
-> Seq Scan on prt_p21 t1 (cost=0.00..1215.92 rows=84292 width=8) (actual time=0.020..15.381 rows=84292 loops=1)
Planning time: 0.192 ms
Execution time: 862.769 ms
(10 rows)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=1791.43..22600.42 rows=1552736 width=16) (actual time=22.116..476.053 rows=1552364 loops=1)
Hash Cond: (t2.b = t1.a)
-> Seq Scan on prt2_p22 t2 (cost=0.00..1125.61 rows=58330 width=8) (actual time=0.017..15.451 rows=58244 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 8205
-> Hash (cost=960.08..960.08 rows=66508 width=8) (actual time=21.990..21.990 rows=66508 loops=1)
Buckets: 131072 Batches: 1 Memory Usage: 3622kB
-> Seq Scan on prt_p22 t1 (cost=0.00..960.08 rows=66508 width=8) (actual time=0.011..9.982 rows=66508 loops=1)
Planning time: 0.214 ms
Execution time: 534.743 ms
(10 rows)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=1405.50..13539.51 rows=880320 width=16) (actual time=19.306..236.209 rows=885535 loops=1)
Hash Cond: (t1.a = t2.b)
-> Seq Scan on prt_p23 t1 (cost=0.00..718.57 rows=49757 width=8) (actual time=0.014..6.375 rows=49757 loops=1)
-> Hash (cost=852.10..852.10 rows=44272 width=8) (actual time=19.235..19.235 rows=44320 loops=1)
Buckets: 65536 Batches: 1 Memory Usage: 2244kB
-> Seq Scan on prt2_p23 t2 (cost=0.00..852.10 rows=44272 width=8) (actual time=0.012..10.982 rows=44320 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 6008
Planning time: 0.225 ms
Execution time: 268.146 ms
(10 rows)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------
Hash Join (cost=753.66..4859.50 rows=276812 width=16) (actual time=10.881..84.828 rows=278020 loops=1)
Hash Cond: (t2.b = t1.a)
-> Seq Scan on prt2_p24 t2 (cost=0.00..472.34 rows=24725 width=8) (actual time=0.018..5.655 rows=24731 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 3136
-> Hash (cost=403.85..403.85 rows=27985 width=8) (actual time=10.820..10.820 rows=27985 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1350kB
-> Seq Scan on prt_p24 t1 (cost=0.00..403.85 rows=27985 width=8) (actual time=0.019..4.847 rows=27985 loops=1)
Planning time: 0.244 ms
Execution time: 94.873 ms
(10 rows)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Merge Join (cost=0.57..2413.81 rows=103419 width=16) (actual time=0.023..83.131 rows=110092 loops=1)
Merge Cond: (t2.b = t1.a)
-> Index Scan using np235_idx on prt2_p25 t2 (cost=0.29..433.67 rows=21185 width=8) (actual time=0.012..21.369 rows=21188 loops=1)
Filter: (a > 8000)
Rows Removed by Filter: 2588
-> Materialize (cost=0.29..435.59 rows=23878 width=8) (actual time=0.009..29.275 rows=110599 loops=1)
-> Index Scan using p21_idx on prt_p25 t1 (cost=0.29..375.90 rows=23878 width=8) (actual time=0.008..19.513 rows=23878 loops=1)
Planning time: 0.483 ms
Execution time: 87.825 ms
(9 rows)