Skip to content

Instantly share code, notes, and snippets.

@jberkus

jberkus/gist:3296689

Created August 8, 2012 17:08
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 jberkus/3296689 to your computer and use it in GitHub Desktop.
Save jberkus/3296689 to your computer and use it in GitHub Desktop.
Download ZIP
Crash jump
Raw
gistfile1.txt
breakpad=# select date_trunc('day', date_processed), count(*) from reports where date_processed between '2012-08-01' and '2012-08-08' group by 1 order by 1;
date_trunc | count
------------------------+--------
2012-08-01 00:00:00+00 | 481349
2012-08-02 00:00:00+00 | 483259
2012-08-03 00:00:00+00 | 480551
2012-08-04 00:00:00+00 | 423422
2012-08-05 00:00:00+00 | 429353
2012-08-06 00:00:00+00 | 508709
2012-08-07 00:00:00+00 | 909945
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment