首页 > 其他分享 >lightdb生成pwr快照

lightdb生成pwr快照

时间:2022-08-20 22:00:22浏览次数:76  
标签:00 pwr lightdb 19 08 2022 快照

[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,如下:

 

标签:00,pwr,lightdb,19,08,2022,快照
From: https://www.cnblogs.com/zhjh256/p/16608724.html

相关文章

  • lightdb create table/index指定表空间
    一般来说,现在为了各司其职,都把硬盘做成了san,raid,至少lvm。但是仍然有一些用户希望可以指定表空间和索引。在lightdb里面也支持该特性。如下:lightdb@postgres=#createta......