Skip to content

Instantly share code, notes, and snippets.

@ereshzealous

ereshzealous/query1.sql

Created September 7, 2021 09:16
Show Gist options
  • Save ereshzealous/9d2c3c0b2f75071194f95d4bc8a58865 to your computer and use it in GitHub Desktop.
Save ereshzealous/9d2c3c0b2f75071194f95d4bc8a58865 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query1.sql
explain analyze select * from user_details where details ->> 'profession' = 'Farmer' limit 50;
QUERY PLAN |
----------------------------------------------------------------------------------------------------------------------|
Limit (cost=0.00..725.37 rows=50 width=426) (actual time=0.014..0.247 rows=50 loops=1) |
-> Seq Scan on user_details (cost=0.00..272014.00 rows=18750 width=426) (actual time=0.013..0.241 rows=50 loops=1)|
Filter: ((details ->> 'profession'::text) = 'Farmer'::text) |
Rows Removed by Filter: 276 |
Planning Time: 0.075 ms |
Execution Time: 0.267 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment