query12.sql

explain analyze select * from user_details where details -> 'info' ->> 'crop' = 'Corn' limit 50;
QUERY PLAN                                                                                                            |
----------------------------------------------------------------------------------------------------------------------|
Limit  (cost=0.00..750.37 rows=50 width=426) (actual time=0.015..0.318 rows=50 loops=1)                               |
  ->  Seq Scan on user_details  (cost=0.00..281389.00 rows=18750 width=426) (actual time=0.014..0.315 rows=50 loops=1)|
        Filter: (((details -> 'info'::text) ->> 'crop'::text) = 'Corn'::text)                                         |
        Rows Removed by Filter: 210                                                                                   |
Planning Time: 0.052 ms                                                                                               |
Execution Time: 0.335 ms                                                                                              |