Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1vpR-0001fd-Gy for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Feb 2020 17:29:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j1vpQ-0007gG-7E for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Feb 2020 17:29:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1vpP-0007g3-Uj for pgsql-hackers@lists.postgresql.org; Wed, 12 Feb 2020 17:29:35 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j1vpI-0003Si-3Z for pgsql-hackers@postgresql.org; Wed, 12 Feb 2020 17:29:35 +0000 Received: from hnk.local (p1752128-ipbf1308funabasi.chiba.ocn.ne.jp [123.218.229.128]) by oss.nttdata.com (Postfix) with ESMTPSA id DE73B60536 for ; Thu, 13 Feb 2020 02:29:20 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.101.5 at oss.nttdata.com To: pgsql-hackers@postgresql.org From: Fujii Masao Subject: Wait event that should be reported while waiting for WAL archiving to finish Message-ID: Date: Thu, 13 Feb 2020 02:29:20 +0900 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Thunderbird/68.4.2 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, When I saw pg_stat_activity.wait_event while pg_basebackup -X none is waiting for WAL archiving to finish, it was either NULL or CheckpointDone. I think this is confusing. What about introducing new wait_event like WAIT_EVENT_BACKUP_WAIT_WAL_ARCHIVE (BackupWaitWalArchive) and reporting it during that period? Regards, -- Fujii Masao NTT DATA CORPORATION Advanced Platform Technology Group Research and Development Headquarters