many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
Date: 2025-06-24 14:22:38
Message-ID: CAHgTRfeXEVi=621+NV=y_m=pWiMGCoE42Y_oKRueqbNNjPhHJg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

-[ RECORD 1 ]-------+------------------------------
relid | 1259
schemaname | pg_catalog
relname | pg_class
seq_scan | 22173212
seq_tup_read | 153735849586
idx_scan | 12471735164
idx_tup_fetch | 12193538267
n_tup_ins | 3604618 <<<hehre
n_tup_upd | 617627
n_tup_del | 3605790 <<< here
n_tup_hot_upd | 566022
n_live_tup | 14252
n_dead_tup | 1257
n_mod_since_analyze | 52
n_ins_since_vacuum | 1119
last_vacuum | 2025-06-24 02:20:28.852129+00
last_autovacuum | 2025-06-24 11:39:14.281472+00
last_analyze | 2025-06-24 02:20:28.929375+00
last_autoanalyze | 2025-06-24 14:15:53.545063+00
vacuum_count | 367
autovacuum_count | 24628
analyze_count | 367
autoanalyze_count | 8904

Thanks,

James

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David G. Johnston 2025-06-24 14:31:12 Re: many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
Previous Message Dimitrios Apostolou 2025-06-17 16:23:09 Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized