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 1qREFx-000yZD-AR for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Aug 2023 15:59:25 +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 1qREFv-006A5l-Op for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Aug 2023 15:59:24 +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 1qREFv-006A5U-GC for pgsql-hackers@lists.postgresql.org; Wed, 02 Aug 2023 15:59:23 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qREFt-000Aa8-9f for pgsql-hackers@postgresql.org; Wed, 02 Aug 2023 15:59:23 +0000 Received: by mail-pl1-x62a.google.com with SMTP id d9443c01a7336-1bbf8cb694aso73715ad.3 for ; Wed, 02 Aug 2023 08:59:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690991959; x=1691596759; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=8HkF1U6fgtQtMl3hLMQjOFTzGNCdtgs17Cj5chAkWXQ=; b=BrSdsNAaRi+qGuJsZVeuVYu8I8RWxVIyacAg761IcbJMBrVAUDnintV4Qe6FVAWht6 J+na71iseBpJf6xOCK6M5kmhThnBFBVjl7ZsxnHFPAmfpymTJYzfstx38DPmauN28Hmo 4JnqgRwda4nLGKKD6d5HIAitY84AQkx+NkgBgtzhLzWZnBL5om4vPDaZqBc2g9KZz8og mEgaxLALP4lA709e+MwVYvVAeqAMKJzLnwcuygjRFnQXupI/yKwx7Udlq1wpVbSzHhut 2wGZGDEZLt0sVJZpUi49FvSVXW3+6r2PAOYwhvI1QHa9dLxSK1ovi06gma6oMVQcQ9RP M8DQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690991959; x=1691596759; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=8HkF1U6fgtQtMl3hLMQjOFTzGNCdtgs17Cj5chAkWXQ=; b=ePuVb30ZXzIXpxtzotLRomQE0Hfgl2gwgIau/J5HZ2tp7vgol2BQWr0zd/A1RnorvV DLQvnwVdwvzOz+cvIOv+k41TktZC3eraQMyF7vETp6todjmAK4zz5FVu3c72aclqq+81 Ul1xT6/JjC3eIOjVW/l8nm/nkMttXL+JVV/9XLddVaskFzHnprD/iLq7uIQXT+4DO+Wv KjmQ3+/OfpmPhSCuTPm+gPwy6XhV9tjSr2C43AFF6BA7ug03WLOrnxzlLVZp00LZQaHR OYbjK8FxaLWcvCzSmht7DHeCtRcfFDTol0B/ZlrJdZprf5CSm070px9muM51ra7AphTl XhMA== X-Gm-Message-State: ABy/qLb/+ZS8C42N756R+XVpAKnIwFm2z8YV6o3OPmWkwHiOW/0ZWh8k XhYaZwPDqv6zWS8tHgXFwDI= X-Google-Smtp-Source: APBJJlG672K12x4v4WvkrD13dfjU+9iKqyLRFqxPRPGa9X4KyyEu7WbHiVITOWEpwzecv8CVXisyOA== X-Received: by 2002:a17:902:e847:b0:1b8:9598:6508 with SMTP id t7-20020a170902e84700b001b895986508mr17836796plg.18.1690991958870; Wed, 02 Aug 2023 08:59:18 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id e11-20020a170902744b00b001b8c6662094sm12614379plt.188.2023.08.02.08.59.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 02 Aug 2023 08:59:18 -0700 (PDT) Date: Wed, 2 Aug 2023 08:59:15 -0700 From: Nathan Bossart To: Peter Eisentraut Cc: Daniel Gustafsson , PostgreSQL Hackers Subject: Re: add timing information to pg_upgrade Message-ID: <20230802155915.GA1008426@nathanxps13> References: <20230727235134.GA3658499@nathanxps13> <204e3982-78be-7550-fdb3-063ecd368f1f@eisentraut.org> <20230801160006.GB723589@nathanxps13> <4fe4c4d2-e87d-fd6d-0866-a453a2d4c32a@eisentraut.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4fe4c4d2-e87d-fd6d-0866-a453a2d4c32a@eisentraut.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 02, 2023 at 09:14:06AM +0200, Peter Eisentraut wrote: > On 01.08.23 18:00, Nathan Bossart wrote: >> One of the main purposes of this thread is to gauge interest. I'm hoping >> there are other developers who are interested in reducing >> pg_upgrade-related downtime, and it seemed like it'd be nice to have >> built-in functionality for measuring the step times instead of requiring >> folks to apply this patch every time. And I think users might also be >> interested in this information, if for no other reason than to help us >> pinpoint which steps are taking longer for various workloads. > > If it's just for developers and expert users, perhaps existing shell-level > functionality like "pg_upgrade | ts" would suffice? Sure, we could just leave it at that unless anyone sees a reason to bake it in. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com