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 1mzOJq-0006us-Gs for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Dec 2021 19:27:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzOJp-0007cl-DC for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Dec 2021 19:27:33 +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 1mzOJp-0007cc-0x for pgsql-hackers@lists.postgresql.org; Mon, 20 Dec 2021 19:27:33 +0000 Received: from mail-il1-x12d.google.com ([2607:f8b0:4864:20::12d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mzOJm-0006j5-IG for pgsql-hackers@postgresql.org; Mon, 20 Dec 2021 19:27:32 +0000 Received: by mail-il1-x12d.google.com with SMTP id l5so8411791ilv.7 for ; Mon, 20 Dec 2021 11:27:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=nklUUL3DQ/BVMt3qcmYPXf9iNAxQZnOQfk09uEthUWA=; b=raOeCiNgq60J2eiXpdXKslRGGF2TfbBj9+ZWhBk1MXaGLaE3JODrET0WHs/jV2i8bB NBuWMItu2+sLj1JDYcnRUGpq+TXDhASP+Iyckwxvr7HoB8pY+xjXayOz8YwCUaJsBimA 8f8RuOAWERtlUGE+TCZZQmAy/4JMcyqB87KrGP1t8PbCKLUgCJcUsVfQtfulohnNBiZZ F6C7NIzJgVheQs0BrwVTIEP8ylqTXixEpKExcr45RyvBZpaT5JFg90bg97KclOpIdkne Zoa6cJ0xDl/vaBkh2slMQfsQnQ32A81jgIvXo5hqDmh3k8awOQomSHso+BDJyClBNS3T jXUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=nklUUL3DQ/BVMt3qcmYPXf9iNAxQZnOQfk09uEthUWA=; b=PlBgU0pP9BuAY8lmXSnfz7nuSUwoXf9bbPXlxoEKogHLDXB2WfXAa6U3SXFViFgp/x gibI0Ty06m02Vk5SptREH0wI0Mm966696thaH6HPx0F+itUbQrUwvF828gnuhZZjk3Wr DoxkpKQE/rQUJJQ0yYe2JBfFyBxySJ26U2I+xcdmC40fP5hC22UzvZYbnZ6IDr3r4bNM gWACe0QSw9hI+zgP9zkwi2GbdwlmrFlAupAOekXm4uO4zzaIbxHaFizjOc1R2xU5aumt NwTAa2nSwrDS7yRHnZUXBCqsXnqBN3lUlyI+B2G0l1ZROYsN9dk/2fGKqGOPflkH9mX1 cWBw== X-Gm-Message-State: AOAM531MTfRWAR2vEc5FWv1QHQQfuje/TyNbpaE07tlHJVKbs+CwQZfH dIDSKQAD8ZLdFCq6YQJgSgPkNQ== X-Google-Smtp-Source: ABdhPJxW8nnSRnUl4JmtiEqVQ0YHZqX2zps0+sixJo8HMkYropU0Ox8JZ6PlugmUTOZsfSMrRYgndA== X-Received: by 2002:a05:6e02:20ee:: with SMTP id q14mr1908899ilv.65.1640028448864; Mon, 20 Dec 2021 11:27:28 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id o7sm9675211ilo.15.2021.12.20.11.27.27 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 20 Dec 2021 11:27:27 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 1AFEC8006D0; Mon, 20 Dec 2021 13:27:27 -0600 (CST) Date: Mon, 20 Dec 2021 13:27:26 -0600 From: Justin Pryzby To: "Imseih (AWS), Sami" Cc: pgsql-hackers@postgresql.org Subject: Re: Add index scan progress to pg_stat_progress_vacuum Message-ID: <20211220192726.GV17618@telsasoft.com> References: <5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This view also doesn't show vacuum progress across a partitioned table. For comparison: pg_stat_progress_create_index (added in v12) has: partitions_total partitions_done pg_stat_progress_analyze (added in v13) has: child_tables_total child_tables_done pg_stat_progress_cluster should have something similar. -- Justin Pryzby System Administrator Telsasoft +1-952-707-8581