Try it free

PostgreSQL

  • Latest Dynatrace
  • Reference
  • Published Jun 15, 2026

Contains entity definitions for PostgreSQL database entities stored in Smartscape on Grail. All PostgreSQL entity types are prefixed with DB_* and end in _POSTGRES.

PostgreSQL database

Smartscape node name: db.database.name

Smartscape node type: DB_DATABASE_POSTGRES

A PostgreSQL database entity.

Query

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)

ID input

The ID is calculated based on the following fields in the defined order: db.connection_details.hostname, db.connection_details.port, db.database.name

Base entity fields

The following base fields are used for all entities.

AttributeTypeDescriptionExamples
idsmartscapeIdstable
Display name: ID
A 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.
<type>-017198AD253CBD63
id_classicstringdeprecated
Display name: Classic ID
The 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 id field instead, which is the Smartscape ID.
<type>-017198AD253CBD63
namestringstable
Display name: Name
The entity name.
localhost; easyTravel; product-catalog
typestringstable
Display name: Type
The entity type. UPPER_SNAKE_CASE string that represents the type of the entity.
Tags: permission
TYPE_A
tagsrecordstable
Display name: Tags
A consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, release or name). The value of each nested field is the tag value from one or multiple contexts. Tags for specific context can be queried via tags:context field. Note that rule-based tags do not exist in the new model.
tags[tag_key-1] = [context_A_tag_val-1, context_B_tag_val-1]; tags[tag_key-2] = context_C_tag_val-1; tags:context_A[tag_key-1] = context_A_tag_val-1
lifetimetimeframestable
Display name: Lifetime
The lifetime of the entity. This is a record with two nested fields: start and end, which represent the time when the entity was first and last observed, respectively. Each time an entity is updated, the end time is updated to the current time.
{ start: 2022-07-06T13:36:00.808Z, end: 2024-04-11T06:56:01.204Z }
referencesrecordstable
Display name: References
Provides 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.
{ references[runs_on.host] : [HOST-C251A1173C2B4B39,HOST-0E9038C7C4409D69], references[runs_on.container] : [CONTAINER-68A08967EF4F675B] }
dt.security_contextstring[]resource stable
Display name: DT security context
The security contexts associated with the entity. For Smartscape entities, this field is always an array.
Tags: permission
[]

Database entity fields

Fields common to all entities within the databases model.

AttributeTypeDescriptionExamples
db.connection_details.ipipAddressexperimental
IP address of the listener to which Dynatrace is connected.
10.100.10.10
db.connection_details.hostnamestringexperimental
Hostname of the listener Dynatrace is connected to.
my-database-server.myorg.org
db.connection_details.portstringexperimental
Port of the listener Dynatrace is connected to.
5432
db.connection_detailsstringexperimental
Listener connection details in the form <hostname>:<port>/<database>.
my-database-server.myorg.org:5432/testdb
db.systemstringexperimental
Display name: Database system
An identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers.
mongodb; mysql

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.

