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 1uU4Y5-00F4sy-Jz for pgsql-performance@arkaria.postgresql.org; Tue, 24 Jun 2025 14:22:57 +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 1uU4Y3-00CZby-8W for pgsql-performance@arkaria.postgresql.org; Tue, 24 Jun 2025 14:22:55 +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 1uU4Y2-00CZbp-SS for pgsql-performance@lists.postgresql.org; Tue, 24 Jun 2025 14:22:55 +0000 Received: from mail-yw1-x1129.google.com ([2607:f8b0:4864:20::1129]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uU4Y1-003q0l-1S for pgsql-performance@lists.postgresql.org; Tue, 24 Jun 2025 14:22:55 +0000 Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-70f862dbeaeso52499327b3.1 for ; Tue, 24 Jun 2025 07:22:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750774971; x=1751379771; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=k1GaZlrc8yypY9aHW4TK/5lRqizsu1m3u4rDVHERK5g=; b=ZYc/qltmXj6sERalr1HCG9A5x2Z9wL2qc6z4CDQr1xNgmn9Dw+dBXMYrIgDmixgMyr Kiaf7Pbyjnq7IYPaetx3KKbMGL1c18tOpJacPbDwIwMpW4i7YgQ20ved1MB3EoUSn2VN TKFGuudkvLP5Kg+BgXYz3YDWIlEyig4JPO7DI3JMND6Sd6ujUy7HvRzf+SMVnudm7XYu SK2DLp8lVxxZOBck86rCjy/aBmVDYUNW5Sqo/n70R+uAAZI2sGDibfwKtjnnv6Vfq1t2 Hn4YQnRh7JiLmO5M924tU9nmcTTk22HIL6AORxCLjlgdC8ay37uM/cyuKDTIjCOgoZdB V2Ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750774971; x=1751379771; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=k1GaZlrc8yypY9aHW4TK/5lRqizsu1m3u4rDVHERK5g=; b=qPB0Z3pk92EXuuhiSGuL7tW/mVeDKyO1BwlnSs94JyoCOQ6bn7P0C6cwEePbnGzfum MA5SMZWU100oJn7znfo32Mka4XxojsNXASrifQ4bWTK6d/vJ5Y/L67goAgJeOpDfgV+A zdLbwiw9R8/75xGf51uRGLDB62AcLkWUaP9yEHu3hbHfLUCuM6lXEzdzLM4yXjjFkx55 Q/eATsgTV/9xTU6CLUnk/Li8u2b2mFOTPc1/NIbFzBw8Qcc1zO0jtgrP8pcUlIE317Jf +XYVDEG3jYNiWx0o5AFf7YcJQs4AbUyDp8dhp+sq7lYEU0jenO6FjHC5YyKfBEAOIKHC FDoQ== X-Gm-Message-State: AOJu0YwqsTIOuHHhnvXiLw06e1hA9AsjpO7i+uHEwdwXUqn9XVd0LavW Kw53VnF8nwPQpIj+2Al8G+W2+7GCCLOOrt2E/PIlL/gCLCNMWQnhigR4ObX26vEAqKJS9hVMXdT jmFb6iXXqQhNpayQmJbFq6KLRV9dTseUfCiVI X-Gm-Gg: ASbGnctARUGsZseCPU/XsjOraBddPa6uj7R1tpaSArqykFVaDnF6LEB39VKy8TWA6rE TTaPuCZ7mraJ8URfPoDG+GBvnIQzvjABn5TTKFzhrwob64e/ikcPE5PTxPyBss2qT2oUr40Aqij 3vqyD9VR4C4uk7hrNpVk8EenFzR0/HlfKPWoquR1W4mWQ= X-Google-Smtp-Source: AGHT+IGFy4mzG1TwoxWm6r6u/RU0MgbkQY6ogISY4KIWA4Hn4YgciU2tX09ptQQhXc5nqv1cXj2VaibDdAay8g6D74M= X-Received: by 2002:a05:690c:f90:b0:70e:719e:75e with SMTP id 00721157ae682-712c63b17ddmr224111947b3.9.1750774971275; Tue, 24 Jun 2025 07:22:51 -0700 (PDT) MIME-Version: 1.0 From: James Pang Date: Tue, 24 Jun 2025 22:22:38 +0800 X-Gm-Features: Ac12FXwt-ltfa80vbQT2URURSd8idLZDnfEzj-OxGv0-47bY1dhIL1Kj2Fc1IhQ Message-ID: 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? To: pgsql-performance@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000003e9e43063852102a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003e9e43063852102a Content-Type: text/plain; charset="UTF-8" -[ 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 <<-[ RECORD 1 ]-------+------------------------------
rel= id =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 1259
schemaname = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| pg_catalog
relname =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | pg_class
seq_scan =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0| 22173212
seq_tup_read =C2=A0 =C2=A0 =C2=A0 =C2=A0| 15373= 5849586
idx_scan =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 12471735164<= br>idx_tup_fetch =C2=A0 =C2=A0 =C2=A0 | 12193538267
n_tup_ins =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | 3604618=C2=A0 =C2=A0 =C2=A0 =C2=A0<<<he= hre=C2=A0
n_tup_upd =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 617627
n_tup= _del =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 3605790=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0<<< here=C2=A0
n_tup_hot_upd =C2=A0 =C2=A0 =C2=A0 | 5= 66022
n_live_tup =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 14252
n_dead_tup= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1257
n_mod_since_analyze | 52
n_= ins_since_vacuum =C2=A0| 1119
last_vacuum =C2=A0 =C2=A0 =C2=A0 =C2=A0 | = 2025-06-24 02:20:28.852129+00
last_autovacuum =C2=A0 =C2=A0 | 2025-06-24= 11:39:14.281472+00
last_analyze =C2=A0 =C2=A0 =C2=A0 =C2=A0| 2025-06-24= 02:20:28.929375+00
last_autoanalyze =C2=A0 =C2=A0| 2025-06-24 14:15:53.= 545063+00
vacuum_count =C2=A0 =C2=A0 =C2=A0 =C2=A0| 367
autovacuum_co= unt =C2=A0 =C2=A0| 24628
analyze_count =C2=A0 =C2=A0 =C2=A0 | 367
aut= oanalyze_count =C2=A0 | 8904

Thanks,

<= /div>
James
--0000000000003e9e43063852102a--