At around 6pm on 09/12/2019, the RDS storage was automatically autoscaled upward to 30GB.
Around that time (perhaps just before), database sessions began stacking linearly. A REFRESH MATERIALIZED VIEW command is scheduled to run every 10 minutes. However, these piled up over a period of about 5 hours, until I manually rebooted the database.
As an attempt to avoid this in the future, I added:
SET SESSION lock_timeout = 3000;
just before the REFRESH MATERIALIZED VIEW CONCURRENTLY [...] command.
At around 6pm on 09/12/2019, the RDS storage was automatically autoscaled upward to 30GB.
Around that time (perhaps just before), database sessions began stacking linearly. A
REFRESH MATERIALIZED VIEWcommand is scheduled to run every 10 minutes. However, these piled up over a period of about 5 hours, until I manually rebooted the database.As an attempt to avoid this in the future, I added:
just before the
REFRESH MATERIALIZED VIEW CONCURRENTLY [...]command.