ValueDescriptionDisplay name
adabasAdabas (Adaptable Database System)Adabas
amazon-documentdbAmazon DocumentDBDocumentDB
aurora-mysqlAmazon Aurora MySQLAurora MySQL
aurora-postgresqlAmazon Aurora PostgreSQLAurora PostgreSQL
cacheInterSystems CachéInterSystems Caché
cassandraApache CassandraCassandra
clickhouseClickHouseClickHouse
cloudscapeCloudscapeCloudscape
cockroachdbCockroachDBCockroachDB
coldfusionColdFusion IMQColdFusion IMQ
cosmosdbMicrosoft Azure Cosmos DBCosmos DB
couchbaseCouchbaseCouchbase
couchdbCouchDBCouchDB
databricksDatabricks Data PlatformDatabricks Data Platform
db2IBM Db2IBM Db2
derbyApache DerbyDerby
dl/iIBM DL/IIBM DL/I
dynamodbAmazon DynamoDBDynamoDB
edbEnterpriseDBEnterpriseDB
elasticsearchElasticsearchElasticsearch
filemakerFileMakerFileMaker
firebirdFirebirdFirebird
firstsqlFirstSQLFirstSQL
geodeApache GeodeGeode
h2H2H2
hanadbSAP HANASAP HANA
hbaseApache HBaseHBase
hiveApache HiveHive
hsqldbHyperSQL DataBaseHSQLDB
informixInformixInformix
ingresIngresIngres
instantdbInstantDBInstantDB
interbaseInterBaseInterBase
keyspaces-cassandraAmazon Keyspaces for Apache CassandraKeyspaces
mariadbMariaDBMariaDB
maxdbSAP MaxDBSAP MaxDB
memcachedMemcachedMemcached
mongodbMongoDBMongoDB
mssqlMicrosoft SQL ServerSQL Server
mssqlcompactMicrosoft SQL Server CompactSQL Server Compact
mysqlMySQLMySQL
neo4jNeo4jNeo4j
neptuneAmazon NeptuneNeptune
netezzaNetezzaNetezza
opensearchOpenSearchOpenSearch
oracleOracle DatabaseOracle
other_sqlSome other SQL database. Fallback only. See notes.Other SQL
pervasivePervasive PSQLPervasive PSQL
phoenixApache PhoenixApache Phoenix
pointbasePointBasePointBase
postgresqlPostgreSQLPostgreSQL
progressProgress DatabaseProgress
redisRedisRedis
redshiftAmazon RedshiftRedshift
snowflakeSnowflake Data PlatformSnowflake Data Platform
spannerCloud SpannerCloud Spanner
sqliteSQLiteSQLite
sybaseSybaseSybase
teradataTeradataTeradata
valkeyValkeyValkey
verticaVerticaVertica

Database fields

Fields that are common across all DB_DATABASE_* type nodes.

AttributeTypeDescriptionExamples
db.database.namestringexperimental
Name of the database.
testdb; PDB1

Relationships

PostgreSQL database relationships

TypeTarget typeKindDescription
runs_onDB_INSTANCE_POSTGRESstaticstable
Defines 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.

PostgreSQL instance

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.

Query

Fetch all PostgreSQL instance entities.

smartscapeNodes DB_INSTANCE_POSTGRES

Count instances by their version.

smartscapeNodes DB_INSTANCE_POSTGRES
| summarize count(), by: { db.instance.version }

ID input

The ID is calculated based on the following fields in the defined order: db.connection_details.hostname, db.connection_details.port

Base entity fields

The following base fields are used for all entities.

AttributeTypeDescriptionExamples
idsmartscapeIdstable
Display name: ID
A 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.
<type>-017198AD253CBD63
id_classicstringdeprecated
Display name: Classic ID
The 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 id field instead, which is the Smartscape ID.
<type>-017198AD253CBD63
namestringstable
Display name: Name
The entity name.
localhost; easyTravel; product-catalog
typestringstable
Display name: Type
The entity type. UPPER_SNAKE_CASE string that represents the type of the entity.
Tags: permission
TYPE_A
tagsrecordstable
Display name: Tags
A consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, release or name). The value of each nested field is the tag value from one or multiple contexts. Tags for specific context can be queried via tags:context field. Note that rule-based tags do not exist in the new model.
tags[tag_key-1] = [context_A_tag_val-1, context_B_tag_val-1]; tags[tag_key-2] = context_C_tag_val-1; tags:context_A[tag_key-1] = context_A_tag_val-1
lifetimetimeframestable
Display name: Lifetime
The lifetime of the entity. This is a record with two nested fields: start and end, which represent the time when the entity was first and last observed, respectively. Each time an entity is updated, the end time is updated to the current time.
{ start: 2022-07-06T13:36:00.808Z, end: 2024-04-11T06:56:01.204Z }
referencesrecordstable
Display name: References
Provides 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.
{ references[runs_on.host] : [HOST-C251A1173C2B4B39,HOST-0E9038C7C4409D69], references[runs_on.container] : [CONTAINER-68A08967EF4F675B] }
dt.security_contextstring[]resource stable
Display name: DT security context
The security contexts associated with the entity. For Smartscape entities, this field is always an array.
Tags: permission
[]

Database entity fields

Fields common to all entities within the databases model.

