PostgreSQL Activity Stats - ScaleGrid DBaaS

Fully managed PostgreSQL hosting at ScaleGrid provides Activity Stats for your PostgreSQL cluster deployment. At a high-level, this gives you the important metrics you need to know about your PostgreSQL server.

Find your Activity Stats tab on your cluster details page so you can see the size of all your databases, size of your tables, how your indexes are doing, and the sizes of all of your indexes. It also gives you all of the bloat information, the number of dead rows in this table, if it needs to be compacted, etc.

Review an estimate of the bloat and index bloat, along with other parameters like which tables have the highest read throughput, and which tables have the highest activity in terms of selects, reads, and inserts.

As always, if you have any questions, please email us at [email protected].

PostgreSQL Activity Stats:
- Total Number of Tables
- Total Number of Indexes
- Size of Database on Disk
- Table Size
- Index Size
- Dead Rows
- Table Bloat Estimate
- Index Bloat Estimate
- Auto-Vacuum - Most Frequent
- Read Throughput
- Update Throughput
- Activity - Select
- Activity - Read Index
- Activity - Insert
- Activity - Update
- Cache Effectiveness
- Sequential Scans

ScaleGrid Managed Databases: https://scalegrid.io/
PostgreSQL Hosting: https://scalegrid.io/postgresql.html
PostgreSQL Enterprise On-Premises: https://scalegrid.io/platforms/enterprise-on-premise.html
ScaleGrid Pricing: https://scalegrid.io/pricing.html
Documentation: https://help.scalegrid.io/docs/postgresql-new-cluster
Free 30-Day Trial: https://console.scalegrid.io/users/register