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 1us6Nx-00HQnb-0T for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2025 21:11: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 1us6Nu-00CrMd-Pa for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2025 21:11:47 +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 1us6Nu-00CrMV-Cl for pgsql-admin@lists.postgresql.org; Fri, 29 Aug 2025 21:11:47 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1us6Ns-002ZTo-2Q for pgsql-admin@lists.postgresql.org; Fri, 29 Aug 2025 21:11:46 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-61bd4ba9fafso1041491eaf.0 for ; Fri, 29 Aug 2025 14:11:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756501902; x=1757106702; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=8r7cHItSS8B92GRm5lD7Hsr4vxVimL5DV5sm8uFm6KQ=; b=L93qqkBVCHply4PrWEfF4FhAVbGuyYX1MygVkgssUsf8WnF7T+pS3+HgY9XCXPKaed XBMvwywwZ7M5DS+NEHM9CY2h654AAEZ9cd3Nuoro7tRtlSgwdXCiHRXS5iGsSx0dOZGp tSyL+3hgXOYPtYJN8+ARAovBGT/Eb8ftu3roJsuUg+pk2cmpZYIJBB330EbWS5qGGg0+ GOwqY1ImSmxsDBlnmyuwIvia2MV8wMMeA+EMSraBYMK4asIwijpL6CwTPr15QSs736DU u/w3MNaZCzdxcihkn1/puf8ce3Qa17tZGIzy96jb8xSleiv/PNLrXcPxIthk/OP1QVbm FALg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756501902; x=1757106702; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=8r7cHItSS8B92GRm5lD7Hsr4vxVimL5DV5sm8uFm6KQ=; b=KsaUyrshHRtaAEbrSbZ3kL1c9YhmxYRKr3ozGJWTE2TiEysYRq0WGqlmSAyL9CY8WM zJtWL8VeWNOSC+tKW+X1BwAAM9bnIGcAtnpN3nL2EdJCKushKzLqirNA4xpngDvP6KZG PYHM+c5WleikdaHCd2+Yv9dlCGARjccltHEZMKcvF9o2ZWMe5ywfdBXAtb0rjhhrCbDH Lp0YJbcPcJYBU7CcCq/RQaBkYiLRVREOzuMFmcgSN1h4bAU7QdYV9zh3jlCSczowIUGt buk73XzqXbp92x3mEzAAQTJI6RcydM5wCjmjLilRP2sf/Zdx1mV7aUhniOafDtX9tCmU ZsvA== X-Gm-Message-State: AOJu0YyzCE28Teu0fhbju0JhT/bHayK8E+easON+5VBmIxPHTq16n0Ah YcajQy0Mr/ebCxRY3+k16UXzvXWfkd+1izBMlkjQvhswwjsJhPXzXpd62TUOQf9QHcORCugD29E pcGNr0rvWA6GqapRHRruAd7QXVM5/G0JB263S X-Gm-Gg: ASbGncu8T0pFrqujeU9Br7L2CTkjdPUzkVW/nrCuI0A3xxwGut8nlBdDRSAMw5Oohdk YpTRmHN7mroLF16+cDzlxKOzhmZAZvNOuJOXmY4ykIqM5leQu5IMT+mjQkARvLDd7ghsyDWA9Wy ZjsU1ppe2fS+jh3/PO7tVnKBJzCkqarSMFqDJYodQxZWIoJ+98VM+dXoeT9a9y9TwtcrgOw5gXt 0KjBnyCwr0PMVkRLiI= X-Google-Smtp-Source: AGHT+IEHM69+n1D7AFCpN1gglWEaf6ukL3q48UsVYNPHQtElINrz2GSrcdisYPsx4gIX+MKi4PMjVXbdyr6MvGZpHwM= X-Received: by 2002:a05:6808:f86:b0:437:d6b7:ad11 with SMTP id 5614622812f47-437f7cbee2bmr33231b6e.2.1756501901951; Fri, 29 Aug 2025 14:11:41 -0700 (PDT) MIME-Version: 1.0 From: Ron Johnson Date: Fri, 29 Aug 2025 17:11:29 -0400 X-Gm-Features: Ac12FXzYN2Lv6CB2NcMIyQZA9oJ5UcyIT8OaaKTWcWkh1pdVxIDhMXB5WkWHy9s Message-ID: Subject: Why might autovacuum not be analyzing chk_image_rp4_y2025m08? To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000e9c8ef063d8777f6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e9c8ef063d8777f6 Content-Type: text/plain; charset="UTF-8" PG 16.9 No messages like this in the log file: LOG: 55P03: skipping analyze of "chk_image_rp4_y2025m08" --- lock not available (The queries below are from a view joining pg_stat_user_tables and pg_class.) postgres=# select name, setting from pg_settings where name like 'autovacuum%' order by name; name | setting ---------------------------------------+----------- autovacuum | on autovacuum_analyze_scale_factor | 0.03 autovacuum_analyze_threshold | 50 autovacuum_freeze_max_age | 200000000 autovacuum_max_workers | 6 autovacuum_multixact_freeze_max_age | 400000000 autovacuum_naptime | 60 autovacuum_vacuum_cost_delay | 4 autovacuum_vacuum_cost_limit | 500 autovacuum_vacuum_insert_scale_factor | 0.03 autovacuum_vacuum_insert_threshold | 500 autovacuum_vacuum_scale_factor | 0.03 autovacuum_vacuum_threshold | 50 autovacuum_work_mem | -1 (14 rows) 2025-08-29 16:54:14.383 table_name | latest_analyze | mod_ana | reltuples | mod_pct ------------------------+-----------------+---------+-----------+--------- chk_image_rp1_y2025w34 | 07:01:20.265676 | 24 | 371 | 6.47 chk_image_rp3_y2025m08 | 11:48:52.968676 | 6 | 39 | 15.38 chk_image_rp4_y2025m08 | 01:13:59.213676 | 2976 | 97747 | 3.04 chk_image_rp6_y2025m08 | 11:48:53.055676 | 6 | 135 | 4.44 chk_image_rp7_y2025m08 | 07:03:20.206676 | 7 | 132 | 5.30 (5 rows) 2025-08-29 16:55:14.704 table_name |latest_analyze | mod_ana | reltuples | mod_pct ------------------------+---------------+---------+-----------+--------- chk_image_rp1_y2025w34 |07:02:20.58316 | 24 | 371 | 6.47 chk_image_rp3_y2025m08 |11:49:53.28616 | 6 | 39 | 15.38 chk_image_rp4_y2025m08 |01:14:59.53116 | 2977 | 97747 | 3.05 chk_image_rp6_y2025m08 |11:49:53.37316 | 6 | 135 | 4.44 chk_image_rp7_y2025m08 |07:04:20.52416 | 7 | 132 | 5.30 (5 rows) 2025-08-29 16:56:15.023 table_name | latest_analyze | mod_ana | reltuples | mod_pct ------------------------+-----------------+---------+-----------+--------- chk_image_rp1_y2025w34 | 07:03:20.908004 | 24 | 371 | 6.47 chk_image_rp3_y2025m08 | 11:50:53.611004 | 6 | 39 | 15.38 chk_image_rp4_y2025m08 | 01:15:59.856004 | 2977 | 97747 | 3.05 chk_image_rp6_y2025m08 | 11:50:53.698004 | 6 | 135 | 4.44 chk_image_rp7_y2025m08 | 07:05:20.849004 | 7 | 132 | 5.30 (5 rows) 2025-08-29 16:57:15.344 table_name | latest_analyze | mod_ana | reltuples | mod_pct ------------------------+-----------------+---------+-----------+--------- chk_image_rp1_y2025w34 | 07:04:21.223701 | 24 | 371 | 6.47 chk_image_rp3_y2025m08 | 11:51:53.926701 | 6 | 39 | 15.38 chk_image_rp4_y2025m08 | 01:17:00.171701 | 2977 | 97747 | 3.05 chk_image_rp6_y2025m08 | 11:51:54.013701 | 6 | 135 | 4.44 chk_image_rp7_y2025m08 | 07:06:21.164701 | 7 | 132 | 5.30 (5 rows) 2025-08-29 16:58:15.662 table_name | latest_analyze | mod_ana | reltuples | mod_pct ------------------------+-----------------+---------+-----------+--------- chk_image_rp1_y2025w34 | 07:05:21.542831 | 24 | 371 | 6.47 chk_image_rp3_y2025m08 | 11:52:54.245831 | 6 | 39 | 15.38 chk_image_rp4_y2025m08 | 01:18:00.490831 | 2977 | 97747 | 3.05 chk_image_rp6_y2025m08 | 11:52:54.332831 | 6 | 135 | 4.44 chk_image_rp7_y2025m08 | 07:07:21.483831 | 7 | 132 | 5.30 (5 rows) [snip] 2025-08-29 17:08:18.849 table_name | latest_analyze | mod_ana | reltuples | mod_pct ------------------------+-----------------+---------+-----------+--------- chk_image_rp1_y2025w34 | 07:15:24.727084 | 24 | 371 | 6.47 chk_image_rp3_y2025m08 | 12:02:57.430084 | 6 | 39 | 15.38 chk_image_rp4_y2025m08 | 01:28:03.675084 | 2977 | 97747 | 3.05 chk_image_rp6_y2025m08 | 12:02:57.517084 | 6 | 135 | 4.44 chk_image_rp7_y2025m08 | 07:17:24.668084 | 7 | 132 | 5.30 (5 rows) -- Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000e9c8ef063d8777f6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
PG 16.9

