query3.sql

explain analyze select * from user_details where jsonb_extract_path_text(details,'familyMembers') :: int = 9 limit 50;
QUERY PLAN                                                                                                             |
-----------------------------------------------------------------------------------------------------------------------|
Limit  (cost=0.00..725.37 rows=50 width=426) (actual time=0.033..26.974 rows=50 loops=1)                               |
  ->  Seq Scan on user_details  (cost=0.00..272014.00 rows=18750 width=426) (actual time=0.032..26.968 rows=50 loops=1)|
        Filter: ((details ->> 'familyMembers'::text) = '9'::text)                                                      |
        Rows Removed by Filter: 73588                                                                                  |
Planning Time: 0.212 ms                                                                                                |
Execution Time: 26.997 ms                                                                                              |