bug on view
but if recap to 1 years not problem...
the log of postgresql is:
2021-05-24 22:26:16.321 UTC [49] ERROR: could not load library "/usr/lib/postgresql/13/lib/llvmjit.so": libLLVM-7.so.1: ELF load command alignment not page-aligned
2021-05-24 22:26:16.321 UTC [49] STATEMENT: SELECT
to_timestamp(floor((extract('epoch' FROM date) / 60)) * 60) AT TIME ZONE 'UTC' AS time,
avg(latitude) AS lat,
avg(longitude) AS lng
FROM
positions
WHERE
car_id = '1' AND
date BETWEEN '2020-05-24T22:26:17.426Z' AND '2021-05-24T22:26:17.426Z'
GROUP BY
1
ORDER BY
1 ASC
Environment
- TeslaMate version: 1.22
- Type of installation: Docker
- OS TeslaMate is installed on: qnap
- User OS & Browser: safari mac
- Others:
bug on view
but if recap to 1 years not problem...
the log of postgresql is:
2021-05-24 22:26:16.321 UTC [49] ERROR: could not load library "/usr/lib/postgresql/13/lib/llvmjit.so": libLLVM-7.so.1: ELF load command alignment not page-aligned
2021-05-24 22:26:16.321 UTC [49] STATEMENT: SELECT
to_timestamp(floor((extract('epoch' FROM date) / 60)) * 60) AT TIME ZONE 'UTC' AS time,
avg(latitude) AS lat,
avg(longitude) AS lng
FROM
positions
WHERE
car_id = '1' AND
date BETWEEN '2020-05-24T22:26:17.426Z' AND '2021-05-24T22:26:17.426Z'
GROUP BY
1
ORDER BY
1 ASC
Environment