query5.sql

explain analyze select * from user_details where details ->> 'hasDisability' = 'false' limit 50;
QUERY PLAN                                                                                                            |
----------------------------------------------------------------------------------------------------------------------|
Limit  (cost=0.00..725.37 rows=50 width=426) (actual time=0.014..0.064 rows=50 loops=1)                               |
  ->  Seq Scan on user_details  (cost=0.00..272014.00 rows=18750 width=426) (actual time=0.013..0.058 rows=50 loops=1)|
        Filter: ((details ->> 'hasDisability'::text) = 'false'::text)                                                 |
        Rows Removed by Filter: 70                                                                                    |
Planning Time: 0.062 ms                                                                                               |
Execution Time: 0.079 ms                                                                                              |