BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.

The following bug has been logged on the website:

Bug reference:      17321
Logged by:          Denis Campredon
Email address:      deni_@hotmail.fr
PostgreSQL version: 13.3
Operating system:   count(*) slow on partitioned table
Description:

I am auditing a database which has a really huge partitioned table.
When working on the whole table queries are slower than the cumulated time
for all partitions, as you can see with the following query. I don't have
yet timings for more complex operations like group by, but it looks like it
is slower than it should be.

explain (ANALYZE, TIMING, COSTS, BUFFERS, VERBOSE) select count(*) from
schema.partitioned_table;

"Finalize Aggregate  (cost=45965939.79..45965939.80 rows=1 width=8) (actual
time=440891.303..440892.972 rows=1 loops=1)"
"  Output: count(*)"
"  Buffers: shared hit=105060 read=32188235"
"  I/O Timings: read=752807.869"
"  ->  Gather  (cost=45965939.57..45965939.78 rows=2 width=8) (actual
time=440890.857..440892.964 rows=3 loops=1)"
"        Output: (PARTIAL count(*))"
"        Workers Planned: 2"
"        Workers Launched: 2"
"        Buffers: shared hit=105060 read=32188235"
"        I/O Timings: read=752807.869"
"        ->  Partial Aggregate  (cost=45964939.57..45964939.58 rows=1
width=8) (actual time=440884.611..440884.637 rows=1 loops=3)"
"              Output: PARTIAL count(*)"
"              Buffers: shared hit=105060 read=32188235"
"              I/O Timings: read=752807.869"
"              Worker 0:  actual time=440880.937..440880.962 rows=1
loops=1"
"                Buffers: shared hit=1269 read=10729539"
"                I/O Timings: read=249376.930"
"              Worker 1:  actual time=440883.418..440883.444 rows=1
loops=1"
"                Buffers: shared hit=1202 read=10789269"
"                I/O Timings: read=252015.417"
"              ->  Parallel Append  (cost=0.00..44012268.28 rows=781068518
width=0) (actual time=0.372..395609.385 rows=624851628 loops=3)"
"                    Buffers: shared hit=105060 read=32188235"
"                    I/O Timings: read=752807.869"
"                    Worker 0:  actual time=0.576..395324.758 rows=622884213
loops=1"
"                      Buffers: shared hit=1269 read=10729539"
"                      I/O Timings: read=249376.930"
"                    Worker 1:  actual time=0.527..395949.555 rows=626403620
loops=1"
"                      Buffers: shared hit=1202 read=10789269"
"                      I/O Timings: read=252015.417"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_07 partitioned_table_43
(cost=0.00..1265058.13 rows=24648313 width=0) (actual time=0.526..28599.401
rows=59154890 loops=1)"
"                          Buffers: shared hit=64 read=1018511"
"                          I/O Timings: read=20446.894"
"                          Worker 1:  actual time=0.526..28599.401
rows=59154890 loops=1"
"                            Buffers: shared hit=64 read=1018511"
"                            I/O Timings: read=20446.894"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_08 partitioned_table_92
(cost=0.00..728982.85 rows=14188585 width=0) (actual time=0.575..15826.505
rows=34052603 loops=1)"
"                          Buffers: shared hit=64 read=587033"
"                          I/O Timings: read=11080.440"
"                          Worker 0:  actual time=0.575..15826.505
rows=34052603 loops=1"
"                            Buffers: shared hit=64 read=587033"
"                            I/O Timings: read=11080.440"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_07 partitioned_table_91
(cost=0.00..726814.23 rows=14146323 width=0) (actual time=0.550..18372.436
rows=33951249 loops=1)"
"                          Buffers: shared hit=64 read=585287"
"                          I/O Timings: read=13805.446"
"                          Worker 0:  actual time=0.550..18372.436
rows=33951249 loops=1"
"                            Buffers: shared hit=64 read=585287"
"                            I/O Timings: read=13805.446"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_08 partitioned_table_80
(cost=0.00..723766.52 rows=14101352 width=0) (actual time=0.712..18433.362
rows=33843341 loops=1)"
"                          Buffers: shared hit=64 read=582689"
"                          I/O Timings: read=13760.709"
"                          Worker 1:  actual time=0.712..18433.362
rows=33843341 loops=1"
"                            Buffers: shared hit=64 read=582689"
"                            I/O Timings: read=13760.709"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_05 partitioned_table_77
(cost=0.00..719933.47 rows=14024747 width=0) (actual time=0.694..17966.914
rows=33660687 loops=1)"
"                          Buffers: shared hit=64 read=579622"
"                          I/O Timings: read=13632.239"
"                          Worker 0:  actual time=0.694..17966.914
rows=33660687 loops=1"
"                            Buffers: shared hit=64 read=579622"
"                            I/O Timings: read=13632.239"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_07 partitioned_table_79
(cost=0.00..718344.33 rows=13996233 width=0) (actual time=0.527..18172.208
rows=33589839 loops=1)"
"                          Buffers: shared hit=64 read=578318"
"                          I/O Timings: read=13643.841"
"                          Worker 1:  actual time=0.527..18172.208
rows=33589839 loops=1"
"                            Buffers: shared hit=64 read=578318"
"                            I/O Timings: read=13643.841"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_05 partitioned_table_89
(cost=0.00..717819.78 rows=13970678 width=0) (actual time=0.968..18006.039
rows=33529710 loops=1)"
"                          Buffers: shared hit=64 read=578049"
"                          I/O Timings: read=13313.481"
"                          Worker 0:  actual time=0.968..18006.039
rows=33529710 loops=1"
"                            Buffers: shared hit=64 read=578049"
"                            I/O Timings: read=13313.481"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_10 partitioned_table_82
(cost=0.00..715375.13 rows=13927313 width=0) (actual time=0.559..18048.597
rows=33425437 loops=1)"
"                          Buffers: shared hit=64 read=576038"
"                          I/O Timings: read=13412.489"
"                          Worker 1:  actual time=0.559..18048.597
rows=33425437 loops=1"
"                            Buffers: shared hit=64 read=576038"
"                            I/O Timings: read=13412.489"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_03 partitioned_table_75
(cost=0.00..713472.79 rows=13892379 width=0) (actual time=0.606..18110.411
rows=33338585 loops=1)"
"                          Buffers: shared hit=64 read=574485"
"                          I/O Timings: read=13509.209"
"                          Worker 0:  actual time=0.606..18110.411
rows=33338585 loops=1"
"                            Buffers: shared hit=64 read=574485"
"                            I/O Timings: read=13509.209"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_07 partitioned_table_67
(cost=0.00..711849.66 rows=13869166 width=0) (actual time=0.926..17756.389
rows=33285519 loops=1)"
"                          Buffers: shared hit=64 read=573094"
"                          I/O Timings: read=13656.835"
"                          Worker 1:  actual time=0.926..17756.389
rows=33285519 loops=1"
"                            Buffers: shared hit=64 read=573094"
"                            I/O Timings: read=13656.835"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_08 partitioned_table_68
(cost=0.00..708078.52 rows=13794952 width=0) (actual time=1.866..17955.398
rows=33108697 loops=1)"
"                          Buffers: shared hit=64 read=570065"
"                          I/O Timings: read=13310.319"
"                          Worker 0:  actual time=1.866..17955.398
rows=33108697 loops=1"
"                            Buffers: shared hit=64 read=570065"
"                            I/O Timings: read=13310.319"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_10 partitioned_table_70
(cost=0.00..706695.68 rows=13768068 width=0) (actual time=0.924..17614.488
rows=33044018 loops=1)"
"                          Buffers: shared hit=64 read=568951"
"                          I/O Timings: read=13445.146"
"                          Worker 1:  actual time=0.924..17614.488
rows=33044018 loops=1"
"                            Buffers: shared hit=64 read=568951"
"                            I/O Timings: read=13445.146"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_03 partitioned_table_87
(cost=0.00..706671.77 rows=13751277 width=0) (actual time=0.888..17895.331
rows=33005522 loops=1)"
"                          Buffers: shared hit=64 read=569095"
"                          I/O Timings: read=13421.382"
"                          Worker 0:  actual time=0.888..17895.331
rows=33005522 loops=1"
"                            Buffers: shared hit=64 read=569095"
"                            I/O Timings: read=13421.382"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_03 partitioned_table_63
(cost=0.00..702586.53 rows=13689252 width=0) (actual time=1.499..17656.363
rows=32853466 loops=1)"
"                          Buffers: shared hit=64 read=565630"
"                          I/O Timings: read=13470.630"
"                          Worker 1:  actual time=1.499..17656.363
rows=32853466 loops=1"
"                            Buffers: shared hit=64 read=565630"
"                            I/O Timings: read=13470.630"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_05 partitioned_table_65
(cost=0.00..701956.95 rows=13676095 width=0) (actual time=1.244..17861.658
rows=32823385 loops=1)"
"                          Buffers: shared hit=64 read=565132"
"                          I/O Timings: read=13322.023"
"                          Worker 0:  actual time=1.244..17861.658
rows=32823385 loops=1"
"                            Buffers: shared hit=64 read=565132"
"                            I/O Timings: read=13322.023"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_06 partitioned_table_66
(cost=0.00..701524.12 rows=13667712 width=0) (actual time=1.655..17635.545
rows=32803233 loops=1)"
"                          Buffers: shared hit=64 read=564783"
"                          I/O Timings: read=13202.308"
"                          Worker 1:  actual time=1.655..17635.545
rows=32803233 loops=1"
"                            Buffers: shared hit=64 read=564783"
"                            I/O Timings: read=13202.308"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_06 partitioned_table_78
(cost=0.00..697501.22 rows=13589222 width=0) (actual time=0.539..17448.129
rows=32614285 loops=1)"
"                          Buffers: shared hit=64 read=561545"
"                          I/O Timings: read=13211.541"
"                          Worker 0:  actual time=0.539..17448.129
rows=32614285 loops=1"
"                            Buffers: shared hit=64 read=561545"
"                            I/O Timings: read=13211.541"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_09 partitioned_table_81
(cost=0.00..695269.64 rows=13546164 width=0) (actual time=0.529..17589.371
rows=32509816 loops=1)"
"                          Buffers: shared hit=64 read=559744"
"                          I/O Timings: read=13184.220"
"                          Worker 1:  actual time=0.529..17589.371
rows=32509816 loops=1"
"                            Buffers: shared hit=64 read=559744"
"                            I/O Timings: read=13184.220"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_04 partitioned_table_76
(cost=0.00..695145.63 rows=13541563 width=0) (actual time=0.683..17489.913
rows=32500714 loops=1)"
"                          Buffers: shared hit=64 read=559666"
"                          I/O Timings: read=13142.546"
"                          Worker 0:  actual time=0.683..17489.913
rows=32500714 loops=1"
"                            Buffers: shared hit=64 read=559666"
"                            I/O Timings: read=13142.546"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_09 partitioned_table_93
(cost=0.00..694648.60 rows=13528660 width=0) (actual time=0.548..17451.845
rows=32471679 loops=1)"
"                          Buffers: shared hit=64 read=559298"
"                          I/O Timings: read=13246.918"
"                          Worker 1:  actual time=0.548..17451.845
rows=32471679 loops=1"
"                            Buffers: shared hit=64 read=559298"
"                            I/O Timings: read=13246.918"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_04 partitioned_table_88
(cost=0.00..693494.50 rows=13498050 width=0) (actual time=0.688..17498.622
rows=32395155 loops=1)"
"                          Buffers: shared hit=64 read=558450"
"                          I/O Timings: read=12878.677"
"                          Worker 0:  actual time=0.688..17498.622
rows=32395155 loops=1"
"                            Buffers: shared hit=64 read=558450"
"                            I/O Timings: read=12878.677"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_01 partitioned_table_73
(cost=0.00..690892.28 rows=13448228 width=0) (actual time=1.399..17302.408
rows=32270104 loops=1)"
"                          Buffers: shared hit=64 read=556346"
"                          I/O Timings: read=12955.458"
"                          Worker 1:  actual time=1.399..17302.408
rows=32270104 loops=1"
"                            Buffers: shared hit=64 read=556346"
"                            I/O Timings: read=12955.458"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_12 partitioned_table_72
(cost=0.00..689095.95 rows=13425495 width=0) (actual time=0.424..17240.899
rows=32219705 loops=1)"
"                          Buffers: shared hit=64 read=554777"
"                          I/O Timings: read=12969.248"
"                          Worker 0:  actual time=0.424..17240.899
rows=32219705 loops=1"
"                            Buffers: shared hit=64 read=554777"
"                            I/O Timings: read=12969.248"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_12 partitioned_table_84
(cost=0.00..688308.80 rows=13396980 width=0) (actual time=0.874..17596.429
rows=32152573 loops=1)"
"                          Buffers: shared hit=64 read=554275"
"                          I/O Timings: read=13032.262"
"                          Worker 1:  actual time=0.874..17596.429
rows=32152573 loops=1"
"                            Buffers: shared hit=64 read=554275"
"                            I/O Timings: read=13032.262"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_11 partitioned_table_83
(cost=0.00..686407.47 rows=13360147 width=0) (actual time=1.375..17378.407
rows=32064177 loops=1)"
"                          Buffers: shared hit=64 read=552742"
"                          I/O Timings: read=12839.418"
"                          Worker 0:  actual time=1.375..17378.407
rows=32064177 loops=1"
"                            Buffers: shared hit=64 read=552742"
"                            I/O Timings: read=12839.418"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_06 partitioned_table_90
(cost=0.00..686127.55 rows=13338555 width=0) (actual time=0.548..17071.026
rows=32008804 loops=1)"
"                          Buffers: shared hit=64 read=552678"
"                          I/O Timings: read=12970.946"
"                          Worker 1:  actual time=0.548..17071.026
rows=32008804 loops=1"
"                            Buffers: shared hit=64 read=552678"
"                            I/O Timings: read=12970.946"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_09 partitioned_table_69
(cost=0.00..682914.77 rows=13304577 width=0) (actual time=1.674..17323.029
rows=31932951 loops=1)"
"                          Buffers: shared hit=64 read=549805"
"                          I/O Timings: read=12585.200"
"                          Worker 0:  actual time=1.674..17323.029
rows=31932951 loops=1"
"                            Buffers: shared hit=64 read=549805"
"                            I/O Timings: read=12585.200"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_04 partitioned_table_64
(cost=0.00..680361.43 rows=13255843 width=0) (actual time=2.442..17145.184
rows=31813327 loops=1)"
"                          Buffers: shared hit=64 read=547739"
"                          I/O Timings: read=12895.394"
"                          Worker 1:  actual time=2.442..17145.184
rows=31813327 loops=1"
"                            Buffers: shared hit=64 read=547739"
"                            I/O Timings: read=12895.394"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_01 partitioned_table_61
(cost=0.00..675106.17 rows=13153617 width=0) (actual time=1.492..16946.294
rows=31568781 loops=1)"
"                          Buffers: shared hit=64 read=543506"
"                          I/O Timings: read=12649.741"
"                          Worker 0:  actual time=1.492..16946.294
rows=31568781 loops=1"
"                            Buffers: shared hit=64 read=543506"
"                            I/O Timings: read=12649.741"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_01 partitioned_table_85
(cost=0.00..673790.98 rows=13114198 width=0) (actual time=0.612..16845.950
rows=31473505 loops=1)"
"                          Buffers: shared hit=64 read=542585"
"                          I/O Timings: read=12849.804"
"                          Worker 1:  actual time=0.612..16845.950
rows=31473505 loops=1"
"                            Buffers: shared hit=64 read=542585"
"                            I/O Timings: read=12849.804"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_10 partitioned_table_58
(cost=0.00..670381.54 rows=13064454 width=0) (actual time=0.647..16948.023
rows=31352349 loops=1)"
"                          Buffers: shared hit=64 read=539673"
"                          I/O Timings: read=12360.781"
"                          Worker 0:  actual time=0.647..16948.023
rows=31352349 loops=1"
"                            Buffers: shared hit=64 read=539673"
"                            I/O Timings: read=12360.781"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_08 partitioned_table_56
(cost=0.00..669464.50 rows=13045450 width=0) (actual time=0.864..16753.468
rows=31307635 loops=1)"
"                          Buffers: shared hit=64 read=538946"
"                          I/O Timings: read=12642.466"
"                          Worker 1:  actual time=0.864..16753.468
rows=31307635 loops=1"
"                            Buffers: shared hit=64 read=538946"
"                            I/O Timings: read=12642.466"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_07 partitioned_table_55
(cost=0.00..667254.39 rows=13002839 width=0) (actual time=1.278..16962.194
rows=31205834 loops=1)"
"                          Buffers: shared hit=64 read=537162"
"                          I/O Timings: read=12736.611"
"                          Worker 0:  actual time=1.278..16962.194
rows=31205834 loops=1"
"                            Buffers: shared hit=64 read=537162"
"                            I/O Timings: read=12736.611"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_05 partitioned_table_53
(cost=0.00..665524.21 rows=12966121 width=0) (actual time=0.892..16633.042
rows=31122189 loops=1)"
"                          Buffers: shared hit=64 read=535799"
"                          I/O Timings: read=12533.326"
"                          Worker 1:  actual time=0.892..16633.042
rows=31122189 loops=1"
"                            Buffers: shared hit=64 read=535799"
"                            I/O Timings: read=12533.326"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_11 partitioned_table_71
(cost=0.00..664270.22 rows=12940822 width=0) (actual time=0.770..16746.847
rows=31058564 loops=1)"
"                          Buffers: shared hit=64 read=534798"
"                          I/O Timings: read=12635.358"
"                          Worker 0:  actual time=0.770..16746.847
rows=31058564 loops=1"
"                            Buffers: shared hit=64 read=534798"
"                            I/O Timings: read=12635.358"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_03 partitioned_table_51
(cost=0.00..662125.20 rows=12901020 width=0) (actual time=1.115..16819.693
rows=30961823 loops=1)"
"                          Buffers: shared hit=64 read=533051"
"                          I/O Timings: read=12281.154"
"                          Worker 1:  actual time=1.115..16819.693
rows=30961823 loops=1"
"                            Buffers: shared hit=64 read=533051"
"                            I/O Timings: read=12281.154"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2020_02 partitioned_table_74
(cost=0.00..660014.85 rows=12853685 width=0) (actual time=0.992..15663.858
rows=30849961 loops=1)"
"                          Buffers: shared hit=64 read=531414"
"                          I/O Timings: read=11853.067"
"                          Worker 0:  actual time=0.992..15663.858
rows=30849961 loops=1"
"                            Buffers: shared hit=64 read=531414"
"                            I/O Timings: read=11853.067"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_10 partitioned_table_46
(cost=0.00..650833.22 rows=12682422 width=0) (actual time=0.652..7440.836
rows=10145844 loops=3)"
"                          Buffers: shared hit=192 read=523817"
"                          I/O Timings: read=17669.229"
"                          Worker 0:  actual time=0.377..5085.493
rows=5651299 loops=1"
"                            Buffers: shared hit=53 read=97233"
"                            I/O Timings: read=4120.203"
"                          Worker 1:  actual time=1.559..10854.003
rows=16312422 loops=1"
"                            Buffers: shared hit=50 read=280794"
"                            I/O Timings: read=8384.617"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_04 partitioned_table_52
(cost=0.00..647300.03 rows=12612302 width=0) (actual time=1.146..16270.596
rows=30268834 loops=1)"
"                          Buffers: shared hit=64 read=521113"
"                          I/O Timings: read=12338.318"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_01 partitioned_table_49
(cost=0.00..645189.38 rows=12570138 width=0) (actual time=0.554..16269.543
rows=30168137 loops=1)"
"                          Buffers: shared hit=64 read=519424"
"                          I/O Timings: read=12216.137"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_08 partitioned_table_44
(cost=0.00..643829.51 rows=12544751 width=0) (actual time=1.482..16193.515
rows=30107270 loops=1)"
"                          Buffers: shared hit=64 read=518318"
"                          I/O Timings: read=12235.776"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_11 partitioned_table_59
(cost=0.00..643752.59 rows=12544359 width=0) (actual time=0.641..16528.581
rows=30107416 loops=1)"
"                          Buffers: shared hit=64 read=518245"
"                          I/O Timings: read=12578.994"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_09 partitioned_table_57
(cost=0.00..642807.62 rows=12526362 width=0) (actual time=0.851..16073.737
rows=30061833 loops=1)"
"                          Buffers: shared hit=64 read=517480"
"                          I/O Timings: read=12172.901"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_12 partitioned_table_60
(cost=0.00..641165.05 rows=12493805 width=0) (actual time=0.687..16176.146
rows=29985386 loops=1)"
"                          Buffers: shared hit=64 read=516163"
"                          I/O Timings: read=12240.218"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_06 partitioned_table_54
(cost=0.00..640023.41 rows=12470441 width=0) (actual time=0.660..15962.206
rows=29930938 loops=1)"
"                          Buffers: shared hit=64 read=515255"
"                          I/O Timings: read=12218.243"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_12 partitioned_table_48
(cost=0.00..637303.68 rows=12417868 width=0) (actual time=0.643..16309.528
rows=29801519 loops=1)"
"                          Buffers: shared hit=64 read=513061"
"                          I/O Timings: read=12084.499"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2019_02 partitioned_table_62
(cost=0.00..623081.20 rows=12140720 width=0) (actual time=0.804..15682.438
rows=29137069 loops=1)"
"                          Buffers: shared hit=64 read=501610"
"                          I/O Timings: read=11871.374"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_09 partitioned_table_45
(cost=0.00..622879.67 rows=12136967 width=0) (actual time=0.518..15590.330
rows=29127752 loops=1)"
"                          Buffers: shared hit=64 read=501446"
"                          I/O Timings: read=11897.198"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_11 partitioned_table_47
(cost=0.00..622254.43 rows=12125843 width=0) (actual time=0.776..15707.713
rows=29100686 loops=1)"
"                          Buffers: shared hit=64 read=500932"
"                          I/O Timings: read=11683.488"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_05 partitioned_table_41
(cost=0.00..621633.83 rows=12110783 width=0) (actual time=0.677..15626.559
rows=29067044 loops=1)"
"                          Buffers: shared hit=64 read=500462"
"                          I/O Timings: read=11664.079"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_02 partitioned_table_86
(cost=0.00..613456.17 rows=11930017 width=0) (actual time=0.823..15509.627
rows=28633902 loops=1)"
"                          Buffers: shared hit=64 read=494092"
"                          I/O Timings: read=11586.768"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_03 partitioned_table_39
(cost=0.00..606932.84 rows=11825184 width=0) (actual time=1.256..15396.361
rows=28379801 loops=1)"
"                          Buffers: shared hit=64 read=488617"
"                          I/O Timings: read=11271.657"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_06 partitioned_table_42
(cost=0.00..602879.98 rows=11748098 width=0) (actual time=0.767..15181.606
rows=28194062 loops=1)"
"                          Buffers: shared hit=64 read=485335"
"                          I/O Timings: read=11221.265"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_04 partitioned_table_40
(cost=0.00..593203.28 rows=11557428 width=0) (actual time=1.744..14750.761
rows=27737891 loops=1)"
"                          Buffers: shared hit=64 read=477565"
"                          I/O Timings: read=11318.111"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_01 partitioned_table_37
(cost=0.00..592917.10 rows=11550710 width=0) (actual time=0.559..14935.979
rows=27721961 loops=1)"
"                          Buffers: shared hit=64 read=477346"
"                          I/O Timings: read=11096.403"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2018_02 partitioned_table_50
(cost=0.00..583726.48 rows=11373248 width=0) (actual time=0.701..14686.769
rows=27294801 loops=1)"
"                          Buffers: shared hit=64 read=469930"
"                          I/O Timings: read=10860.303"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2017_02 partitioned_table_38
(cost=0.00..536309.93 rows=10448192 width=0) (actual time=0.957..13563.131
rows=25075852 loops=1)"
"                          Buffers: shared hit=64 read=431764"
"                          I/O Timings: read=10176.725"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_12 partitioned_table_36
(cost=0.00..391785.55 rows=7632855 width=0) (actual time=0.552..9766.753
rows=18318342 loops=1)"
"                          Buffers: shared hit=64 read=315393"
"                          I/O Timings: read=7346.216"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_11 partitioned_table_35
(cost=0.00..376609.97 rows=7336397 width=0) (actual time=0.586..9384.043
rows=17608875 loops=1)"
"                          Buffers: shared hit=64 read=303182"
"                          I/O Timings: read=7161.653"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_10 partitioned_table_94
(cost=0.00..328126.93 rows=6372593 width=0) (actual time=1.121..8186.868
rows=15296004 loops=1)"
"                          Buffers: shared hit=64 read=264337"
"                          I/O Timings: read=6130.696"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_10 partitioned_table_34
(cost=0.00..214396.89 rows=4176589 width=0) (actual time=0.691..4349.390
rows=10024402 loops=1)"
"                          Buffers: shared hit=64 read=172567"
"                          I/O Timings: read=2880.095"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_07 partitioned_table_7  (cost=0.00..6268.90
rows=118190 width=0) (actual time=0.003..28.509 rows=283656 loops=1)"
"                          Buffers: shared hit=5087"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_10 partitioned_table_10  (cost=0.00..6045.28
rows=113628 width=0) (actual time=0.004..27.244 rows=272708 loops=1)"
"                          Buffers: shared hit=4909"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_01 partitioned_table_1  (cost=0.00..6025.90
rows=114190 width=0) (actual time=0.004..28.434 rows=274055 loops=1)"
"                          Buffers: shared hit=4884"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_07 partitioned_table_19  (cost=0.00..5759.58
rows=107758 width=0) (actual time=0.006..42.513 rows=258619 loops=1)"
"                          Buffers: shared hit=4682"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_04 partitioned_table_4  (cost=0.00..5717.73
rows=108272 width=0) (actual time=0.006..49.663 rows=259854 loops=1)"
"                          Buffers: shared hit=4635"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_01 partitioned_table_13  (cost=0.00..5604.39
rows=105339 width=0) (actual time=0.005..48.954 rows=252814 loops=1)"
"                          Buffers: shared hit=4551"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_10 partitioned_table_22  (cost=0.00..5536.35
rows=103535 width=0) (actual time=0.006..47.237 rows=248483 loops=1)"
"                          Buffers: shared hit=4501"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_04 partitioned_table_16  (cost=0.00..5110.62
rows=98162 width=0) (actual time=0.005..47.767 rows=235588 loops=1)"
"                          Buffers: shared hit=4129"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_02 partitioned_table_2  (cost=0.00..4510.64
rows=86064 width=0) (actual time=0.004..39.437 rows=206554 loops=1)"
"                          Buffers: shared hit=3650"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_05 partitioned_table_5  (cost=0.00..4486.34
rows=85134 width=0) (actual time=0.004..39.062 rows=204322 loops=1)"
"                          Buffers: shared hit=3635"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_04 partitioned_table_28  (cost=0.00..4425.68
rows=82668 width=0) (actual time=0.005..36.159 rows=198404 loops=1)"
"                          Buffers: shared hit=3599"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_01 partitioned_table_25  (cost=0.00..4362.80
rows=81480 width=0) (actual time=0.004..35.836 rows=195553 loops=1)"
"                          Buffers: shared hit=3548"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_11 partitioned_table_23  (cost=0.00..4266.11
rows=79811 width=0) (actual time=0.006..36.039 rows=191547 loops=1)"
"                          Buffers: shared hit=3468"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_08 partitioned_table_20  (cost=0.00..4257.76
rows=79676 width=0) (actual time=0.006..34.557 rows=191222 loops=1)"
"                          Buffers: shared hit=3461"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_05 partitioned_table_17  (cost=0.00..4146.19
rows=80719 width=0) (actual time=0.006..26.288 rows=193725 loops=1)"
"                          Buffers: shared hit=3339"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_11 partitioned_table_11  (cost=0.00..4069.25
rows=76625 width=0) (actual time=0.005..35.953 rows=183899 loops=1)"
"                          Buffers: shared hit=3303"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_08 partitioned_table_8  (cost=0.00..4004.55
rows=75455 width=0) (actual time=0.005..35.724 rows=181092 loops=1)"
"                          Buffers: shared hit=3250"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_02 partitioned_table_26  (cost=0.00..3963.09
rows=97109 width=0) (actual time=0.005..30.178 rows=165085 loops=1)"
"                          Buffers: shared hit=2992"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_02 partitioned_table_14  (cost=0.00..3949.99
rows=74299 width=0) (actual time=0.005..34.201 rows=178318 loops=1)"
"                          Buffers: shared hit=3207"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_07 partitioned_table_31  (cost=0.00..3589.05
rows=88005 width=0) (actual time=0.005..25.053 rows=149609 loops=1)"
"                          Buffers: shared hit=2709"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_03 partitioned_table_3  (cost=0.00..3324.56
rows=83456 width=0) (actual time=0.007..27.113 rows=141876 loops=1)"
"                          Buffers: shared hit=2490"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_08 partitioned_table_32  (cost=0.00..3045.42
rows=74642 width=0) (actual time=0.003..19.520 rows=126891 loops=1)"
"                          Buffers: shared hit=2299"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_06 partitioned_table_6  (cost=0.00..2865.90
rows=71790 width=0) (actual time=0.006..19.735 rows=122043 loops=1)"
"                          Buffers: shared hit=2148"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_05 partitioned_table_29  (cost=0.00..2692.74
rows=65974 width=0) (actual time=0.005..20.497 rows=112156 loops=1)"
"                          Buffers: shared hit=2033"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_09 partitioned_table_9  (cost=0.00..2689.43
rows=67243 width=0) (actual time=0.006..21.551 rows=114313 loops=1)"
"                          Buffers: shared hit=2017"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_03 partitioned_table_15  (cost=0.00..2514.41
rows=62641 width=0) (actual time=0.006..19.047 rows=106489 loops=1)"
"                          Buffers: shared hit=1888"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2014_12 partitioned_table_12  (cost=0.00..2335.67
rows=58067 width=0) (actual time=0.007..19.037 rows=98714 loops=1)"
"                          Buffers: shared hit=1755"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_12 partitioned_table_24  (cost=0.00..2309.84
rows=56984 width=0) (actual time=0.006..18.278 rows=96872 loops=1)"
"                          Buffers: shared hit=1740"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_06 partitioned_table_18  (cost=0.00..2290.48
rows=57548 width=0) (actual time=0.006..18.535 rows=97831 loops=1)"
"                          Buffers: shared hit=1715"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2015_09 partitioned_table_21  (cost=0.00..2266.35
rows=56035 width=0) (actual time=0.006..17.624 rows=95260 loops=1)"
"                          Buffers: shared hit=1706"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_03 partitioned_table_27  (cost=0.00..2181.75
rows=53675 width=0) (actual time=0.006..16.973 rows=91247 loops=1)"
"                          Buffers: shared hit=1645"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_09 partitioned_table_33  (cost=0.00..1541.32
rows=38132 width=0) (actual time=0.005..11.383 rows=64825 loops=1)"
"                          Buffers: shared hit=1160"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2016_06 partitioned_table_30  (cost=0.00..1186.16
rows=29316 width=0) (actual time=0.006..8.147 rows=49838 loops=1)"
"                          Buffers: shared hit=893"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_11 partitioned_table_95  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2021_12 partitioned_table_96  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_01 partitioned_table_97  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_02 partitioned_table_98  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_03 partitioned_table_99  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_04 partitioned_table_100  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_05 partitioned_table_101  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_06 partitioned_table_102  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_07 partitioned_table_103  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_08 partitioned_table_104  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_09 partitioned_table_105  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_10 partitioned_table_106  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_11 partitioned_table_107  (cost=0.00..10.88
rows=88 width=0) (actual time=0.000..0.000 rows=0 loops=1)"
"                    ->  Parallel Seq Scan on
schema.partitioned_table_y2022_12 partitioned_table_108  (cost=0.00..10.88
rows=88 width=0) (actual time=0.001..0.002 rows=0 loops=1)"
"Planning:"
"  Buffers: shared hit=98"
"Planning Time: 4.585 ms"
"Execution Time: 440893.238 ms"