Your index is based on split_part functionbut the WHERE clause is specific to full_path, so the planner cannot find a valid index
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных