Skip to content

Instantly share code, notes, and snippets.

@joebartels

joebartels/medium.date_fields_vs_extract.query_cycling_entry_by_day_of_week.sql

Created September 12, 2018 15:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joebartels/403ed0021093e546758d377e3131a479 to your computer and use it in GitHub Desktop.
Save joebartels/403ed0021093e546758d377e3131a479 to your computer and use it in GitHub Desktop.
Download ZIP
query time for cycling_entry using date field and extract() function
Raw
medium.date_fields_vs_extract.query_cycling_entry_by_day_of_week.sql
select *
from cycling_entry
where day_of_week = 1;
-- average time: 8.75ms
select *
from cycling_entry
where extract(dow from date) = 1;
-- average time: 21ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment