lightdb生成pwr快照

[lightdb@db1 ~]$ 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下载。