Multi-week EC2 Cost Report

The Multi-week Elastic Compute Cloud (EC2) Cost report is a multi-dimensional report that provides several views that uniquely display the cost of each (or the sum) of your EC2 instances over a selected time period (ranging from the last day to the previous month). With this report, you can easily identify instances that are costing you the most and compare that against utilization, type of instance, other elements, or other tags. You will also be able to identify how much each different state of instance (e.g., Reserved, On-Demand) is costing you. The report is updated every day (depending on the lag from AWS publishing your cost data to S3). There is no estimated cost version of the Multi-week EC2 Cost Report.

The billing data AWS produce can have hundreds of different line item types. This report aggregates, simplifies, and reduces the data to the following high level categories:

Cost Description
Reserved Instance Hourly fees for partial upfront or no-upfront reserved instances.
On-Demand Instance Hourly fee for an on-demand instance.
Dedicated Instance Hourly fee for a dedicated instance.
Spot Instance Hourly fee for a spot instance.
EBS EBS costs directly linked to an EC2 instance. Includes fees for storage capacity, IOPS capacity and I/O requests (where applicable)
Data Transfer Comprises the following Data Transfer cost types:

  • Data In / Out – Interzone: Costs for data transfer to/from another AWS service in another availability zone or peered VPC in the same region.
  • Data In / Out – Interregion: Costs for data transfer to/from another AWS service in another region.
  • Data In / Out – PublicIP: Costs for data transfer to/from another AWS service via a public or elastic IP address.
  • Data In / Out – Internet: Costs for data transfer to/from the EC2 from/to the internet.
  • Data In / Out – CloudFront: Costs for data transfer to/from the EC2 via CloudFront.
  • Other: Other data transfer costs (e.g., Direct Connect).
Other Includes other incremental costs such as EBS optimized fees and public or elastic IPv4 addresses.

EC2 Cost Report Usage

For more information on Amazon’s EC2 Pricing structure, go here.

Refer to the image above when reading the following:

  1. Filters: Contains several filters where you can search for element names, element types, tags, attributes, collectors, and more. Expand the More filter to see additional filters; select a filter to add it to the list of active filters.
  2. View Options: Select a Report View to change the type of graph displayed. The other options in this section vary by Report View.
  3. Summary Table: Summary of all the data displayed in the graph above. Click Download to download the summary information to share with others who don’t have access to Metricly.
    Click a column header to sort the table; the graph will update to reflect your sort order.
  4. Graph: The graph varies depending on the Report View you have selected. Below the graph is the legend.
    Click any of the legend items to show / hide them on the graph. In addition to updating the graph, the items will also be toggled in the table and the cost total above the graph will also update.
  5. Totals: Your total cost for the selected time period. If you’ve filtered the EC2s using the Filters panel then these values will reduce accordingly.
  6. Time Frame: Because EC2 Costs are collected every day, you have several time periods available to you, all of which have varying Report View options. Note that Grouped by ElementGrouped by TagGrouped by Attribute and Cost vs. Utilization Scatter views are available for all periods.

    Options

    • Latest day (ending MM/DD/YYYY): the latest full day of data recorded and sent from AWS.
    • Latest month (to MM/DD/YYYY): the current month-to-date of data collected by AWS. Additional Report Views available:
      • Grouped by Day
      • Grouped by Week
      • Cumulative Daily Run rate
    • Previous Month (YYYY-MM): the previous full month of data collected by AWS. Additional Report Views available:
      • Grouped by Day
      • Grouped by Week
      • Grouped by Month
    • Latest 7 days (ending MM/DD/YYYY): the latest seven full days of data collected by AWS. Additional Report Views available:
      • Grouped by Day
    • Latest 30 days: the latest 30 full days of data collected by AWS. Additional Report Views available:
      • Grouped by Day
      • Grouped by Week
      • Grouped by Month

Report Views

Below is an overview of each type of Report View. Expand the section to view detailed information.

You can click and drag across a section of the graph to zoom in.

Grouped By Element

This graph breaks down how much each element is costing by category. The utilization of each element is plotted against the right-hand axis. With this view, you can compare the relative cost of elements versus their level of utilization.

Where you have EC2 elements without a Metricly agent / Windows agent installed, two utilization measures are available: Active Hours and CPU Utilization %. For elements with a Metricly agent installed, the following additional utilization metrics are available: Memory Utilization %Disk I/O %, and Disk Space Used %. For elements with a Windows agent installed, the Network I/O % metric will be available. If you have a mix of elements with and without a Metricly agent, you will see gaps in the utilization figures where values are not available.

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the total cost and the cost breakdown.

View Options

  • Elements with the Same Name: Choose if elements with the same name are grouped on the graph or treated separately.
    • Grouped
    • Separate
  • Show: Choose how many elements you want displayed on the graph.
    • 20 elements
    • 50 elements
    • 100 elements
    • 200 elements
    • All elements
  • Having: Create data filters. Select the desired operation (<, >, ≤, ≥, =) next to a filter type and then type a numerical value. The graph will automatically filter. Clear the value to remove the data filter. The data filters available will depend on the cost categories for your environment.
  • Utilization Metric: Choose which utilization metric is displayed on the graph. The options shown here will depend on which Metricly agents (if any) are installed on your EC2s:
    • Active Hours (available for all EC2s)
    • CPU Utilization % (available for all EC2s)
    • Memory Utilization % (available for EC2s with the Metricly Linux / Windows agent installed)
    • Disk I/O % (available for EC2s with the Metricly Linux / Windows agent installed)
    • Disk Space Used % (available for EC2s with the Metricly Linux / Windows agent installed)
    • Network I/O % (available for EC2s with the Metricly Windows agent installed)
  • Metric Statistic: Choose which statistic for the metric you selected is displayed on the graph.
    • Mean
    • Maximum
    • 95th Percentile
    • 75th Percentile
    • Median
    • 25th Percentile
    • 5th Percentile
    • Minimum

