very slow preview load and HTTP500 - Postgresql database index missing for storage+path_hash about previewgenerator HOT 4 OPEN

This is an index that is already created automatically.

Did you run occ db:add-missing-indices recently? Indexes are only created when running this command as the creation might take a long time.

from previewgenerator.

When there was a mention on the admin page to do so, then yes. Otherwise no. (too much time has passed to remember what I did exactly)

Maybe I can find some info in the bash history.

from previewgenerator.

Please try to run the command anyway and see if it makes a difference.

from previewgenerator.

did it now. now output so far, so no missing indices

~# occ db:add-missing-indices 
~# echo $?
0

from previewgenerator.