SELECT * FROM test where ST_Dwithin(ST_geomfromtext('POINT(100 28)')::GEOGRAPHY,location,1000)IS TRUE；
location是geography类型，为其添加的gist索引，但是查询不走索引
https://blog.csdn.net/xianyucishi/article/details/71309760?utm_source=blogxgwz4