以下图片是在postgresql数据库中使用EXPLAIN (ANALYZE, FORMAT JSON)+查询语句得到的查询结果,输出了涉及的具体操作信息和时间代价,由于实验我需要这种输出信息,请问oceanbase能得到这样的查询信息吗
查询语句为
EXPLAIN (ANALYZE, FORMAT JSON)
SELECT MIN(mc.note) AS production_note,
MIN(t.title) AS movie_title,
MIN(t.production_year) AS movie_year
FROM company_type AS ct,
info_type AS it,
movie_companies AS mc,
movie_info_idx AS mi_idx,
title AS t
WHERE ct.kind = 'production companies'
AND it.info = 'top 250 rank'
AND mc.note NOT LIKE '%(as Metro-Goldwyn-Mayer Pictures)%'
AND (mc.note LIKE '%(co-production)%'
OR mc.note LIKE '%(presents)%')
AND ct.id = mc.company_type_id
AND t.id = mc.movie_id
AND t.id = mi_idx.movie_id
AND mc.movie_id = mi_idx.movie_id
AND it.id = mi_idx.info_type_id;