0

From the dynamodb tables, I'm trying to get max sized item (top 3 with their ID) from the table. Is there a way that we can get the max sized item using scan or query. The table doesn't have any item size stored in a separate column

Improve this question

1 Answer 1

Reset to default
1

You can Scan the table, and run each item through an item calculator and keep a track of the largest items. If you use JS you can install this npm package:

https://www.npmjs.com/package/ddb-calc

You can easily build something in a different language if you do not use JS.

Another solution is to track the consumed WCU each time you insert or update an item, the larger the WCU consumed indicates the size of the item.

https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_PutItem.html#DDB-PutItem-request-ReturnConsumedCapacity

The same approach can be used for GetItem operations.

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

Thanks Leeroy, the problem with scan is that its money for each request.. so can't think how much is it going to cost for say billion records. I'm trying to see if I can get on to something that saves money...
Monitoring the item size as you read/write is free. Is this for w one time check or something you'll want to run frequently?
This is one timer but for multiple tables
If the tables are too large to Scan, then you can export the data to S3 and run your analysis there instead. But if they're less than a couple of 100GB then Scan is the best option.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.