query13.sql

explain analyze select * from user_details where details -> 'info' ->> 'crop' = 'Corn' and details -> 'info' ->> 'farmSize' = '2-3' limit 50;
QUERY PLAN                                                                                                                                                |
----------------------------------------------------------------------------------------------------------------------------------------------------------|
Limit  (cost=1000.00..136551.01 rows=50 width=426) (actual time=3.764..4.346 rows=50 loops=1)                                                             |
  ->  Gather  (cost=1000.00..255835.90 rows=94 width=426) (actual time=0.165..40.441 rows=50 loops=1)                                                     |
        Workers Planned: 2                                                                                                                                |
        Workers Launched: 2                                                                                                                               |
        ->  Parallel Seq Scan on user_details  (cost=0.00..254826.50 rows=39 width=426) (actual time=4.638..4.818 rows=17 loops=3)                        |
              Filter: ((((details -> 'info'::text) ->> 'crop'::text) = 'Corn'::text) AND (((details -> 'info'::text) ->> 'farmSize'::text) = '2-3'::text))|
              Rows Removed by Filter: 369                                                                                                                 |
Planning Time: 0.059 ms                                                                                                                                   |
JIT:                                                                                                                                                      |
  Functions: 7                                                                                                                                            |
  Options: Inlining false, Optimization false, Expressions true, Deforming true                                                                           |
  Timing: Generation 1.774 ms, Inlining 0.000 ms, Optimization 1.014 ms, Emission 14.855 ms, Total 17.643 ms                                              |
Execution Time: 44.733 ms                                                                                                                                 |