Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kvSIv-00088c-0J for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Jan 2021 21:49:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kvSIr-0000Wh-8i for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Jan 2021 21:49:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kvSIq-0000Wa-Uw for pgsql-hackers@lists.postgresql.org; Fri, 01 Jan 2021 21:49:45 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kvSIh-0006yh-SU for pgsql-hackers@postgresql.org; Fri, 01 Jan 2021 21:49:42 +0000 Received: by mail-il1-x133.google.com with SMTP id t9so20129136ilf.2 for ; Fri, 01 Jan 2021 13:49:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=i1Qa7X8e00ef4QmHNUAkFltoYa+SyE8cOa+U9dLf1eo=; b=HJCm979lPoaadBI9Xolqj6kamvbwMLRr9AgWT/RiJNvCwjPwJVcINyFSKLBlkrMk+b sgBtgb2bTi95xHCkKODkZAFRArH/j2Le9iB865JJTAY/x7s37gTg7YRSGzUqQwC01yJk o8ZH+LKa9bkWKAhp6A922fBwQVR9yyZPNpp8PNDio8nTciig80TWcm4OaBS+RIdhsqDL yRtfCRz8in4tDcO5Gp/A4ZHkO0o87awH8CW9aEG/v3neNey1qZWXoedQ/+cSXA2bfMAQ bNwhOCjoaftGfZ8pcejiLOen8ruoc71rdafK/29dTBoKua4dveq9Tnc1OhDAZEzOZhrI VffQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=i1Qa7X8e00ef4QmHNUAkFltoYa+SyE8cOa+U9dLf1eo=; b=ZLbG4ykYZRA1gzKU98XOc2Wb/Wap+IeZZP2LcstFplOCsm3cLJeIhF0FbtM4p0iq9d jAktqvyLWtEhsqLq/c4ChNmV8CKZ9ZVsSx04OeIhYIK2KPhAcSmLWK1uOdlqe6Kdezfv 91HdVPui3cpY5mrxAPF7CFCY90HdJNpGfOjESF3DrqclCVlg35nnFDWLOOgbrMBHaYYd g0XW98YdVmg8XmXiJvBMsiwfJpY0BsDHdbSM40YM+BT+ykc7W8cOVQ5I8EnYxf6Y8G5u NGVtvNTQAmTWGeLmkmkuOfdqFmw4DkVQS5XyxjecJDCS3ORuNLIK1UgblqAkuS6iMAln IrLw== X-Gm-Message-State: AOAM530haaNqzUqBefjdswaV6CKqu1YESo2jsGWUnrrtcQvC1tQKSUYl e8h3cPEkzTxnyFz6SOFIHzMkgcxwNEkHZw== X-Google-Smtp-Source: ABdhPJyCUYqST8J70OUSOQ1WgFJeoGqQUuXlImH5cYJBe3y4DT4m18q1ffFqUF87xgOao9+zidFdHg== X-Received: by 2002:a92:84d6:: with SMTP id y83mr61375692ilk.184.1609537773765; Fri, 01 Jan 2021 13:49:33 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id k15sm34292412ilo.88.2021.01.01.13.49.32 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 01 Jan 2021 13:49:32 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id BCFFF800F32; Fri, 1 Jan 2021 15:49:30 -0600 (CST) Date: Fri, 1 Jan 2021 15:49:30 -0600 From: Justin Pryzby To: torikoshia Cc: pgsql-hackers@postgresql.org Subject: Re: adding wait_start column to pg_locks Message-ID: <20210101214930.GH25152@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Dec 15, 2020 at 11:47:23AM +0900, torikoshia wrote: > So I'm now thinking about adding a new column in pg_locks which > keeps the time at which locks started waiting. > > Attached a patch. This is failing make check-world, would you send an updated patch ? I added you as an author so it shows up here. http://cfbot.cputube.org/atsushi-torikoshi.html -- Justin