BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes. - Mailing list pgsql-bugs
| From | PG Bug reporting form |
|---|---|
| Subject | BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes. |
| Date | |
| Msg-id | 17321-a10c625e59181269@postgresql.org Whole thread Raw |
| Responses |
Re: BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.
Re: BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes. |
| List | pgsql-bugs |
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"
pgsql-bugs by date: