[lightdb@hs-10-20-30-199 ~]$ ltsql -p5432 ltsql (13.3-22.2) Type "help" for help. lightdb@postgres=# select show_samples(); show_samples ------------------------------------- (1,"2022-08-19 19:00:00+08",t,,,) (2,"2022-08-19 19:10:00+08",t,,,) (3,"2022-08-19 19:20:00+08",t,,,) (4,"2022-08-19 19:30:00+08",t,,,) (5,"2022-08-19 19:40:00+08",t,,,) (6,"2022-08-19 19:44:03+08",t,,,) (7,"2022-08-19 19:46:43+08",t,,,)
ltsql -Aqtc "SELECT get_pwr(480,482)" -o report_480_482.html
生成的快照类似Oracle awr,如下:
除了基本快照外,lightdb pwr也支持基线以及针对会话的psh分析,具体可参见http://www.light-pg.com/docs/lightdb/13.8-22.3/pgprofile.html。
lightdb-em集成了一体化的监控运维管理平台,具体可查看https://github.com/hslightdb/LightDB-training/wiki/LightDB%E7%94%A8%E6%88%B7%E6%89%8B%E5%86%8C或从www.hs.net/lightdb下载。