search

pgspider / influxdb_fdw

InfluxDB Foreign Data Wrapper for PostgreSQL.
Other
58 stars 14 forks source link

Feature Request: `ORDER BY` pushdown #49

Open cobolbaby opened 8 months ago

cobolbaby commented 8 months ago 
explain verbose 
select * from dm.iot_sqt_agv_count 
order by time desc
limit 10
/*
"Limit  (cost=871.43..871.46 rows=10 width=72)"
"  Output: ""time"", ""agvState"", value"
"  ->  Sort  (cost=871.43..873.57 rows=853 width=72)"
"        Output: ""time"", ""agvState"", value"
"        Sort Key: iot_sqt_agv_count.""time"" DESC"
"        ->  Foreign Scan on dm.iot_sqt_agv_count  (cost=10.00..853.00 rows=853 width=72)"
"              Output: ""time"", ""agvState"", value"
"              InfluxDB query: SELECT * FROM ""F3AGV.count"""
*/
lamdn1409 commented 2 weeks ago

@cobolbaby

Sorry, we have no plan to support ORDER BY pushdown.