Amazon Q and RDS Postgresql integration doesn't work

Question

Hello,

I'm currently developing a Proof of Concept utilizing Amazon Q chatbot and the RDS PostgreSQL connector. My data source is successfully set up, and I'm able to connect to my RDS instance and scan the rows. As illustrated in the attached screenshot, while 1003 rows were scanned, they are not being added to the index. Do you have any insights or suggestions on why this might be happening? If you need more specific information, please feel free to ask.

Thank you for your assistance.

Best regards,
Dorian

![Enter image description here](/media/postImages/original/IMFAgBT-L8RP6FuVaMN0O3Hw)

Answer

There are a few potential reasons why rows may not be getting indexed in your PostgreSQL database on RDS:

The indexes are not being created properly. Ensure the indexes exist and have been analyzed after loading data or making changes. You can check if indexes exist using 
SELECT * FROM pg_indexes
 and analyze them with 
ANALYZE
.

The autovacuum process is not removing expired index entries. Ensure autovacuum is enabled and running regularly to clean up indexes.

The table statistics are out of date. Running 
ANALYZE
 on the tables will update statistics and may cause PostgreSQL to use the indexes more efficiently.

The query plan is not using the indexes. Check the query plan using 
EXPLAIN
 and make sure indexes are being used if they could help. Indexes won't be used if the optimizer estimates a sequential scan is more efficient.

The indexes are corrupted or inconsistent. Rebuilding indexes with 
REINDEX
 may fix issues preventing them from being used.

Sources

[1] Amazon RDS for PostgreSQL updates - Amazon Relational Database Service - https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.html

[2] Amazon RDS (PostgreSQL) - Amazon Kendra - https://docs.aws.amazon.com/kendra/latest/dg/data-source-rds-postgresql.html

Amazon Q and RDS Postgresql integration doesn't work

Relevant content