Skip to content

Instantly share code, notes, and snippets.

@ereshzealous

ereshzealous/query13.sql

Created September 7, 2021 09:28
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ereshzealous/c65992fd9e4c590e64bc050eef702e0a to your computer and use it in GitHub Desktop.
Save ereshzealous/c65992fd9e4c590e64bc050eef702e0a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment