query14.sql

explain analyze select * from user_details where details @> '{"info" : {"crop" : "Corn", "farmSize": "2-3"}}' limit 50;
QUERY PLAN                                                                                                           |
---------------------------------------------------------------------------------------------------------------------|
Limit  (cost=0.00..3501.85 rows=50 width=426) (actual time=0.016..0.587 rows=50 loops=1)                             |
  ->  Seq Scan on user_details  (cost=0.00..262639.00 rows=3750 width=426) (actual time=0.015..0.581 rows=50 loops=1)|
        Filter: (details @> '{"info": {"crop": "Corn", "farmSize": "2-3"}}'::jsonb)                                  |
        Rows Removed by Filter: 1046                                                                                 |
Planning Time: 0.058 ms                                                                                              |
Execution Time: 0.613 ms                                                                                             |