query8.sql

explain analyze select * from user_details where details @> '{"alternateContacts" : ["+6171836370278"]}';
QUERY PLAN                                                                                                                       |
---------------------------------------------------------------------------------------------------------------------------------|
Gather  (cost=1000.00..236670.25 rows=3750 width=426) (actual time=646.851..652.494 rows=1 loops=1)                              |
  Workers Planned: 2                                                                                                             |
  Workers Launched: 2                                                                                                            |
  ->  Parallel Seq Scan on user_details  (cost=0.00..235295.25 rows=1562 width=426) (actual time=618.252..618.545 rows=0 loops=3)|
        Filter: (details @> '{"alternateContacts": ["+6171836370278"]}'::jsonb)                                                  |
        Rows Removed by Filter: 1250000                                                                                          |
Planning Time: 0.050 ms                                                                                                          |
JIT:                                                                                                                             |
  Functions: 6                                                                                                                   |
  Options: Inlining false, Optimization false, Expressions true, Deforming true                                                  |
  Timing: Generation 1.930 ms, Inlining 0.000 ms, Optimization 1.689 ms, Emission 15.892 ms, Total 19.511 ms                     |
Execution Time: 653.037 ms                                                                                                       |