The query used to search for samples is complex and involves many tables. In some cases, Postgresql does not prepare its execution properly, which can then take a lot of time (several dozen times the normal time).

To solve the problem, you have to “clean” the database, by asking a system administrator :

to connect to the server hosting the database by root ;

to connect by root to the server hosting the database ;

to connect by root to the server hosting the database ;

to connect by root to the server hosting the database ;

to connect by root to the server hosting the database ;

to connect by root to the server hosting the database

.

su - postgres
vacuumdb -d "collec" --analyze

This command can also be integrated in the backup script (cf. Database configuration).