The Management Pack for PostgreSQL collects the metrics listed in the table below, according to PostgreSQL resource kinds.
Download metrics list as .csv file
| Resource Kind | Resource Group | Resource Attribute | Attribute Type |
|---|---|---|---|
| PostgreSQL Instance |
Tablespaces|General |
Tablespace Size |
double |
| PostgreSQL Instance |
Tablespaces|Configuration |
Tablespace Name |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
Tablespace Location |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
Tablespace Location |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
Tablespace Owner |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
Privileges |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
User Name |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
IP Address |
string |
| PostgreSQL Instance |
Tablespaces|Configuration |
Port |
integer |
| PostgreSQL Instance |
Tablespaces|Configuration |
Instance Name |
string |
| PostgreSQL Instance |
Buffers |
Buffers Allocated |
double |
| PostgreSQL Instance |
Buffers |
Times Backend Executed Own fsync |
double |
| PostgreSQL Instance |
Buffers |
Times Background Writer Stopped Due to too Many Buffers |
double |
| PostgreSQL Instance |
Buffers |
Buffers Written by Backend |
double |
| PostgreSQL Instance |
Buffers |
Buffers Written by Background Writer |
double |
| PostgreSQL Instance |
Buffers |
Buffers Written During Checkpoint |
double |
| PostgreSQL Instance |
Configuration |
Name |
string |
| PostgreSQL Instance |
Configuration |
Server IP |
string |
| PostgreSQL Instance |
Configuration |
Server Port |
integer |
| PostgreSQL Instance |
Configuration |
Last Time Stats Reset |
string |
| PostgreSQL Instance |
Configuration |
Version |
string |
| PostgreSQL Instance |
Checkpoints |
Scheduled Checkpoints Performed |
double |
| PostgreSQL Instance |
Checkpoints |
Time Synchronizing Checkpoint Files to Disk |
double |
| PostgreSQL Instance |
Checkpoints |
Requested Checkpoints Performed |
double |
| PostgreSQL Instance |
Checkpoints |
Time Writing Checkpoint Files to Disk |
double |
| PostgreSQL Database |
Sessions |
Number of Active Connections |
integer |
| PostgreSQL Database |
Sessions |
Total Sessions |
integer |
| PostgreSQL Database |
Sessions |
Active Sessions |
integer |
| PostgreSQL Database |
Sessions |
Idle Sessions |
integer |
| PostgreSQL Database |
Sessions |
Idle Sessions in Transaction |
integer |
| PostgreSQL Database |
Sessions |
Idle Sessions in Transaction (Aborted) |
integer |
| PostgreSQL Database |
Sessions |
Sessions Executing Fastpath Function Call |
integer |
| PostgreSQL Database |
Sessions |
Sessions with Unknown State (Track Activities is Disabled) |
integer |
| PostgreSQL Database |
General |
Canceled Queries Due to Conflicts |
integer |
| PostgreSQL Database |
General |
Deadlock Count |
integer |
| PostgreSQL Database |
General |
Database Size |
integer |
| PostgreSQL Database |
General |
Last Timestamp Stats Reset |
string |
| PostgreSQL Database |
Activity |
Rows Deleted |
double |
| PostgreSQL Database |
Activity |
Rows Returned |
double |
| PostgreSQL Database |
Activity |
Rows Updated |
double |
| PostgreSQL Database |
Activity |
Rows Fetched |
double |
| PostgreSQL Database |
Activity |
Rows Inserted |
double |
| PostgreSQL Database |
Configuration |
Tablespace Name |
string |
| PostgreSQL Database |
Configuration |
Database Name |
string |
| PostgreSQL Database |
Configuration |
Database ID |
integer |
| PostgreSQL Database |
Configuration |
IP Address |
string |
| PostgreSQL Database |
Configuration |
Port |
integer |
| PostgreSQL Database |
Conflicts |
Queries Canceled Due to Deadlocks |
double |
| PostgreSQL Database |
Conflicts |
Queries Canceled Due to Old Snapshot |
double |
| PostgreSQL Database |
Conflicts |
Queries Canceled Due to Lock Timeouts |
double |
| PostgreSQL Database |
Conflicts |
Queries Canceled Due to Dropped Tablespaces |
double |
| PostgreSQL Database |
Conflicts |
Queries Canceled Due to Pinned Buffers |
double |
| PostgreSQL Database |
Transactions |
Transaction Rollbacks |
double |
| PostgreSQL Database |
Transactions |
Transaction Commits |
double |
| PostgreSQL Database |
Disk IO |
Temporary Bytes Written |
double |
| PostgreSQL Database |
Disk IO |
Temporary Files Created |
double |
| PostgreSQL Database |
Disk IO |
Buffer Hit Ratios |
double |
| PostgreSQL Database |
Disk IO |
Block Reads/Buffer Misses |
double |
| PostgreSQL Database |
Disk IO |
Time Spent Writing Data |
double |
| PostgreSQL Database |
Disk IO |
Buffer Hits |
double |
| PostgreSQL Database |
Disk IO |
Time Spent Reading Data |
double |
| PostgreSQL Database |
Disk IO |
Blocks Read by Sequences |
integer |
| PostgreSQL Database |
Disk IO |
Blocks Hit by Sequences |
integer |
| PostgreSQL Table |
Triggers|Configuration |
Trigger Enabled Status |
string |
| PostgreSQL Table |
Triggers|Configuration |
Trigger ID |
double |
| PostgreSQL Table |
Triggers|Configuration |
Trigger Name |
string |
| PostgreSQL Table |
Triggers|Configuration |
Type of Trigger Fire |
integer |
| PostgreSQL Table |
Triggers|Configuration |
Arguments Passed to Trigger |
string |
| PostgreSQL Table |
Triggers|Configuration |
Table ID |
integer |
| PostgreSQL Table |
Triggers|Configuration |
Table Name |
string |
| PostgreSQL Table |
Triggers|Configuration |
Function Name |
string |
| PostgreSQL Table |
Triggers|Configuration |
Function ID |
integer |
| PostgreSQL Table |
Triggers|Configuration |
IP Address |
string |
| PostgreSQL Table |
Triggers|Configuration |
Port |
integer |
| PostgreSQL Table |
Indexes|Activity |
Number of Block Reads |
integer |
| PostgreSQL Table |
Indexes|Activity |
Number of Table Rows Fetched by Scan |
integer |
| PostgreSQL Table |
Indexes|Activity |
Number of Buffer Hits |
integer |
| PostgreSQL Table |
Indexes|Activity |
Number of Index Entries Returned |
integer |
| PostgreSQL Table |
Indexes|Activity |
Number of Scans |
integer |
| PostgreSQL Table |
Indexes|Configuration |
Index ID |
string |
| PostgreSQL Table |
Indexes|Configuration |
Index Name |
string |
| PostgreSQL Table |
Indexes|Configuration |
Table Name |
string |
| PostgreSQL Table |
Indexes|Configuration |
Schema Name |
string |
| PostgreSQL Table |
Indexes|Configuration |
Table ID |
integer |
| PostgreSQL Table |
Indexes|Configuration |
IP Address |
string |
| PostgreSQL Table |
Indexes|Configuration |
Port |
integer |
| PostgreSQL Table |
General |
Table Size |
integer |
| PostgreSQL Table |
Activity |
Number of Rows Updated |
double |
| PostgreSQL Table |
Activity |
Number of Sequential Scans |
double |
| PostgreSQL Table |
Activity |
Last Time Table Analyzed by Auto Daemon |
string |
| PostgreSQL Table |
Activity |
Number of Dead Rows |
double |
| PostgreSQL Table |
Activity |
Last Time Table Vacuumed by Auto Daemon |
string |
| PostgreSQL Table |
Activity |
Number of Rows Deleted |
double |
| PostgreSQL Table |
Activity |
Last Time Table Manually Analyzed |
string |
| PostgreSQL Table |
Activity |
Number of Index Scans |
double |
| PostgreSQL Table |
Activity |
Number of Rows Inserted |
double |
| PostgreSQL Table |
Activity |
Number of Times Table Manually Vacuumed |
double |
| PostgreSQL Table |
Activity |
Number of Times Table Vacuumed By Auto Daemon |
double |
| PostgreSQL Table |
Activity |
Last Time Table Manually Vacuumed |
string |
| PostgreSQL Table |
Activity |
Number of Rows Fetched by Index Scans |
double |
| PostgreSQL Table |
Activity |
Number of Times Table Manually Analyzed |
double |
| PostgreSQL Table |
Activity |
Number of Rows Modified Since Last Analyzed |
integer |
| PostgreSQL Table |
Activity |
Number of Times Table Analyzed by Auto Daemon |
double |
| PostgreSQL Table |
Activity |
Rows fetched by Sequential Scans |
double |
| PostgreSQL Table |
Activity |
Number of Live Rows |
double |
| PostgreSQL Table |
Activity |
Number of Rows Hot Updated (No separate index update requried) |
double |
| PostgreSQL Table |
Configuration |
Table ID |
integer |
| PostgreSQL Table |
Configuration |
Tablespace Name |
string |
| PostgreSQL Table |
Configuration |
Database Name |
string |
| PostgreSQL Table |
Configuration |
Table Name |
string |
| PostgreSQL Table |
Configuration |
Table Schema |
string |
| PostgreSQL Table |
Configuration |
IP Address |
string |
| PostgreSQL Table |
Configuration |
Port |
integer |
| PostgreSQL Table |
Disk IO |
Number of Block Reads from Indexes |
double |
| PostgreSQL Table |
Disk IO |
Number of Block Reads |
double |
| PostgreSQL Table |
Disk IO |
Number of Buffer Reads |
double |
| PostgreSQL Table |
Disk IO |
Number of Block Reads from TOAST Table Indexes |
double |
| PostgreSQL Table |
Disk IO |
Number of Buffer Hits from TOAST Table |
double |
| PostgreSQL Table |
Disk IO |
Number of Buffer Hits from Indexes |
double |
| PostgreSQL Table |
Disk IO |
Number of Buffer Hits from TOAST Table Indexes |
double |
| PostgreSQL Table |
Disk IO |
Number of Block Reads from TOAST Table |
double |
| PostgreSQL Function |
Activity |
Total Time Spent Calling This and All Called Functions |
double |
| PostgreSQL Function |
Activity |
Average Total Call Time |
double |
| PostgreSQL Function |
Activity |
Times Called |
double |
| PostgreSQL Function |
Activity |
Time Spent on This Function Alone (not referenced functions) |
double |
| PostgreSQL Function |
Configuration |
Schema Name |
string |
| PostgreSQL Function |
Configuration |
Function Name |
string |
| PostgreSQL Function |
Configuration |
Function ID |
integer |
| PostgreSQL Function |
Configuration |
IP Address |
string |
| PostgreSQL Function |
Configuration |
Port |
integer |
| PostgreSQL Function |
Configuration |
Database Name |
string |
| PostgreSQL Function |
Configuration |
Rank |
integer |
| PostgreSQL Query |
Activity |
Query Text |
string |
| PostgreSQL Query |
Activity |
Total Time |
double |
| PostgreSQL Query |
Activity |
Average Time Spent Per Call |
double |
| PostgreSQL Query |
Activity |
Number of Calls |
double |
| PostgreSQL Query |
Activity |
Rows Returned |
integer |
| PostgreSQL Query |
Configuration |
User Name |
string |
| PostgreSQL Query |
Configuration |
Database Name |
string |
| PostgreSQL Query |
Configuration |
IP Address |
string |
| PostgreSQL Query |
Configuration |
Port |
integer |
| PostgreSQL Query |
Configuration |
Rank |
integer |
| PostgreSQL Query |
Disk IO |
Local Block Cache Hits |
integer |
| PostgreSQL Query |
Disk IO |
Shared Block Reads |
integer |
| PostgreSQL Query |
Disk IO |
Shared Blocks Written |
integer |
| PostgreSQL Query |
Disk IO |
Total Time Spent Writing Blocks |
integer |
| PostgreSQL Query |
Disk IO |
Shared Blocks Dirty Read |
integer |
| PostgreSQL Query |
Disk IO |
Local Block Reads |
integer |
| PostgreSQL Query |
Disk IO |
Shared Block Cache Hits |
integer |
| PostgreSQL Query |
Disk IO |
Local Blocks Dirty Read |
integer |
| PostgreSQL Query |
Disk IO |
Total Time Spent Reading Blocks |
integer |
| PostgreSQL Query |
Disk IO |
Local Blocks Written |
integer |
