query2.sql

select * from user_details where details ->> 'profession' like '%Farm%' limit 50;
QUERY PLAN                                                                                                            |
----------------------------------------------------------------------------------------------------------------------|
Limit  (cost=0.00..453.36 rows=50 width=426) (actual time=0.024..0.169 rows=50 loops=1)                               |
  ->  Seq Scan on user_details  (cost=0.00..272014.00 rows=30000 width=426) (actual time=0.023..0.165 rows=50 loops=1)|
        Filter: ((details ->> 'profession'::text) ~~ '%Farm%'::text)                                                  |
        Rows Removed by Filter: 216                                                                                   |
Planning Time: 0.152 ms                                                                                               |
Execution Time: 0.211 ms                                                                                              |