-
-
Save seamusabshere/1c1d869ee24145689f45e4124d8730d3 to your computer and use it in GitHub Desktop.
count example
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- here I query a single partition of the 64 that exist | |
| postgres=# explain analyze select count(*) from test_3pd_cstore_partitioned_7_cstore where age > 50; | |
| QUERY PLAN | |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| Aggregate (cost=56007.38..56007.39 rows=1 width=8) (actual time=959.326..959.326 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_7_cstore (cost=0.00..52516.54 rows=1396337 width=0) (actual time=2.033..818.748 rows=1884736 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2304274 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957582 | |
| CStore File Size: 774152985 | |
| Planning Time: 1.133 ms | |
| Execution Time: 959.503 ms | |
| (8 rows) | |
| Time: 1056.753 ms (00:01.057) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- here's the full query, taking 8 seconds to use 8 workers across 64 partitions | |
| postgres=# explain analyze select count(*) from test_3pd_cstore_partitioned where age > 50; | |
| QUERY PLAN | |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| Finalize Aggregate (cost=558860.96..558860.97 rows=1 width=8) (actual time=8528.509..8538.627 rows=1 loops=1) | |
| -> Gather (cost=56918.65..558860.94 rows=7 width=8) (actual time=1863.462..8538.603 rows=64 loops=1) | |
| Workers Planned: 7 | |
| Workers Launched: 7 | |
| -> Parallel Append (cost=55918.65..557860.24 rows=1 width=8) (actual time=1877.875..8417.486 rows=8 loops=8) | |
| -> Partial Aggregate (cost=56020.35..56020.36 rows=1 width=8) (actual time=1887.367..1887.368 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_52_cstore test_3pd_cstore_partitioned_51 (cost=0.00..52528.70 rows=1396660 width=0) (actual time=950.640..1756.333 rows=1882959 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2307021 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957723 | |
| CStore File Size: 774328384 | |
| -> Partial Aggregate (cost=56007.38..56007.39 rows=1 width=8) (actual time=1883.472..1883.473 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_7_cstore test_3pd_cstore_partitioned_6 (cost=0.00..52516.54 rows=1396337 width=0) (actual time=949.139..1753.384 rows=1884736 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2304274 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957582 | |
| CStore File Size: 774152985 | |
| -> Partial Aggregate (cost=55978.23..55978.24 rows=1 width=8) (actual time=1873.962..1873.963 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_33_cstore test_3pd_cstore_partitioned_32 (cost=0.00..52489.21 rows=1395609 width=0) (actual time=946.249..1743.723 rows=1879366 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2307460 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957665 | |
| CStore File Size: 774002724 | |
| -> Partial Aggregate (cost=55951.99..55952.00 rows=1 width=8) (actual time=1875.643..1875.644 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_15_cstore test_3pd_cstore_partitioned_14 (cost=0.00..52464.61 rows=1394954 width=0) (actual time=941.324..1745.451 rows=1879110 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2305753 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957606 | |
| CStore File Size: 773686048 | |
| -> Partial Aggregate (cost=55941.44..55941.45 rows=1 width=8) (actual time=1887.203..1887.204 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_6_cstore test_3pd_cstore_partitioned_5 (cost=0.00..52454.71 rows=1394692 width=0) (actual time=954.559..1756.704 rows=1884177 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2299899 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957594 | |
| CStore File Size: 773401795 | |
| -> Partial Aggregate (cost=55922.42..55922.43 rows=1 width=8) (actual time=1888.814..1888.815 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_9_cstore test_3pd_cstore_partitioned_8 (cost=0.00..52436.88 rows=1394215 width=0) (actual time=952.845..1758.549 rows=1879867 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2302779 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957585 | |
| CStore File Size: 773605696 | |
| -> Partial Aggregate (cost=55918.65..55918.66 rows=1 width=8) (actual time=1878.554..1878.554 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_29_cstore test_3pd_cstore_partitioned_28 (cost=0.00..52433.34 rows=1394123 width=0) (actual time=945.790..1748.577 rows=1876347 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2306022 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957649 | |
| CStore File Size: 773228505 | |
| -> Partial Aggregate (cost=55915.48..55915.49 rows=1 width=8) (actual time=932.542..932.543 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_13_cstore test_3pd_cstore_partitioned_12 (cost=0.00..52430.37 rows=1394043 width=0) (actual time=2.104..801.955 rows=1882773 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2299356 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957588 | |
| CStore File Size: 773392738 | |
| -> Partial Aggregate (cost=55912.60..55912.61 rows=1 width=8) (actual time=932.782..932.783 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_17_cstore test_3pd_cstore_partitioned_16 (cost=0.00..52427.67 rows=1393972 width=0) (actual time=2.141..801.542 rows=1880654 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2301263 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957616 | |
| CStore File Size: 773120180 | |
| -> Partial Aggregate (cost=55908.87..55908.88 rows=1 width=8) (actual time=929.675..929.675 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_59_cstore test_3pd_cstore_partitioned_58 (cost=0.00..52424.18 rows=1393879 width=0) (actual time=2.099..799.649 rows=1875775 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2305863 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957744 | |
| CStore File Size: 773100574 | |
| -> Partial Aggregate (cost=55897.03..55897.04 rows=1 width=8) (actual time=929.334..929.334 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_48_cstore test_3pd_cstore_partitioned_47 (cost=0.00..52413.07 rows=1393584 width=0) (actual time=2.117..798.330 rows=1876379 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2304372 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957710 | |
| CStore File Size: 773004634 | |
| -> Partial Aggregate (cost=55889.24..55889.25 rows=1 width=8) (actual time=931.986..931.987 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_28_cstore test_3pd_cstore_partitioned_27 (cost=0.00..52405.77 rows=1393390 width=0) (actual time=2.170..801.775 rows=1878741 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2301430 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957652 | |
| CStore File Size: 772749120 | |
| -> Partial Aggregate (cost=55886.99..55887.00 rows=1 width=8) (actual time=927.518..927.519 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_27_cstore test_3pd_cstore_partitioned_26 (cost=0.00..52403.65 rows=1393333 width=0) (actual time=2.206..797.288 rows=1879324 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2300675 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957646 | |
| CStore File Size: 772920247 | |
| -> Partial Aggregate (cost=55880.58..55880.59 rows=1 width=8) (actual time=929.839..929.839 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_14_cstore test_3pd_cstore_partitioned_13 (cost=0.00..52397.64 rows=1393174 width=0) (actual time=2.106..799.725 rows=1877792 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2301730 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957609 | |
| CStore File Size: 772682269 | |
| -> Partial Aggregate (cost=55877.39..55877.40 rows=1 width=8) (actual time=933.984..933.985 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_42_cstore test_3pd_cstore_partitioned_41 (cost=0.00..52394.65 rows=1393093 width=0) (actual time=2.104..803.245 rows=1878711 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2300569 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957692 | |
| CStore File Size: 772855288 | |
| -> Partial Aggregate (cost=55876.39..55876.40 rows=1 width=8) (actual time=936.322..936.322 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_61_cstore test_3pd_cstore_partitioned_60 (cost=0.00..52393.71 rows=1393070 width=0) (actual time=2.167..805.306 rows=1877925 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2301284 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957750 | |
| CStore File Size: 772590266 | |
| -> Partial Aggregate (cost=55871.62..55871.63 rows=1 width=8) (actual time=935.946..935.946 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_51_cstore test_3pd_cstore_partitioned_50 (cost=0.00..52389.24 rows=1392951 width=0) (actual time=2.175..805.438 rows=1880907 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2297947 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957720 | |
| CStore File Size: 772417506 | |
| -> Partial Aggregate (cost=55866.66..55866.67 rows=1 width=8) (actual time=936.135..936.135 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_23_cstore test_3pd_cstore_partitioned_22 (cost=0.00..52384.60 rows=1392825 width=0) (actual time=2.146..805.804 rows=1881235 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2297241 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957634 | |
| CStore File Size: 772844824 | |
| -> Partial Aggregate (cost=55865.76..55865.77 rows=1 width=8) (actual time=935.615..935.616 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_57_cstore test_3pd_cstore_partitioned_56 (cost=0.00..52383.75 rows=1392803 width=0) (actual time=2.121..804.926 rows=1875685 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2302724 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957738 | |
| CStore File Size: 772780470 | |
| -> Partial Aggregate (cost=55852.92..55852.93 rows=1 width=8) (actual time=937.637..937.637 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_43_cstore test_3pd_cstore_partitioned_42 (cost=0.00..52371.71 rows=1392485 width=0) (actual time=2.180..807.150 rows=1877563 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2299891 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957695 | |
| CStore File Size: 772254982 | |
| -> Partial Aggregate (cost=55850.09..55850.10 rows=1 width=8) (actual time=934.647..934.648 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_56_cstore test_3pd_cstore_partitioned_55 (cost=0.00..52369.06 rows=1392412 width=0) (actual time=2.192..803.714 rows=1879648 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2297587 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957735 | |
| CStore File Size: 772721348 | |
| -> Partial Aggregate (cost=55845.77..55845.78 rows=1 width=8) (actual time=934.967..934.968 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_41_cstore test_3pd_cstore_partitioned_40 (cost=0.00..52365.01 rows=1392304 width=0) (actual time=2.122..804.801 rows=1879166 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2297746 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957689 | |
| CStore File Size: 772613569 | |
| -> Partial Aggregate (cost=55845.47..55845.48 rows=1 width=8) (actual time=936.258..936.258 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_20_cstore test_3pd_cstore_partitioned_19 (cost=0.00..52364.73 rows=1392297 width=0) (actual time=2.144..805.232 rows=1880890 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2296002 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957628 | |
| CStore File Size: 772465407 | |
| -> Partial Aggregate (cost=55841.31..55841.32 rows=1 width=8) (actual time=934.155..934.155 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_19_cstore test_3pd_cstore_partitioned_18 (cost=0.00..52360.83 rows=1392194 width=0) (actual time=2.125..804.277 rows=1874631 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2301951 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957622 | |
| CStore File Size: 772339343 | |
| -> Partial Aggregate (cost=55840.79..55840.80 rows=1 width=8) (actual time=934.372..934.372 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_11_cstore test_3pd_cstore_partitioned_10 (cost=0.00..52360.34 rows=1392180 width=0) (actual time=2.123..804.088 rows=1881416 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2295125 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957603 | |
| CStore File Size: 772461828 | |
| -> Partial Aggregate (cost=55836.22..55836.23 rows=1 width=8) (actual time=933.953..933.954 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_50_cstore test_3pd_cstore_partitioned_49 (cost=0.00..52356.05 rows=1392067 width=0) (actual time=2.105..803.583 rows=1874845 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2301357 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957717 | |
| CStore File Size: 772227989 | |
| -> Partial Aggregate (cost=55834.14..55834.15 rows=1 width=8) (actual time=931.993..931.993 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_63_cstore test_3pd_cstore_partitioned_62 (cost=0.00..52354.11 rows=1392014 width=0) (actual time=2.111..801.152 rows=1876772 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2299270 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957759 | |
| CStore File Size: 772489392 | |
| -> Partial Aggregate (cost=55833.78..55833.79 rows=1 width=8) (actual time=934.683..934.683 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_24_cstore test_3pd_cstore_partitioned_23 (cost=0.00..52353.76 rows=1392006 width=0) (actual time=2.141..804.712 rows=1877791 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2298226 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957637 | |
| CStore File Size: 772329010 | |
| -> Partial Aggregate (cost=55827.15..55827.16 rows=1 width=8) (actual time=932.374..932.374 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_40_cstore test_3pd_cstore_partitioned_39 (cost=0.00..52347.55 rows=1391841 width=0) (actual time=2.100..801.263 rows=1879156 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2296366 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957686 | |
| CStore File Size: 772211021 | |
| -> Partial Aggregate (cost=55824.42..55824.43 rows=1 width=8) (actual time=937.845..937.846 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_36_cstore test_3pd_cstore_partitioned_35 (cost=0.00..52344.99 rows=1391772 width=0) (actual time=2.109..805.288 rows=1879337 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2295979 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957674 | |
| CStore File Size: 772274898 | |
| -> Partial Aggregate (cost=55821.83..55821.84 rows=1 width=8) (actual time=933.512..933.512 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_12_cstore test_3pd_cstore_partitioned_11 (cost=0.00..52342.56 rows=1391708 width=0) (actual time=2.096..800.714 rows=1877339 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2297784 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957597 | |
| CStore File Size: 772211191 | |
| -> Partial Aggregate (cost=55815.64..55815.65 rows=1 width=8) (actual time=936.248..936.248 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_22_cstore test_3pd_cstore_partitioned_21 (cost=0.00..52336.76 rows=1391552 width=0) (actual time=2.136..803.150 rows=1876254 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2298403 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957631 | |
| CStore File Size: 772343258 | |
| -> Partial Aggregate (cost=55806.95..55806.96 rows=1 width=8) (actual time=926.716..926.717 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_44_cstore test_3pd_cstore_partitioned_43 (cost=0.00..52328.61 rows=1391337 width=0) (actual time=2.127..792.156 rows=1875915 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2298096 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957698 | |
| CStore File Size: 771936812 | |
| -> Partial Aggregate (cost=55804.96..55804.97 rows=1 width=8) (actual time=936.598..936.599 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_2_cstore test_3pd_cstore_partitioned_1 (cost=0.00..52326.74 rows=1391288 width=0) (actual time=2.106..802.297 rows=1874656 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2299209 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957570 | |
| CStore File Size: 771695016 | |
| -> Partial Aggregate (cost=55792.02..55792.03 rows=1 width=8) (actual time=935.361..935.362 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_64_cstore test_3pd_cstore_partitioned_63 (cost=0.00..52314.61 rows=1390964 width=0) (actual time=2.085..802.323 rows=1876198 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2296694 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957756 | |
| CStore File Size: 771858880 | |
| -> Partial Aggregate (cost=55788.85..55788.86 rows=1 width=8) (actual time=933.229..933.229 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_45_cstore test_3pd_cstore_partitioned_44 (cost=0.00..52311.64 rows=1390885 width=0) (actual time=2.126..800.669 rows=1877574 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2295080 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957701 | |
| CStore File Size: 771892477 | |
| -> Partial Aggregate (cost=55788.81..55788.82 rows=1 width=8) (actual time=936.568..936.568 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_3_cstore test_3pd_cstore_partitioned_2 (cost=0.00..52311.60 rows=1390884 width=0) (actual time=2.152..803.303 rows=1873272 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2299381 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957576 | |
| CStore File Size: 771756281 | |
| -> Partial Aggregate (cost=55788.69..55788.70 rows=1 width=8) (actual time=933.699..933.699 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_47_cstore test_3pd_cstore_partitioned_46 (cost=0.00..52311.49 rows=1390881 width=0) (actual time=2.105..799.874 rows=1881370 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2291272 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957707 | |
| CStore File Size: 771891334 | |
| -> Partial Aggregate (cost=55788.16..55788.17 rows=1 width=8) (actual time=943.266..943.266 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_32_cstore test_3pd_cstore_partitioned_31 (cost=0.00..52310.99 rows=1390868 width=0) (actual time=2.140..809.912 rows=1878576 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2294028 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957661 | |
| CStore File Size: 771793354 | |
| -> Partial Aggregate (cost=55784.69..55784.70 rows=1 width=8) (actual time=928.883..928.883 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_30_cstore test_3pd_cstore_partitioned_29 (cost=0.00..52307.73 rows=1390783 width=0) (actual time=2.145..797.471 rows=1873573 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2298775 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957655 | |
| CStore File Size: 771491906 | |
| -> Partial Aggregate (cost=55780.41..55780.42 rows=1 width=8) (actual time=938.258..938.258 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_58_cstore test_3pd_cstore_partitioned_57 (cost=0.00..52303.73 rows=1390673 width=0) (actual time=2.113..803.591 rows=1877555 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2294465 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957741 | |
| CStore File Size: 771990192 | |
| -> Partial Aggregate (cost=55775.61..55775.62 rows=1 width=8) (actual time=932.877..932.878 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_53_cstore test_3pd_cstore_partitioned_52 (cost=0.00..52299.22 rows=1390555 width=0) (actual time=2.120..800.390 rows=1873726 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2297938 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957726 | |
| CStore File Size: 771691888 | |
| -> Partial Aggregate (cost=55767.78..55767.79 rows=1 width=8) (actual time=935.090..935.091 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_34_cstore test_3pd_cstore_partitioned_33 (cost=0.00..52291.88 rows=1390360 width=0) (actual time=2.082..802.455 rows=1873026 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2298055 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957668 | |
| CStore File Size: 771392228 | |
| -> Partial Aggregate (cost=55763.14..55763.15 rows=1 width=8) (actual time=934.010..934.011 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_54_cstore test_3pd_cstore_partitioned_53 (cost=0.00..52287.54 rows=1390243 width=0) (actual time=2.180..800.467 rows=1878173 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2292557 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957729 | |
| CStore File Size: 771643517 | |
| -> Partial Aggregate (cost=55759.65..55759.66 rows=1 width=8) (actual time=935.080..935.080 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_38_cstore test_3pd_cstore_partitioned_37 (cost=0.00..52284.26 rows=1390156 width=0) (actual time=2.169..801.781 rows=1876180 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2294289 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957677 | |
| CStore File Size: 771542575 | |
| -> Partial Aggregate (cost=55754.95..55754.96 rows=1 width=8) (actual time=931.560..931.560 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_5_cstore test_3pd_cstore_partitioned_4 (cost=0.00..52279.85 rows=1390040 width=0) (actual time=2.144..799.081 rows=1876446 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2293675 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957591 | |
| CStore File Size: 771245014 | |
| -> Partial Aggregate (cost=55735.78..55735.79 rows=1 width=8) (actual time=937.490..937.491 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_26_cstore test_3pd_cstore_partitioned_25 (cost=0.00..52261.87 rows=1389562 width=0) (actual time=2.131..804.103 rows=1873345 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2295340 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957643 | |
| CStore File Size: 771117992 | |
| -> Partial Aggregate (cost=55733.12..55733.13 rows=1 width=8) (actual time=931.578..931.578 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_49_cstore test_3pd_cstore_partitioned_48 (cost=0.00..52259.39 rows=1389494 width=0) (actual time=2.144..799.142 rows=1875003 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2293480 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957714 | |
| CStore File Size: 771327856 | |
| -> Partial Aggregate (cost=55726.32..55726.33 rows=1 width=8) (actual time=937.103..937.104 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_35_cstore test_3pd_cstore_partitioned_34 (cost=0.00..52253.00 rows=1389326 width=0) (actual time=2.128..803.777 rows=1874201 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2293778 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957671 | |
| CStore File Size: 770915322 | |
| -> Partial Aggregate (cost=55714.94..55714.95 rows=1 width=8) (actual time=931.878..931.878 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_62_cstore test_3pd_cstore_partitioned_61 (cost=0.00..52242.33 rows=1389042 width=0) (actual time=2.104..797.973 rows=1873443 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2293684 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957753 | |
| CStore File Size: 770788490 | |
| -> Partial Aggregate (cost=55710.33..55710.34 rows=1 width=8) (actual time=934.797..934.798 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_31_cstore test_3pd_cstore_partitioned_30 (cost=0.00..52238.01 rows=1388927 width=0) (actual time=2.123..802.357 rows=1873250 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2293532 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957658 | |
| CStore File Size: 770754373 | |
| -> Partial Aggregate (cost=55707.65..55707.66 rows=1 width=8) (actual time=929.518..929.518 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_8_cstore test_3pd_cstore_partitioned_7 (cost=0.00..52235.50 rows=1388859 width=0) (actual time=2.106..796.760 rows=1873737 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2292840 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957573 | |
| CStore File Size: 770998399 | |
| -> Partial Aggregate (cost=55696.16..55696.17 rows=1 width=8) (actual time=936.274..936.275 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_25_cstore test_3pd_cstore_partitioned_24 (cost=0.00..52224.73 rows=1388574 width=0) (actual time=2.116..803.185 rows=1873019 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2292702 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957640 | |
| CStore File Size: 770661209 | |
| -> Partial Aggregate (cost=55694.32..55694.33 rows=1 width=8) (actual time=931.046..931.046 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_16_cstore test_3pd_cstore_partitioned_15 (cost=0.00..52223.01 rows=1388527 width=0) (actual time=2.098..797.801 rows=1874038 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2291542 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957612 | |
| CStore File Size: 770853054 | |
| -> Partial Aggregate (cost=55683.68..55683.69 rows=1 width=8) (actual time=936.224..936.225 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_1_cstore test_3pd_cstore_partitioned (cost=0.00..52213.03 rows=1388262 width=0) (actual time=2.097..803.087 rows=1869689 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2295097 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957567 | |
| CStore File Size: 770585732 | |
| -> Partial Aggregate (cost=55670.36..55670.37 rows=1 width=8) (actual time=921.091..921.091 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_21_cstore test_3pd_cstore_partitioned_20 (cost=0.00..52200.54 rows=1387931 width=0) (actual time=2.124..789.594 rows=1871790 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2292002 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957625 | |
| CStore File Size: 770259142 | |
| -> Partial Aggregate (cost=55664.55..55664.56 rows=1 width=8) (actual time=930.709..930.710 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_10_cstore test_3pd_cstore_partitioned_9 (cost=0.00..52195.09 rows=1387785 width=0) (actual time=2.139..798.642 rows=1871827 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2291527 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957600 | |
| CStore File Size: 770378016 | |
| -> Partial Aggregate (cost=55653.68..55653.69 rows=1 width=8) (actual time=934.068..934.069 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_46_cstore test_3pd_cstore_partitioned_45 (cost=0.00..52184.89 rows=1387514 width=0) (actual time=2.104..802.216 rows=1869638 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2292904 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957704 | |
| CStore File Size: 770160481 | |
| -> Partial Aggregate (cost=55650.39..55650.40 rows=1 width=8) (actual time=931.923..931.924 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_55_cstore test_3pd_cstore_partitioned_54 (cost=0.00..52181.81 rows=1387432 width=0) (actual time=2.134..797.895 rows=1871159 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2291137 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957732 | |
| CStore File Size: 770105159 | |
| -> Partial Aggregate (cost=55650.19..55650.20 rows=1 width=8) (actual time=929.607..929.608 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_37_cstore test_3pd_cstore_partitioned_36 (cost=0.00..52181.62 rows=1387427 width=0) (actual time=2.148..797.083 rows=1871340 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2290940 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957680 | |
| CStore File Size: 770183887 | |
| -> Partial Aggregate (cost=55640.45..55640.46 rows=1 width=8) (actual time=955.273..955.274 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_39_cstore test_3pd_cstore_partitioned_38 (cost=0.00..52172.49 rows=1387183 width=0) (actual time=2.077..822.162 rows=1871873 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2289677 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957683 | |
| CStore File Size: 770145715 | |
| -> Partial Aggregate (cost=55633.41..55633.42 rows=1 width=8) (actual time=952.293..952.294 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_18_cstore test_3pd_cstore_partitioned_17 (cost=0.00..52165.89 rows=1387008 width=0) (actual time=2.152..819.451 rows=1870981 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2290044 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957619 | |
| CStore File Size: 769946903 | |
| -> Partial Aggregate (cost=55628.99..55629.00 rows=1 width=8) (actual time=930.133..930.134 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_60_cstore test_3pd_cstore_partitioned_59 (cost=0.00..52161.75 rows=1386897 width=0) (actual time=2.128..798.112 rows=1867041 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2293650 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957747 | |
| CStore File Size: 770143836 | |
| -> Partial Aggregate (cost=55611.92..55611.93 rows=1 width=8) (actual time=1847.976..1847.977 rows=1 loops=1) | |
| -> Foreign Scan on test_3pd_cstore_partitioned_4_cstore test_3pd_cstore_partitioned_3 (cost=0.00..52145.73 rows=1386473 width=0) (actual time=915.765..1715.315 rows=1870830 loops=1) | |
| Filter: (age > 50) | |
| Rows Removed by Filter: 2288588 | |
| CStore File: /tank/postgresql/13/main/cstore_fdw/13414/1121957579 | |
| CStore File Size: 769614098 | |
| Planning Time: 62.042 ms | |
| JIT: | |
| Functions: 2050 | |
| Options: Inlining true, Optimization true, Expressions true, Deforming true | |
| Timing: Generation 169.575 ms, Inlining 362.245 ms, Optimization 3516.685 ms, Emission 3627.307 ms, Total 7675.813 ms | |
| Execution Time: 8565.734 ms | |
| (395 rows) | |
| Time: 8809.830 ms (00:08.810) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment