query4.sql

explain analyze select * from user_details where details ->> 'familyMembers' >= '1' and details ->> 'familyMembers' <= '3' limit 50;
QUERY PLAN                                                                                                                 |
---------------------------------------------------------------------------------------------------------------------------|
Limit  (cost=0.00..775.37 rows=50 width=426) (actual time=0.019..0.656 rows=50 loops=1)                                    |
  ->  Seq Scan on user_details  (cost=0.00..290764.00 rows=18750 width=426) (actual time=0.018..0.652 rows=50 loops=1)     |
        Filter: (((details ->> 'familyMembers'::text) >= '1'::text) AND ((details ->> 'familyMembers'::text) <= '3'::text))|
        Rows Removed by Filter: 100                                                                                        |
Planning Time: 0.096 ms                                                                                                    |
Execution Time: 0.672 ms                                                                                                   |