postgis
Spatial data and geometry/geography column statistics:
Table of Contents
- pgexporter_postgis_coordinate_dimensions_column_count
- pgexporter_postgis_coordinate_dimensions_coord_dimension
- pgexporter_postgis_geography_columns_detail_coord_dimension
- pgexporter_postgis_geometry_columns_detail_coord_dimension
- pgexporter_postgis_geometry_type_stats_column_count
- pgexporter_postgis_schema_spatial_stats_geometry_columns
- pgexporter_postgis_schema_spatial_stats_spatial_tables
- pgexporter_postgis_schema_spatial_stats_unique_srids
- pgexporter_postgis_spatial_index_summary_geography_indexes
- pgexporter_postgis_spatial_index_summary_geometry_indexes
- pgexporter_postgis_spatial_index_summary_total_spatial_indexes
- pgexporter_postgis_spatial_tables_geography_tables
- pgexporter_postgis_spatial_tables_geometry_tables
- pgexporter_postgis_spatial_tables_srid_count
- pgexporter_postgis_srid_usage_usage_count
pgexporter_postgis_spatial_tables_geometry_tables
The total number of tables in the database that have at least one column of the geometry type.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
pgexporter_postgis_spatial_tables_geography_tables
The total number of tables in the database that have at least one column of the geography type.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
pgexporter_postgis_spatial_tables_srid_count
The total count of Spatial Reference System Identifiers (SRIDs) defined in the spatial_ref_sys table.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
pgexporter_postgis_srid_usage_usage_count
Usage count for each Spatial Reference System ID across all spatial data.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| srid | Spatial Reference System Identifier. |
pgexporter_postgis_geometry_columns_detail_coord_dimension
Coordinate dimension for geometry columns in PostGIS.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| table_schema | Schema containing the geometry column. |
| table_name | Table containing the geometry column. |
| column_name | Name of the geometry column. |
pgexporter_postgis_geography_columns_detail_coord_dimension
Coordinate dimension for geography columns in PostGIS.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| table_schema | Schema containing the geography column. |
| table_name | Table containing the geography column. |
| column_name | Name of the geography column. |
pgexporter_postgis_spatial_index_summary_total_spatial_indexes
The total number of GIST spatial indexes found in the database.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
pgexporter_postgis_spatial_index_summary_geometry_indexes
Total number of spatial indexes on geometry columns.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
pgexporter_postgis_spatial_index_summary_geography_indexes
Total number of spatial indexes on geography columns.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
pgexporter_postgis_geometry_type_stats_column_count
Number of geometry columns grouped by geometry type.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| geometry_type | Type of geometry (Point, LineString, Polygon, etc.). |
pgexporter_postgis_coordinate_dimensions_coord_dimension
The coordinate dimension value for PostGIS geometry/geography columns.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| coord_dimension | Coordinate dimension count. |
pgexporter_postgis_coordinate_dimensions_column_count
Number of geometry/geography columns with specific coordinate dimensions.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| coord_dimension | Coordinate dimension count. |
pgexporter_postgis_schema_spatial_stats_geometry_columns
Number of geometry columns in each schema.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| table_schema | Schema containing spatial data. |
pgexporter_postgis_schema_spatial_stats_spatial_tables
Number of tables containing spatial data in each schema.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| table_schema | Schema containing spatial data. |
pgexporter_postgis_schema_spatial_stats_unique_srids
Number of unique Spatial Reference System IDs used in each schema.
| Attribute | Description |
|---|---|
| server | The configured name/identifier for the PostgreSQL server. |
| database | Database being monitored. |
| table_schema | Schema containing spatial data. |