Database Monitor

Content Type: Module
Categories: Utility,Tracing,Data

Overview

Monitor your database during runtime!

  • Check the size of all of your tables.
  • Perform VACUUM ANALYSE or VACUUM FULL on 1 or more tables
  • Set alerts for table sizes to proactively monitor performance bottlenecks.


Very easy to setup and no dependencies.

Documentation

Database Monitor

A module to quickly check the sizes of the database tables during runtime and set alerts if the tablesize becomes to big.

Features

  • Analyze table sizes during runtime
  • Set thresholds to warn/alert on when a tablesize becomes to big
  • Perform vaccuum actions on 1 or all tables

Dependencies

  • none

Usage

  1. Import the module
  2. Set the correct administrator userrole for the module
  3. Add the SNIP_TableSizes snippet to a page
  4. Run the app and navigate to the new page to use the functionality

Optional: Set warning and critical thresholds for the tables, if crossed it will either log a warning or critical message and change the table status.

Import notes

This module will only work for Postgres in the cloud or when running a restored postgres database locally!

Issues, suggestions and feature requests

https://github.com/hunter-koppen/DatabaseMonitor/issues

Releases

Version: 1.4.0
Framework Version: 11.12.3
Release Notes:

Added VACUUM functionality

Version: 1.3.0
Framework Version: 11.12.3
Release Notes:

Updated for Mx 11

Bugfix for calculating correct Index sizes

Version: 1.2.0
Framework Version: 10.24.14
Release Notes:

Update to mx10

Version: 1.1.0
Framework Version: 9.24.21
Release Notes: Update module for React Client
Version: 1.0.0
Framework Version: 9.18.4
Release Notes: Initial Release