On Sunday, May 1, 2016, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
>
> Your index is based on split_part function
> but the WHERE clause is specific to full_path, so the planner cannot find
> a valid index
>
>
This sentence is even less useful than the questions that you asked...
David J.