How can I cancel VACUUM FULL VERBOSE ANALYZE?

N

Nikolai Savelyev2017-01-16 06:47:26

linux

Nikolai Savelyev, 2017-01-16 06:47:26

VACUUM FULL VERBOSE ANALYZE running on cron has been hanging for 9 hours. It used to take 40 minutes. How can I cancel?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

N

Nikolay Savelyev, 2017-01-16
@nikweter

SELECT pg_cancel_backend(pid) as x FROM pg_stat_activity WHERE query like 'VACUUM FULL VERBOSE ANALYZE;';
In general, he asked - he answered. It remains to understand why the vacuum was made for so long ...

P

Pavel, 2017-01-16
@electronik777

запущенный по крон висит уже 9 часов. Раньше укладывался в 40 минут.

Может база разрослась, возможно проблемы с оборудованием, например умирает HDD, или в этот момент был rebuld RAID-массива