On Sat, Feb 20, 2021 at 10:37:08AM +0900, Michael Paquier wrote: > > Also, I noticed that vacuum recurses into partition heirarchies since v10, > > but > > pg_stat_progress_vacuum also doesn't show anything about the parent table or > > the progress of recursing through the hierarchy. > > Yeah, that's an area where it would be possible to improve the > monitoring, for both autovacuums and manual VACUUMs.
I was thinking that instead of reporting partitions_done/partitions_total in the individual progress views, maybe the progress across partitions should be reported in a separate pg_stat_progress_partitioned. This would apply to my CLUSTER patch as well as VACUUM. I haven't though about the implementation, though. If the partitions_done/total were *removed* from the create_index view, that would resolve the odd behavior that a single row simultanously shows 1) the overall progress of the operation across partitions; and, 2) the detailed information about the status of the operation on the current leaf partition. However I guess it's not general enough to support progress reports of execution of planned (not utility) statements. -- Justin
