Skip to main content

Amazon RDS for PostgreSQL

pocketPG works with RDS PostgreSQL instances out of the box. Auto-detected from *.rds.amazonaws.com hostnames.

What works​

  • All core monitoring tabs (Health, Queries, Indexes, Bloat, Activity, Connections, WAL)
  • ALTER SYSTEM SET for tuning recommendations (unlike Aiven, RDS allows this)
  • VACUUM / ANALYZE / REINDEX maintenance actions
  • pg_stat_statements (pre-installed on most RDS instances)

Cloud metrics​

Cloud metrics integration (CPU, memory, IOPS from CloudWatch) is architecturally ready but not yet implemented. pocketPG falls back to SQL-based monitoring which covers most operational needs.

Considerations​

  • Parameter group changes — some parameters require a reboot to take effect. pocketPG marks these with a "RESTART" badge.
  • Managed-provider checkpoint caveat — RDS internal operations can trigger requested checkpoints. The Health tab notes this.
  • pg_stat_statements — enabled by default on most RDS instances via the shared_preload_libraries parameter group setting.