Grouped By Day

This graph breaks down how much cost you incurred each day during the selected compatible time period. The active hours of the EC2s in your environment is plotted against the right-hand axis. With this view, you can compare the cost per day versus the active hours.

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the total cost and the cost breakdown.

View Options

None.

Grouped By Week

This graph breaks down how much cost you incurred each week during the selected compatible time period. The active hours of the EC2s in your environment is plotted against the right-hand axis. With this view, you can compare the cost per week versus the active hours.

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the total cost and the cost breakdown.

View Options

None.

Grouped By Month

This graph breaks down how much cost you incurred each month during the selected compatible time period. The active hours of the EC2s in your environment is plotted against the right-hand axis. With this view, you can compare the cost per month versus the active hours.

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the total cost and the cost breakdown.

View Options

None.

Cumulative Daily Run rate

This graph lets you see how much cumulative cost was incurred each day in the current month-to-date. A trend line shows the estimated projected total cost at the end of the month compared with the grand total for the preceding period (i.e. if the current month has 28 days then the total line is for the preceding 28 days.)

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the total cost and the cost breakdown.

View Options

None.

Grouped by Tag

This graph lets you group the costs by any custom tag. To use this view you need to have tags on your EC2 elements. These can be source tags (set in AWS) or tags you have created in Metricly. For example, if combinations of your EC2s represent different applications you could create a tag called “application” in each EC2 and set the value accordingly. In this view, you could select the “application” tag to aggregate the costs according to the grouping you have specified. Other examples could include grouping by department or by environment.

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the instance type, total cost, and the cost breakdown.

View Options

  • Group Tag: Choose which custom tag to use to group the costs.
  • Show: Choose how many elements you want displayed on the graph.
    • 20 elements
    • 50 elements
    • 100 elements
    • 200 elements
    • All elements
  • Having: Create data filters. Select the desired operation (<, >, ≤, ≥, =) next to a filter type and then type a numerical value. The graph will automatically filter. Clear the value to remove the data filter. The data filters available will depend on the cost categories for your environment.

Grouped by Attribute

This graph lets you group the costs by any attribute. For example, if you chose to group by Availability Zone, you could see how much each zone costs per selected time period.

You can zoom into the chart by clicking and dragging your mouse across a set of elements. If you hover the mouse over a bar, you will see a tooltip showing the instance type, total cost, and the cost breakdown.

View Options

  • Group Attribute: Choose which attribute to use to group the costs.
    • accountId
    • instanceType
    • availabilityZone
  • Show: Choose how many elements you want displayed on the graph.
    • 20 elements
    • 50 elements
    • 100 elements
    • 200 elements
    • All elements
  • Having: Create data filters. Select the desired operation (<, >, ≤, ≥, =) next to a filter type and then type a numerical value. The graph will automatically filter. Clear the value to remove the data filter. The data filters available will depend on the cost categories for your environment.

Cost vs. Utilization Scatter

This graph displays a scatter plot of the cost versus utilization for your EC2 instances. Hover over a point on the graph to view the instance name, utilization, instance type, tag, and cost. You can zoom into an area of the chart by clicking and dragging the mouse.

This view lets you compare the relative cost and utilization of your instances amongst their peers: elements to the bottom-right have relatively high utilization and lower cost compared with elements in the top-left corner which have lower utilization and higher costs. Elements are given different markers based on their tag. To use this view you need to have tags on your EC2 elements; these can be source tags (set in AWS) or tags you have created in Metricly.

If combinations of your EC2s represent different applications you could create a tag called “application” in each EC2 and set the value accordingly. In this view, you could select the “application” tag to mark the elements according to the grouping you have specified. This is useful for identifying outliers where you expect elements of the same tag to have similar cost/utilization positions on the chart.

View Options

  • Group Tag: Choose which custom tag to use to group elements with different markers
  • Elements with the Same Name: Choose if elements with the same name are grouped on the graph or treated separately.
    • Grouped
    • Separate
  • Show: Choose how many elements you want displayed on the graph.
    • 20 elements
    • 50 elements
    • 100 elements
    • 200 elements
    • All elements
  • Having: Create data filters. Select the desired operation (<, >, ≤, ≥, =) next to a filter type and then type a numerical value. The graph will automatically filter. Clear the value to remove the data filter. The data filters available will depend on the cost categories for your environment.
  • Utilization Metric: Choose which utilization metric is displayed on the graph. The options shown here will depend on which Metricly agents (if any) are installed on your EC2s:
    • Active Hours (available for all EC2s)
    • CPU Utilization % (available for all EC2s)
    • Memory Utilization % (available for EC2s with the Metricly Linux / Windows agent installed)
    • Disk I/O % (available for EC2s with the Metricly Linux / Windows agent installed)
    • Disk Space Used % (available for EC2s with the Metricly Linux / Windows agent installed)
    • Network I/O % (available for EC2s with the Metricly Windows agent installed)
  • Metric Statistic: Choose which statistic for the metric you selected is displayed on the graph.
    • Mean
    • Maximum
    • 95th Percentile
    • 75th Percentile
    • Median
    • 25th Percentile
    • 5th Percentile
    • Minimum