Isok -- A query centered monitoring tool for PostgreSQL

Karl O. Pinc


Table of Contents

Introduction to Isok
Installation
Requirements
Quick-Start
Preparing, While Logged-In to Un*x
Loading Into PostgreSQL
Uninstalling
An Overview of the Isok Tables
The Isok Main Tables
ISOK_QUERIES
ISOK_RESULTS (Isok query Results)
Isok Support Tables
IQ_TYPES (Integrity Query Types)
IR_TYPES (Isok Result Types)
The Isok Functions (Activating Isok)
run_isok_queries — execute one or more of the queries stored in the ISOK_QUERIES table
A. Security Considerations
Limiting Access
What Queries Access Matters
The Search Path
Roles
Mitigation Strategies
Creating an Audit Trail
B. Local Copies of the Documentation
C. Periodic Execution
Example Periodic Reporting via Email Using systemd
D. Techniques For Making Local Extensions to Isok
Wrap run_isok_queries()
Extend Issue Classification
Fully Utilize ISOK_RESULTS.QR_Extra
Modify Isok's Generated SQL
E. Developing Isok
Tool Requirements
Building and Distributing
F. Acknowledgments and History
The Gombe Mother-Infant Project Acknowledgments
The Babase Acknowledgments
The SokweDB Acknowledgements
G. Isok Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
H. GNU Affero General Public License version 3
I. CC0 1.0 Universal Deed
No Copyright
Other Information
Notice
J. CC0 1.0 Universal

Page generated: 2025-06-03T23:35:41-05:00.