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 1rgzgY-0092cS-S6 for pgsql-general@arkaria.postgresql.org; Mon, 04 Mar 2024 04:12:19 +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 1rgzgW-003sOY-AX for pgsql-general@arkaria.postgresql.org; Mon, 04 Mar 2024 04:12:16 +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 1rgzgW-003sOQ-0P for pgsql-general@lists.postgresql.org; Mon, 04 Mar 2024 04:12:16 +0000 Received: from mail-wr1-x42a.google.com ([2a00:1450:4864:20::42a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rgzgR-002eiW-1E for pgsql-general@lists.postgresql.org; Mon, 04 Mar 2024 04:12:15 +0000 Received: by mail-wr1-x42a.google.com with SMTP id ffacd0b85a97d-33e1207bba1so3234080f8f.1 for ; Sun, 03 Mar 2024 20:12:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1709525530; x=1710130330; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=gVz5WJwSVztK5rYrN63eehPY04L9Bti4SAdMe6LMEAk=; b=COv/xZ27CxyPl6i5upg00Z8B3ew9PjE/yuwpd6aQbJDmAfJlW+9x5q4I2aSQVaknGi pWWhv0WcsEbKTWQzJwgt6xAorn20fZk7QWxIRhKCMMG8+k71QEGSK0GWGQfbNvhV/Wn/ XWVj+IGKrLCoEV4pQ+zbQ6jjQRYqpVglC5eArNg/3rsNc4him8xmP0dqbdiurnDbKoeg B5oVsUFnjKPzPBxIFxuDujJVNPE/o+BVSWybU72+ofPP7cKijBs/J+Xv/qLOrQfgCbeU 4F77JMY2/ATpbc72/f/NSf0Ni2BnZ+gbQrgLCWuJ1RZC8YjmFm8Ny/ID4Svywfx7qpwX 2x8Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709525530; x=1710130330; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=gVz5WJwSVztK5rYrN63eehPY04L9Bti4SAdMe6LMEAk=; b=muoNnEXCwE5xSsemXpV+O+ZoX6ofbJID72g0rbwlpPtjS/6Gr0flm6pafBxCGXXQ0v Su63fk9lSz1SdRK7xzq23lD1C0HezyM2aLyjw+S+Y7vdNvnPaiCX75APDyv1eCi5H+Lo iyL5e45193SOt5XokRHrTOTTcl+X0dVWLcJXVEb7qwuOTJqcVmcbgeR3M3nY2zHdAu7/ eOn08zvnUWuoId2lJFLYoBm5BiA/yb6MD16JT1kTUXlV7tidFIRXsUCsYueb2whUem2J U0Lim4FaveHSurCDlM6svC9+R6oR7xkPBd45rrtNBw69ixjHbaDvhWSU1bp8pKfbbOoB n3XA== X-Forwarded-Encrypted: i=1; AJvYcCX5e1cF+xl71Ga5qq7sPuZMV7WrNFnkYVLrWN+zyTFiF1aD+XyC6Fh2jQjW5SjGGTf19eppt/dSmII1X+Nz1kN3ZPiHIIS5rZAp0oI+AM6dFiJE X-Gm-Message-State: AOJu0YyaFaWR+/0bxazOO8LGohWPit8eFMIRGK0MR2HGLgCG88Z5QirI zjpzDRdtKldFX3tpGjEgFCJr1+nUxldt8T8vyrIWfvYeGwKaHcpX7xsNdfjQ07I= X-Google-Smtp-Source: AGHT+IHlV4AIQe/IdaTRBkZFJkyuDte6MK0JpxHN62bU7EP33FLFlx0dmzOZvs8KNLafSwuKcL7X0w== X-Received: by 2002:a5d:4d8c:0:b0:33e:1deb:acb1 with SMTP id b12-20020a5d4d8c000000b0033e1debacb1mr6595749wru.36.1709525530053; Sun, 03 Mar 2024 20:12:10 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:eba2:d2c3:119e:d9c8:3367]) by smtp.gmail.com with ESMTPSA id i10-20020a05600011ca00b0033b60bad2fcsm11039295wrx.113.2024.03.03.20.12.09 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 03 Mar 2024 20:12:09 -0800 (PST) Message-ID: Subject: Re: When manual analyze is needed From: Laurenz Albe To: veem v , pgsql-general Date: Mon, 04 Mar 2024 05:12:09 +0100 In-Reply-To: References: Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2024-03-04 at 01:33 +0530, veem v wrote: > We see in one of the RDS postgres instances, from pg_stat_user_tables , > the auto vacuum and auto analyze happening on the tables without our > manual intervention. That's exactly the idea behind autovacuum. > So is auto vacuum analyze is sufficient=C2=A0 to make sure optimal stats > and unbloated table structure in place Yes, it is sufficient. If you have a busy database, you may have to tune autovacuum to keep up. The only things that require manual ANALYZE are 1. partitioned tables (autoanalyze will collect statistics on the partitions, but not the partitioned table itself) 2. after you create an index on an expression (otherwise you have to wait until autoanalyze runs to get statistics on the indexed expression) Yours, Laurenz Albe