Skip to content

Instantly share code, notes, and snippets.

@csarcom

csarcom/gist:8bf3450e8567f06ad0cc

Created October 30, 2014 16:55
Show Gist options
  • Save csarcom/8bf3450e8567f06ad0cc to your computer and use it in GitHub Desktop.
Save csarcom/8bf3450e8567f06ad0cc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
presto:store> select * from metrics_rollup60 where name = 'upstream_cache_status.miss.2747t.hd' limit 10;
name | time | count | sum
-------------------------------------+-------------------------+--------+--------
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:45:00.000 | 9893 | 9893
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:46:00.000 | 166883 | 166883
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:47:00.000 | 223586 | 223586
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:48:00.000 | 232457 | 232457
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:49:00.000 | 234066 | 234066
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:50:00.000 | 240202 | 240202
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:51:00.000 | 231517 | 231517
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:52:00.000 | 220672 | 220672
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:53:00.000 | 229232 | 229232
upstream_cache_status.miss.2747t.hd | 2014-10-29 18:54:00.000 | 230842 | 230842
(10 rows)
presto:store> select * from metrics_rollup60 where name = 'bytes_sent.miss.2747t.hd' limit 10;
name | time | count | sum
--------------------------+-------------------------+--------+------------
bytes_sent.miss.2747t.hd | 2014-10-29 18:45:00.000 | 9893 | 112072036
bytes_sent.miss.2747t.hd | 2014-10-29 18:46:00.000 | 166883 | 1637354586
bytes_sent.miss.2747t.hd | 2014-10-29 18:47:00.000 | 223586 | 2271573231
bytes_sent.miss.2747t.hd | 2014-10-29 18:48:00.000 | 232457 | 2432849911
bytes_sent.miss.2747t.hd | 2014-10-29 18:49:00.000 | 234066 | 2453397952
bytes_sent.miss.2747t.hd | 2014-10-29 18:50:00.000 | 240202 | 2371110880
bytes_sent.miss.2747t.hd | 2014-10-29 18:51:00.000 | 231517 | 2360339360
bytes_sent.miss.2747t.hd | 2014-10-29 18:52:00.000 | 220672 | 2353953186
bytes_sent.miss.2747t.hd | 2014-10-29 18:53:00.000 | 229232 | 2397765383
bytes_sent.miss.2747t.hd | 2014-10-29 18:54:00.000 | 230842 | 2410652695
(10 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment