RDS: ReadIOPS spike due to activity in rdsadmin database

0

Last week I've noticed a sudden spike in the ReadIOPS activity across all our RDS instances. It happened in two batches, actually, but it affected all of them: Enter image description here

Digging into this with the Performance Insights monitoring panel I can tell these spikes correlate with activity on a database called rdsadmin that seems to be present on every RDS instance: Enter image description here

And if I look at the SQL section I see this query being executed at the moment:

SELECT DATNAME,
	LARGEST_DB_BYTES,
	ALL_DB_BYTES,
	OLDEST_XACT_SEC,
	OLDEST_XACT_XID
FROM (
SELECT DATNAME,
	DATALLOWCONN,
	CONNECTIONS,
	BYTES,
	MAX(BYTES) OVER () LARGEST_DB_BYTES,
	SUM(BYTES) OVER () ALL_DB_BYTES,
	MAX(SEC) OVER () OLDEST_XACT_SEC,
	MAX(XID) OVER () OLDEST_XACT_XID
FROM (
SELECT D.DATNAME,
	D.DATALLOWCONN,
	PG_CATALOG.PG_DATABASE_SIZE(D.OID) BYTES,
	SUBQ_DB_BY_ACTIVITY.CONNECTIONS,
	SUBQ_DB_BY_ACTIVITY.SEC,
	SUBQ_DB_BY_ACTIVITY.XID
FROM (
SELECT A.DATID,
	COUNT(*) CONNECTIONS,
	MAX(EXTRACT(EPO...

Does someone know what this query is about and why it triggers across every RDS instance? Does it depend on activity on other databases or is it a RDS scheduled maintenance task? If so, is there a way we can anticipate/delay these spikes so they don't potentially affect our databases' performnace?

沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南