{"id":752,"date":"2022-04-16T08:53:35","date_gmt":"2022-04-16T07:53:35","guid":{"rendered":"https:\/\/www.cipv6.de\/worp\/?p=752"},"modified":"2024-12-16T10:33:36","modified_gmt":"2024-12-16T09:33:36","slug":"influxdb-show-real-database-size-in-grafana","status":"publish","type":"post","link":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","title":{"rendered":"Influxdb: show real database size in Grafana"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Influxdb has no useful functions to look at the real database size.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As I have created a retention policy combined with continuous queries I want to see the exact values per database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I use the following approach:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>in Crontab a bash is executed to get the real influxes database values<\/li><li>the values are then pushed into a dedicated database for storing  the values<\/li><li>Grafana dashboard setup to show the values<\/li><\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a8694e9c080b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a8694e9c080b\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#Crontab\" >Crontab<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#Bash-script\" >Bash-script<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#Grafana-dashboard\" >Grafana-dashboard<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Crontab\"><\/span>Crontab<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">vi \/etc\/crontab and add the following line:<\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\"><code lang=\"bash\" class=\"language-bash\">*\/30  * * * *\troot\tsh \/home\/pi\/test.sh &gt;\/dev\/null 2&gt;&amp;1<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">the script <strong>\/home\/pi\/test.sh<\/strong> is executed every half an hour<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bash-script\"><\/span>Bash-script <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">vi <strong>\/home\/pi\/test.sh<\/strong> and paste this code in:<br><\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\"><code lang=\"bash\" class=\"language-bash\">#!\/usr\/bin\/env bash\n\n#get real database size\ntelegraf_data=$(du -s \/var\/lib\/influxdb\/data\/telegraf | awk '{print $1}')\n_internal_data=$(du -s \/var\/lib\/influxdb\/data\/_internal | awk '{print $1}')\nopenhab_db_data=$(du -s \/var\/lib\/influxdb\/data\/openhab_db | awk '{print $1}')\ncollectd_data=$(du -s \/var\/lib\/influxdb\/data\/collectd | awk '{print $1}')\nmydbsize_data=$(du -s \/var\/lib\/influxdb\/data\/mydbsize | awk '{print $1}')\n\n#print real database size to screen\necho \"******\"\necho $telegraf_data\necho $_internal_data\necho $openhab_db_data\necho $collectd_data\necho $mydbsize_data\necho \"******\"\n\n#push real database size values to database mydbsize\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=telegraf Size='\"$telegraf_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=_internal Size='\"$_internal_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=openhab_db Size='\"$openhab_db_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=collectd Size='\"$collectd_data\"' '\ncurl -i -XPOST 'http:\/\/localhost:8086\/write?db=mydbsize' --data-binary 'database,dbsize=mydbsize Size='\"$mydbsize_data\"' '\n\n#End\n\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I have created a dedicated database for these measurements in my case:<br><\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\"><code lang=\"bash\" class=\"language-bash\">root@raspi5:\/home\/pi# influx\nConnected to http:\/\/localhost:8086 version 1.8.10\nInfluxDB shell version: 1.8.10\n> create database mydbsize<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Grafana-dashboard\"><\/span>Grafana-dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Create a new db-source in Grafana:<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\" alt=\"\" class=\"wp-image-762\" width=\"1024\" height=\"914\" srcset=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png 1024w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-300x268.png 300w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-768x685.png 768w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1536x1371.png 1536w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-2048x1828.png 2048w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1200x1071.png 1200w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Add the queries per database in Grafana<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-1024x1007.png\" alt=\"\" class=\"wp-image-763\" width=\"1024\" height=\"1007\" srcset=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-1024x1007.png 1024w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-300x295.png 300w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-768x755.png 768w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-1536x1511.png 1536w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-2048x2014.png 2048w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.30.30@2x-1200x1180.png 1200w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Panel shown as JSON-data<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"json\" class=\"language-json\">{\n  \"id\": 8,\n  \"gridPos\": {\n    \"h\": 14,\n    \"w\": 23,\n    \"x\": 0,\n    \"y\": 9\n  },\n  \"type\": \"timeseries\",\n  \"title\": \"DB size\",\n  \"datasource\": {\n    \"type\": \"influxdb\",\n    \"uid\": \"cq2DkaZgk\"\n  },\n  \"pluginVersion\": \"8.4.4\",\n  \"links\": [],\n  \"fieldConfig\": {\n    \"defaults\": {\n      \"custom\": {\n        \"drawStyle\": \"line\",\n        \"lineInterpolation\": \"smooth\",\n        \"barAlignment\": 0,\n        \"lineWidth\": 2,\n        \"fillOpacity\": 10,\n        \"gradientMode\": \"none\",\n        \"spanNulls\": true,\n        \"showPoints\": \"auto\",\n        \"pointSize\": 4,\n        \"stacking\": {\n          \"mode\": \"none\",\n          \"group\": \"A\"\n        },\n        \"axisPlacement\": \"auto\",\n        \"axisLabel\": \"\",\n        \"scaleDistribution\": {\n          \"type\": \"log\",\n          \"log\": 2\n        },\n        \"hideFrom\": {\n          \"tooltip\": false,\n          \"viz\": false,\n          \"legend\": false\n        },\n        \"thresholdsStyle\": {\n          \"mode\": \"off\"\n        },\n        \"lineStyle\": {\n          \"fill\": \"solid\"\n        }\n      },\n      \"color\": {\n        \"mode\": \"palette-classic\"\n      },\n      \"mappings\": [],\n      \"thresholds\": {\n        \"mode\": \"absolute\",\n        \"steps\": [\n          {\n            \"color\": \"green\",\n            \"value\": null\n          },\n          {\n            \"color\": \"red\",\n            \"value\": 80\n          }\n        ]\n      },\n      \"unit\": \"deckbytes\"\n    },\n    \"overrides\": []\n  },\n  \"options\": {\n    \"tooltip\": {\n      \"mode\": \"multi\",\n      \"sort\": \"none\"\n    },\n    \"legend\": {\n      \"displayMode\": \"table\",\n      \"placement\": \"bottom\",\n      \"calcs\": [\n        \"lastNotNull\",\n        \"max\",\n        \"min\"\n      ]\n    }\n  },\n  \"targets\": [\n    {\n      \"alias\": \"_internal\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"A\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"_internal\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"collectd\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"B\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"collectd\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"openhab_db\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"C\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"openhab_db\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"mydbsize\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"autogen\",\n      \"refId\": \"D\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"mydbsize\"\n        }\n      ]\n    },\n    {\n      \"alias\": \"telegraf\",\n      \"datasource\": {\n        \"type\": \"influxdb\",\n        \"uid\": \"cq2DkaZgk\"\n      },\n      \"groupBy\": [\n        {\n          \"params\": [\n            \"$__interval\"\n          ],\n          \"type\": \"time\"\n        },\n        {\n          \"params\": [\n            \"null\"\n          ],\n          \"type\": \"fill\"\n        }\n      ],\n      \"hide\": false,\n      \"measurement\": \"database\",\n      \"orderByTime\": \"ASC\",\n      \"policy\": \"default\",\n      \"refId\": \"E\",\n      \"resultFormat\": \"time_series\",\n      \"select\": [\n        [\n          {\n            \"params\": [\n              \"Size\"\n            ],\n            \"type\": \"field\"\n          },\n          {\n            \"params\": [],\n            \"type\": \"last\"\n          }\n        ]\n      ],\n      \"tags\": [\n        {\n          \"key\": \"dbsize\",\n          \"operator\": \"=\",\n          \"value\": \"telegraf\"\n        }\n      ]\n    }\n  ]\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Example-view of dashboard:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x.png\" alt=\"\" class=\"wp-image-764\" width=\"1823\" height=\"1307\" srcset=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x.png 3646w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x-300x215.png 300w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x-1024x734.png 1024w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x-768x551.png 768w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x-1536x1101.png 1536w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x-2048x1468.png 2048w, https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x-1200x860.png 1200w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">done!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database. I use the following approach: in Crontab a bash is executed to get the real influxes database values the values are then pushed &hellip; <a href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Influxdb: show real database size in Grafana&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"template-page-builder.php","format":"standard","meta":{"footnotes":""},"categories":[65,66,61],"tags":[44,27,26,45,25,55],"class_list":["post-752","post","type-post","status-publish","format-standard","hentry","category-home-assistant","category-influx","category-linux","tag-database","tag-database-size","tag-grafana","tag-grafanba","tag-influxdb","tag-raspi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Influxdb: show real database size in Grafana - cipv6.de<\/title>\n<meta name=\"description\" content=\"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Influxdb: show real database size in Grafana - cipv6.de\" \/>\n<meta property=\"og:description\" content=\"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/\" \/>\n<meta property=\"og:site_name\" content=\"cipv6.de\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-16T07:53:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-16T09:33:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\" \/>\n<meta name=\"author\" content=\"ugu5ma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Influxdb: show real database size in Grafana\" \/>\n<meta name=\"twitter:description\" content=\"Influxdb has no useful functions to look at the real database size.As I have created a retention policy combined with continuous queries I want to see the exact values per database.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x.png\" \/>\n<meta name=\"twitter:creator\" content=\"@ugu5ma\" \/>\n<meta name=\"twitter:site\" content=\"@ugu5ma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ugu5ma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\"},\"author\":{\"name\":\"ugu5ma\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\"},\"headline\":\"Influxdb: show real database size in Grafana\",\"datePublished\":\"2022-04-16T07:53:35+00:00\",\"dateModified\":\"2024-12-16T09:33:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\"},\"wordCount\":143,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\",\"keywords\":[\"database\",\"database size\",\"grafana\",\"Grafanba\",\"influxdb\",\"Raspi\"],\"articleSection\":[\"Home-Assistant\",\"Influx\",\"Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\",\"url\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\",\"name\":\"Influxdb: show real database size in Grafana - cipv6.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png\",\"datePublished\":\"2022-04-16T07:53:35+00:00\",\"dateModified\":\"2024-12-16T09:33:36+00:00\",\"description\":\"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45@2x.png\",\"contentUrl\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/CleanShot-2022-04-16-at-09.24.45@2x.png\",\"width\":3028,\"height\":2702},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/index.php\\\/2022\\\/04\\\/16\\\/influxdb-show-real-database-size-in-grafana\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Influxdb: show real database size in Grafana\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#website\",\"url\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/\",\"name\":\"cipv6.de\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.cipv6.de\\\/worp\\\/#\\\/schema\\\/person\\\/5d62b275485540be9e5e9e33d4fab86d\",\"name\":\"ugu5ma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\",\"caption\":\"ugu5ma\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g\"},\"sameAs\":[\"https:\\\/\\\/cipv6.de\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Influxdb: show real database size in Grafana - cipv6.de","description":"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","og_locale":"en_US","og_type":"article","og_title":"Influxdb: show real database size in Grafana - cipv6.de","og_description":"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.","og_url":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","og_site_name":"cipv6.de","article_published_time":"2022-04-16T07:53:35+00:00","article_modified_time":"2024-12-16T09:33:36+00:00","og_image":[{"url":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png","type":"","width":"","height":""}],"author":"ugu5ma","twitter_card":"summary_large_image","twitter_title":"Influxdb: show real database size in Grafana","twitter_description":"Influxdb has no useful functions to look at the real database size.As I have created a retention policy combined with continuous queries I want to see the exact values per database.","twitter_image":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.31.31@2x.png","twitter_creator":"@ugu5ma","twitter_site":"@ugu5ma","twitter_misc":{"Written by":"ugu5ma","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#article","isPartOf":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/"},"author":{"name":"ugu5ma","@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d"},"headline":"Influxdb: show real database size in Grafana","datePublished":"2022-04-16T07:53:35+00:00","dateModified":"2024-12-16T09:33:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/"},"wordCount":143,"commentCount":0,"publisher":{"@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d"},"image":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png","keywords":["database","database size","grafana","Grafanba","influxdb","Raspi"],"articleSection":["Home-Assistant","Influx","Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","url":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/","name":"Influxdb: show real database size in Grafana - cipv6.de","isPartOf":{"@id":"https:\/\/www.cipv6.de\/worp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage"},"image":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x-1024x914.png","datePublished":"2022-04-16T07:53:35+00:00","dateModified":"2024-12-16T09:33:36+00:00","description":"Influxdb has no useful functions to look at the real database size. As I have created a retention policy combined with continuous queries I want to see the exact values per database.","breadcrumb":{"@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#primaryimage","url":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x.png","contentUrl":"https:\/\/www.cipv6.de\/worp\/wp-content\/uploads\/2022\/04\/CleanShot-2022-04-16-at-09.24.45@2x.png","width":3028,"height":2702},{"@type":"BreadcrumbList","@id":"https:\/\/www.cipv6.de\/worp\/index.php\/2022\/04\/16\/influxdb-show-real-database-size-in-grafana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cipv6.de\/worp\/"},{"@type":"ListItem","position":2,"name":"Influxdb: show real database size in Grafana"}]},{"@type":"WebSite","@id":"https:\/\/www.cipv6.de\/worp\/#website","url":"https:\/\/www.cipv6.de\/worp\/","name":"cipv6.de","description":"","publisher":{"@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cipv6.de\/worp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.cipv6.de\/worp\/#\/schema\/person\/5d62b275485540be9e5e9e33d4fab86d","name":"ugu5ma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g","caption":"ugu5ma"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/7211dd31d32612293e4228c8f880721a803dcc15211868f096ea9a8e77b6f316?s=96&d=mm&r=g"},"sameAs":["https:\/\/cipv6.de"]}]}},"_links":{"self":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/posts\/752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/comments?post=752"}],"version-history":[{"count":0,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/posts\/752\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/media?parent=752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/categories?post=752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cipv6.de\/worp\/index.php\/wp-json\/wp\/v2\/tags?post=752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}