PGSQL 执行计划检查

 EXPLAIN ANALYZE 

-- 加上 EXPLAIN ANALYZE 显示执行计划内容 (包含索引情况、执行时间等)
EXPLAIN ANALYZE 
SELECT provinceidname, cityidname, countyidname ,name ,address,longitude ,latitude 
FROM odp_accountbase oa 
WHERE
name  ~ '医院$'
AND StateCode =0
AND accountclassificationcode = 2
AND address is not null
--AND (address not like '%市' and address not like '%县' and address not like '%区' and address not like '%镇')
order by countyidname;

返回示例