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 1vEUzp-00CQJS-QJ for pgsql-general@arkaria.postgresql.org; Thu, 30 Oct 2025 15:55:29 +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 1vEUzo-009KBt-PN for pgsql-general@arkaria.postgresql.org; Thu, 30 Oct 2025 15:55:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vEUzo-009KBk-BR for pgsql-general@lists.postgresql.org; Thu, 30 Oct 2025 15:55:27 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vEUzl-0055vB-0Y for pgsql-general@lists.postgresql.org; Thu, 30 Oct 2025 15:55:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1761839724; x=1762444524; i=jimis@gmx.net; bh=AuSW6txtoCrHAdq5lUyS3WPa+FCYOXQnB2hSs1gWMII=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:MIME-Version: Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=fRjUGnaUcdl/Vl2/3smxeCvTcMqDzExuSZny4W8oXEBDf9b/HFntCl2TX3vFOKtQ RfwVFpOuLiQmjx64S60bbnk3IihkYhX3uldCJSKadihqiDZQ7RaWTTdJQtItYbwKX yTK44L+Xh0FCmII/Vxx8uOAT1EGXZz0PQVDb5Bg6bttmEoQcXj5mBk+YCpkCpFEv+ BJMvidhFpdZWFB7Kj+JE/xRUaYUlbRmsLujBdNuMfj7O81K9ZQDhyVeiKV3omCJls L/aoCbfXrqCrN5yQcFXSnAC0CV24U9MeglzUOsJqftqZdp5VDPILYmE4JqssgHZ8W 4Bp5i5w0xGvSf/Z7Jg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.66] ([185.55.106.54]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1My32F-1wC7630Hhn-00y6S8 for ; Thu, 30 Oct 2025 16:55:24 +0100 Date: Thu, 30 Oct 2025 16:55:18 +0100 (CET) From: Dimitrios Apostolou To: pgsql-general@lists.postgresql.org Subject: Why isn't my table auto-analyzed/vacuumed? Message-ID: <26qs98r6-0q81-non7-3n17-0r14o9851pp9@tzk.arg> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=US-ASCII X-Provags-ID: V03:K1:jzPNUXbfr+s74+l1nE4FvyslPOcWfTTFH1KWP6SJr2kOEC5biMQ eOsgHXa6AMBy0M6FVAdr9UOHBj0Ave/hi1z7jkMRQcepCiIndn8cp8XnsyBh8ifpdLHGLJo LHPiQRIJK1J/lrLOZ9QQTOUckrAmTOmPp0zm/65UCyBc/j6iQNNrh7tnRJIgnUzvp/EV0dY Rz49D09PbmFIYTj8Vs/iA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:trnJ0IBg1Cw=;FEpNeim4ZzwEjpba8K1jnItf/lj EA/WoXJVPGVEb7uyo/NQWsRcpWpbh321NRWXBM00GUqHIu1ZvM5u5JyAUXqjlkDKFi/aZRNBJ IsNH0r/tNQB6PdtRpATR8JmccDVgL7K8j37V1e9xux8uMsoV1Hpamec25MfBdyprNFl8k3Ngf qbsQ25ZfbALopRDeVWaVTeBDhW9S6AR2sp2Y6Ev8tbfivV6h2vkwndaXXmznneyZPUlR7+tiI xOhjgX1DvxIe+tSJ6j5rs2ukQHsb6szwmYBn666rwBxVZhdDovdMjM8xJ5XHYpOTrleQGxVvR D0M7oOMX2FsipIK0eBV1d1xgT6vqfSf7ylq81sBdA8/7h/NUzLaG284c4iWfu+ZV9vcJ8C8m8 Kth7sZUSblFSVAvzs+uhUMoAqWq8LXTgwfzHidYSCvNQDoCCXj8OwP3apvHwnPFRnzVDiNX+x jcD2tfOB3JIFAvRNMo4p5QVSqoJdeonQ2M+LS94TouRJQ9M6PKXa9YwtEUNz8rURU0ZjdTr/e 7WEKfQ/73QKitYmCcQmO+5oW4zOGjZSzf2gNOI38krLmtFnCzBaYEz9ao7/ckvOgqQl/vCysa 79I/WL0I0JCDzXDOMoZpiTbWJEm1EO37FKdaCjKutwujShYGL3m4ROX+HphoukvxaMmrOpK/J R85/zHVV5JVdw+yJC8oUzGTp3H8gPctN5tWER3DFpwfn/6NcAZBNrYh79nYLcDKNKW048xtVk RbhWpjqdXYTNEpSzESn9mTp7HTQmUq5ZU+5zjRKILFRuxfRrMg1RYjor9eiJyMFsWia8HXuVq 2cncJn/VO6KZnKrWqpPsOX5WJJZjVNBTSDJcAh1WtgIL1yevon1W08M8XWH3wiTQSDTWsXek5 /G6Iua3UFBA0u1w1xtkMkPuHpMpruTxfTatxujmR8Gi/ApaaeS/nE5Tu62u8tvtqh61uJ1Pid wakehf88OBnaLkLcOr1oqD5644pwJ8Bm5OHZr1Xbrcn8AePaNzDRXDguLOECqwLmIsNVJW3NR Ro2MYycdmRM8vAe3Z42KWVM7aUYPmenuFAhzEGjnCTnSllj/bMpAqMO4jKVL+svt14w2buRdA hY9sgTKCZF+ABE/gPy5X2MHcA1gqoU/rQagKU9MDWfzoNTd4ZbQ9j+UUVk+hxyb0wR8q0s97V xdgJ+2A6WZ1uj5p0HT50fzhiF1hVPP9dOB7uNUCK2htGmpgmT7CHGtEavRTDgn2nVBEVXeRlQ qGYiB4aeu6LH9dlEixskGkin/BOzfpeMUXVpLxoVEMX2LGsvwNhbLTugs67F1M8OLkXPp6glT T58Vn/1TZZI2aaiqm4AcyVnbZK5I5CnUwSoDGOq5bWD3pjr2Cdfs9FI+hm+wHiwkld4ZgTUJp kfa6Ukbo9QM72MG8laVlrgnh0B7Xhn1yUKCS0W3fguWFxNwyFQpaNWPld5WbxhvK7zbC5upxn vu6AWwHARQf3IOoW8QLzHilIeRaRvyqj78jtiBSf9j7Mq6FhJGeoN7Siy3buht7uZ+FKFqlFH DUXr6Q4YLOQbA44mUZ4OZyTr9BcpkJd7ZRSydB2vHZ0+7PF3RddKFXPyqgfGVG1omXp4EM2e6 Bbp5RRvX0+wHeS+bG8L9onM7FRFA+67xyH5xbMJjYUrluMnn6QU5E2eEeL9yMKm3yrokEUSJe /JgsoCk6iYrZ0a1XNeYvgZMW+7AC7lNSDDxNCzfw1kArd6Yt5l8pYuJngFyiE77dNes0qPSrY pTEz8e0UFpQBbRQPuzmmmjMT/IDV5Q18fbk9wfFow5nNhXGKRacUuWj1px7uabewY6FHLBLlR WBwWhjo3/TeA0Q7ulnxoUaHq+O83+pKuOZsqG8QHATNEDNKgdUQMF7AkK0qE5+gnSNw1ea9QA Unb6Kd4l+SHWyZXl/SgMMkEH2Sa2AhQ7I7gIKqLCGK5nHPMDlXjug1sMlmPFBEZaGucU9cDEX HRHm5LLyoZ3ii2829IN13Bt7rpm4urH8RnjgeTZp/lwy2+MgaVfEbqbqLRujPQ+ug6c14sw// CVBzsPC7ZSSunrqD5xosrx/bdoRrfjD4jVuODyKQ2LWHVOcbXO0o3gCNuhsudSraPWsnRLg6c m2MlhNdGpjQrs+Bnf7QRylH+alRB96ozV75hH+E9eqGR9anqQLOBWmC1C/4gPFII/x12QHBQU yD1yMD0v8VQ2BvXiamPytZ8yMuu49LEdl6DdchmUV+z77C/Uyx1ZheVx/hEkx0MFHLS97sQtY SehNmY9lesjn8tkhcZai6kPyi3tXr/rJPTGpUU1b+NB/NvpuCek5wpJJ6/ziDZtt4iQZu67K9 3rnsj6GK3EOH+tLijMOzD+cvF5+7QvNyeccq1rO99pN0YTJnz/sCWGwBwjZaBBzhTRsPj48t4 bZTpjYFam3feZA5Etu+DsmUPuGhIo4He7Bwr2Ww6JP8S6SqyA9mTLX4s1RDUMcCQEkCeT+IdE YvtZB4axAZvo11d8iMB5iLLSpj2Eh5QuFVo/aka2BGftJRPIxKZa6Mgr9PPdrpiZ7AtobA4hm RWWAHc15Zpm4YJgeMbDo2q3WiErR656k2r+8xy3LpANJ7EjMpjZ9MxC0qSN9iIEl5J3QvEEmk tzBmwdqXzHA+fXVXq/XY+Ak5GfLidBCgNRIV3C9KHS699+cxwpYivF6vJBSeqUsJ4AwQDmW99 BynoOu0TEJQjfxE7H3T4pA4pNidhQpSMh5OpLhWGtKLSiz23wmN1fiNXKGkae6DvOvAzHicAO zKHgIZjKWApJutkgsebP9PyySr1OOgfnE0O3olSymGuIwqVlpfnSzOdIk4L7T69sP9kgUNPfk Ivxk0g6bRuQ6dOhsggB0ETbWFbTbrpGMWx2psyNt61tR993EV/+KRXEKcV5PJpcL9vdgH+OE/ qB2v3u/mLJS+6zRFGGzeWMzhJXYtkgJTC3jtkcfQ9iHUCrTDC1VOltngG74KF1FNbxais/7az SzeXAVJEzBZx8yBgL+mfClCvwNrms5XxTqH4wAM7WENh3kh1WjAvqbetbTLXW7/+a0apVFr5l OV8vDq5/aIQUHQP/JHVcd32UVQqCjTgjSAUT2M3H8RY39fLbZWVvZkKS9AVrWTngOIHHeLFSf OKa6aL3eVVESxx84Mu1J27JaemeKh3osbbyF4bay/v0h8PZ+wvGUPHPpjduNrj4fQ7c2fBEK3 jPPU+yLGgefOx754FgfChSH7EEUNhTTuG5d8S3ytp5qbjUrnpR9N4QpwsNBpzMx/w3sWcTg/r WAC1fxNBSoYmxyzHAn9psCpJ6kHOc5AWrFbbvmXXEfGrSrPpvk0V67z7znjgN7Wnx6qJCc7gs GgdcxiWTVkNenNcT0GX6zWdmZ+7lE+YK5Uq4slmBdGq5UcmwLJyZ4MN+Q/lL7I5zRb5kUbmEY uGblFwUkY8IP60SMGaZEpMxyJfvLSEK6lIwb36TnBkBcjs/L+GjwsBMAZb7RdPPCSijEQXyZ7 LuUqunDxluIsGF2j6WzXIk10H28kd6Ry7+CCCFqvbPXw3SiKB4uB4QIIZRUfsFwiG/pP4RFAD 6TKbr8Mm1rwnZWVgz5J3Yus2wTdEfTf2kbCFyF7lFhcBp61KDrrydJIU81vNoL2s/73Y5Iktn FTfJuafkAeI57+zcaq4gSbtumq0RMXTiPSh/WoHZz8bt/E34OKU1a7JHF4jngDK9R95O1YIgi BMuC72TpqyyCJbEw1jEEXHjXAXCHZo0SCo8P4m+gMBxHcR8wcOetpcE2jNwdffke2Z8/GRWG0 oIWumF+u0LmwWI+OdxmbDVnXCGuow/qrrWWvWptteMSVFzPmfUj+yDUI0KFRC2Mc8OJH/5q1T 8XZvniuLSJT/eHYvxQToWsoW3NnOH0tnUE4y1JZ5IXygeeWEmcGIPAr0OaX3JoQtBQ9v1b5U0 TMtltMT1EZy09VmIQIWe3zwl/rxkjQVMHEWP9qHG1dqOAhRm9IjMo8oeXXNVijmMtAoY2Fk9Z qOoD6nUHgNJ3ol9utcFKbNmIrw8C1oeHGMAnC9AEpegOHJv6IIX8KyOWCrtnWn6ZvEgTxahI4 ZT8Y3pWTy4Oz3o1akIP2VkXuzggRt/+M26P229S25IEcXicEf9TwJ8TbtbNR1UXLiO0nldVnL 7AIHORpVqo0y2Tx15H32A02OcZ/iUL3KPEirZc1YuxT9nrw8x8mRGS6HDyVpgPg1zRn44a9Ey OcyJES4bATzjqrFMu8YQc+m7Ip3Z03KR7g0A1BFDlaOpbult3cnRUF/t8MH0gJkSz69Z30qFz 6sCEEwrMmMWANF0a/dPGb784+7QEvh3bbDYF8pApMCHjCrn/NvCVWW9sugJ02+BH4ep6Y4wPx b2AYeQynmdZn/rxZn5js97hdH8DGCFvTGNsdkLi5Qe9ijS2WZRhCQUQuIjLXtt7HyH1+YUI1l izox7TPzwLqGp0C1EiUIzOw9sb3xHKEOh/wdndu3uATq6WYUI6o/CVA+wc4x4Dx1ENt2rFmPv nRlo1WDSpVrU0Gb6h0w1u5B8hpKB4m0S1qotoCuPUD4Ss+Xh+TihVHg4uAV+8Fp1IfTxjgjJT J4rpu4Z86a0bBDsKPtmck9r9f4YnfQM/cuOmz136OYP+uIAClxb2vq7xDtjswR446TDPc/10A QUnAceEXTqa1AeJgsWAWYnTeqnCuYMdYzBKUdUJIvt0aKHcgcbnm7yKyYFMQmA3SB38A5q2u0 xUKRb4tGKFwVXnVtouTChqo+CPWOTS4Lf3fO7HjpoGUyOPTKJpC8PthpD50pZx49gqn1AHdKZ 9f3xCHy3LPA4qr4Inbp1yUEP8VTiLGuh0353qttE9FF4hwGnWwMWe5iXpJ4ZW97Q8QshfX1rV 28tuF7Ol3RIufQ6DnfSUKt2dZ8v8A2tXe96e2069UgSkjaFefR+9I= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello list, I have a table that is constantly growing, and it's not being=20 vacuumed/analyzed. I think my problem is rather common, but how to even=20 debug it if "nothing works"? I've already set log_autovacuum_min_duration =3D 0 but the table is never= =20 mentioned in my logs, grep'ing for "vacuum". I have run ANALYZE manually once but nothing automatic. Here is more info: > SELECT * FROM pg_stat_user_tables WHERE relname =3D=20 'test_runs_summarized_per_function' \gx -[ RECORD 1 ]-------+---------------------------------- relid | 780653 schemaname | public relname | test_runs_summarized_per_function seq_scan | 32 last_seq_scan | 2025-10-19 10:31:08.289922+00 seq_tup_read | 26484817584 idx_scan | 4554128 last_idx_scan | 2025-10-10 22:02:50.987532+00 idx_tup_fetch | 7418587674 n_tup_ins | 921064234 n_tup_upd | 0 n_tup_del | 0 n_tup_hot_upd | 0 n_tup_newpage_upd | 0 n_live_tup | 6484485348 n_dead_tup | 0 n_mod_since_analyze | 423101205 n_ins_since_vacuum | 921064234 last_vacuum | last_autovacuum | last_analyze | 2025-09-30 18:24:47.550543+00 last_autoanalyze | vacuum_count | 0 autovacuum_count | 0 analyze_count | 1 autoanalyze_count | 0 > SELECT reltuples FROM pg_class WHERE relname =3D=20 'test_runs_summarized_per_function' \gx -[ RECORD 1 ]----------- reltuples | 6.061923e+09 > SELECT name,setting FROM pg_settings WHERE name ILIKE '%factor%' ; name | setting =2D--------------------------------------+--------- autovacuum_analyze_scale_factor | 0.1 autovacuum_vacuum_insert_scale_factor | 0.2 autovacuum_vacuum_scale_factor | 0.2 recursive_worktable_factor | 10 How can I get more info from postgres on the autovacuum logic? Thank you in advance, Dimitris