Hi!
I am using the multi dimension plugin for querying postgres-Layers.
Unfortunately the queries care not unsing the Indizes on my PostGIS-Table.
This is an example:
SELECT
"object_tracking_uid","object_class","classification",encode(ST_AsBinary("shape"),
'base64') as "shape FROM trackingtable WHERE ('2020-08-03 13:40:35.419' >=
"log_time" AND "log_time" IS NOT NULL AND '2020-08-03 13:40:35.419' <=
"log_time_end" AND "log_time_end" IS NOT NULL AND "shape" &&
ST_GeomFromText('POLYGON ((16.35019227862358 48.19559302106291,
16.35019227862358 48.19743098341618, 16.35538771748543 48.19743098341618,
16.35538771748543 48.19559302106291, 16.35019227862358
48.19559302106291))', 4326)
When editing a layer, you can deactivate the "End Attribute" for the "Time"
component under "Dimensions". This improves the performance of the "Time
Range" queries of the timeline - the geoserver then builds the time clause
with BETWEEN: WHERE log_time BETWEEN <start-time> AND <end-time>
Does anyone of know if this is a known bug and if there is a workaround for
this problem? I thought about building a SQL function and integrating into
geoserver as an sql-view:
https://docs.geoserver.org/latest/en/user/data/database/sqlview.html
Thanks and all the best,
Michael
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