No messages like thi= s in the log file:
LOG: =C2=A055P03: skipping analyze of "chk_image_rp4_y2025m08" ---= lock not available

(The queries below are from a = view joining=C2=A0pg_stat_user_tables and pg_class.)

postgres=3D# select name, setting from pg_setti= ngs where name like 'autovacuum%' order by name;
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0name =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0setting =C2=A0
--------= -------------------------------+-----------
=C2=A0autovacuum =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0| on
=C2=A0autovacuum_analyze_scale_factor =C2=A0 =C2=A0 = =C2=A0 | 0.03
=C2=A0autovacuum_analyze_threshold =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0| 50
=C2=A0autovacuum_freeze_max_age =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | 200000000
=C2=A0autovacuum_max_workers =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 6
=C2=A0autovacuum_multix= act_freeze_max_age =C2=A0 | 400000000
=C2=A0autovacuum_naptime =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 60
=C2= =A0autovacuum_vacuum_cost_delay =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 4
= =C2=A0autovacuum_vacuum_cost_limit =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 500<= br>=C2=A0autovacuum_vacuum_insert_scale_factor | 0.03
=C2=A0autovacuum_v= acuum_insert_threshold =C2=A0 =C2=A0| 500
=C2=A0autovacuum_vacuum_scale_= factor =C2=A0 =C2=A0 =C2=A0 =C2=A0| 0.03
=C2=A0autovacuum_vacuum_thresho= ld =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 50
=C2=A0autovacuum_work_mem =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | -1
(14 row= s)