AttributeTypeDescriptionExamples
db.connection_details.ipipAddressexperimental
IP address of the listener to which Dynatrace is connected.
10.100.10.10
db.connection_details.hostnamestringexperimental
Hostname of the listener Dynatrace is connected to.
my-database-server.myorg.org
db.connection_details.portstringexperimental
Port of the listener Dynatrace is connected to.
5432
db.connection_detailsstringexperimental
Listener connection details in the form <hostname>:<port>/<database>.
my-database-server.myorg.org:5432/testdb
db.systemstringexperimental
Display name: Database system
An identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers.
mongodb; mysql

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.

ValueDescriptionDisplay name
adabasAdabas (Adaptable Database System)Adabas
amazon-documentdbAmazon DocumentDBDocumentDB
aurora-mysqlAmazon Aurora MySQLAurora MySQL
aurora-postgresqlAmazon Aurora PostgreSQLAurora PostgreSQL
cacheInterSystems CachéInterSystems Caché
cassandraApache CassandraCassandra
clickhouseClickHouseClickHouse
cloudscapeCloudscapeCloudscape
cockroachdbCockroachDBCockroachDB
coldfusionColdFusion IMQColdFusion IMQ
cosmosdbMicrosoft Azure Cosmos DBCosmos DB
couchbaseCouchbaseCouchbase
couchdbCouchDBCouchDB
databricksDatabricks Data PlatformDatabricks Data Platform
db2IBM Db2IBM Db2
derbyApache DerbyDerby
dl/iIBM DL/IIBM DL/I
dynamodbAmazon DynamoDBDynamoDB
edbEnterpriseDBEnterpriseDB
elasticsearchElasticsearchElasticsearch
filemakerFileMakerFileMaker
firebirdFirebirdFirebird
firstsqlFirstSQLFirstSQL
geodeApache GeodeGeode
h2H2H2
hanadbSAP HANASAP HANA
hbaseApache HBaseHBase
hiveApache HiveHive
hsqldbHyperSQL DataBaseHSQLDB
informixInformixInformix
ingresIngresIngres
instantdbInstantDBInstantDB
interbaseInterBaseInterBase
keyspaces-cassandraAmazon Keyspaces for Apache CassandraKeyspaces
mariadbMariaDBMariaDB
maxdbSAP MaxDBSAP MaxDB
memcachedMemcachedMemcached
mongodbMongoDBMongoDB
mssqlMicrosoft SQL ServerSQL Server
mssqlcompactMicrosoft SQL Server CompactSQL Server Compact
mysqlMySQLMySQL
neo4jNeo4jNeo4j
neptuneAmazon NeptuneNeptune
netezzaNetezzaNetezza
opensearchOpenSearchOpenSearch
oracleOracle DatabaseOracle
other_sqlSome other SQL database. Fallback only. See notes.Other SQL
pervasivePervasive PSQLPervasive PSQL
phoenixApache PhoenixApache Phoenix
pointbasePointBasePointBase
postgresqlPostgreSQLPostgreSQL
progressProgress DatabaseProgress
redisRedisRedis
redshiftAmazon RedshiftRedshift
snowflakeSnowflake Data PlatformSnowflake Data Platform
spannerCloud SpannerCloud Spanner
sqliteSQLiteSQLite
sybaseSybaseSybase
teradataTeradataTeradata
valkeyValkeyValkey
verticaVerticaVertica

Database instance fields

Fields that are common across all DB_INSTANCE_* type nodes.

AttributeTypeDescriptionExamples
db.instance.namestringexperimental
Name of the database instance.
my-database-server.myorg.org:5432; ORCLCDB1; MSSQLSERVER@EC2AMAZ-EV24GE8
db.instance.versionstringexperimental
Version of the database instance as reported by the database vendor.
21.0.0.0.0; 16.10 (Debian 16.10-1.pgdg13+1); 14.15

PostgreSQL instance relationships

TypeTarget typeKindDescription
runs_onHOSTstaticstable
Defines 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.
same_asPROCESSstaticexperimental
Defines an equivalence relationship. Examples: A database instance is the same as a host process.