Red Hat Summit Red Hat Summit지원콘솔개발자평가판 시작연락처

이 콘텐츠는 선택한 언어로 제공되지 않습니다.

3.3. Postgres Server

Overview

Expand
Table 3.26. Overview
Description: PostgreSQL Server
Singleton: no
Plugin: Postgres

Parent Resource Types

Child Resource Types

Autodiscovery Process Scans

Expand
Table 3.27. Metrics
Name Query
unix process|basename|match=^(postgres|postmaster)$,process|basename|nomatch|parent=^(postgres|postmaster)$
windows process|basename|match=^(?i)(postgres|postmaster)\.exe$,process|basename|nomatch|parent=^(?i)(postgres|postmaster)\.exe$

Connection Properties

Expand
Table 3.28. 
Name Description Required Internal Name
listen host the hostname or IP address that the database is listening on yes host
listen port the TCP port that the database is listening on yes port
database name the name of the database to connect to yes db
JDBC driver class the fully-qualified classname of the JDBC driver class no driverClass
role name the database role to connect as yes principal
role password the password for the database role being used to connect yes credentials
PGDATA directory the absolute path to the directory containing the cluster configuration files postgresql.conf, pg_hba.conf, and pg_ident.conf yes pgdataDir
configuration file the absolute path to the main cluster configuration file; default value is '{pgDataDir}/postgresql.conf', where [pgDataDir] is the value of the pgDataDir connection property no configFile

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.

Metrics

Expand
Table 3.29. Metrics
Name Type Description Internal Name
User Time measurement The aggregate amount of CPU user time spent by all postgres processes Process.aggregateCpu.user
User Time per Minute measurement The aggregate amount of CPU user time spent by all postgres processes Process.aggregateCpu.user
Kernel Time measurement The aggregate amount of CPU kernel time spent by all postgres processes Process.aggregateCpu.sys
Kernel Time per Minute measurement The aggregate amount of CPU kernel time spent by all postgres processes Process.aggregateCpu.sys
CPU Percentage measurement The percentage of CPU currently being used by all postgres processes Process.aggregateCpu.percent
Physical Memory measurement The aggregate amount of resident memory used by all postgres processes Process.aggregateMemory.resident
Virtual Memory measurement The aggregate amount of virtual memory used by all postgres processes Process.aggregateMemory.size
Open File Descriptors measurement The aggregate number of file descriptors open by all postgres processes Process.aggregateFileDescriptor.total
Active Backends measurement Number of currently active backends (user connections) Database.backends
Start time trait Start time of the PostgreSQL database server Database.startTime

Note

You must use the internal name to reference Traits in Dynamic Group Definition expressions.

Configuration Properties

Expand
Table 3.30. 
Name Description Required Internal Name
Port Sets the TCP port the server listens on; default value is '5432'. no port
Max_connections Sets the maximum number of concurrent connections; default value is '100'. no max_connections
Shared_buffers Sets the number of the shared memory buffers used by the server; default value is typically '1000'. no shared_buffers
Max_fsm_pages Maximum FSM Pages, must be a minimum of max_fsm_relations*16, 6 bytes each) no max_fsm_pages
Log_destination Available options depend on operating system; default value is 'stderr' no log_destination
Redirect_stderr Enable capturing of stderr into log files; enabled by default no redirect_stderr
Stats_start_collector needed for block or row stats; enabled by default no stats_start_collector
Stats_block_level Enables the collection of block-level statistics on database activity; if this option is enabled, the data that is produced can be accessed via the pg_stat and pg_statio family of system views; disabled by default no stats_block_level
Stats_row_level Enables the collection of row-level statistics on database activity; if this option is enabled, the data that is produced can be accessed via the pg_stat and pg_statio family of system views; disabled by default no stats_row_level
Autovacuum Enable autovacuum subprocess? (requires stats_start_collector and stats_row_level to also be on); enabled by default no autovacuum
Runtime Settings properties available from show all no runtimeSettings

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.

Operations

Expand
Table 3.31. Metrics
Name Description
List Process Statistics List statistics about the currently executing postgres backends

Package Types

none

