Content-Type: multipart/alternative;
 boundary="------------604KVak7W8GBVjrtV9HecBm0"
Message-ID: <aeec68b8-9602-4572-b530-2c09a892df03@ya.ru>
Date: Mon, 26 Jan 2026 17:35:42 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: autoanalyze did not run
To: Laurenz Albe <laurenz.albe@cybertec.at>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: <0dce35ca-24fa-4234-99fe-071bd5725a32@ya.ru>
 <c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at>
Content-Language: ru, en-US
From: =?UTF-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= <splarv@ya.ru>
In-Reply-To: <c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/aeec68b8-9602-4572-b530-2c09a892df03%40ya.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------604KVak7W8GBVjrtV9HecBm0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit


26.01.2026 10:23, Laurenz Albe пишет:
> On Mon, 2026-01-26 at 08:31 +0300, Олег Самойлов wrote:
>> I try to investigate why autoanalyze did not run in time of our initial
>> loading data. Yes, I know, running analyze manually is highly
>> recommended in such case. But is must run automatically too.
> You'd have to show more evidence that this is a bug, or provide a way
> to reproduce the problem.
I need to narrow my case, that why I need to know on what exactly 
depends (on what column) the launching the autoexplain.
>> select relid::regclass, n_live_tup, n_tup_ins, n_tup_upd,
>> n_mod_since_analyze from pg_stat_user_tables as s join pg_class as c on
>> (s.relid=c.oid) where s.autoanalyze_count=0 and relkind='r' and
>> n_live_tup>0 limit 1;
>> -[ RECORD 1 ]-------+----------
>> relid               | addresses
>> n_live_tup          | 13844405
>> n_tup_ins           | 0
>> n_tup_upd           | 0
>> n_mod_since_analyze | 0
>>
>> PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu,
>> compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit (from PGDG)
> Are you sure that you committed the transaction?

I am very sure, thats why there are 13844347 rows in that table. By 
single copy.

> Is "track_activities" set to "on"?

I checked, yep.

> Yours,
> Laurenz Albe
--------------604KVak7W8GBVjrtV9HecBm0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class="moz-cite-prefix">26.01.2026 10:23, Laurenz Albe пишет:<br>
    </div>
    <blockquote type="cite"
cite="mid:c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at">
      <pre wrap="" class="moz-quote-pre">On Mon, 2026-01-26 at 08:31 +0300, Олег Самойлов wrote:
</pre>
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">I try to investigate why autoanalyze did not run in time of our initial 
loading data. Yes, I know, running analyze manually is highly 
recommended in such case. But is must run automatically too.
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
You'd have to show more evidence that this is a bug, or provide a way
to reproduce the problem.
</pre>
    </blockquote>
    I need to narrow my case, that why I need to know on what exactly
    depends (on what column) the launching the autoexplain.
    <blockquote type="cite"
cite="mid:c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at">
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">select relid::regclass, n_live_tup, n_tup_ins, n_tup_upd, 
n_mod_since_analyze from pg_stat_user_tables as s join pg_class as c on 
(s.relid=c.oid) where s.autoanalyze_count=0 and relkind='r' and 
n_live_tup&gt;0 limit 1;
-[ RECORD 1 ]-------+----------
relid               | addresses
n_live_tup          | 13844405
n_tup_ins           | 0
n_tup_upd           | 0
n_mod_since_analyze | 0

PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu, 
compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit (from PGDG)
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
Are you sure that you committed the transaction?</pre>
    </blockquote>
    <p>I am very sure, thats why there are 13844347 rows in that table.
      By single copy.</p>
    <p><span style="white-space: pre-wrap">
</span><span style="white-space: pre-wrap">
</span></p>
    <blockquote type="cite"
cite="mid:c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at">
      <pre wrap="" class="moz-quote-pre">Is "track_activities" set to "on"?</pre>
    </blockquote>
    <p>I checked, yep.</p>
    <p><span style="white-space: pre-wrap">
</span></p>
    <blockquote type="cite"
cite="mid:c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at">
      <pre wrap="" class="moz-quote-pre">Yours,
Laurenz Albe
</pre>
    </blockquote>
  </body>
</html>

--------------604KVak7W8GBVjrtV9HecBm0--