set optimizer_trace="enabled=on";

explain select distinct country from aiport_geo order by country;

select query, TRACE->'$**.Rapid_Offload_Fails' 'Offload Failed',

           TRACE->'$**.secondary_engin_not_used' "HeatWave Not Used'

from information_schema.optimizer_trace\G;

 

 

'기타' 카테고리의 다른 글

type script  (0) 2020.11.30
Spring Cloud Netfix  (0) 2020.03.12
prometheus 모니터링  (0) 2020.02.02
ansible library 확장  (0) 2019.09.13
ansible 소스 설치  (0) 2019.09.12

+ Recent posts