3.3.1. Database Service
링크 복사

Overview

Expand
Table 3.32. Overview
Description:
Singleton: no
Plugin: Postgres

Parent Resource Types

Child Resource Types

Connection Properties

Expand
Table 3.33. 
Name Description Required Internal Name
Database Name yes databaseName

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.

Metrics

Expand
Table 3.34. Metrics
Name Type Description Internal Name
Backends measurement Number of active server processes for database numbackends
Transactions Committed measurement Transactions committed in database xact_commit
Transactions Committed per Minute measurement Transactions committed in database xact_commit
Transactions Rolled Back measurement Transactions rolled back in database xact_rollback
Transactions Rolled Back per Minute measurement Transactions rolled back in database xact_rollback
Blocks Read measurement Number of disk block fetch requests for database blks_read
Blocks Read per Minute measurement Number of disk block fetch requests for database blks_read
Blocks Hit measurement Number of disk block fetch requests found in cache for database blks_hit
Blocks Hit per Minute measurement Number of disk block fetch requests found in cache for database blks_hit
Size measurement Disk space used by the database size

Note

You must use the internal name to reference Traits in Dynamic Group Definition expressions.

Configuration Properties

none

Operations

Expand
Table 3.35. Metrics
Name Description
Reset Statistics Resets the statistics in this database
Invoke Sql Execute arbitrary SQL

Package Types

none

3.3.1.1. Query Service
링크 복사

Overview
Expand
Table 3.36. Overview
Description:
Singleton: no
Plugin: Postgres
Parent Resource Types
Child Resource Types
none
Connection Properties
Expand
Table 3.37. 
Name Description Required Internal Name
Table The table to discover yes table
Name yes name
Description yes description
Metric Query The query that will gather metric data yes metricQuery

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.
Metrics
Expand
Table 3.38. Metrics
Name Type Description Internal Name
Metric Column measurement Metric Column metricColumn

Note

You must use the internal name to reference Traits in Dynamic Group Definition expressions.
Configuration Properties
none
Operations
none
Package Types
none

3.3.1.2. Table Service
링크 복사

Overview
Expand
Table 3.39. Overview
Description: Database table
Singleton: no
Plugin: Postgres
Parent Resource Types
Child Resource Types
none
Connection Properties
Expand
Table 3.40. 
Name Description Required Internal Name
Table Name yes tableName

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.
Metrics
Expand
Table 3.41. Metrics
Name Type Description Internal Name
Sequential Scans measurement Number of sequential scans done against this table (when an index scan was not possible) seq_scan
Sequential Scans per Minute measurement Number of sequential scans done against this table (when an index scan was not possible) seq_scan
Sequential Rows Read measurement Number of rows read by sequential scans seq_tup_read
Sequential Rows Read per Minute measurement Number of rows read by sequential scans seq_tup_read
Index Scans measurement Number of index scans done against this table idx_scan
Index Scans per Minute measurement Number of index scans done against this table idx_scan
Index Scan Rows Read measurement Number of index entries returned by index scans idx_tup_fetch
Index Scan Rows Read per Minute measurement Number of index entries returned by index scans idx_tup_fetch
Heap Blocks Read measurement The number of heap blocks read that were not a buffer cache hit heap_blks_read
Heap Blocks Read per Minute measurement The number of heap blocks read that were not a buffer cache hit heap_blks_read
Heap Blocks Hit measurement The number of heap block requests that were found in the buffer cache heap_blks_hit
Heap Blocks Hit per Minute measurement The number of heap block requests that were found in the buffer cache heap_blks_hit
Index Blocks Read measurement The number of index blocks fetched that were not a buffer cache hit idx_blks_read
Index Blocks Read per Minute measurement The number of index blocks fetched that were not a buffer cache hit idx_blks_read
Index Blocks Hit measurement The number of index block requests that were found in the buffer cache idx_blks_hit
Index Blocks Hit per Minute measurement The number of index block requests that were found in the buffer cache idx_blks_hit
Toast Blocks Reads measurement The number of toast blocks fetched that were not a buffer cache hit toast_blks_read
Toast Blocks Reads per Minute measurement The number of toast blocks fetched that were not a buffer cache hit toast_blks_read
Toast Blocks Hit measurement The number of toast block requests that were found in the buffer cache toast_blks_hit
Toast Blocks Hit per Minute measurement The number of toast block requests that were found in the buffer cache toast_blks_hit
Toast Index Blocks Read measurement The number of toast index blocks fetched that were not a buffer cache hit tidx_blks_read
Toast Index Blocks Read per Minute measurement The number of toast index blocks fetched that were not a buffer cache hit tidx_blks_read
Toast Index Blocks Hit measurement The number of toast index block requests that were found in the buffer cache tidx_blks_hit
Toast Index Blocks Hit per Minute measurement The number of toast index block requests that were found in the buffer cache tidx_blks_hit
Row Inserts measurement The number of rows ever inserted into this table n_tup_ins
Row Inserts per Minute measurement The number of rows ever inserted into this table n_tup_ins
Row Updates measurement The number of rows ever updated on this table n_tup_upd
Row Updates per Minute measurement The number of rows ever updated on this table n_tup_upd
Row Deletes measurement The number of rows ever deleted from this table n_tup_del
Row Deletes per Minute measurement The number of rows ever deleted from this table n_tup_del
Table Size measurement The size in bytes of the data in the table table_size
Total Size measurement The size in bytes of the data and all associated indexes and toast tables total_size
Rows measurement The count of rows in the table. Warning: This may be an expensive operation rows
Approximate rows measurement The approximate count of rows in the table. This is basically the number of rows of the last ANALYZE of the table. This metric is not expensive. rows_approx

