Re: vacuum analyse waiting

I'm a little lost in solving this problem.
The process vacuum waiting to disappeared. I do not think it is completed successfully.
How to verify that the vacuum passes successfully?
How to prevent it happening in modewaiting?

2016-03-21 16:37 GMT+01:00 bricklen <bricklen@gmail.com>:

On Mon, Mar 21, 2016 at 8:26 AM, Nicolas Aubert <aubertnicolas11@gmail.com> wrote:

the vacuum process is the 22510
here is what I found in pg_locks

virtualtransaction |  pid  |           mode           | granted | fastpath
------------+---------------+---------+-------+----------+--------------------+-------+--------------------------+---------+----------
                                                          3/376480           | 22510 | ExclusiveLock            | t       |
            |               |         |       |          | 3/376480           | 22510 | ShareUpdateExclusiveLock | f       | f

Have a look at the lock dependency queries at https://wiki.postgresql.org/wiki/Lock_dependency_information for more information about what is holding the locks.