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 1qwMym-00BKJm-68 for pgsql-admin@arkaria.postgresql.org; Fri, 27 Oct 2023 13:34:24 +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 1qwMyj-00FeQL-Rw for pgsql-admin@arkaria.postgresql.org; Fri, 27 Oct 2023 13:34:21 +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 1qwMyj-00FeQB-Gs for pgsql-admin@lists.postgresql.org; Fri, 27 Oct 2023 13:34:21 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwMyg-0037Lc-Qb for pgsql-admin@lists.postgresql.org; Fri, 27 Oct 2023 13:34:20 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-5a7eef0b931so15824287b3.0 for ; Fri, 27 Oct 2023 06:34:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698413656; x=1699018456; darn=lists.postgresql.org; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=uB7MxPhI3SoeEAnPJGwXimzmgj9JMCO+D/ur0DsTmeU=; b=exAP3GFn0GL3TkRCx/MOuDkvXuAuxku+R7lrpwO4oksc1YDxFXR/qzYXq+cXu4lk9O PygUzBWbeAD+AxCgWlf81DRkEK2HQRu5N+3O/0bTTuchSr4vvKyQXGyMqFvzSXH3Q8l4 UClKOV4GHyYasW/dcchBgJHt3CD3qM2i7EaU55v8hGnBXHZjkhDfWX+yVzNpTKFn4rMl 5qd03zjeqYuAjfgULSSKy2JKPcQRXBE66izt2LPhd33ZijGkGc4im7tPLA8KkBKNkY/5 FW8sywVDncnP5HKhauPu31quzlAvB85wXnzGdf8tPCFlp5rq9sIIMdzMgBbl84Flz9Mf PmFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698413656; x=1699018456; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=uB7MxPhI3SoeEAnPJGwXimzmgj9JMCO+D/ur0DsTmeU=; b=JmJNAikArpd+DaRq3q83eye4OxCs/kWPcwkACdsgvNFkHdnFZ7IRzAaKd4qbCTVhlr b7t5RJ0DD58GRbf82WaLlDrV+QHRXwMPfXgPC+d6X96c8Prr1zMgDKlVvNkNNvsSilTC O0r3x/z1LBQigdtXbZgMot2WNtseMefDcEeV/p3ZhBE8/kyTqDVa+Xhi0xriMg3e0vOF xrHa/GzqSP05KFixZHVFlhO2U7FgBptoNNxP8hbjGVhuwbeEEzjOfzbutTlxZIii3f5p hvcJAZSVGYHvzdo8Pw31bpp/1+oYn7eTEvJLG6pEUbxQv7oaGWSr510psS4lr6vpiMB9 7nTQ== X-Gm-Message-State: AOJu0YwIzEhxVQFsoM7GEIuky46O8MMVcr6U/uSzptgmZW0VH1Z8Djeb 7Q/RoTYhDbx3w5I1SRrDgSP4B2yJ5ss= X-Google-Smtp-Source: AGHT+IHutLrHcaHW7L8v3z9XQFM7ydFmFNR3z55GzZzPagyj99mLsxs6jaOXrq44rWJxi6yf1d7aGw== X-Received: by 2002:a81:7641:0:b0:59b:bd55:8452 with SMTP id j1-20020a817641000000b0059bbd558452mr2600381ywk.36.1698413656573; Fri, 27 Oct 2023 06:34:16 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2? ([2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2]) by smtp.googlemail.com with ESMTPSA id e67-20020a816946000000b0059b24bd4f2asm703761ywc.57.2023.10.27.06.34.16 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 27 Oct 2023 06:34:16 -0700 (PDT) Message-ID: <400b499f-7db5-4e00-ac1c-0b20e855dc88@gmail.com> Date: Fri, 27 Oct 2023 08:34:15 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird To: pgsql-admin@lists.postgresql.org Content-Language: en-US From: Ron Subject: Progress of ALTER TABLE on inheritance-partitioned table? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Pg 9.6.24 (Yes, I know; it's out of my control.) I'm ALTERing that table to change a column from INTEGER to BIGINT. Of course, all of the partitions are pretty big. Even though it's one giant transaction, is there any way for me to monitor it's progress? -- Born in Arizona, moved to Babylonia.