Skip to content

Instantly share code, notes, and snippets.

@workmaster2n

workmaster2n/3_seconds.sql

Created March 15, 2014 19:17
Show Gist options
  • Save workmaster2n/9572375 to your computer and use it in GitHub Desktop.
Save workmaster2n/9572375 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
3_seconds.sql
SELECT DISTINCT("tracked_points"."decisecond_recorded_at")
FROM "tracked_points" WHERE
"tracked_points"."recorded_at" >= '2014-03-05 06:00:00.000000'
Raw
5_seconds.sql
SELECT DISTINCT("tracked_points"."decisecond_recorded_at")
FROM "tracked_points" WHERE
"tracked_points"."recorded_at" >= '2014-03-05 06:00:00.000000'
ORDER BY decisecond_recorded_at
@workmaster2n
Copy link
Author

Slower: http://explain.depesz.com/s/TpW
Faster: http://explain.depesz.com/s/hGGG

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment