Caching Issues with PostgreSQL Database

Hey,
Im using postgres Db (on AWS RDS).
While Im changing records in the DB and query again on retool I don't see any changes (seems like there is some of cache that keeping the data. but it's taking long time (sometimes more than a day) to see the change (also in a new window it doesn't change the old result).

Is there any way to fix it\cllean the retool cache? I try to refresh the Schema and it doesn't work.

Thank! :slight_smile:

Hey @Dorc! Thanks for reaching out.

By default, Retool shouldn't cache the results of any query. There is an option in the query's Advanced settings, though, to enable caching.

The option to clear any existing cache is located in the ... dropdown menu! Alternatively, you can do the same in a JS script.

If the query in question doesn't actually have caching enabled, there might be something else going on. :thinking: Let me know what you see on your end and we can take it from there!