Databases
Overview
The Databases dashboard contains 2 sections separated by a horizontal splitter: the top section, which displays a row for each database as well as some key information, and the bottom section, which displays metric information related to the database selected in the top section as well as highlighting tables in that database with the highest or lowest value for a particular metric. The size of the two sections can be increased or decreased by dragging the horizontal splitter bar up or down. In the action panel on the right pane, the PostgreSQL Agent Selector allows you to switch between PostgreSQL servers.
Data
Top Section – DB Table
- Health – Shows the overall health of the database.
- Name – The name of the database.
- Connections – Number of connections to this database.
- Tables – Number of tables in the database.
- Functions – Number of functions in the database.
- Workload – A calculation of time spent reading and writing data file blocks by backends in this database in a sample period, divided by the sample period time. This represents the load on the server and may exceed 1 because of concurrent processing. This is not an estimation of resource usage or availability. Requires track_io_timing to be enabled, available only in v9.2+.
- Blk Hit Rate – Rate at which disk blocks are found already in the buffer cache, so that a read was not necessary.
- Blk Read Rate – Rate at which disk blocks are read from the database.
- Blk Hit % - Percentage where a table read is successfully sourced from buffer cache rather than needing physical disk I/O.
- DB Size – Disk size of this database. • Conflicts Rate – Rate of queries cancelled due to conflicts with recovery in this database.
- Tablespace – Name of the default tablespace for objects created in this database.
- Statements – The number of statements gathered in the last sample for this database. This collection may be limited due to the # of Top Statements property in the Agent Properties or the pg_stat_statements.max setting on the PostgreSQL server.
Bottom Section – DB Metrics
- Tuple Retrieval – Rate of tuples retrieved with sequential scans (tup_returned_rate) vs. bitmap or simple scans (tup_fetched_rate).
- Tuple Modifications – Rate of tuples modified by deletion, update, or insert operations.
- Transaction Results – Rate of transactions finished with commits or rollback.
- Deadlocks – Number of deadlocks detected in the database.
- Memory Reads – Rate of memory blocks read from buffer cache vs. physical disk.
- Memory Operation Time – Time spent reading or writing data file blocks by backends.
- DB Size – Disk size of the database. o Temp File Writes – Number of temporary files created by queries in this database and the total data size.
- Conflict Issues – Breakdown of cancelled queries due to conflict by reason.
Bottom Section – Table Highlights
- Most Blocks Read – Tables with the most disk blocks read during queries.
- Lowest Mem Blk Hit % - Tables with the lowest memory block hit %, i.e. tables where data is being read from disk rather than buffer cache.
- Most Tuples Modified – Tables most actively being modified.
- Largest Size – Tables with the largest disk size.
Actions
Database Table
- Health (dwell or drilldown) - Shows a breakdown of child objects in a warning, critical, or fatal state.
- Connections
- Dwell - A popup time plot of connections.
- Drilldown – Navigates to the Current Backends page filtered for selected database.
- Tables (drilldown) – Navigates to the Tables page for the selected database.
- Functions (drilldown) – Navigates to the Functions page for the selected database.
- Blk Hit Rate (dwell) – A popup time plot of the block hit rate.
- Blk Read Rate (dwell) – A popup time plot of the block read rate.
- Blk Hit % (dwell) – A popup time plot of the block hit percentage.
- DB Size (dwell) – A popup time plot of the database size.
- Conflicts Rate (dwell) – A popup time plot of the conflicts rate.
- Tablespace
- Dwell - A popup table with the tablespace’s health, OI, owner, and disk size.
- Drilldown – Navigates to the Tablespaces page.
- Statements (drilldown) – Navigates to the Statements dashboard, filtered for statements only performed on the selected database.
Table Highlights
Clicking on an area of the graph reserved for displaying the metric value for a table will drilldown to the Tables page for that database with the selected table highlighted.
Admin Actions
If your user account has the PostgreSQL Administrator role and the PostgreSQL user provided to the agent has the appropriate permissions, you can perform administrative actions on the server from the dashboard. Click the icon in the Admin table column to perform one of the following actions:
- Vacuum + Analyze – Perform a VACUUM ANALYZE operation on the database.
- Vacuum – Perform a VACUUM operation on the database.
- Analyze – Perform an ANALYZE operation on the database.
- Stat Reset – Reset the statistic counts on the database.
Tables
Overview
The Tables page contains 2 sections separated by a horizontal splitter: the top section, which displays a row for each table as well as some key information, and the bottom section, which displays metric information related to the table selected in the top section. The size of the two sections can be increased or decreased by dragging the horizontal splitter bar up or down. In the action panel on the right pane, the DB Selector allows you to switch between databases or show tables from all databases.
Data
Top Section – Tables Table
- Health – Shows the overall health of the table.
- Name – The name of the table. • DB – The database that contains the table.
- Schema – The schema that contains the table.
- Tuples – The number of tuples in the table.
- Indexes – The number of indexes in the table.
- Memory Hit % - Percentage where a read from the table or any related resource is successfully sourced from buffer cache rather than needing physical disk I/O.
- Idx Mem Hit % – Percentage where a read from the table indexes is successfully sourced from buffer cache rather than needing physical disk I/O.
- Idx/Seq Scan Tuple % – Percentage of tuples returned from index vs. sequential scans.
- HOT Update % – Percentage of rows updated by HOT.
- Idx Size – Disk size of all index tables associated with the table.
- Table Size – Disk size of the table.
- Idx/Table Size – Ratio of index size to table size.
- Owner – Owner of the table.
- Tablespace – Tablespace where table data is stored.
Bottom Section – Table Metrics
- Tuple Modifications Rates – Rate of tuples modified by deletion, update, or insert operations.
- Tuple Modification Pcts – Distribution of modification operations affecting table tuples.
- Live/Dead Tuples – Counts of live and dead tuples in table memory. Dead tuples are deleted rows that have not yet been cleaned up.
- Disk Sizes – Disk sizes of table, table indexes, and total table size, including related resources.
- Table Scan Rates – Rates of index and sequential scans on this table.
- Buffer Efficiency – Breakdown of memory block hits by table resource.
- Stat Calculations – Counts of vacuum and analyze operations.
- Last…Operation – Timestamp of last operation on the table.
Actions
Table Table
- Health (dwell or drilldown) - Shows a breakdown of child objects in a warning, critical, or fatal state.
- DB (drilldown) – Navigates to the Database page for the selected table.
- Tuples (dwell) – A popup time plot of the tuple count.
- Indexes
- Dwell – A popup time plot of the index count.
- Drilldown – Navigates to the indexes page.
- Memory Hit % (dwell or drilldown) - A popup time plot of the memory hit percentage.
- Idx Mem Hit % (dwell or drilldown) - A popup time plot of the index memory hit percentage.
- Idx/Seq Scan Tuple % (dwell or drilldown) - A popup time plot of the index/sequential scan tuple percent.
- HOT Update % (dwell or drilldown) - A popup time plot of the HOT update percent.
- Idx Size (dwell or drilldown) - A popup time plot of the index size.
- Table Size (dwell or drilldown) - A popup time plot of the table size.
- Idx/Table Size (dwell or drilldown) - A popup time plot of the index/table size.
- Tablespace
- Dwell - A popup table with the tablespace’s health, OI, owner, and disk size.
- Drilldown – Navigates to the Tablespaces page.
Admin Actions
If your user account has the PostgreSQL Administrator role and the PostgreSQL user provided to the agent has the appropriate permissions, you can perform administrative actions on the server from the dashboard. Click the icon in the Admin table column to perform one of the following actions:
- Vacuum + Analyze – Perform a VACUUM ANALYZE operation on the table.
- Vacuum – Perform a VACUUM operation on the table.
- Analyze – Perform an ANALYZE operation on the table.
- Stat Reset – Reset the statistic counts on the table.
Indexes
Overview
The Indexes page displays key information on indexes for the selected database table as well as providing comparisons between multiple table indexes in the four graphs at the top of the page.
Data
Top Section – Index Comparisons
- Indexes v Table Size Comparison – Compares disk size of table vs. combined table indexes.
- Index sizes – Compares disk sizes of table indexes.
- Memory Hit % - Compares memory hit percentage of indexes.
- Average Tuples Returned – Average number of tuples returned per query.
Bottom Section – Index Table
- Health – Shows the overall health of the index.
- Name – The name of the index.
- Size – Disk size of the index.
- isPrimary – Whether index is the primary index in the table.
- isUnique – Whether index values must be unique.
- isValid – Whether index is configured correctly and can be used as an index.
- Attributes – The number of columns used in the index.
- Avg Tuples – Average number of tuples returned from an index scan.
- Memory Hit % - Percentage where a read from the index is successfully sourced from buffer cache rather than needing physical disk I/O.
- Hit Rate – Rate of buffer hits in this index.
- Scan Rate – Rate of index scans initiated on the index.
- Tuple Read Rate – Number of index entries returned by scans on the index.
- Tuple Fetch Rate – Number of live table rows fetched by simple index scans using the index.
Actions
Index Table
- Health (dwell or drilldown) - Shows a breakdown of child objects in a warning, critical, or fatal state.
- Size (dwell) - A popup time plot of the index size.
- Attributes (dwell) – A popup table of the columns used in the index.
- Avg Tuples – A popup time plot of the average number of tuples returned.
- Memory Hit % - A popup time plot of the memory hit percentage.
- Hit Rate – A popup time plot of the hit rate.
- Scan Rate – A popup time plot of the scan rate.
- Tuple Read Rate – A popup time plot of the tuple read rate.
- Tuple Fetch Rate – A popup time plot of the tuple fetch rate.