pgsql的explain关键字是在是，有个慢sql，需要优化，网上找的文章都不太靠谱啊

Question

select
event.traffic_event_id
from
traffic_event_pileloc plc
inner join
(
select
max(id) as id,
traffic_event_id
from traffic_event_history
group by traffic_event_id
) history
on history.id = plc.traffic_event_history_id
inner join traffic_event event on event.traffic_event_id = history.traffic_event_id
where
event.drc_event_report_time notnull

            and plc.number = '测试里程桩2'
        
    order by event.drc_event_report_time desc

其中涉及到的关联字段都是有索引的，
原来mysql的explain还能知道会给一些索引意见，pgsql这玩意完全看不懂的干活