Skip to content

Instantly share code, notes, and snippets.

@ereshzealous
Created September 7, 2021 09:26
Show Gist options
  • Save ereshzealous/6cdda48966107e1db61322696e014b69 to your computer and use it in GitHub Desktop.
Save ereshzealous/6cdda48966107e1db61322696e014b69 to your computer and use it in GitHub Desktop.
explain analyze select * from user_details where to_date(details ->>'dateOfBirth', 'YYYY-MM-DD') between '2000-03-01' and '2000-03-31' limit 50;
QUERY PLAN |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
Limit (cost=0.00..825.37 rows=50 width=426) (actual time=0.113..27.525 rows=50 loops=1) |
-> Seq Scan on user_details (cost=0.00..309514.00 rows=18750 width=426) (actual time=0.112..27.515 rows=50 loops=1) |
Filter: ((to_date((details ->> 'dateOfBirth'::text), 'YYYY-MM-DD'::text) >= '2000-03-01'::date) AND (to_date((details ->> 'dateOfBirth'::text), 'YYYY-MM-DD'::text) <= '2000-03-31'::date))|
Rows Removed by Filter: 38675 |
Planning Time: 0.079 ms |
Execution Time: 27.552 ms |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment