{"id":3010,"date":"2026-04-20T12:00:00","date_gmt":"2026-04-20T10:00:00","guid":{"rendered":"https:\/\/sascha-brockel.de\/?p=3010"},"modified":"2026-04-05T19:29:24","modified_gmt":"2026-04-05T17:29:24","slug":"home-assistant-dbstats-database-optimization","status":"publish","type":"post","link":"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/","title":{"rendered":"DBStats: Home Assistant Find and solve database problems"},"content":{"rendered":"<p class=\"wp-block-yoast-seo-estimated-reading-time yoast-reading-time__wrapper\"><span class=\"yoast-reading-time__icon\"><svg aria-hidden=\"true\" focusable=\"false\" data-icon=\"clock\" width=\"20\" height=\"20\" fill=\"none\" stroke=\"currentColor\" style=\"display:inline-block;vertical-align:-0.1em\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewbox=\"0 0 24 24\"><path stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2\" d=\"M12 8v4l3 3m6-3a9 9 0 11-18 0 9 9 0 0118 0z\"><\/path><\/svg><\/span><span class=\"yoast-reading-time__spacer\" style=\"display:inline-block;width:1em\"><\/span><span class=\"yoast-reading-time__descriptive-text\">Estimated reading time: <\/span><span class=\"yoast-reading-time__reading-time\">9<\/span><span class=\"yoast-reading-time__time-unit\"> minutes<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Do you know this? You want to check yesterday's temperature history in your Home Assistant dashboard and the loading cycle seems to take forever. Or even worse: your nightly backups suddenly fail because the files have grown to gigantic proportions and the storage space on your Raspberry Pi or mini PC is bursting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In 99 % of cases, the cause lies precisely here: <strong>The Home Assistant database has become too large.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Every click, every temperature change and every passing cloud that your weather sensor detects is recorded in the database by default (usually the <code>home-assistant_v2.db<\/code>) is saved. If you don't intervene, the system will clog itself up. But how do you find out which devices are the real culprits?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is where the fantastic tool comes in <strong><a href=\"https:\/\/github.com\/jehy\/hass-dbstats\">DBStats<\/a><\/strong> into play. In this article, I'll show you how to use the DBStats add-on from jehy to take a deep look into your database, identify the worst memory hogs and make your system light-footed and lightning-fast again.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For detailed instructions and explanations of all configuration options, I recommend watching the YouTube video linked below. This video goes into detail about each individual setting, providing you with comprehensive instructions on how to set everything up correctly. Any code from the video can be found in this article, so you can use it directly without having to type it out.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title ez-toc-toggle\" style=\"cursor:pointer\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" 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: #dd3333;color:#dd3333\" 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><\/span><\/a><\/span><\/div>\n<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:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Was_ist_Home_Assistant\" >What is Home Assistant?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Was_ist_DBStats_und_warum_brauchst_du_es\" >What is DBStats and why do you need it?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#DBStats_in_Home_Assistant_installieren\" >Install DBStats in Home Assistant<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Die_Analyse_%E2%80%93_Wie_du_Probleme_mit_DBStats_identifizierst\" >The analysis - How to identify problems with DBStats<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#1_Die_states_Tabelle_Zustandsanderungen\" >1. the states table (state changes)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#2_Die_events_Tabelle_Ereignisse\" >2. the events table (events)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Speicherfresser_eliminieren_Der_Recorder\" >Eliminate memory hogs (The recorder)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Die_Datenbank_bereinigen_Purge\" >Purge the database (Purge)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Umsetzung_im_YouTube-Video\" >YouTube video implementation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Fazit\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/#Nutzliche_Links_auf_einen_Blick\" >Useful links at a glance<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-was-ist-home-assistant\"><span class=\"ez-toc-section\" id=\"Was_ist_Home_Assistant\"><\/span>What is Home Assistant?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Home Assistant is an open-source platform for home automation that aims to connect all devices in the home and control them centrally. It was developed to provide a unified user interface and simple, flexible control for a wide range of smart home devices from different ecosystems. Here are some points in favor of Home Assistant:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Compatibility<\/strong>Home Assistant supports thousands of devices and services from various manufacturers, including lighting, air conditioning, heating, cameras, weather sensors, voice assistants and more.<\/li>\n\n\n\n<li><strong>Local control<\/strong>Unlike many commercial smart home platforms that rely on cloud services, Home Assistant runs locally on your network. This means increased privacy and reliability, as your smart home devices work even without an active internet connection.<\/li>\n\n\n\n<li><strong>Automation and scenes<\/strong>One of the main features of Home Assistant is the ability to create complex automations and scenarios. For example, you can have lights turn on automatically when it gets dark, or turn on the heating when the temperature drops below a certain level.<\/li>\n\n\n\n<li><strong>Simple user interface<\/strong>Home Assistant offers a user-friendly interface that makes it easy to monitor and control devices. This interface is fully customizable.<\/li>\n\n\n\n<li><strong>Integration with voice assistants<\/strong>Home Assistant can be integrated with voice assistants such as Amazon Alexa or Google Assistant to enable voice-controlled control of your smart home devices.<\/li>\n\n\n\n<li><strong>Open source and community-driven<\/strong>Since Home Assistant is open source, it is supported by an active community that is constantly developing new integrations and improving existing ones.<\/li>\n\n\n\n<li><strong>Data protection and security<\/strong>As a locally running platform, Home Assistant has the advantage that the data remains within its own network. This protects privacy and increases security compared to cloud-based solutions.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">In summary, Home Assistant is a powerful and flexible solution for those who want to design their own smart home and control their devices centrally, regardless of the manufacturer or ecosystem.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-hauptteil\"><span class=\"ez-toc-section\" id=\"Was_ist_DBStats_und_warum_brauchst_du_es\"><\/span>What is DBStats and why do you need it?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By default, Home Assistant offers you hardly any options to look deep into the structure of your database. You can see the file size, but not the size of the file, <em>what<\/em> occupies exactly this memory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a target=\"_blank\" rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/jehy\/hass-dbstats\">DBStats (hass-dbstats)<\/a><\/strong> is a custom add-on for Home Assistant OS (and Supervised). It acts as an analysis tool that scans your database (whether the standard SQLite database or an external MariaDB\/MySQL) and shows you which entities generate the most entries in a clear web interface.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Your advantages at a glance:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Targeted troubleshooting:<\/strong> Instead of fiddling around blindly in the recorder, you know exactly which entities you need to exclude after the scan.<\/li>\n\n\n\n<li><strong>Visual analysis:<\/strong> You can immediately see which sensors are taking up the most memory.<\/li>\n\n\n\n<li><strong>Table insights:<\/strong> You can recognize whether the problem is in the table <code>states<\/code> (changes of state) or in <code>events<\/code> (events).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DBStats_in_Home_Assistant_installieren\"><\/span>Install DBStats in Home Assistant<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Since DBStats is not an official add-on, you need to add it via a custom repository. This only takes two minutes:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>In your Home Assistant, go to <strong>Settings<\/strong> > <strong>Apps<\/strong>.<\/li>\n\n\n\n<li>Click at the bottom right on <strong>Add-on store<\/strong>.<\/li>\n\n\n\n<li>Click on the bottom right on the <strong>Install app<\/strong>.<\/li>\n\n\n\n<li>Click on the top right on the <strong>three points<\/strong> and select <strong>Repositories<\/strong>.<\/li>\n\n\n\n<li>Add the following URL from GitHub: <code><a href=\"https:\/\/github.com\/jehy\/hass-addons\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/jehy\/hass-addons<\/a><\/code> and click on <strong>Add<\/strong> or alternatively use this button:<br> <a href=\"https:\/\/my.home-assistant.io\/redirect\/supervisor_add_addon_repository\/?repository_url=https%3A%2F%2Fgithub.com%2Fjehy%2Fhass-addons\"><img decoding=\"async\" src=\"https:\/\/camo.githubusercontent.com\/ec9c2f71a62da9a3cf53df2bba1d0f1068cb31f8eb1cac9323a68cee219a531d\/68747470733a2f2f6d792e686f6d652d617373697374616e742e696f2f6261646765732f73757065727669736f725f6164645f6164646f6e5f7265706f7369746f72792e737667\" alt=\"Open your Home Assistant instance and show the add add-on repository dialog with a specific repository URL pre-filled.\"><\/a><\/li>\n\n\n\n<li>Close the window and reload the page.<\/li>\n\n\n\n<li>Scroll down until you see the new repository, select <strong>DBStats<\/strong> and click on <strong>Install<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Once the installation is complete, start the add-on and open the web user interface.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>(Tip: If you use MariaDB, you may need to enter your database access data in the add-on configuration. If you use the standard SQLite database, the tool usually works out-of-the-box).<\/em><\/p>\n\n\n\n<div class=\"atkp-container atkp-grid_3_columns-box  atkp-template-grid_3_columns\">\n            <div class=\"atkp-clearfix atkp-box-3-cols\">\n                            <div class=\"atkp-box atkp-smallbox atkp-box-3-cols-item atkp-clearfix\">\n                    <div class=\"atkp-thumb\">\n                                                    <img decoding=\"async\" class=\"atkp-image\" src=\"https:\/\/m.media-amazon.com\/images\/I\/415MIdvMnZL._SL160_.jpg\"\n                                 alt=\"Intel NUC 13 PRO NUC13ANHi5 Arena Canyon, 16 GB RAM 512 GB SSD, Intel Core i5-1340P, Win 11 Pro Mini Desktop Computer, 8K\/4K UHD, Gigabit Ethernet\/WiFi-6\/VESA for Business\/Office\/Home\"\/>\n                                            <\/div>\n                    <div class=\"atkp-content\">\n                                                    <a class=\"atkp-title\" href=\"https:\/\/www.amazon.de\/dp\/B0C1YKGGWY?tag=sasbro0a-21&linkCode=osi&th=1&psc=1\" rel=\"sponsored nofollow noopener\" target=\"_blank\"  title=\"Buy now at Amazon\">Intel NUC 13 PRO NUC13ANHi5 Arena Canyon, 16 GB RAM 512 GB SSD, Intel Core i5-1340P, Win 11 Pro Mini Desktop Computer, 8K\/4K UHD, Gigabit Ethernet\/WiFi-6\/VESA for business\/office\/home*<\/a>\n                                                <div class=\"atkp-author\">by Intel Corporation<\/div>\n                    <\/div>\n                    <div class=\"atkp-bottom\">\n                        <div class=\"atkp-ratingbar\">\n                                                            <div class=\"atkp-rating\"><span class=\"atkp-star atkp-star-0 atkp-star-00\" title=\"0.00 of 5 stars\"><\/span><\/div>\n                                                        <div class=\"atkp-primelogo\"><\/div>\n                            <div class=\"atkp-clearfix\"><\/div>\n                        <\/div>\n                                                    <span class=\"atkp-price atkp-saleprice\">\n                                Price: \u20ac 759.00\n                                                                    <span class=\"atkp_price atkp-baseprice\"><\/span>\n                                                            <\/span>\n                                                                            <a href=\"https:\/\/www.amazon.de\/dp\/B0C1YKGGWY?tag=sasbro0a-21&linkCode=osi&th=1&psc=1\" rel=\"sponsored nofollow noopener\" target=\"_blank\"  title=\"Buy now at Amazon\" class=\"atkp-button\">Buy now on Amazon*<\/a>\n                        \n                        \n                                                    <span class=\"atkp-priceinfo\">Price incl. VAT, Excl. shipping<\/span>\n                                                                            <div class=\"atkp-shoplogo\">Amazon<\/div>\n                                            <\/div>\n                <\/div>\n                            <div class=\"atkp-box atkp-smallbox atkp-box-3-cols-item atkp-clearfix\">\n                    <div class=\"atkp-thumb\">\n                                                    <img decoding=\"async\" class=\"atkp-image\" src=\"https:\/\/m.media-amazon.com\/images\/I\/31z5HMCxvCL._SL160_.jpg\"\n                                 alt=\"ASUS NUC 15 Pro Tall Kit RNUC15CRHI300002 (Intel Core i3 processor, Arc graphics, WiFi 7, Bluetooth 5.4, without operating system, with EU power cable)\"\/>\n                                            <\/div>\n                    <div class=\"atkp-content\">\n                                                    <a class=\"atkp-title\" href=\"https:\/\/www.amazon.de\/dp\/B0DY83YSSW?tag=sasbro0a-21&linkCode=osi&th=1&psc=1\" rel=\"sponsored nofollow noopener\" target=\"_blank\"  title=\"Buy now at Amazon\">ASUS NUC 15 Pro Tall Kit RNUC15CRHI300002 (Intel Core i3 processor, Arc graphics, WiFi 7, Bluetooth 5.4, without operating system, with EU power cable)*<\/a>\n                                                <div class=\"atkp-author\">by Asus<\/div>\n                    <\/div>\n                    <div class=\"atkp-bottom\">\n                        <div class=\"atkp-ratingbar\">\n                                                            <div class=\"atkp-rating\"><span class=\"atkp-star atkp-star-0 atkp-star-00\" title=\"0.00 of 5 stars\"><\/span><\/div>\n                                                        <div class=\"atkp-primelogo\"><\/div>\n                            <div class=\"atkp-clearfix\"><\/div>\n                        <\/div>\n                                                    <span class=\"atkp-price atkp-saleprice\">\n                                Price: \u20ac 295.58\n                                                                    <span class=\"atkp_price atkp-baseprice\"><\/span>\n                                                            <\/span>\n                                                                            <a href=\"https:\/\/www.amazon.de\/dp\/B0DY83YSSW?tag=sasbro0a-21&linkCode=osi&th=1&psc=1\" rel=\"sponsored nofollow noopener\" target=\"_blank\"  title=\"Buy now at Amazon\" class=\"atkp-button\">Buy now on Amazon*<\/a>\n                        \n                        \n                                                    <span class=\"atkp-priceinfo\">Price incl. VAT, Excl. shipping<\/span>\n                                                                            <div class=\"atkp-shoplogo\">Amazon<\/div>\n                                            <\/div>\n                <\/div>\n                            <div class=\"atkp-box atkp-smallbox atkp-box-3-cols-item atkp-clearfix\">\n                    <div class=\"atkp-thumb\">\n                                                    <img decoding=\"async\" class=\"atkp-image\" src=\"https:\/\/m.media-amazon.com\/images\/I\/31z5HMCxvCL._SL160_.jpg\"\n                                 alt=\"ASUS NUC 15 Pro Slim Kit RNUC15CRKU500002 (Intel Core i5 Ultra processor, Arc graphics, WiFi 7, Bluetooth 5.4, without operating system, with EU power cable)\"\/>\n                                            <\/div>\n                    <div class=\"atkp-content\">\n                                                    <a class=\"atkp-title\" href=\"https:\/\/www.amazon.de\/dp\/B0DY811HD9?tag=sasbro0a-21&linkCode=osi&th=1&psc=1\" rel=\"sponsored nofollow noopener\" target=\"_blank\"  title=\"Buy now at Amazon\">ASUS NUC 15 Pro Slim Kit RNUC15CRKU500002 (Intel Core i5 Ultra processor, Arc graphics, WiFi 7, Bluetooth 5.4, without operating system, with EU power cable)*<\/a>\n                                                <div class=\"atkp-author\">by Asus<\/div>\n                    <\/div>\n                    <div class=\"atkp-bottom\">\n                        <div class=\"atkp-ratingbar\">\n                                                            <div class=\"atkp-rating\"><span class=\"atkp-star atkp-star-0 atkp-star-00\" title=\"0.00 of 5 stars\"><\/span><\/div>\n                                                        <div class=\"atkp-primelogo\"><\/div>\n                            <div class=\"atkp-clearfix\"><\/div>\n                        <\/div>\n                                                    <span class=\"atkp-price atkp-saleprice\">\n                                Price: \u20ac 429.99\n                                                                    <span class=\"atkp_price atkp-baseprice\"><\/span>\n                                                            <\/span>\n                                                                            <a href=\"https:\/\/www.amazon.de\/dp\/B0DY811HD9?tag=sasbro0a-21&linkCode=osi&th=1&psc=1\" rel=\"sponsored nofollow noopener\" target=\"_blank\"  title=\"Buy now at Amazon\" class=\"atkp-button\">Buy now on Amazon*<\/a>\n                        \n                        \n                                                    <span class=\"atkp-priceinfo\">Price incl. VAT, Excl. shipping<\/span>\n                                                                            <div class=\"atkp-shoplogo\">Amazon<\/div>\n                                            <\/div>\n                <\/div>\n                    <\/div>\n            <\/div>\n\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Die_Analyse_%E2%80%93_Wie_du_Probleme_mit_DBStats_identifizierst\"><\/span>The analysis - How to identify problems with DBStats<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you open the DBStats web UI, the system performs a scan. Depending on the size of your database, this can take a few seconds or minutes. DBStats then presents you with various tables and diagrams.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here you need to pay attention to the following two key areas:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Die_states_Tabelle_Zustandsanderungen\"><\/span>1. the <code>states<\/code> Table (state changes)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This is usually the number one culprit. Each change of a sensor (e.g. temperature goes from 20.1\u00b0C to 20.2\u00b0C) is a new entry in this table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Typical memory hogs that you will find here:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Electricity metering sockets (smart plugs):<\/strong> Sensors that measure the current wattage are often updated every second. A single refrigerator plug can generate thousands of entries per hour.<\/li>\n\n\n\n<li><strong>System monitors:<\/strong> Sensors for CPU utilization or free RAM are updated extremely frequently, but are often of little historical value to you.<\/li>\n\n\n\n<li><strong>Media Player:<\/strong> A playing Chromecast or Sonos speaker changes its status permanently (e.g. current playback time in seconds).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Die_events_Tabelle_Ereignisse\"><\/span>2. the <code>events<\/code> Table (events)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This is where Home Assistant stores automation triggers, API calls and status events. If you find extremely high values here, this is often due to faulty integrations that are constantly pinging the system in the background or automations that run in endless loops.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>A concrete example from practice:<\/strong> You can see in DBStats that the sensor <code>sensor.washing_machine_performance<\/code> has generated an incredible 450,000 entries in the last 7 days. This one sensor accounts for 30 % of your database! Do you really need every tenth of a watt fluctuation for the history? No. It's enough if the value in the dashboard is up-to-date, but it doesn't necessarily have to end up in the database for eternity.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Speicherfresser_eliminieren_Der_Recorder\"><\/span>Eliminate memory hogs (The recorder)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now that DBStats has served you the culprits on a silver platter, it's time to act. The magic word is: <strong>Configuring the recorder<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The recorder integration controls what is written to the database and what is not. Open your <code>configuration.yaml<\/code> and create filters.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>This allows you to specifically exclude the identified memory hogs:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>recorder:\n  # Keep data for 7 days only (default is 10)\n  purge_keep_days: 7\n  \n  exclude:\n    # Exclude entire domains if you never need their history\n    domains:\n      - camera\n      - media_player\n      - update\n      \n    # Exclude certain entities that you found in DBStats\n    entities:\n      - sensor.washing_machine_performance\n      - sensor.cpu_utilization\n      - sensor.memory_free\n      \n    # Exclude entities according to certain patterns (e.g. all watt sensors)\n    entity_globs:\n      - sensor.*_power\n      - sensor.*_voltage\n      - sensor.*_current<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Important to understand:<\/strong> If you connect a sensor via the <code>exclude<\/code>-command, it disappears <strong>not<\/strong> from your dashboard. It still shows you the current value in real time! You can also continue to use it as a trigger for automations. The only thing that has been removed is the history graph for the past.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>(Advanced tip: If you want to store data long-term without bloating the Home Assistant database, set up an external <strong>InfluxDB<\/strong> and move the data there. InfluxDB is specially optimized for such time series data).<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Die_Datenbank_bereinigen_Purge\"><\/span>Purge the database (Purge)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You have the <code>configuration.yaml<\/code> adjusted and Home Assistant restarted. Great! Your database will grow much more slowly in future.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">But: The old data is still there. To free up the storage space immediately, you must instruct Home Assistant to clean up the database (repack).<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>In Home Assistant, go to <strong>Developer tools<\/strong> > <strong>Actions<\/strong>.<\/li>\n\n\n\n<li>Search for the service <code>Recorder: Purge<\/code> (Clean up).<\/li>\n\n\n\n<li>Set a check mark at <strong>Repacking<\/strong> (This is important, otherwise SQLite will not return the memory space to the operating system).<\/li>\n\n\n\n<li>Click on <strong>Execute action<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Depending on the size of the database, this process can take a few minutes. If you check your system afterwards (or make a new backup), you will notice that your <code>home-assistant_v2.db<\/code> has shrunk massively!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"youtube\"><span class=\"ez-toc-section\" id=\"Umsetzung_im_YouTube-Video\"><\/span>YouTube video implementation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/youtu.be\/YWS70Dcy7QM\n<\/div><\/figure>\n\n\n<p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-fazit\"><span class=\"ez-toc-section\" id=\"Fazit\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The database is the beating heart of your Home Assistant. If it clogs up, the entire system suffers from a loss of performance, SD cards break more quickly and backups become unwieldy.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Take 15 minutes today, install DBStats and take a look under the hood of your Home Assistant. You'll be amazed at what's there!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The add-on <strong>DBStats<\/strong> is an absolute must-have tool for every smart home administrator. It takes the guesswork out of database optimization. Instead of making settings at random, DBStats shows you in black and white where the problem lies. In combination with a clean <code>recorder<\/code>-configuration, you can keep your system stable, responsive and secure in the long term.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-nutzliche-links-auf-einen-blick\"><span class=\"ez-toc-section\" id=\"Nutzliche_Links_auf_einen_Blick\"><\/span>Useful links at a glance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/github.com\/jehy\/hass-dbstats\" target=\"_blank\" rel=\"noreferrer noopener\">GitHub repository of DBStats (jehy\/hass-dbstats)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.home-assistant.io\/integrations\/recorder\/\" target=\"_blank\" rel=\"noreferrer noopener\">Official Home Assistant documentation on recorder integration<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/community.home-assistant.io\/\" target=\"_blank\" rel=\"noreferrer noopener\">Home Assistant Forum: Discussions about database performance<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"jp-block-themeisle-blocks-font-awesome-icons-8c6d8bc1\" class=\"wp-block-themeisle-blocks-font-awesome-icons jp-block-themeisle-blocks-font-awesome-icons\"><span class=\"wp-block-themeisle-blocks-font-awesome-icons-container\"><a href=\"https:\/\/sascha-brockel.de\/en\/#contact\" target=\"_self\" rel=\"noopener noreferrer\"><i class=\"fas fa-business-time\"><\/i><\/a><\/span><\/div>\n\n\n\n<h4 id=\"jp-block-themeisle-blocks-advanced-heading-baa7fa4c\" class=\"wp-block-themeisle-blocks-advanced-heading jp-block-themeisle-blocks-advanced-heading-baa7fa4c jp-block-themeisle-blocks-advanced-heading ticss-116fe371\">Interested, but lack time or knowledge?<\/h4>\n\n\n\n<p id=\"jp-block-themeisle-blocks-advanced-heading-16f35f43\" class=\"wp-block-themeisle-blocks-advanced-heading jp-block-themeisle-blocks-advanced-heading-16f35f43 jp-block-themeisle-blocks-advanced-heading ticss-0e2b851d\">No problem. Contact me and we will discuss your requirements. No matter if business or private.<\/p>\n\n\n\n<div id=\"jp-block-themeisle-blocks-button-group-77e0455a\" class=\"wp-block-themeisle-blocks-button-group wp-block-buttons align-center jp-block-themeisle-blocks-button-group jp-block-buttons\">\n<div id=\"jp-block-themeisle-blocks-button-c6fb3687\" class=\"wp-block-themeisle-blocks-button wp-block-button jp-block-themeisle-blocks-button jp-block-button\"><a href=\"https:\/\/sascha-brockel.de\/en\/#contact\" target=\"_self\" rel=\"noopener noreferrer\" class=\"wp-block-button__link\"><i class=\"fas fa-fw fa-phone-volume margin-right\"><\/i><span>Contact<\/span><\/a><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Kennst du das? Du m\u00f6chtest in deinem Home Assistant Dashboard den Temperaturverlauf des gestrigen Tages pr\u00fcfen, und der Ladekreis dreht sich gef\u00fchlt eine Ewigkeit. Oder noch schlimmer: Deine n\u00e4chtlichen Backups schlagen pl\u00f6tzlich fehl, weil die Dateien gigantische Ausma\u00dfe angenommen haben und der Speicherplatz auf deinem Raspberry Pi oder Mini-PC platzt. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[32],"tags":[127,46,28],"class_list":["post-3010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart-home","tag-datenbank","tag-home-assistant","tag-smart-home"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.7 (Yoast SEO v27.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen - Sascha Brockel<\/title>\n<meta name=\"description\" content=\"Home Assistant Datenbank zu gro\u00df? Finde mit DBStats die gr\u00f6\u00dften Speicherfresser und mache dein Smart Home wieder rasend schnell.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen\" \/>\n<meta property=\"og:description\" content=\"Home Assistant Datenbank zu gro\u00df? Finde mit DBStats die gr\u00f6\u00dften Speicherfresser und mache dein Smart Home wieder rasend schnell.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/\" \/>\n<meta property=\"og:site_name\" content=\"Sascha Brockel\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-20T10:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"867\" \/>\n\t<meta property=\"og:image:height\" content=\"1300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sascha Brockel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@saschabrockel\" \/>\n<meta name=\"twitter:site\" content=\"@saschabrockel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sascha Brockel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/\"},\"author\":{\"name\":\"Sascha Brockel\",\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/#\\\/schema\\\/person\\\/3675ac2cf16fa04c60aca4dedca5c970\"},\"headline\":\"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen\",\"datePublished\":\"2026-04-20T10:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/\"},\"wordCount\":1135,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/#\\\/schema\\\/person\\\/3675ac2cf16fa04c60aca4dedca5c970\"},\"image\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/pexels-photo-12266915.avif\",\"keywords\":[\"Datenbank\",\"Home Assistant\",\"Smart Home\"],\"articleSection\":[\"Smart Home\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/en\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/\",\"url\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/\",\"name\":\"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen - Sascha Brockel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/pexels-photo-12266915.avif\",\"datePublished\":\"2026-04-20T10:00:00+00:00\",\"description\":\"Home Assistant Datenbank zu gro\u00df? Finde mit DBStats die gr\u00f6\u00dften Speicherfresser und mache dein Smart Home wieder rasend schnell.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/pexels-photo-12266915.avif\",\"contentUrl\":\"https:\\\/\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/pexels-photo-12266915.avif\",\"width\":867,\"height\":1300,\"caption\":\"Photo by Paul Seling on Pexels.com\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/home-assistant-dbstats-datenbank-optimieren\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/sascha-brockel.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/#website\",\"url\":\"https:\\\/\\\/sascha-brockel.de\\\/\",\"name\":\"Sascha Brockel\",\"description\":\"Fortschritt kennt keine Grenzen\",\"publisher\":{\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/#\\\/schema\\\/person\\\/3675ac2cf16fa04c60aca4dedca5c970\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sascha-brockel.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/sascha-brockel.de\\\/#\\\/schema\\\/person\\\/3675ac2cf16fa04c60aca4dedca5c970\",\"name\":\"Sascha Brockel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1\",\"width\":709,\"height\":945,\"caption\":\"Sascha Brockel\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/sascha-brockel.de\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1\"},\"sameAs\":[\"https:\\\/\\\/sascha-brockel.de\\\/\",\"https:\\\/\\\/www.instagram.com\\\/saschabrockel\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sascha-brockel-b20725164\\\/\",\"https:\\\/\\\/x.com\\\/saschabrockel\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCogo25FboCahP7s8--HDuIQ\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DBStats: Home Assistant Find and solve database problems - Sascha Brockel","description":"Home Assistant database too big? Find the biggest memory hogs with DBStats and make your smart home blazingly fast again.","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:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/","og_locale":"en_US","og_type":"article","og_title":"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen","og_description":"Home Assistant Datenbank zu gro\u00df? Finde mit DBStats die gr\u00f6\u00dften Speicherfresser und mache dein Smart Home wieder rasend schnell.","og_url":"https:\/\/sascha-brockel.de\/en\/home-assistant-dbstats-database-optimization\/","og_site_name":"Sascha Brockel","article_published_time":"2026-04-20T10:00:00+00:00","og_image":[{"width":867,"height":1300,"url":"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif","type":"image\/jpeg"}],"author":"Sascha Brockel","twitter_card":"summary_large_image","twitter_creator":"@saschabrockel","twitter_site":"@saschabrockel","twitter_misc":{"Written by":"Sascha Brockel","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#article","isPartOf":{"@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/"},"author":{"name":"Sascha Brockel","@id":"https:\/\/sascha-brockel.de\/#\/schema\/person\/3675ac2cf16fa04c60aca4dedca5c970"},"headline":"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen","datePublished":"2026-04-20T10:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/"},"wordCount":1135,"commentCount":0,"publisher":{"@id":"https:\/\/sascha-brockel.de\/#\/schema\/person\/3675ac2cf16fa04c60aca4dedca5c970"},"image":{"@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#primaryimage"},"thumbnailUrl":"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif","keywords":["Datenbank","Home Assistant","Smart Home"],"articleSection":["Smart Home"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/sascha-brockel.de\/en\/#organization"}},{"@type":"WebPage","@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/","url":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/","name":"DBStats: Home Assistant Find and solve database problems - Sascha Brockel","isPartOf":{"@id":"https:\/\/sascha-brockel.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#primaryimage"},"image":{"@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#primaryimage"},"thumbnailUrl":"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif","datePublished":"2026-04-20T10:00:00+00:00","description":"Home Assistant database too big? Find the biggest memory hogs with DBStats and make your smart home blazingly fast again.","breadcrumb":{"@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#primaryimage","url":"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif","contentUrl":"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif","width":867,"height":1300,"caption":"Photo by Paul Seling on Pexels.com"},{"@type":"BreadcrumbList","@id":"https:\/\/sascha-brockel.de\/home-assistant-dbstats-datenbank-optimieren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/sascha-brockel.de\/"},{"@type":"ListItem","position":2,"name":"DBStats: Home Assistant Datenbank-Probleme finden und l\u00f6sen"}]},{"@type":"WebSite","@id":"https:\/\/sascha-brockel.de\/#website","url":"https:\/\/sascha-brockel.de\/","name":"Sascha Brockel","description":"Progress knows no boundaries","publisher":{"@id":"https:\/\/sascha-brockel.de\/#\/schema\/person\/3675ac2cf16fa04c60aca4dedca5c970"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sascha-brockel.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/sascha-brockel.de\/#\/schema\/person\/3675ac2cf16fa04c60aca4dedca5c970","name":"Sascha Brockel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/i0.wp.com\/sascha-brockel.de\/wp-content\/uploads\/2023\/10\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1","url":"https:\/\/i0.wp.com\/sascha-brockel.de\/wp-content\/uploads\/2023\/10\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1","contentUrl":"https:\/\/i0.wp.com\/sascha-brockel.de\/wp-content\/uploads\/2023\/10\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1","width":709,"height":945,"caption":"Sascha Brockel"},"logo":{"@id":"https:\/\/i0.wp.com\/sascha-brockel.de\/wp-content\/uploads\/2023\/10\/Brockel_Sascha_3_3zu4-Grau.png?fit=709%2C945&ssl=1"},"sameAs":["https:\/\/sascha-brockel.de\/","https:\/\/www.instagram.com\/saschabrockel\/","https:\/\/www.linkedin.com\/in\/sascha-brockel-b20725164\/","https:\/\/x.com\/saschabrockel","https:\/\/www.youtube.com\/channel\/UCogo25FboCahP7s8--HDuIQ"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sascha-brockel.de\/wp-content\/uploads\/2026\/04\/pexels-photo-12266915.avif","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/posts\/3010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/comments?post=3010"}],"version-history":[{"count":2,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/posts\/3010\/revisions"}],"predecessor-version":[{"id":3047,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/posts\/3010\/revisions\/3047"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/media\/3046"}],"wp:attachment":[{"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/media?parent=3010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/categories?post=3010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sascha-brockel.de\/en\/wp-json\/wp\/v2\/tags?post=3010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}