Multiple log streams in CloudWatch - PostgreSQL RDS

Question

I've got logs publishing from an Amazon RDS Postgres instance to CloudWatch:

• Published logs
• CloudWatch Logs
• Postgresql

Going to CloudWatch Service, I see there are 4 different "streams" which contain similar data from the same time:

What's the difference between those 4? I've checked, and in all the files are statements like, UPDATE, SELECT etc. I'm not sure which one should I analyze.

Answer 1

Better late than never, but I was told from AWS support that in later versions of PostgreSQL in RDS they write to logs in parallel to increase performance.

I also navigated to the log the way you did, by going directly to CloudWatch, but apparently the correct way to access the log is to go to your RDS instance on AWS console, click on Configuration tab, and on the rightmost column there should be a clickable link (PostgreSQL in my case) under Published Logs/CloudWatch Logs section.

Clicking on that link should take you back to CloudWatch, but now all the log entries from the four parallel streams should now be in order.