InfluxDB questions (attention - rookie alarm)

Configuration
1

First of all: I am running:

Home Assistant 2022.11.4
Supervisor 2022.11.2
Operating System 9.3
Frontend 20221108.0 - latest

For long term availability (instead of the internal DB which is SQLite if I am not mistaken), I installed influxDB with the community addon.

However, I am missing some basic and I am sorry for this lack of experience.

  1. I have created the db homeassistant according to the docs of the addon mentioned above, bit I can’t find it on my system (just want to check if its size is increasing). Some says it’s in /usr/share/hassio/share/ but there is nothing to be found (no hassio directory).

  2. I tried to QUERY using the UI by:

SELECT "temperature" FROM "sensor.carbon_monoxide_sensor_air_temperature" WHERE time > now() - 24h;

but I get database name required
How to fix this?
Any simple check to verify if there is data written to the homeassistant DB at all?

  1. The DB is obviously there:

    image
    image1261×420 20.5 KB

    What about the permissions? The docs don’t mention that something needs to be changed after creating the DB.

  2. The Hosts List does not show any hosts (I assume that’s because it’s the localhost only?
    The Connections Tab shows this:

    image
    image1291×279 17.8 KB

EDIT:
About 1:
I tried
docker exec -it addon_a0d7b954_influxdb /bin/bash

But there is no homeassistant DB either:

root@a0d7b954-influxdb:/data# ls -la
total 48
drwxr-xr-x 4 root root  4096 Nov 26 08:21 .
drwxr-xr-x 1 root root  4096 Nov 26 08:20 ..
-rw------- 1 root root 32768 Nov 27 09:21 chronograf.db
drwxr-xr-x 5 root root  4096 Nov 26 08:21 influxdb
drwxr-xr-x 3 root root  4096 Nov 26 08:20 kapacitor
-rw------- 1 root root   130 Nov 26 08:20 options.json
-rw-r--r-- 1 root root    33 Nov 26 08:20 secret
root@a0d7b954-influxdb:/data#