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 1rVFtw-00Fonh-Ow for pgsql-general@arkaria.postgresql.org; Wed, 31 Jan 2024 19:05:39 +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 1rVFtv-00G1yf-E0 for pgsql-general@arkaria.postgresql.org; Wed, 31 Jan 2024 19:05:35 +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 1rVFtu-00G1yX-EQ for pgsql-general@lists.postgresql.org; Wed, 31 Jan 2024 19:05:35 +0000 Received: from sonic314-14.consmr.mail.bf2.yahoo.com ([74.6.132.124]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rVFtq-004lKH-Ci for pgsql-general@lists.postgresql.org; Wed, 31 Jan 2024 19:05:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.br; s=s2048; t=1706727926; bh=kuh00UfAN9KIShmSs+C6u2gPM6QKKb0BX4QS+EQgfic=; h=Date:From:Reply-To:To:Subject:References:From:Subject:Reply-To; b=Z80XJTY5JkEFyWdWnndGsNFnZSgLpLSUr2/GogTK/mJNIenGL1jOb8T8is6QuZmwZnF5laspNv0UfrmmAnUsLVlSeVR9r1SxlTOOyzilAYw8A1aU8dW3/GepJ5LvJ9gMFcE0ZAPYj7s9jwjalJ3LKqWcxvmEy/KClgSq2kSerb3muCz/es8DuJtOh7L1QqTdpc4vk+Bss6E0u60gItAsM8tO2J8CRwWvbMK9ycVnne5tux5UTYH4TmvLdHuzzwJnrMMWDRnGytRELEi+jiN/sfn1raei3Mv/VKUAQC0Zfer2ySln4nDe2awilwKnoyRN3HM3/3SzqXbPA8kwsDoymg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1706727926; bh=BHAjZBENf6Q4U9HC33/Gy3X5QWUiho+UT9kL4dyWAEH=; h=X-Sonic-MF:X-Sonic-MF:Date:From:To:Subject:From:Subject; b=jN2Alr8fZKXbr4V9dg0FcE/bNJfpQO2rwFnUs3i34Et7V55rOQwsY3tZEnaVM4RkAvI8Q7Kdtpe5+pjLsx8GXPj5kkFmNryKrgZY0pxJi9NT7Fhq+H09MhnrYxae3dtcxgKKjSnFxvM9Z7W58JhSoctu+9KXBbDEXxtMbS+yDh4l+NnKg7CIzhk9C1ZH2ugq2PXkkNT5jIAw+nF1UDu6r2crawKmLKyOjqpNRBA26BsXBmA536lgxCbSqjP9XWiFYHwEoVxKXUdcIe6y5VaHJh05BGq9RtXEfWQhaaF+PpWe+5H0ECtrdmIKtMBTdkoFAodTHFm+8V7a71C4c8mIkw== X-YMail-OSG: ldnOoYAVM1m9zLJ4U5_oR4.9yJOXjmMd10WTNZIN6HGqJzcCRdy0f_Y8lG80v5W RsaWLOM5WyQ4RuY0oIt4Ny4ioTFB_v69OPoJyEUpv9EnRXuf4YGNpN.6I1bnA689VOWxfcrs1h.H Njm3_NLY4YoJgpU8TG4EA_Ll7rGYthgB2KhZlcTZtq5bxr0Ry_QquX_d.Gj5EmlJVG.V1MUcYR.S GxoODXWChlgR6Atuueh74b1A2_rYENS4xWV.DpJEdaGT.rF81qDN78jAmE8GL7nNJ_wRXmpCqMQw bjHhUl5ohaJXg10EynjdTDtjVQ3eUj5.8mSr_Q5cDyhwH_l6sUVjDE8pm.Q_ICu7K9aX8UlB3Cex Q.kL93Z5l7wgUQe9zVa49RnYIYyTctVnCODmlB820zx6OsKNqrXGBVGM4iQKX2JUEEr17oBZ8VT7 A1gGtdA19wCqgHyTfzq6V45ll9zzpOV2DvRLGpaDXuT4_ybGypJ94hvQbgCbpXAHjMgMRT0wPC6T q426huVEjy4zRhi5K695WsCaJQrJRR3mvIeLIL456_VYBk.YDh41KlWph_Qs_rQNgQJJNhDwZyhV _ifrw6uMSVLsfn3JpCsQ9GyOwTpN7wf9NtMnQpH_MroxeE.brAw7wiea74P_72zbqHW2nYoWjoxB Kif687J8oy0Teak152po5P77.r8GA9Cpaa.qasoaAJApbR3z2UxZyT33BbACbddquddz3nptQ2QY Ex3fOxbGGGI.Xz3r3z_KnfvEMzh7TxkeDftmB2tNl2LvxyEj7YCOkW28c4bORnBYZ24BxkAhJvcf aDfnYOaRPlrQj4KFyZhi84QnGw9mcqkAZuCZ7ZXh5iRHcCNDaErjKKKcD6HAHkHiVKMizbUwoWj6 AIQaucBuZhDhMTdRMvRsGLAwlaXq9PoammLry2hhaiiiSkP4JYRCwuz.a3qzEGW2me5709d7QMWY vd_YxYJON6zRn1TZiX0ZSYmORSv1WT4xxwMsbvOC_ZLdkuUtckvL0E7QyzwdBjYz8AhudRVIyT4I zmXxyy7Gcp4vPd1xu5C_A2OhHG.fJ1Wi4kH3k1EcBbhs_WxOpRPS2vWIvvbgc09XcaPu0DgrISCd qc8feovlWNolJnBiOg3rJBVoA9uZTFQfEM_4qZ1U4xSoEn27R2pD1oUeK_Fg8U5eoAfqIpmQWFWg hyNzZcvX4dVzk.Y.i0nnNiRy_EDDocSqT0EIj2Bn2ISodx12LkdxADN4RAwdlSWZ7onBHR5k_Omc 5pXpBx9b4y69kcfjyN8OJpselIaixKtRpkFPpm1dLaZT9sq.qBEiA3JH8pm_DOEceygF4lqAEwg2 EgsCK0fvSPFsXCs.7nfh9KulR5wFS0DFF6DBggIP9o7rEahzYSnI_7OkKXocVAgQc57bIA7YHi78 Vv3jHyDmMtv.uvFm2kOikuAmxIzkOi9gp80MZLxYesI4kfKEHi5U20I1gNYoJvYeIP1cCjbx2odD uwo0r33hr16BqGExnZkLKLagBRaZeXWQcky9DG5K5Vz00kT75UeDpBOKLLObN66b35NqAqSHH2zf 7ER1HzBFi.a0TPZlCIPBNQUdd_Bet3LsNQQy.HU.uSFARl7H459zhnGVWdw2gEQoWDNGbri2nAKN 5OCI1O5LXxT0oXlAYuSglqwJkYzV_U3XBkv6M3HGdii1t6zHMfyDRAqgABVwyGTOtSYAGABDN2CJ IUk1SJ00p6diJhRYieUqDkjVmeTquAx97.U79x7m2JgaMcwZtYpuTjopmUBNvOAoK6fVYjF4vGmo ETYnJbW_I7.LSVWEzOhRYUHKbqO5OPyfm1PY8YVyGh_6khEsD7KP2FQEZm1uUS3a_FhvW2_EAo69 NvaZaj8pJ6xmmBLtj1HRsT9CDpzFzrrrIrAR1.iZIiycRZRGLRvtK6Rk20ePOyEx1J_Il6x.7RTR 7p8iOCvUyp7V_zt_nwI2z0urMbwhodHnSpr5GRGKmH9nVbQ_rLtZsvULKshJhpYzboiOTaM5EQd1 UdiAuYtCGVn7zaWhEW3kghe8M4yO7xWSsGd8thDCn3eJeVFL7m_tkuA6eSMNZG_POh8Y7BU476Oq e4vCHCr6aKEtp7qD3DV_qZx7zTGKksRP_In9r6Z3Mp10W2QfeExVqx7csaUHcUdEHeO80rxFhWRE D_atxYJXfP9fntWLgY8jWXqqaLjxqD3tRJK9P4hUb5Clno61lZDGZQbWd9XWBrxGUsQ0vf5qqTEm PQLxOMv4mCnrUE7ktON9l5frYRMFelyxunIuKLObnZSdgigMyu6UBs_HRUehyQ7SyNekbLXRXjon tvUBjeC8VoV5oTdJbp8_jXMVo X-Sonic-MF: X-Sonic-ID: 796ecd6e-e24d-4b72-b083-1f8e5ee384e3 Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Wed, 31 Jan 2024 19:05:26 +0000 Received: by hermes--production-gq1-5c57879fdf-kht2b (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 22340c609c976061ab3a88e1710b42ed; Wed, 31 Jan 2024 19:05:24 +0000 (UTC) X-YMail-OSG: KqTe8yEVM1lku2w6PcwN_ZsZ3YFfekQDCQGQPIntns.FdLHLFMRuhhfqNhyt70X uCv5rewwjWHKr8rlL09BJIjfkW8zyZRVRcABV6t2ee7x0iHNlo..9Z5XRkM5YZ6_IY0FGWl1GMwW yVETjCkC0m7nhJxYTGKf7QP6NvvOcTPSrVUKArmYPWCMej5uvzh6Ssajhh9Dj2PdcEBl7Mc5NGGI 3vRMqSY6s644vRDNeWsH70aI.lKpTOZSF_Z_6tJLs_RItp6etjDqDNSJkVpCgEjwTE02HmR090wQ Td2wbiNf1q6LXikOY.uvB2IkEHan9KBZ3aykP8f.Die6qSWU8nPpk7OfKghjx7s.E4yQzdhStAVU Z8EvbTTYDv_YQTReHa1g32ywQQ2B.u.Axjbmj24znkATskoKURumJtQTU7IM6.8kBLtK0keDdlzM 7yVKp9iIkdOjnyoV65Y3NOs2rM.7A2ej6U.Sc_D3sZGYrC6.ZsBw5VDwVe7r3DqXRKV..JGuIefS v0bFTARGw.BwSSopoOjcFm_FxZwRDDvOaneDr38q24JOvPcQutj9UPuO4.KOfathOnTg3sa4WuQl OQgjNw6t0XFq.E3gUMor74FPHyQHtqTk.yFBlTpGeU1Hlaz0a4RGZKfnJE3NIRUWWV4ADmFkcHDm _3X2M.QyWNgM_Mc2IgkWjqsy6stn1.Vweq79PxCsKdVPGobzuWxuSnS4JOHVA4eZxpaQeOgXZP6a eLHLs2Gt_smQw8pHwJJIpFv69PHPPm8MQNal1m.FQJlusGNPDAKqD_H5QE2GZp481ntlky7Y2o_f ShI_A_KhBPCUKJ2ob9El4Q2QOswogjx1MIj58uiqXgGO6plx1P8olk0U03HOCiCmqbDQGhwdHtGB qXk3_mpAJqSipya_QNZuKudOrFZNy0.tFC05Ukgo5xLQsKWH_X3XcdmcuKjOLZ0rwz.xOHKrsuHA Tz1DWAoQFWGFsl4Hl_nk6XkLg8uTKH6QhDzaydld1GZTYJ.GEOS70FaJw.BBQGGX3N8grhN6Iz8k LApteJA9FT3imyd.6V.rHMCb5zeXdvQeImz0ZKQqLkcLR8Y4OZiEc1cZ.G32L_1YIeoCCKhLHFVn iJG75HyJCL5qpX8wF05GakNjs1fIl_8KbTFfACm5GV1bfMuin0PKuK9bJr914MVJvmC_Qj7mDebd eQm_bDBLQFjVFC8EqeZEvZQslCt9UVzdT4_wcAkyRLXWrqMytqT7IOqRtzoHljYFT0R9ndU_5FMZ 2h.Juqh.dnY0sQX_3V56KgH9VQrBWaeQTK543JZM7m2lc1UYh2_dmUrSmhbzrdHIcHnhPmH_IabE 6gXT5KNS0MhWX4DHlE_gJljt.z02erSmErjJKHwYYcFZYGoy4x5uu4yeXCu418rCAWvCAVw2qk6P LA0gHVBDFBk7S8G9WYNoCFA3l1jn3Kr_15ubq8uBza9brlVwK1l8D5LjQLy91wfoXF99vLmYYEO3 kf5AzlcQkOBLzz4Z4RGr_pU8vSiTN5XHdxeTzsEegf1oZV6CWyrajwk2es94Ex_J5MYIUmchGspj 9EM38IhLtc4zTDb.iCiOaFY838KXQi.04gT4GFGMPyhVu5e6Fe5eMBOL4mp6X37P4UODjc1S5xHy yq8MQWij1QHdFUEdveUDUxs7qpqDx4s_mPlei7kQ1zVQo4c2oahOXYgIqeHiWD1gXk6NX2Wf9pcn kExzoBjlXfbr3FFj1JV9a72Hj9ynwF7xr7G7wjU292X_XifAmZwmCIQBtOAEOPODWUMhKgY7E2H8 5v3tJSoPdEh_dpyHE9BigtBwlLM5Gp37SzPdz2ULzmGY845UK4uz8WyPNcHv_0eGHwfDo2U4cq1e 52ip2EvuweoSWj1u6YDmqPNEaYCFHNFu3OXF7NFwRfZmprInYT2_gLXDej9Fy24WqgdBRgKq04Jq 0ovUKM_E22HRcJVLhoFbjAU3qz5qPypSpHVpX9DgqPCQhkiRNciFj7vNsc3bPpohPIrWZ67Ubbc4 xyDMcnZPhCPzbHeuJ22TdEVTNNH0YjZYW_wlmcK_w7CTxM3fbwEEC4J4BRGEnd7FtJ0_665LkPyI yDq.HpPGFpa4c.SqxanZSQ.4L_O7p41VvLxnNugyEFjXvc4hRbU3P0Ey7u8BawfOuFp5461zsuTD K3P.r80vhlNZS4w38GdTEIp9w62vFJRwAXd8UUjZX8odzfXdY1WbO1gUbTEcliaHm0J13Sb4S35g TtHya8BLrMlbWlZ9zK2UehSJbFfKSvbUchpT7ZHbbCAlbHS3xhxMqRvnSdqB8tvtpYYTOIDRNEY7 sQM1cAGvyC8KJxoSiYlQ1FKWpoGSzOiCFBvEixdik_lukDX628wG_UrBBLY0- X-Sonic-MF: X-Sonic-ID: 8340411e-c522-44f5-869d-aa14096b6ee1 Received: from sonic.gate.mail.ne1.yahoo.com by sonic321.consmr.mail.gq1.yahoo.com with HTTP; Wed, 31 Jan 2024 19:05:23 +0000 Date: Wed, 31 Jan 2024 19:05:19 +0000 (UTC) From: abrahim abrahao Reply-To: abrahim abrahao To: "pgsql-general@lists.postgresql.org" Message-ID: <1059371874.2807306.1706727919318@mail.yahoo.com> Subject: vacuum freeze wait_event BufferPin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2807305_456680259.1706727919312" References: <1059371874.2807306.1706727919318.ref@mail.yahoo.com> X-Mailer: WebService/1.1.22046 YMailNorrin Content-Length: 54010 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2807305_456680259.1706727919312 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable There is a three-day vacuum freeze on a partition table with wait_event = =3D BufferPin, no transactions (active or idle) older than it that are not = blocked, but at least one select query is executing at all times related of= this partition table.=C2=A0 This behaviour happens with some partitions, but not always. Running simpl= y vacuum works because it does not wait for BufferPin. I just expect to see= vacuum freeze wait_event =3D BufferPin if there is any old transaction rel= ated to the table, am I wrong? Is there a wait to figure out which session = vacuum freeze to wait for? Below is a list of all sessions at a particular moment in time; at this po= int, there are only Select queries with query starts older than the vacuum = freeze, and no cursor, transaction block, or zombie sessions. SELECT pg.query_start,=C2=A0 now() -=C2=A0 query_start AS duration, pg.pi= d pg_pid, pg.state,=C2=A0 pg.wait_event, backend_type=C2=A0 ,pg.wait_event_= type, pg_blocking_pids(pid) as blocked_by,SPLIT_PART(trim(pg.query),' ', 1)= FROM pg_stat_activity pg order by now() -=C2=A0 query_start desc;=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 query_start=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 |=C2=A0 =C2=A0 = =C2=A0 =C2=A0 duration=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | pg= _pid | state=C2=A0 |=C2=A0 =C2=A0 =C2=A0 wait_event=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=A0backend_t= ype=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| wait_event_type= | blocked_by | split_part----------------------------------------------+--= --------------------------+-----------+--------+---------------------------= ---+--------------------------------------+-----------------------+--------= ----+------------=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 =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 =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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 249=C2=A0 = =C2=A0 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| AutoVacuumMain=C2=A0 =C2= =A0 =C2=A0 =C2=A0 | autovacuum launcher=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| Activity=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 =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 =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 =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 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2= =A0 252=C2=A0 =C2=A0 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| LogicalLau= ncherMain=C2=A0 | logical replication launcher=C2=A0 =C2=A0| Activity=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 =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 =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|=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 247=C2=A0 =C2= =A0 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| BgWriterMain=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| background writer=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Activity=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 =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 =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|=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 250=C2=A0 =C2=A0 |=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| ArchiverMain=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | archiver=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 =C2=A0 =C2= =A0 | Activity=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 =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 =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|=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0|=C2= =A0 =C2=A0 246=C2=A0 =C2=A0 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| Che= ckpointWriteDelay | checkpointer=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| Timeout=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 =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 =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 =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 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 248=C2=A0 =C2=A0 |=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| WalWriterMain=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0| walwriter=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 =C2=A0 =C2=A0| Acti= vity=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 =C2=A0 =C2=A0 =C2=A0|=C2=A02024-01-27 23:10:54.159= 577+00 | 3 days 18:55:48.=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 271039 | activ= e| BufferPin=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | BufferPin=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0| {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| vacuum=C2=A02024-0= 1-30 21:33:50.262265+00 | 20:32:52.490309=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 5588= 10 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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= =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 16:53:17.695929+00 | 0= 1:13:25.056645=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 641053 | idle=C2=A0 =C2=A0 =C2= =A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| SELECT=C2=A02024-01-31 18:04:48.929097+00 | 00:01:53.823477=C2=A0 =C2= =A0 =C2=A0 =C2=A0 | 645812 | active |=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 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0| client backend=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 =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 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:05:02.221272+00 | 00= :01:40.531302=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645814 | active |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| client backend=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=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=C2=A0=C2=A0 =C2=A0 =C2=A0| {}=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:05:04.927131+00 | 00:01:37.825443= =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645925 | active |=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 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| client backend=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 =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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= | SELECT=C2=A02024-01-31 18:05:12.088875+00 | 00:01:30.663699=C2=A0 =C2=A0 = =C2=A0 =C2=A0 | 645109 | active |=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 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 | client backend=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 =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=C2= =A0=C2=A0=C2=A0=C2=A0| {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A020= 24-01-31 18:05:30.202305+00 | 00:01:12.550269=C2=A0 =C2=A0 =C2=A0 =C2=A0 | = 645695 | active |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= | client backend=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 =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=C2=A0=C2=A0=C2=A0= =C2=A0| {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:05= :47.872601+00 | 00:00:54.879973=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645924 | activ= e |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client back= end=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 =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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| {}=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:16.425286+00 = | 00:00:26.327288=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645593 | active |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=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=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| {}=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:18.286905+00 | 00:00:24.465= 669=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 646174 | idle=C2=A0 =C2=A0 =C2=A0| ClientR= ead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client = backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| select= =C2=A0 =C2=A0=C2=A0=C2=A02024-01-31 18:06:24.878488+00 | 00:00:17.874086=C2= =A0 =C2=A0 =C2=A0 =C2=A0 | 644993 | active |=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 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0| client backend=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 =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 =C2=A0 | {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT =C2=A02024-01-31 18:06:32.560233+00 | 00:00:10.192341=C2=A0 =C2=A0 =C2=A0 = =C2=A0 | 645590 | active |=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 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0| client backend=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 =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 =C2=A0 |= {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:34.0689= 19+00 | 00:00:08.683655=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 646175 | idle=C2=A0 = =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 = =C2=A0 =C2=A0| select=C2=A02024-01-31 18:06:36.159063+00 | 00:00:06.593511= =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645926 | active |=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 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| client backend=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 =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 =C2=A0 =C2=A0| {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT= =C2=A02024-01-31 18:06:40.002643+00 | 00:00:02.749931=C2=A0 =C2=A0 =C2=A0 = =C2=A0 |=C2=A0 =C2=A0 351=C2=A0 =C2=A0 =C2=A0| idle=C2=A0 =C2=A0 | ClientRe= ad=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client b= ackend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2= =A02024-01-31 18:06:42.5886+00=C2=A0 =C2=A0| 00:00:00.163974=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | 645212 | active |=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 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| client backend=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 =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 =C2=A0 | {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| WITH=C2=A02024-01-31 = 18:06:42.717906+00 | 00:00:00.034668=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645207 | = idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.721052+00 | 00:00= :00.031522=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645817 | idle=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| client backend= =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 =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 =C2=A0 | {}=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.723673+00 | 00:00:00.028901= =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 644916 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client bac= kend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A0= 2024-01-31 18:06:42.725967+00 | 00:00:00.026607=C2=A0 =C2=A0 =C2=A0 =C2=A0 = | 645815 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| (SELECT=C2=A02024-01-31 18:06:42.732666= +00 | 00:00:00.019908=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 644752 | idle=C2=A0 =C2= =A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2= =A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.733953+00 | 00:00:00.018621=C2= =A0 =C2=A0 =C2=A0 =C2=A0 | 645697 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backen= d=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A0202= 4-01-31 18:06:42.735012+00 | 00:00:00.017562=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 6= 45193 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.735088+00 = | 00:00:00.017486=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645927 | idle=C2=A0 =C2=A0 = =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| SELECT=C2=A02024-01-31 18:06:42.736222+00 | 00:00:00.016352=C2=A0 = =C2=A0 =C2=A0 =C2=A0 | 645221 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |= Client=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-= 31 18:06:42.741013+00 | 00:00:00.011561=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645813= | active |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| clie= nt backend=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 =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 =C2=A0 =C2=A0| {}=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.745033+00 | 00= :00:00.007541=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645238 | idle=C2=A0 =C2=A0 =C2= =A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| (SELECT=C2=A02024-01-31 18:06:42.747161+00 | 00:00:00.005413=C2=A0 =C2= =A0 =C2=A0 =C2=A0 | 645596 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Cl= ient=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-3= 1 18:06:42.747703+00 | 00:00:00.004871=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645232 = | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 = =C2=A0 =C2=A0 =C2=A0 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.749182+00 | 00= :00:00.003392=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645820 | active |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| client backend=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 =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 =C2=A0 | {}=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = SELECT =C2=A02024-01-31 18:06:42.750896+00 | 00:00:00.001678=C2=A0 =C2=A0 =C2=A0 = =C2=A0 | 645594 | idle=C2=A0 =C2=A0 =C2=A0| ClientRead=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | client backend=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0| SELECT=C2=A02024-01-31 18:06:42.752015+00 | 00= :00:00.000559=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 645620 | idle=C2=A0 =C2=A0 =C2= =A0| ClientRead=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | client backend=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 | Client=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 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| SELECT=C2=A02024-01-31 18:06:42.752574+00 | 00:00:00=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 642199 | activ= e |=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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| client back= end=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 =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 =C2=A0 | {}=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0| SELECT(40 rows) SELECT * FROM pgstattuple('pg_catalog.pg_proc');=C2=A0=C2=A0=C2=A0table_len= | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_= len | dead_tuple_percent | free_space | free_percent-----------+-----------= --+-----------+---------------+------------------+----------------+--------= ------------+------------+--------------=C2=A0 =C2=A0 851968 |=C2=A0 =C2=A0= =C2=A0 =C2=A0 3450 |=C2=A0 =C2=A0 799839 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A093.88 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A026 |=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 11602 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A01.36 |=C2=A0 =C2=A0 =C2=A0 10960 |=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A01.29 SELECT * FROM pgstattuple('[table_name]'); =C2=A0table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_coun= t | dead_tuple_len | dead_tuple_percent | free_space | free_percent--------= ---+-------------+-----------+---------------+------------------+----------= ------+--------------------+------------+--------------=C2=A0922165248 |=C2= =A0 =C2=A0 11679432 | 805880808 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A087.39 |= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 |=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 |=C2=A0 =C2=A031376484 |=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 3.4 SELECT * FROM pgstatindex('[index_name_01]');=C2=A0version | tree_level | i= ndex_size | root_block_no | internal_pages | leaf_pages | empty_pages | del= eted_pages | avg_leaf_density | leaf_fragmentation---------+------------+--= ----------+---------------+----------------+------------+-------------+----= -----------+------------------+--------------------=C2=A0 =C2=A0 =C2=A0 =C2= =A04 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 2 |=C2=A0 262348800 |=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0412 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = 113 |=C2=A0 =C2=A0 =C2=A0 31911 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A00= |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A00 |=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 90.09 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 0 =C2=A0SELECT * FROM pgstatindex('[index_name_02]');=C2=A0version | tree_lev= el | index_size | root_block_no | internal_pages | leaf_pages | empty_pages= | deleted_pages | avg_leaf_density | leaf_fragmentation---------+---------= ---+------------+---------------+----------------+------------+------------= -+---------------+------------------+--------------------=C2=A0 =C2=A0 =C2= =A0 =C2=A04 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 2 |=C2=A0 381714432 |=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0351 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 226 |=C2=A0 =C2=A0 =C2=A0 46369 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A00 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A00 |=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A086.9 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A05.67 ------=_Part_2807305_456680259.1706727919312 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
There is a three-day vacuum freeze on a partition table with wait_e= vent =3D BufferPin, no transactions (active or idle) older than it that are= not blocked, but at least one select query is executing at all times relat= ed of this partition table. 

This= behaviour happens with some partitions, but not always. Running simply vac= uum works because it does not wait for BufferPin.
I just expect to see v= acuum freeze wait_event =3D BufferPin if there is any old transaction relat= ed to the table, am I wrong?
Is there a wait to figur= e out which session vacuum freeze to wait for?

Below is a list of all sessions= at a particular moment in time; at this point, there are only Select queri= es with query starts older than the vacuum freeze, and no cursor, transacti= on block, or zombie sessions.


<= /div>
SELECT pg.query_start,  now() -&nb= sp; query_start AS duration, pg.pid pg_pid, pg.state,  pg.wait_event, = backend_type  ,
pg.wait_event_type, pg_blocking_pids(pid) as= blocked_by,SPLIT_PART(trim(pg.query),' ', 1)
FROM pg_stat_activi= ty pg order by now() -  query_start desc;
    &nbs= p;     query_start             = ;               |      &n= bsp; duration              | pg_pid | st= ate  |      wait_event         = ;      |         backend_type =              | wait_event_type | blocke= d_by | split_part
------------------------------= ----------------+----------------------------+-----------+--------+------------------------------+----------= ----------------------------+-----------------------+------------+---------= ---
                &n= bsp;                &= nbsp;                    =  |                  &nbs= p;                |    24= 9    |           | AutoVacuumMain&n= bsp;       | autovacuum launcher        =    | Activity              &nb= sp; | {}         |
      =                      = ;                     &nb= sp;       |              =                      = ;|    252    |           = | LogicalLauncherMain  | logical replication launcher   | Ac= tivity                | {}  &n= bsp;      |
         =                     &nbs= p;                     &n= bsp;   |            &= nbsp;                    =  |    247    |          =  | BgWriterMain               = | background writer                = | Activity                | {} = ;        |
=         &n= bsp;                     =                      = ;     |          &nbs= p;                     &n= bsp;  |    250    |        &nb= sp;  | ArchiverMain              &n= bsp; | archiver                &nbs= p;               | Activity   =             | {}        =  |
              &nbs= p;                     &n= bsp;                   |                 =                  |  &nbs= p; 246    |           | CheckpointW= riteDelay | checkpointer              &n= bsp;          | Timeout       =       | {}         |
                    &nbs= p;                     &n= bsp;             |  &= nbsp;                    =            |    248    |=            | WalWriterMain     = ;        | walwriter          =                      = ;| Activity             &= nbsp;  | {}         |
 2024-01= -27 23:10:54.159577+00 | 3 days 18:55:48.         = | 271039 | active| BufferPin             = ;         | client backend        &= nbsp;             | BufferPin    &n= bsp;        | {}         | vac= uum
 2024-01-30 21:33:50.262265+00 | 20:32:52.490309  &= nbsp;     | 558810 | idle     | ClientRead  &= nbsp;               | client backend&nbs= p;                     | = Client              =     | {}         | SELECT
&nbs= p;2024-01-31 16:53:17.695929+00 | 01:13:25.056645       = ; | 641053 | idle     | ClientRead       = ;           | client backend      &= nbsp;               | Client   = ;               | {}=          | SELECT
 2024-01-31 18:04:48.929097+00 | 00:01:53.823477  &nb= sp;     | 645812 | active |          &nb= sp;                     &= nbsp;    | client backend           = ;           |          &n= bsp;                 | {}  &nb= sp;      | SELECT
 2024-01-31 18:05:02.221272= +00 | 00:01:40.531302        | 645814 | active |  =                               &= nbsp;    | client backend       = ;               |    = ;                 &n= bsp;       | {}         |= SELECT
 2024-01-31 18:05:04.927131+00 | 00:01:37.825443&nbs= p;       | 645925 | active |        &nbs= p;                            | client backend              &n= bsp;       |           &n= bsp;              &n= bsp;  | {}         | SELECT
 2024-01-31 18:05:12.088875+00 | 00:01:30.6= 63699        | 645109 | active |      &n= bsp;                        &nbs= p;     | client backend            =           |          &nbs= p;              &nbs= p;   | {}         | SELECT
 2024-01-31 18:05:30.202305+00 | 0= 0:01:12.550269        | 645695 | active |    =                              &n= bsp;   | client backend         = ;             |        &n= bsp;              &n= bsp;     | {}         | SELECT=
 2024-01-31 18:05:47.8726= 01+00 | 00:00:54.879973        | 645924 | active | = ;                              =       | client backend      &nb= sp;               |      =              &n= bsp;         | {}         = ;| SELECT
 2024-01-31 18:06:16.425286+00 | 00:00:26.327288&n= bsp;       | 645593 | active |        &n= bsp;                            | client backend              =         |         &n= bsp;                =    | {}         | SELECT
 = ;2024-01-31 18:06:18.286905+00 | 00:00:24.465669       = | 646174 | idle     | ClientRead       =           | client backend      &n= bsp;               | Client   =               | {}&= nbsp;        | select    
&nbs= p;2024-01-31 18:06:24.878488+00 | 00:00:17.874086       = ; | 644993 | active |               = ;                     &nb= sp;| client backend                =       |            &= nbsp;               | {} =        | SELECT
 2024-01-31 18:06:3= 2.560233+00 | 00:00:10.192341        | 645590 | active = |                    &nbs= p;                | client backend&= nbsp;                    = |                &n= bsp;           | {}       = ;  | SELECT
 2024-01-31 18:06:34.068919+00 | 00:00:08.6= 83655        | 646175 | idle     | Clien= tRead                  | clien= t backend                  &nb= sp;   | Client           =        | {}         | select
 2024-01-31 18:06:36.159063+00 | 00:00:06.593511   =     | 645926 | active |           =                     &nbs= p;    | client backend            &= nbsp;         |           = ;               &nbs= p;  | {}         | SELECT
 202= 4-01-31 18:06:40.002643+00 | 00:00:02.749931        |&n= bsp;   351     | idle    | ClientRead  &= nbsp;               | client backend&nbs= p;                     | = Client              =     | {}         | SELECT
&nbs= p;2024-01-31 18:06:42.5886+00   | 00:00:00.163974    &n= bsp;     | 645212 | active |          &n= bsp;                     =      | client backend          &nbs= p;           |          &= nbsp;               =   | {}         | WITH
 2024-01= -31 18:06:42.717906+00 | 00:00:00.034668        | 64520= 7 | idle     | ClientRead          =         | client backend        &nb= sp;             | Client      =             | {}  &n= bsp;      | SELECT
 2024-01-31 18:06:42.72105= 2+00 | 00:00:00.031522        | 645817 | idle  &nb= sp;  |                  &= nbsp;                  | clien= t backend                  &nb= sp;   |                &n= bsp;           | {}    &n= bsp;    | SELECT
 2024-01-31 18:06:42.723673+00 | = 00:00:00.028901        | 644916 | idle    &nb= sp;| ClientRead                &nbs= p; | client backend                =       | Client          &= nbsp;       | {}         = | SELECT
 2024-01-31 18:06:42.725967+00 | 00:00:00.026607&nb= sp;       | 645815 | idle     | ClientRead&nb= sp;                 | client backen= d                    &nbs= p; | Client             &= nbsp;    | {}         | (SELECT
 2024-01-31 18:06:42.732666+00 | 00:00:00.019908     =   | 644752 | idle     | ClientRead     =             | client backend    &n= bsp;                 | Client =                = ; | {}         | SELECT
 2024-01-31= 18:06:42.733953+00 | 00:00:00.018621        | 645697 |= idle     | ClientRead          &nb= sp;       | client backend         =             | Client      &nb= sp;           | {}   = ;      | SELECT
 2024-01-31 18:06:42.735012+0= 0 | 00:00:00.017562        | 645193 | idle   =  | ClientRead                =   | client backend              &nb= sp;       | Client         &nb= sp;        | {}        &n= bsp;| SELECT
 2024-01-31 18:06:42.735088+00 | 00:00:00.01748= 6        | 645927 | idle     | ClientRea= d                  | client ba= ckend                    =   | Client            &nb= sp;     | {}         | SELECT
=
 2024-01-31 18:06:42.736222+00 | 00:00:00.016352    &nb= sp;   | 645221 | idle     | ClientRead    &nb= sp;             | client backend   =                   | Client&nb= sp;               &n= bsp; | {}         | SELECT
 2024-01= -31 18:06:42.741013+00 | 00:00:00.011561        | 64581= 3 | active |                  =                    | clie= nt backend                  &n= bsp;   |               &n= bsp;             | {}  &n= bsp;      | SELECT
 2024-01-31 18:06:42.74503= 3+00 | 00:00:00.007541        | 645238 | idle  &nb= sp;  | ClientRead              &nbs= p;   | client backend              =         | Client       &n= bsp;          | {}       =  | (SELECT
 2024-01-31 18:06:42.747161+00 | 00:00:00.0= 05413        | 645596 | idle     | Clien= tRead                  | clien= t backend                  &nb= sp;   | Client           =        | {}         | SELECT
 2024-01-31 18:06:42.747703+00 | 00:00:00.004871   =     | 645232 | idle     | ClientRead   =               | client backend  &n= bsp;                   | Clien= t               = ;   | {}         | SELECT
 202= 4-01-31 18:06:42.749182+00 | 00:00:00.003392        | 6= 45820 | active |                &nb= sp;                    | = client backend                 = ;     |                &n= bsp;           | {}  &nbs= p;      | SELECT
 2024-01-31 18:06:42.750= 896+00 | 00:00:00.001678        | 645594 | idle  &= nbsp;  | ClientRead              &n= bsp;   | client backend             = ;         | Client          &n= bsp;         | {}         | SE= LECT
 2024-01-31 18:06:42.752015+00 | 00:00:00.000559  =       | 645620 | idle     | ClientRead  =                 | client backend&nb= sp;                     |= Client             =     | {}         | SELECT
&nb= sp;2024-01-31 18:06:42.752574+00 | 00:00:00        &nbs= p;            | 642199 | active |   = ;                     &nb= sp;            | client backend    =                   |  &nbs= p;                  =        | {}         | SEL= ECT
(40 rows)

SELECT * FROM pgstattuple('pg_catalog.pg_proc');&nb= sp; 
 table_len | tuple_count | tuple_len | tuple_perce= nt | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | = free_percent
-----------+-------------+-----------+--------------= -+------------------+----------------+--------------------+------------+---= -----------
    851968 |        345= 0 |    799839 |         93.88 |  &n= bsp;            26 |      &nbs= p;   11602 |               1.3= 6 |      10960 |         1.29
=


SELECT * FROM pgstattuple('[table_name]'= );

 table_len | tuple_count | tuple_len | tup= le_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_= space | free_percent
-----------+-------------+-----------+------= ---------+------------------+----------------+--------------------+--------= ----+--------------
 922165248 |    11679432 | 805= 880808 |         87.39 |       = ;         0 |            =   0 |                  0 = |   31376484 |          3.4

SELECT * FROM pgstatindex('[index_name_01]');
 version | tree_level | index_size | root_block_no | internal= _pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf= _fragmentation
---------+------------+------------+--------------= -+----------------+------------+-------------+---------------+-------------= -----+--------------------
       4 |  &= nbsp;       2 |  262348800 |       =    412 |            113 |  &n= bsp;   31911 |           0 |   = ;          0 |          &= nbsp; 90.09 |                 = 0

 SELECT * FROM pgstatindex('[index_name_02= ]');
 version | tree_level | index_size | root_block_no | in= ternal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density = | leaf_fragmentation
---------+------------+------------+--------= -------+----------------+------------+-------------+---------------+-------= -----------+--------------------
       4 |&n= bsp;         2 |  381714432 |      =      351 |            226 |&nb= sp;     46369 |           0 | =            0 |        &n= bsp;    86.9 |              &n= bsp;5.67





------=_Part_2807305_456680259.1706727919312--