gistfile1.txt

Results from pg_stat_all_tables for Postgres 16.11

--- after update-inlist which precedes update-one

relid               | 16724
schemaname          | public
relname             | sbtest5
seq_scan            | 7
last_seq_scan       | 2026-01-01 11:24:56.626549+00
seq_tup_read        | 1500000000
idx_scan            | 23998133
last_idx_scan       | 2026-01-01 12:32:59.141769+00
idx_tup_fetch       | 46804750
n_tup_ins           | 250000000
n_tup_upd           | 7209997
n_tup_del           | 0
n_tup_hot_upd       | 1915466
n_tup_newpage_upd   | 4486547
n_live_tup          | 250000009
n_dead_tup          | 6739337
n_mod_since_analyze | 7209997
n_ins_since_vacuum  | 0
last_vacuum         | 2026-01-01 10:59:28.801882+00
last_autovacuum     | 2026-01-01 09:14:33.198324+00
last_analyze        | 2026-01-01 10:59:29.890017+00
last_autoanalyze    | 2026-01-01 09:14:33.601996+00
vacuum_count        | 1
autovacuum_count    | 55
analyze_count       | 1
autoanalyze_count   | 34

--- after update-zipf

relid               | 16724
schemaname          | public
relname             | sbtest5
seq_scan            | 7
last_seq_scan       | 2026-01-01 11:24:56.626549+00
seq_tup_read        | 1500000000
idx_scan            | 47100145
last_idx_scan       | 2026-01-01 13:04:10.190855+00
idx_tup_fetch       | 69906762
n_tup_ins           | 250000000
n_tup_upd           | 30312009
n_tup_del           | 0
n_tup_hot_upd       | 23613573
n_tup_newpage_upd   | 5890452
n_live_tup          | 249996441
n_dead_tup          | 9723067
n_mod_since_analyze | 5145902
n_ins_since_vacuum  | 0
last_vacuum         | 2026-01-01 10:59:28.801882+00
last_autovacuum     | 2026-01-01 09:14:33.198324+00
last_analyze        | 2026-01-01 10:59:29.890017+00
last_autoanalyze    | 2026-01-01 12:47:45.278664+00
vacuum_count        | 1
autovacuum_count    | 55
analyze_count       | 1
autoanalyze_count   | 35