Kill concurrent materialized view refresh PID

2 votes

1 answer

2002 views

postgresql postgresql-10 materialized-view kill

                          Concurrent refreshes of materialized views don't have a record in pg_stat_activity, other than the initial (~immediately completing) query to start them.

Is there some other way to obtain the PID, in order to perform pg_terminate_backend(pid)?

Asked by OJFord (125 rep)

May 14, 2020, 08:44 AM
Last activity: May 14, 2020, 09:11 AM

Kill concurrent materialized view refresh PID

Related Questions