Note

You must use the internal name to reference Traits in Dynamic Group Definition expressions.
Configuration Properties
Expand
Table 3.42. 
Name Description Required Internal Name
Table Name yes tableName
Columns yes columns

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.
Operations
Expand
Table 3.43. Metrics
Name Description
Vacuum Vacuum the table
Package Types
none

3.3.2. User Service
링크 복사

Overview

Expand
Table 3.44. Overview
Description: A User in the Postgres System
Singleton: no
Plugin: Postgres

Parent Resource Types

Child Resource Types

none

Connection Properties

Expand
Table 3.45. 
Name Description Required Internal Name
User Name yes userName

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.

Metrics

Expand
Table 3.46. Metrics
Name Type Description Internal Name
Total User Connections measurement The total number of user connections in the system, whether actively querying or idle total
Active User Connections measurement The number of user connections in the system actively querying active

Note

You must use the internal name to reference Traits in Dynamic Group Definition expressions.

Configuration Properties

Expand
Table 3.47. 
Name Description Required Internal Name
Inherit Rights Inherit rights from parent roles yes inheritRights
Super User Is a super user yes superuser
Can Create Database Types yes canCreateDatabaseObjects
Can Create Roles yes canCreateRoles
Can Modify Catalog Directly yes canModifyCatalogDirectly
User connection limit yes connectionLimit
User yes user
Can Login yes canLogin
Password yes password

Note

You must use the internal name to reference Configuration Properties in Dynamic Group Definition expressions.

Operations

none

Package Types

none
맨 위로 이동
Red Hat logoGithubredditYoutubeTwitter

자세한 정보

평가판, 구매 및 판매

커뮤니티

Red Hat 문서 정보

Red Hat을 사용하는 고객은 신뢰할 수 있는 콘텐츠가 포함된 제품과 서비스를 통해 혁신하고 목표를 달성할 수 있습니다. 최신 업데이트를 확인하세요.

보다 포괄적 수용을 위한 오픈 소스 용어 교체

Red Hat은 코드, 문서, 웹 속성에서 문제가 있는 언어를 교체하기 위해 최선을 다하고 있습니다. 자세한 내용은 다음을 참조하세요.Red Hat 블로그.

Red Hat 소개

Red Hat은 기업이 핵심 데이터 센터에서 네트워크 에지에 이르기까지 플랫폼과 환경 전반에서 더 쉽게 작업할 수 있도록 강화된 솔루션을 제공합니다.

Theme

© 2025 Red Hat