Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vEvLi-003lnB-Bb for pgsql-general@arkaria.postgresql.org; Fri, 31 Oct 2025 20:03:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vEvLg-000EQC-FR for pgsql-general@arkaria.postgresql.org; Fri, 31 Oct 2025 20:03:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vEvLf-000EQ4-V4 for pgsql-general@lists.postgresql.org; Fri, 31 Oct 2025 20:03:47 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vEvLc-004myy-2H for pgsql-general@lists.postgresql.org; Fri, 31 Oct 2025 20:03:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1761941021; x=1762545821; i=jimis@gmx.net; bh=uCgBrpdLtMcBSij4/R2ycbySZnY9L31xMi4DD0PmMd0=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=e7ezs+0ZQrT2Lcmx4Cj9KPPZP5V/YtGY2gD437LNxNsde99qumYyKgkxKgkBduvU ue3593i4Zr8Her7KhoQbtQCfNhQJVvZ+uGcI31v6aK1lRMihTqbUgNYUgEMIamMVA hA/mJ65/aBYh4h0equfwSaHDirR/5GpjKwumEqurOr6w7VknVQDQi1VQ8Mee3tKWo i35gYs/6etSsBGC93Kfduvt9lxKggrIUGnmGlvLmkrbPOJh2zrPiWiWGPwR2EBGKj BE/3TktSDxi8LRyjpe+sjkvbx0SnykZysEm1UlKiXK19PIb8/7lD0RjU0R2MCiHHB 5MXo8xFTlnoL6oR3ig== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.66] ([185.55.106.54]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1My36N-1wBgjC08eF-00rJSU; Fri, 31 Oct 2025 21:03:41 +0100 Date: Fri, 31 Oct 2025 21:03:39 +0100 (CET) From: Dimitrios Apostolou To: Ron Johnson cc: pgsql-general@lists.postgresql.org Subject: Re: Why isn't my table auto-analyzed/vacuumed? In-Reply-To: Message-ID: <07sp7s76-r633-spqr-so3o-5oqs44r80np6@tzk.arg> References: <26qs98r6-0q81-non7-3n17-0r14o9851pp9@tzk.arg> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-483988485-1761941021=:929621" X-Provags-ID: V03:K1:iVqfsf5upftVaXN3UAoO0TMsHRvvn33FlvMpCj4b3c1RL3WIhwe /icHyXyLNHWrjBVu+8Jx3WtYElaIdA/v1qm5DQXfD8jBHPGtIsu/Lzvj4XWad9SZkIx5JfX N0o/8emr6bieYduY/TtwGt1CIKQ3sg+GSubB/lkxUyG+tbzbPuQ9wM7tf8LXlQeQ3GhhNry x1iSEdABybII0pEINnTRw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:oj9ODrqaacU=;iY5iE5FXHX3xor7puWVsz7WrRuK AKtZi/LLK6KX2Leb1fDgvmsddw3i/px8o3sJCV1QpezI6Xvqqg7xJ73HGKPFosMCA2ZNpNxfK qos/vrLUq34X5BSZOJQ4BM4RbGO8h0fS5fits06lcx9AKzi8PR9+awCuz/hrq4xObn6EQWedD jHP9df1+fdoacIWwzHEgnJRpEp0fDO2A2mumA7bB82a32Nedhf7eX4yP1nMHvAaWfwArqHkBw JBBnp170ThlLaKl7WMPSvsqXjLTZOZ9UtGukoWvE1CVubjn8mfPzRnVTkV8trdLp+RZ3N7uUc xQ0h8nIBManT6nEBWclHw/qeKIs1MART9uK15CeOCvhcyVPcMMOWd74rF+mdiWGBLGIpk0KEU 43Q2hFvGTIfpbyiVhFY6CwW9i5eIMqa9tKnPb6QrPakIkg/CekFZw0tkspq3juBIyMFdVJ6e4 7YK/0Uvknrl8+jilCjdL/KGA5ckVUfcc5LLSbME5G3LfGjf+fODs7J8dZtoHxc7UDiumPsOh9 QPpo2k00s/eWcdSngOs9XqfDEEfB8kxuMDCZe7buLZonIlI5D2UTjB08R6xu5lQpghzXlkqx5 Pnzovff1L5EmR1+NZuLpWYXCyAJYZPCXRDqe8bMnnnfCwMSQtQmQ/vPjlh05Goqai3iW1Bj60 DAAXlex31Bh0s4thFvNq9TRBfeIwFY9MlYl7fJC3RLK+lEUZ3UGVLXPFmDI283fMRv8WDHlsE 77R9cNWxma1t9CbnbjXJaJQtLLtvQiEWLKjd5jxoHDp/gIyRf54TEqYb4mLMljo+LXUuaNYc7 c1xFL8T9baahdd4JGmEzXlBVFMx+ogF1r2InobYychAQM6tUcpMoyLAqeVLYj+r2Fx3Rlh5Jt tFZja4OL83t5S00MBCUIgs0npfyykw5QIrQgwk/XnD2JcBA6yy5317C+581zJBJn7bzZljHUJ vy0X8GO4xtyrCB2fdVu9XUJzCJqGOpYy3jjgKe7+Lmx8o5zRyd8h4JJ/5oZ3MUHnfG72iN+ge 4cr3O+FbZSEK4BXEhBi3yINXbxic74x4XBzAoYXJPfOxliBunyak2JOLBMV33n1YQxWZetrr4 1lt/O3MdreXGOjahb62IxUcKyqvryzxBnTrsIEqCDh4z4oTa7ewnnCZgVCYr7vL2LXsejTRpH HkDVan/6NjDEW8qlyHID2k6PTJigxOjREjTKk+DrPXwttmc75d8RWylCuPm9NY5ODx/3CCdhJ 7UkwCq0bKr8BMOGfM4Q7HGXyniCjURYxJ87LOchCXpYFM6k/CHzQIHH2kmBpEHAK2r9KMT1TE M1tieRzkQ4PRU//KuiNMRq9Ba2kY1kxVcnS5Yu3wsK8IcLlMkOfWOAY6QXgI6rTHrw23jRvY4 3wfnkp7AR01dVZTQSYKUrENvzxZhmRi++vegP6uJ4Pni7punwlK3LxvRAOTtXKgOAbqkuFTJj 6dDBKyeG/I/8hBmvcqBRxtm2mC3xsU/zKvbRJ3ksfimXBkKTY42JGbwYFKrJOZ68S3NT2Z+Ao XeHTSJUIlo8hYRTyMv5eUbjRO4EKExzexB5ertzWOoNtarorn5n6tuMXsa5Y00097ekMKteZE /ij3xjBGeIm9LBIRYe0NUFwubqVQDwBbU9+CD5R8ADDafwG1aZYDuGF2xIRQ66epyoi8ECy3g dAAnHqmsJSSaVrM9viW0LOZMpZqOhYtqj158T+zzTgRXzrKo7Vi86XJIrK0gax/sGabKcxNuD poemPHwWaY3xHQt9XWCqyyJU2OOqK2vvWckCT9RAgNS7CXmRYIbX6TZTSn1qj/cx2zuPN/5GR ZDtcMRPvbq6JK9pgO6VeXgypa7UG4d3i+zwdg6jBcTwpNrgtqFLQVLYwmLE01uoi5EWexgWZr Ub17zNLOZyjRDAbbMCOPRY21GkEWlak9iNGuvumGRgPdkR+s6XWqeRgwxaMB0l3KWfKVD+7wH YZy4fZbNO4DGnzdQN6X9GTgIP+s3EAy+MvBf7cEWxHi7mmxDZDvI2N/DEOCuKM0lSkeZNhyGn M3vSmKcy55unzFuLxLxBL6sa2i2p03kndRgncmE+90O98+0fypoIX2MoYkJuR6KccR2F2MA/H pDSrMNYqKyid38xSJwU6ePDoRqEpcSNoVxFGeWURFHtW1nD9G16Rv37KoyqBCZ//pI07BJVrb GJmiVVIfWWTcGzVj9hrdPKtypvxg1LX4XoTWfVinyCE3gH0DFIIsh/uf/VGz7XEwRDy0gy5gp g5rq+a4XQkyPMaFoU+4jfAj9US/OS9MteEsFksPiZj6louwAr4JUPPHxuQdP1a62oBum6bl7s L/PHP0jhavDZh8zKuHc/6mEmaWc1b7dJDMvbI/LeHrozWDSnh+7Qr2HSDUy4+uZphi9Xj1GNV g+z8s3u2zbuaPaJixn1UkiBujQnVODbQgC8L7m/j5/0t/kO0sFxK4Zyn31b8Cd88n6yFbr63K Wk1MYhSX0nY6XVCj5l4wQkGQMmYjmfpIZycHQTzMWXpteaPjZdECKmnrFedIGC4mZRpET3Esd dzQ6Jwtv+qGxJB30J82YGPxp6HQrSz2yfKbWNKqujHnSaYgR2NV8go6oCBLwFuH2FqG2nBIuy ak2YzP4Zd1YxQ+Dq9dPPXyf8MjS/50DZN4ozb1oJMQlLzM0iv/oGSpDedWgsFuYflv56m5kjB nUPvyEQhqpLb9PHFPtRPH+bo8OhI+RMA31x98IJr3TsK10PYxPDUHC43VfuZUjzZTfdybuM+Z Li2ys3ozVUoeeSr3LDu9cQ6BpNC+Rz0B6ZNt+eF4Jm4cxh3zmMtXbwXt3HofSUw1A0+ONHeCF IIUbq5yJdOZ0P1bCg5rT7x1/vjDMIuV0FnqfiyIZyD1wUrJLMs7xcHXH9yt/88dA0RN09aLwc u3Flef7QOZUtTLqVvCix75tASG1JzhpOxnseoSJBfuj3bVbwW633Pzx1cf9OyHM6ZLfH/Lt8T hJHsOTHiB1dWGCqsX2E1BXSg7KWhvMmz1xWwgrIYI6FPvK0bR1Yb099X1866h8FVPGimqTcms HhVbst5yg+YQ2Mr0lfIcxZtsDxUYkuiwVyKu8b1tuuQ2eMQMoxHDlrmfDwy87mNE7jOJMavyD ZUr8QEkw3kChO92P/envbrgfOoAvIIQ0uSJe7IcvxFwErOZbc9a8aTBm3FHKi0MUo6oDwUocJ WHlT+CLAd/WsYZTElN85J93vnXU09NEA2hDurd8ZvbLRpU0KynUe/DZjNaWm30//RgygRrelB zmjxR8gjpIdZatKv44EEBi/uIYIXYlrUJBhcwYR+wWPNfZjag/+4qWl978VVVpfJ4+fa3ltJL 6v4er/98x64UOhnY/5QAisZRA7tgjc0BlsTmWN9lyKJ3Leh7mk9APC71oyezZdC5yRzTCl2dQ +Luoab3Vu4syh9Eb57g6TjtaBpbadkKNze9K25ka6uyaLSnL4rSrwZa0OyWMuQIM6kYu8SxqH 6QW2fjJArrRfcMjB2Vhk+EDDxMZlx1CaGyMzl7kfXZnzChBGcdLT/M378AQdpAJZOGVW0cRIQ dI+jcvoGecpFdDDuF/B/1nlAEIpySO0tehsefhdovyOK4j3fkE7A6k7xrO8M7jOl4nc/uVpOK N4iYBuYwsliv3pCJk2uN73imcj4jWQY2J3BMBCTbl1Xzl0jCKU4qguiYD+RmNbYt5lpBXn39T nVKQYegQ6jqGlTSP8TDWIdAyE9xqeLRlHG3tOpsZjt1ineoYwq395tB7mNcAGzpaeilDZVFNt srCco3uXMXCJKv+ydtPK6zCnUOT5Y8TDuE1l0hHJevygil1mhfVie5kXUdzcnCGROgEYyGWl9 mDQKQLrbrPtrZSHRcNTb4koWZtCksFpmu27WWXUGS7DV4sl3kBjwDSsBNTY48ynbh4rc41XVn iWwai/qdNxIpatRGC0pTo92oMkRu7ZtAGBdsEux1Bu46hjJ2j6C8WsAshXwd49QkHwmS7WSNe kPKmvl+K1+oZeUwVGh0fGInwAjZS8u0k7l96sMg2fgNCvu8KCtiHG4ilNtc100GVcAt8sKdqA yhXclOb0ZLR+uTmvVQQ2+H/iJI2/quaMk+WQfzw3BB8rVIcNyWbFHGdlACpwZP05znifQxR3G K5GvwyJr1jAv2hpNGt4EjBjOUPFhi4DOk38HRrau/XQ2JhrnUodfusGM4orM6a5+DS7at3Ps2 4s5RL+8k5AbtiMMlgIh0PI+YkGm4zofQXBcEyuHsX08MlmwqE+Og+mQY/z5dgnLWm/XeNQJd/ yMYvVYtRgxoL4F8mUmpvKg66tQqSVw9g+u5XIrYsmO/1jfYYtcDJehp8WSEMy7zxXPNRzBN0l 4zCtq9xPfXNnEDxFXXdl+zfD7LAS+7DpmbXrdeS6ogHyPMD+HOi4Kvzf28bqpdZBUb8HtbvV9 ZQL7SaMHQO55fGgG7Ig6OlbohXzlEd8RP6o2St2ae3PtjVhRQRml90I1/phKj2HW+9GGNQ8xL 9lqO+ag0uEZ4oClsKrAUy+CxOlV3nVmpPcNvkkHX/cYS6G3Ijpffwi9kmfnk2bn1rFA+VaK2S eXmjRRQkiV1t3FmmzvXnTy/ZGxNzjznVhPg4+Tv0rNGmUg4AwNpO9bsNvpjcir/dNRRNHW92v rjG3GAV7HkzVyrTzkRaiqWwuN17klTcHz/KEKKYB950bY8rHSzHlGO5YOOTGBiduSJ5nyiIF2 3cd51LnJCXIOuyBJNeKNW+DioWZrzhI2Yf1a9l7ILYezjcTOpFJIHiMjRxsr08InBKB/gDMIA erTsZ1q4cjHE5v8GEq1MrvxXe7WR8O5diAqAynsmb0K1w/f5ugR/1WWmNIifX51lFYwBjXg/u ApQe2NJpFNHh0gJine4V6oXewoRy5gGM1lDsiVbLi7J8KCaaYnjr7SgI/HAuFLIrr4zEIkT0m HQCR8DlRgaEP3Kl6XMEMGTUrPjvwjcSlgPX74QcbP/GYWunI/+ZaPI4rpE2/bhCEnlzFXpHRX FTAYgRx7fvvS8dgbgMWrYxGj3SPjq7f82UtegkC26SbqlukkKdr7/h5CJHe93PnsWHJ+pTw4t pHzvA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. --0-483988485-1761941021=:929621 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable On Thursday 2025-10-30 18:00, Ron Johnson wrote: > > > SELECT reltuples FROM pg_class WHERE relname =3D > 'test_runs_summarized_per_function' \gx > -[ RECORD 1 ]----------- > reltuples | 6.061923e+09 > > > SELECT name,setting FROM pg_settings WHERE name ILIKE '%factor%' = ; > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | setting > ---------------------------------------+--------- > =C2=A0 autovacuum_analyze_scale_factor=C2=A0 =C2=A0 =C2=A0 =C2=A0| = 0.1 > > >0.1 means 10%. >=C2=A0 > =C2=A0 autovacuum_vacuum_insert_scale_factor | 0.2 > =C2=A0 autovacuum_vacuum_scale_factor=C2=A0 =C2=A0 =C2=A0 =C2=A0 | = 0.2 > =C2=A0 recursive_worktable_factor=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 | 10 > > >n_mod_since_analyze=3D423101205 >n_live_tup=3D6484485348 > >n_mod_since_analyze/n_live_tup =3D 6.5% >=C2=A0 > How can I get more info from postgres on the autovacuum logic? > > >I would: >1) manually VACUUM ANALYZE the table, >2) drop the three autovacuum_*_scale_factor values down to 0.03 (i.e. 3%)= , Reporting back, after reducing the values, the table has been picked up=20 for both autovacuum and analyze. Thank you for the immediate feedback! Since I had spent some time looking into these values and was "certain"=20 that they were % while they are apparently *not*, I'm wondering if=20 max_val=3D100 is there because of historical reasons, and if it would make= =20 sense to change it to 1. Dimitris --0-483988485-1761941021=:929621--