1.执行命令查看数据库实例中SQL语句执行信息
\x
select * from dbe_perf.get_global_full_sql_by_timestamp('2024-04-07 20:00:00', '2024-04-08 11:00:00');
2.执行命令查看数据库实例中慢SQL语句执行信息
\x
select * from dbe_perf.get_global_slow_sql_by_timestamp('2024-04-07 20:00:00', '2024-04-08 11:00:00');
3.查看当前主节点SQL语句执行信息
select * from statement_history;
4.查看当前备节点SQL语句执行信息
--备节点执行。主节点执行会报错。
--select * from dbe_perf.standby_statement_history(is_only_slow, start_timestamp, end_timestamp);
--例如:
select * from dbe_perf.standby_statement_history(true, '2024-04-07 20:00:00', '2024-04-08 11:00:00');