2025-08-29 = 16:54:14.383
=C2=A0 =C2=A0 =C2=A0 =C2=A0table_name =C2=A0 =C2=A0 =C2=A0 = | latest_analyze =C2=A0| mod_ana | reltuples | mod_pct
----------------= --------+-----------------+---------+-----------+---------
=C2=A0chk_ima= ge_rp1_y2025w34 | 07:01:20.265676 | =C2=A0 =C2=A0 =C2=A024 | =C2=A0 =C2=A0 = =C2=A0 371 | =C2=A0 =C2=A06.47
=C2=A0chk_image_rp3_y2025m08 | 11:48:52.= 968676 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 =C2=A039 | =C2=A0 15= .38
=C2=A0chk_image_rp4_y2025m08 | 01:13:59.213676 | =C2=A0 =C2=A02976 = | =C2=A0 =C2=A0 97747 | =C2=A0 =C2=A03.04
=C2=A0chk_image_rp6_y2025m08 = | 11:48:53.055676 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 135 | =C2= =A0 =C2=A04.44
=C2=A0chk_image_rp7_y2025m08 | 07:03:20.206676 | =C2=A0 = =C2=A0 =C2=A0 7 | =C2=A0 =C2=A0 =C2=A0 132 | =C2=A0 =C2=A05.30
(5 rows)=

