SELECT * FROMdbe_perf.global_recovery_status
SELECTstatement_detail_decode(details, 'plaintext', true) FROMDBE_PERF.get_global_slow_sql_by_timestamp('start time','end time') WHEREunqiue_sql_id = xxx;
SELECT * FROM gs_asp WHEREsample_time > 'start_time' and sample_time < 'end_time' and query like 'xxx';
SELECT * FROM gs_asp WHEREsample_time > 'start_time' and sample_time < 'end_time' and query like'xxx' and sessionid = $block sessionid;
SELECT a.*,b.wait_status, b.wait_eventFROM pgxc_stat_activity as a left join pgxc_thread_wait_status as b on a.pid =b.tid and a.sessionid = b. sessionid and a.coorname = b.node_name andb.sessionid = $block_sessionid;
SELECT * FROMDBE_PERF.get_global_slow_sql_by_timestamp('start time','end time');
SELECT * FROMdynamic_func_control('GLOBAL', 'STMT', 'TRACK', '{"3182919165","L1"}'); -- 抓此SQL的FULLSQL L2 SELECT * FROM dynamic_func_control('GLOBAL', 'STMT', 'UNTRACK','{"3182919165"}'); -- 取消抓取 SELECT * FROM dynamic_func_control('GLOBAL', 'STMT', 'LIST', '{}'); SELECT * FROM dynamic_func_control('LOCAL', 'STMT', 'CLEAN', '{}');
SELECT * FROM pg_stat_all_tableswhere relname = 'xxx';
SELECT * FROMDBE_PERF.get_global_slow_sql_by_timestamp('start time','end time');
SELECT * FROMdynamic_func_control('GLOBAL', 'STMT', 'TRACK', '{"3182919165","L1"}'); -- 抓此SQL的FULLSQL L2 SELECT * FROM dynamic_func_control('GLOBAL', 'STMT', 'UNTRACK','{"3182919165"}'); -- 取消抓取 SELECT * FROM dynamic_func_control('GLOBAL', 'STMT', 'LIST', '{}'); SELECT * FROM dynamic_func_control('LOCAL', 'STMT', 'CLEAN', '{}');
如果您发现该资源为电子书等存在侵权的资源或对该资源描述不正确等,可点击“私信”按钮向作者进行反馈;如作者无回复可进行平台仲裁,我们会在第一时间进行处理!
加入交流群
请使用微信扫一扫!