defect.ch - Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Delete Peaks ======



Latest Data / Graph

URL: <code>https://zabbix.example.com/history.php?action=showgraph&itemids[]=32446</code>



===== History =====

<code>
postgres=# \c zabbix
You are now connected to database "zabbix" as user "postgres".
zabbix=# SELECT * FROM history_uint WHERE itemid=32446 ORDER BY value DESC LIMIT 5;
 itemid |   clock    |   value    |    ns
--------+------------+------------+-----------
  32446 | 1563839842 | 2315255879 | 804036669
  32446 | 1563333140 |  553648165 | 743858737
  32446 | 1563094839 |      97738 | 795507182
  32446 | 1563093020 |      84130 | 778013000
  32446 | 1563092665 |      84130 | 787202656
(5 rows)

zabbix=#
</code>

<code>
zabbix=# DELETE FROM history_uint WHERE itemid=32446 AND clock=1563839842 AND value=2315255879;
DELETE 1
zabbix=#
</code>

<code>
zabbix=# DELETE FROM history_uint WHERE itemid=32446 AND clock=1563333140 AND value=553648165;
DELETE 1
zabbix=#
</code>

<code>
zabbix=# SELECT * FROM history_uint WHERE itemid=32446 ORDER BY value DESC LIMIT 5;
 itemid |   clock    | value |    ns
--------+------------+-------+-----------
  32446 | 1563094839 | 97738 | 795507182
  32446 | 1563093020 | 84130 | 778013000
  32446 | 1563092665 | 84130 | 787202656
  32446 | 1563090501 | 79620 | 821510998
  32446 | 1563091219 | 75971 | 733541239
(5 rows)

zabbix=#
</code>


===== Trends =====

<code>
zabbix=# SELECT * FROM trends_uint WHERE itemid=32446 ORDER BY value_max DESC LIMIT 5;
 itemid |   clock    | num | value_min | value_avg | value_max
--------+------------+-----+-----------+-----------+------------
  32446 | 1563836400 |  20 |        14 | 115762854 | 2315255879
  32446 | 1563332400 |  20 |        37 |  27682572 |  553648165
  32446 | 1563094800 |  20 |      7295 |     17593 |      97738
  32446 | 1563091200 |  20 |     16811 |     62771 |      84130
  32446 | 1563087600 |  20 |     41822 |     52669 |      79620
(5 rows)
</code>

<code>
zabbix=# SELECT * FROM history_uint WHERE itemid=32446 AND clock>=1563836400 ORDER BY clock LIMIT 20;
 itemid |   clock    | value |    ns
--------+------------+-------+-----------
  32446 | 1563836418 |    34 | 887305104
  32446 | 1563836599 |    52 | 841617953
  32446 | 1563836778 |   110 | 907114797
  32446 | 1563836959 |    30 |  12333028
  32446 | 1563837136 |    52 | 922040514
  32446 | 1563837315 |   110 | 863996787
  32446 | 1563837503 |    14 | 855106664
  32446 | 1563837679 |    52 | 847014732
  32446 | 1563837863 |   110 | 841293598
  32446 | 1563838041 |    34 |  19946886
  32446 | 1563838221 |    71 | 857007217
  32446 | 1563838401 |   110 | 856505356
  32446 | 1563838582 |    34 | 849365992
  32446 | 1563838760 |    71 | 832328704
  32446 | 1563838941 |    89 | 825639986
  32446 | 1563839117 |    34 | 836295686
  32446 | 1563839300 |    71 | 830385251
  32446 | 1563839479 |    89 | 821144867
  32446 | 1563839659 |    34 | 786519995
  32446 | 1563840022 |    71 | 803161238
(20 rows)
</code>

<code>
zabbix=# SELECT * FROM history_uint WHERE itemid=32446 AND clock>=1563332400 ORDER BY clock LIMIT 20;
 itemid |   clock    | value |    ns
--------+------------+-------+-----------
  32446 | 1563332421 |    92 | 749687785
  32446 | 1563332597 |    37 | 721083051
  32446 | 1563332783 |    53 | 680233074
  32446 | 1563332961 |    92 | 793757552
  32446 | 1563333323 |    53 | 645005988
  32446 | 1563333499 |    92 | 746841050
  32446 | 1563333682 |    37 | 636116474
  32446 | 1563333863 |    94 | 749749234
  32446 | 1563334039 |   162 | 602596205
  32446 | 1563334222 |   132 | 624911127
  32446 | 1563334405 |   132 | 674211650
  32446 | 1563334590 |   162 | 632405190
  32446 | 1563334761 |   148 | 802656456
  32446 | 1563334945 |   194 | 572960822
  32446 | 1563335124 |   273 | 556156341
  32446 | 1563335300 |   275 | 610291516
  32446 | 1563335483 |   339 | 644894608
  32446 | 1563335659 |   440 | 552092226
  32446 | 1563335839 |   474 | 558358744
  32446 | 1563336027 |   585 | 670905365
(20 rows)
</code>

<code>

zabbix=# SELECT MIN(value),MAX(value),AVG(value) FROM history_uint WHERE itemid=32446 AND clock>=1563836400 AND clock<=1563840022;
 min | max |         avg
-----+-----+---------------------
  14 | 110 | 63.6000000000000000
(1 row)
</code>

<code>
zabbix=# SELECT MIN(value),MAX(value),AVG(value) FROM history_uint WHERE itemid=32446 AND clock>=1563332421 AND clock<=1563336027;
 min | max |         avg
-----+-----+----------------------
  37 | 585 | 193.3000000000000000
(1 row)
</code>

<code>
zabbix=# UPDATE trends_uint SET value_max=110, value_avg=63 WHERE itemid=32446 AND clock=1563836400;
UPDATE 1
zabbix=# UPDATE trends_uint SET value_max=585, value_avg=193 WHERE itemid=32446 AND clock=1563332400;
UPDATE 1
</code>