Skip to content

Instantly share code, notes, and snippets.

@denishaskin

denishaskin/gist:3085445

Created July 10, 2012 18:43
Show Gist options
  • Save denishaskin/3085445 to your computer and use it in GitHub Desktop.
Save denishaskin/3085445 to your computer and use it in GitHub Desktop.
Download ZIP
the-query
Raw
gistfile1.sql
select sysdate(), c.time_received, c.archive_time_received,
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency',
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency',
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency'
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment