Simple Log Service:Use the new Cost Manager

Basic syntax

Cost Manager exposes billing data as an external Logstore table. All queries must target this external table.

• The search statement before the pipe character (|) must be an asterisk (*).

• The external table name is instance_bill. Add all query conditions to the WHERE clause.

* | select xxx from instance_bill where xxx group by xxx limit xxx

For example, query daily SLS costs:

* |
select
  date_trunc('day', __time__) as day,
  sum(PretaxAmount) as cost
FROM  instance_bill
where
  productcode = 'sls'
group by
  day

Example 1: Aggregation query

To get the total cost for SLS:

• Query and analysis statement

  * |
  select
    sum(PretaxAmount) as cost
  FROM  instance_bill
  where
    productcode = 'sls'

• Query and analysis result

Example 2: Group query

To query costs by service:

• Query and analysis statement

  * |
  select
    productcode,
    sum(PretaxAmount) as cost
  FROM  instance_bill
  group by
    productcode

• Query and analysis result

Example 3: Time-based comparison

To compare costs month-over-month:

• Query and analysis statement

  * |
  SELECT
    diff [1] AS "Current month cost",
    diff [2] AS "Previous month cost",
    diff [3] * 100 -100 as "Increase (%)"
  FROM (
      SELECT
        compare(amount, 2592000) as diff
      FROM (
          SELECT
            sum(PretaxAmount) AS amount
          FROM instance_bill
        )
    )

• Query and analysis result

Example 4: Billable item analysis

To query the cost and usage of each billable item in SLS:

• Query and analysis statement

  * |
  SELECT
    BillingItem,
    sum(PretaxAmount) AS "Cost",
    sum(Usage) as "Usage"
  FROM  instance_bill
  where
    productcode = 'sls'
  GROUP by
    BillingItem

• Query and analysis result

Example 5: Daily usage trend analysis

To analyze the daily usage trend of billable items:

• Query and analysis statement

  * |
  SELECT
  	date_trunc('day', __time__) as t,
    BillingItem,
    sum(PretaxAmount) AS "Cost",
    sum(Usage) as "Usage"
  FROM  instance_bill
  where
    productcode = 'sls'
  GROUP by
    BillingItem,
    t
  ORDER by
    t

• Query and analysis result

  

Example 6: Instance analysis

To query the cost for each SLS instance:

• Query and analysis statement

  * |
  SELECT
    InstanceID,
    sum(PretaxAmount) AS "Cost"
  FROM  instance_bill
  where
    productcode = 'sls'
  GROUP by
    InstanceID

• Query and analysis result

Example 7: Daily instance cost analysis

To analyze the daily cost trend of each SLS instance:

• Query and analysis statement

  * |
  SELECT
    date_trunc('day', __time__) as t,
    InstanceID,
    sum(PretaxAmount) AS "Cost"
  FROM  instance_bill
  where
    productcode = 'sls'
  GROUP by
    InstanceID,
    t
  ORDER by
    t

• Query and analysis result

  

Example 8: External table joins

To join billing data with a custom external table:

This example joins instance_bill with a custom external table instance_name_table that maps instance IDs to names.

• Query and analysis statement

  * | with t1 as (
    select
      InstanceID,
      sum(PretaxAmount) as PretaxAmount
    FROM    instance_bill
  ),
  t2 as (
    select
      InstanceID,
      InstanceName
    FROM    instance_name_table
  )
  select
    t1.InstanceID,
    t1.PretaxAmount,
    t2.InstanceName
  FROM  t1
    left join t2 on t1.InstanceID = t2.InstanceID