TeslaMate [megathread]

[Russinating]

Anyone better at Linux than me (anyone) know how to access/view the teslamate database through the command line? I've installed psql but using \list only lists three databases; postgres, template0 and template1. No teslamate to be seen anywhere.

Using sudo -u teslamate psql as the username (as per the install) also fails; unknown user.

Doesn't seem like I can even create a database either...

 

[DaveW]

If you go back a few posts/pages on here you can get to the TeslaMate database via command line by following the steps to insert the supercharger / destination charger geofences

 

[Russinating]

If you go back a few posts/pages on here you can get to the TeslaMate database via command line by following the steps to insert the supercharger / destination charger geofences

Boom, thanks. Lack of understanding of how docker works I think.

 

[3xcalibur]

Does anyone know if it's possible (and if so, how) to add a sort of dummy data in the databases?
I have installed TeslaMate on my Raspberry Pi (and PiVPN so I can connect to it from everywhere via VPN) but I don't have my Tesla yet.I would like to play around with the Grafana dashboards to make them more ideal for me or to add some.
But right now, almost every dashboard created out of the box, gjve me some errors. I assume because the databases are empty

 

[DaveW]

Turns out the ‘Free Supercharging’ button doesn’t 0 out the cost, so must only do something if your car actually has free for life supercharging rather than just free miles.

Supercharged today and found that out

 

[Roy W.]

Turns out the ‘Free Supercharging’ button doesn’t 0 out the cost, so must only do something if your car actually has free for life supercharging rather than just free miles.

Supercharged today and found that out

How strange! I wonder what it's supposed to do?

 

[DaveW]

How strange! I wonder what it's supposed to do?

Absolutely no idea!

On the plus side, the bulk update worked, the destination shows up properly

 

[Russinating]

Does anyone know if it's possible (and if so, how) to add a sort of dummy data in the databases?
I have installed TeslaMate on my Raspberry Pi (and PiVPN so I can connect to it from everywhere via VPN) but I don't have my Tesla yet.I would like to play around with the Grafana dashboards to make them more ideal for me or to add some.
But right now, almost every dashboard created out of the box, gjve me some errors. I assume because the databases are empty

Not really unless someone gives you their export. The data for drives etc produces a new db row every 15s or whatever the stream outputs so there's a LOT of data to dummy.

 

[BMW740iL]

Pretty much as @bhanorthy has said, it's so you know where you've charged and how much it cost (if there's a cost associated)

For how much it cost, this list just returns zero. Should I edit this to say 25 cents for SuC and 36 cents for non-SuC? That is what I approximately pay for charging

 

[DaveW]

For how much it cost, this list just returns zero. Should I edit this to say 25 cents for SuC and 36 cents for non-SuC? That is what I approximately pay for charging

What Superchargers did you want to import @BMW740iL - I could try and do an export for a certain country if you want and put in 0.25 for them

 

[BMW740iL]

What Superchargers did you want to import @BMW740iL - I could try and do an export for a certain country if you want and put in 0.25 for them

Can you add the average cost per kWh per country as published by Tesla?

Netherlands €0.25
Germany €0.33
France €0.24
UK £0.24
IRL €0.29
ITA €0.30

Supercharging

 

[DaveW]

I can add those values in, but it’s not in a certain currency. So the values are just 0.25 or whatever they are as per the above.

Suggest it’d be better do just add prices in for the countries in Euros and add in the individual costs per charging sessions when you visit the UK?

 

[BMW740iL]

I can add those values in, but it’s not in a certain currency. So the values are just 0.25 or whatever they are as per the above.

Suggest it’d be better do just add prices in for the countries in Euros and add in the individual costs per charging sessions when you visit the UK?

Yes, that is the best solution

 

[DaveW]

Created them for you @BMW740iL

Dropbox - Superchargers for TeslaMate - Simplify your life

Made them individual files, haven't done UK as you've already got these in the thread above. I've also stuck this link in the guide on my site (TeslaMate - How to bulk import UK Supercharger locations - TeslaEV.co.uk) where I've copied in the Australia ones I did for someone on Facebook.

 

[BMW740iL]

Thanks, inserting then was easy. My geofence list is now huge I added a single quote in front of my own geofences to make them appear at the top of the list

 

[DaveW]

Cool, glad to help

I've made a google sheet to import them from OpenChargeMap, there are probably easier ways of doing it if you're skilled enough with API's etc..

 

[Russinating]

Requested that negative charge costs are allowed: Allow negative charge costs · Issue #743 · adriankumpf/teslamate

Please comment or upvote/whatever you can do on github, and hopefully it's an easy change that's simply for human input validation and not something that breaks the database/code calculations.

 

[Durzel]

Not ideal, but you could update the table yourself if you wanted to:

teslamate=# \d charging_processes
                                             Table "public.charging_processes"
        Column        |            Type             | Collation | Nullable |                    Default
----------------------+-----------------------------+-----------+----------+------------------------------------------------
 id                   | integer                     |           | not null | nextval('charging_processes_id_seq'::regclass)
 start_date           | timestamp without time zone |           |          |
 end_date             | timestamp without time zone |           |          |
 charge_energy_added  | numeric(8,2)                |           |          |
 start_ideal_range_km | numeric(6,2)                |           |          |
 end_ideal_range_km   | numeric(6,2)                |           |          |
 start_battery_level  | smallint                    |           |          |
 end_battery_level    | smallint                    |           |          |
 duration_min         | smallint                    |           |          |
 outside_temp_avg     | numeric(4,1)                |           |          |
 car_id               | smallint                    |           | not null |
 position_id          | integer                     |           | not null |
 address_id           | integer                     |           |          |
 start_rated_range_km | numeric(6,2)                |           |          |
 end_rated_range_km   | numeric(6,2)                |           |          |
 geofence_id          | integer                     |           |          |
 charge_energy_used   | numeric(8,2)                |           |          |
 cost                 | numeric(6,2)                |           |          |

The field accepts a negative value. I presume TeslaMate converts the kWh dropdown to the total cost before sticking it in this field.

Contemplating writing a trigger or some sort of process to periodically update this value by pulling in the API rates at the time, since a charge can go over several 30 minute blocks with different £/kWh

 

[Russinating]

Yeah, just did exactly that. Set the cost to 666 through Teslamate and updated it via psql. I'm sure there's a better way just didn't want to screw up the db .

UPDATE charging_processes SET cost = -0.38 WHERE cost = 666.00;

All the Grafana panels, graphs and calcs etc seem to be fine and correct.

 

[DaveW]

Might be of interest to some of you, if you wanted to see max bhp as well as max kw

I've added the following line in under power_max, in the drives dashboard

concat(TRUNC(power_max * 1.34102,0), ' bhp') as "Max bhp",

You then have to save it as a new dash sadly, but still interesting