explain analyse select * from "db1" ps where "Url" like '%profilesettings%'
Gather (cost=1000.00..2359455.91 rows=3141 width=439) (actual time=0.590..4487.742 rows=220 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Parallel Seq Scan on "db1" ps (cost=0.00..2358141.81 rows=1309 width=439) (actual time=13.173..4311.107 rows=73 loops=3)
Filter: ("Url" ~~ '%profilesettings%'::text)
Rows Removed by Filter: 13994795
Planning Time: 0.214 ms
Execution Time: 4487.844 ms
create extension pg_trgm;
create index concurrently db_url_trgm_idx on db1 using gin ("Url" gin_trgm_ops);