All posts
Data Platform

What a DynamoDB Scan Costs: The Dashboard That Refreshes Every Five Minutes

By

November 4, 2026

5 min read

A Scan of a million 327-byte orders reads about 40,000 request units, half a cent. Run it every five minutes for a dashboard and it is $43 a month; at 100 million orders, $4,337. The arithmetic from measured item sizes, and the four alternatives: Stream-fed aggregates, exports to S3 with Athena, zero-ETL to an analytics store, or Postgres.

DynamoDB
Cost Optimization
Analytics
1 million orders$43.3710 million orders$434100 million orders$4,3371 billion orders$43,370

Monthly read cost of one dashboard query that Scans the table every five minutes (8,640 runs a month). From our measurement of 0.0402 read units per 327-byte item scanned, eventually consistent, $0.125 per million. Log scale.

The data
Per month
1 million orders$43.37
10 million orders$434
100 million orders$4,337
1 billion orders$43,370

The bill isn't the only cost. A Scan reads 1 MB per page, so a million of these items is about 315 sequential requests unless you split it into parallel segments, and it uses throughput your users' requests also need. Every additional dashboard tile that scans multiplies all of it.

Alternatives

Approach

How it works

Good when

Watch for

Stream-fed aggregates

DynamoDB Streams triggers a Lambda that updates running totals in a small item

A few fixed numbers on a dashboard

One hot aggregate item takes every write: 1,000 writes a second per key at most, so shard busy counters

Export to S3 and Athena

Point-in-time export to S3, queried with SQL

Daily or hourly reports, ad-hoc analysis

Freshness is as good as the export schedule

Zero-ETL to an analytics store

Managed replication into Redshift or OpenSearch

Near-real-time analytics without your own pipeline

A second system to pay for and secure

Postgres for this data

GROUP BY on an indexed table

The data is relational and the questions keep changing

A migration

Is a dashboard scanning your table?

We'll find the scans in your bill and CloudWatch metrics and tell you which alternative fits. Free, 30 minutes.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of November 4, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.