GBASE 8s 逻辑日志使用查询

您可以从 SMI 获取此信息，如下所示：

 SELECT  uniqid, (used/size*100)

        FROM    sysmaster:syslogs

        WHERE   uniqid >=       (

                                SELECT  MIN(tx_loguniq)

                                FROM    sysmaster:systrans

                                WHERE   tx_loguniq > 0

                                )

        UNION

        SELECT  uniqid, 0.00

        FROM    sysmaster:syslogs

        WHERE   uniqid <        (

                                SELECT  MIN(tx_loguniq)

                                FROM    sysmaster:systrans

                                WHERE   tx_loguniq > 0

                                )