Contains entity definitions for PostgreSQL database entities stored in Smartscape on Grail. All PostgreSQL entity types are prefixed with DB_* and end in _POSTGRES.
Smartscape node name: db.database.name
Smartscape node type: DB_DATABASE_POSTGRES
A PostgreSQL database entity.
Fetch all PostgreSQL database entities.
smartscapeNodes DB_DATABASE_POSTGRES
Get databases and corresponding instances.
smartscapeEdges "runs_on"| filter matchesValue(source_type, "DB_DATABASE_POSTGRES") and matchesValue(target_type, "DB_INSTANCE_POSTGRES")| fields database_name=getNodeName(source_id), instance_name=getNodeName(target_id)
The ID is calculated based on the following fields in the defined order: db.connection_details.hostname, db.connection_details.port, db.database.name
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs. |
|
| string | deprecatedThe entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_DATABASE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST. |
Smartscape node name: db.instance.name
Smartscape node type: DB_INSTANCE_POSTGRES
A PostgreSQL instance entity. Represents a physical server on which multiple databases can run.
Fetch all PostgreSQL instance entities.
smartscapeNodes DB_INSTANCE_POSTGRES
Count instances by their version.
smartscapeNodes DB_INSTANCE_POSTGRES| summarize count(), by: { db.instance.version }
The ID is calculated based on the following fields in the defined order: db.connection_details.hostname, db.connection_details.port
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs. |
|
| string | deprecatedThe entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_INSTANCE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database instance. |
|
| string | experimentalVersion of the database instance as reported by the database vendor. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST. |
|
| static | experimentalDefines an equivalence relationship. Examples: A database instance is the same as a host process. |