Recorder wont always release memory after nightly purge

[Mariusthvdb]

The problem

seeing this happening regularly on nightly purges:

(had to put the handle just before the purge time, otherwise the popup would cover the graph)

another one from sept 11, zoomed in a bit more:

cant say it happens each night, but in another discussion with Nick (Bdraco) he suggested this was happening. Dont think we made an issue for it at that moment, so separating it here now for investigation, because it occurs regularly.

What version of Home Assistant Core has the issue?

2022.9.4

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

recorder

Link to integration documentation on our website

https://www.home-assistant.io/integrations/recorder/

Diagnostics information

No response

Example YAML snippet

db_url: !secret db_url # mysql://[user]:[pw]@core-mariadb/homeassistant?charset=utf8mb4
purge_keep_days: 14

# https://www.home-assistant.io/integrations/recorder/#configure-filter
exclude:
  !include excluded_entities.yaml

include:
  !include included_entities.yaml

Anything in the logs that might be useful for us?

dont think so, only line logged around that time is:

2022-09-15 04:35:16.458 WARNING (MainThread) [homeassistant.components.websocket_api.http.connection] [140518028832448] Disconnected: Did not receive auth message within 10 seconds

but believe that to be not related?

Additional information

No response

[probot-home-assistant[bot]]

recorder documentation recorder source _{^{(message by IssueLinks)}}

[probot-home-assistant[bot]]

Hey there @home-assistant/core, mind taking a look at this issue as it has been labeled with an integration (recorder) you are listed as a code owner for? Thanks! _{^{(message by CodeOwnersMention)}}