Matthias Wirtz

adrian did the same last year (bump to 15). https://github.com/teslamate-org/teslamate/commit/b79a4544fb8f1937784c0a16b54bf558e2aa07e4 i think it's fine to bump for new users.

tested, for me works fine! LGTM @JakobLichterfeld

I think that subquery can be improved way more - will have a look over the weekend! - two cars within my db but no `? Missing` Action so far....

ok - from the analysis that i've done so far - you could comment out the filter cond. for TP1 & TP2 - commenting out T2 can result in query...

Looks like a great improvement 👍 @DrMichael / @JakobLichterfeld could you maybe run the queries as well? Please include Postgres version and test in bottom up order. @jheredianet - what...

diving into that seeing more issues within the query also leading to missing entries i think the geofence condition needs to be: ```sql AND T1.end_address_id T2.start_address_id AND ( (coalesce(T1.end_geofence_id, 0)...

Thanks @jheredianet - how many drives do you have? 900 in my instance (32gb, 20 cpu, nvme, pg16) and all queries take equally long. i've added queries 6-8, could you...

Ok, I think we will go with query 8, will open a PR later. Any other queries to speed up? ,🤓

👍 - thanks @andreadam82 - you can try running the dashboard provided in #4019 by using the corresponding grafana image: `docker pull ghcr.io/teslamate-org/teslamate/grafana:pr-4019`

found this confusing as well - the dialog is structured in a way that it seems perfectly fine: