Shrirang Chitnis <Shrirang.Chitnis@hovservices.com> writes:
> I see that an auto vacuum process that has started on April 08 is still continuing till date on a production server
thatI manage.
> A) Is there a way to know whether the process is still running or is stalled?
strace the process for a few minutes and see if it does anything or just
sits there. Alternatively, does ps show its runtime is increasing?
> B) Can the process be killed safely without causing issues in the autovacuum daemon?
You could try SIGINT'ing it. Anything stronger might be risky.
regards, tom lane