Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Information related to autovacuum and schema level statistics of an Azure Database for PostgreSQL Flexible Servers.
Table attributes
| Attribute | Value |
|---|---|
| Resource types | microsoft.dbforpostgresql/flexibleservers |
| Categories | Audit, Azure Resources |
| Solutions | LogManagement |
| Basic log | No |
| Ingestion-time transformation | No |
| Sample Queries | - |
Columns
| Column | Type | Description |
|---|---|---|
| AnalyzeCount | long | Number of times tables have been manually analyzed in this schema. |
| AutoanalyzeCount | long | Number of times tables have been analyzed by the autovacuum daemon in this schema. |
| AutovacuumCount | long | Number of times tables have been vacuumed by the autovacuum daemon in this schema. |
| _BilledSize | real | The record size in bytes |
| DatabaseName | string | Name of the database the schema belongs to. |
| DeadRowsCount | long | Estimated number of dead rows of all tables in this schema. |
| IndexScansCount | long | Number of index scans initiated on all tables in this schema. |
| _IsBillable | string | Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account |
| LiveRowsCount | long | Estimated number of live rows of all tables in this schema. |
| Location | string | Location of Azure Database for PostgreSQL Flexible server. |
| LogicalServerName | string | Logical name of the instance. |
| ModificationsSinceAnalyzeCount | long | Estimated number of rows modified from all tables since last analyzed of each individual table in this schema. |
| ReplicaRole | string | Replica role example. Primary or secondary. |
| _ResourceId | string | A unique identifier for the resource that the record is associated with |
| RowsDeletedCount | long | Number of rows deleted from all tables in this schema. |
| RowsFromIndexScansCount | long | Number of live rows fetched by index scans on all tables in this schema. |
| RowsFromSeqentialScansCount | long | Number of live rows fetched by sequential scans on all tables in this schema. |
| RowsHotUpdatedCount | long | Number of rows HOT updated from all tables in this schema (i.e., with no separate index update required). |
| RowsInsertedCount | long | Number of rows inserted in all tables in this schema. |
| RowsUpdatedCount | long | Number of rows updated from all tables in this schema (includes HOT updated rows). |
| SchemaName | string | Name of the schema the statistics were collected from. |
| SeqentialScansCount | long | Number of sequential scans initiated on all tables in this schema. |
| SourceSystem | string | The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| TablesAnalyzedCount | long | Number of tables that were manually analyzed in this schema. |
| TablesAutoanalyzedCount | long | Number of tables that were analyzed by the autovacuum daemon in this schema. |
| TablesAutovacuumedCount | long | Number of tables that were vacuumed by the autovacuum daemon in this schema. |
| TablesCount | long | Number of tables in this schema. |
| TablesVacuumedCount | long | Number of tables that were manually vacuumed in this schema. |
| TenantId | string | The Log Analytics workspace ID |
| TimeGenerated | datetime | The timestamp (UTC) of when the log was generated. |
| Type | string | The name of the table |
| VacuumCount | long | Number of times tables have been manually vacuumed in this schema (not counting VACUUM FULL). |