2025-08-29 16:55:14.704
=C2=A0 =C2=A0 =C2=A0 =C2=A0table_name = =C2=A0 =C2=A0 =C2=A0 |latest_analyze | mod_ana | reltuples | mod_pct
--= ----------------------+---------------+---------+-----------+---------
= =C2=A0chk_image_rp1_y2025w34 |07:02:20.58316 | =C2=A0 =C2=A0 =C2=A024 | =C2= =A0 =C2=A0 =C2=A0 371 | =C2=A0 =C2=A06.47
=C2=A0chk_image_rp3_y2025m08 = |11:49:53.28616 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 =C2=A039 | = =C2=A0 15.38
=C2=A0chk_image_rp4_y2025m08 |01:14:59.53116 | =C2=A0 =C2= =A02977 | =C2=A0 =C2=A0 97747 | =C2=A0 =C2=A03.05
=C2=A0chk_image_rp6_y= 2025m08 |11:49:53.37316 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 135= | =C2=A0 =C2=A04.44
=C2=A0chk_image_rp7_y2025m08 |07:04:20.52416 | =C2= =A0 =C2=A0 =C2=A0 7 | =C2=A0 =C2=A0 =C2=A0 132 | =C2=A0 =C2=A05.30
(5 r= ows)

2025-08-29 16:56:15.023
=C2=A0 =C2=A0 =C2=A0 =C2=A0table_nam= e =C2=A0 =C2=A0 =C2=A0 | latest_analyze =C2=A0| mod_ana | reltuples | mod_p= ct
------------------------+-----------------+---------+-----------+---= ------
=C2=A0chk_image_rp1_y2025w34 | 07:03:20.908004 | =C2=A0 =C2=A0 = =C2=A024 | =C2=A0 =C2=A0 =C2=A0 371 | =C2=A0 =C2=A06.47
=C2=A0chk_image= _rp3_y2025m08 | 11:50:53.611004 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 = =C2=A0 =C2=A039 | =C2=A0 15.38
=C2=A0chk_image_rp4_y2025m08 | 01:15:59.= 856004 | =C2=A0 =C2=A02977 | =C2=A0 =C2=A0 97747 | =C2=A0 =C2=A03.05
= =C2=A0chk_image_rp6_y2025m08 | 11:50:53.698004 | =C2=A0 =C2=A0 =C2=A0 6 | = =C2=A0 =C2=A0 =C2=A0 135 | =C2=A0 =C2=A04.44
=C2=A0chk_image_rp7_y2025m= 08 | 07:05:20.849004 | =C2=A0 =C2=A0 =C2=A0 7 | =C2=A0 =C2=A0 =C2=A0 132 | = =C2=A0 =C2=A05.30
(5 rows)

=C2=A02025-08-29 16:57:15.344
=C2= =A0 =C2=A0 =C2=A0 =C2=A0table_name =C2=A0 =C2=A0 =C2=A0 | latest_analyze = =C2=A0| mod_ana | reltuples | mod_pct
------------------------+--------= ---------+---------+-----------+---------
=C2=A0chk_image_rp1_y2025w34 |= 07:04:21.223701 | =C2=A0 =C2=A0 =C2=A024 | =C2=A0 =C2=A0 =C2=A0 371 | =C2= =A0 =C2=A06.47
=C2=A0chk_image_rp3_y2025m08 | 11:51:53.926701 | =C2=A0 = =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 =C2=A039 | =C2=A0 15.38
=C2=A0ch= k_image_rp4_y2025m08 | 01:17:00.171701 | =C2=A0 =C2=A02977 | =C2=A0 =C2=A0 = 97747 | =C2=A0 =C2=A03.05
=C2=A0chk_image_rp6_y2025m08 | 11:51:54.01370= 1 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 135 | =C2=A0 =C2=A04.44 <= br>=C2=A0chk_image_rp7_y2025m08 | 07:06:21.164701 | =C2=A0 =C2=A0 =C2=A0 7 = | =C2=A0 =C2=A0 =C2=A0 132 | =C2=A0 =C2=A05.30
(5 rows)

2025-08-= 29 16:58:15.662
=C2=A0 =C2=A0 =C2=A0 =C2=A0table_name =C2=A0 =C2=A0 =C2= =A0 | latest_analyze =C2=A0| mod_ana | reltuples | mod_pct
------------= ------------+-----------------+---------+-----------+---------
=C2=A0chk= _image_rp1_y2025w34 | 07:05:21.542831 | =C2=A0 =C2=A0 =C2=A024 | =C2=A0 =C2= =A0 =C2=A0 371 | =C2=A0 =C2=A06.47
=C2=A0chk_image_rp3_y2025m08 | 11:52= :54.245831 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 =C2=A039 | =C2= =A0 15.38
=C2=A0chk_image_rp4_y2025m08 | 01:18:00.490831 | =C2=A0 =C2= =A02977 | =C2=A0 =C2=A0 97747 | =C2=A0 =C2=A03.05
=C2=A0chk_image_rp6_y= 2025m08 | 11:52:54.332831 | =C2=A0 =C2=A0 =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 1= 35 | =C2=A0 =C2=A04.44
=C2=A0chk_image_rp7_y2025m08 | 07:07:21.483831 |= =C2=A0 =C2=A0 =C2=A0 7 | =C2=A0 =C2=A0 =C2=A0 132 | =C2=A0 =C2=A05.30
= (5 rows)
[snip]
= 2025-08-29 17:08:18.849
=C2=A0 =C2=A0 =C2=A0 = =C2=A0table_name =C2=A0 =C2=A0 =C2=A0 | latest_analyze =C2=A0| mod_ana | re= ltuples | mod_pct
------------------------+-----------------+---------+= -----------+---------
=C2=A0chk_image_rp1_y2025w34 | 07:15:24.727084 | = =C2=A0 =C2=A0 =C2=A024 | =C2=A0 =C2=A0 =C2=A0 371 | =C2=A0 =C2=A06.47
= =C2=A0chk_image_rp3_y2025m08 | 12:02:57.430084 | =C2=A0 =C2=A0 =C2=A0 6 | = =C2=A0 =C2=A0 =C2=A0 =C2=A039 | =C2=A0 15.38
=C2=A0chk_image_rp4_y2025m= 08 | 01:28:03.675084 | =C2=A0 =C2=A02977 | =C2=A0 =C2=A0 97747 | =C2=A0 =C2= =A03.05
=C2=A0chk_image_rp6_y2025m08 | 12:02:57.517084 | =C2=A0 =C2=A0 = =C2=A0 6 | =C2=A0 =C2=A0 =C2=A0 135 | =C2=A0 =C2=A04.44
=C2=A0chk_image= _rp7_y2025m08 | 07:17:24.668084 | =C2=A0 =C2=A0 =C2=A0 7 | =C2=A0 =C2=A0 = =C2=A0 132 | =C2=A0 =C2=A05.30
(5 rows)

= --
De= ath to <Redacted>, and butter sauce.
Don't boil me, I'm s= till alive.
<Redacted> lobster!
<= /div>
--000000000000e9c8ef063d8777f6--