Postgres

17 probes

Governance

Probe	Description
postgres.governance.grants	Extract table-level grants from information_schema.role_table_grants
postgres.governance.roles	Extract database roles and their attributes from pg_roles

Metadata

Probe	Description
postgres.metadata.columns	Extract column definitions from information_schema.columns
postgres.metadata.constraints	Extract PK, FK, unique constraints from information_schema
postgres.metadata.extensions	Extract installed PostgreSQL extensions
postgres.metadata.functions	Extract function/procedure definitions from pg_proc + pg_get_functiondef
postgres.metadata.indexes	Extract index definitions from pg_indexes
postgres.metadata.sequences	Extract sequence definitions from information_schema.sequences
postgres.metadata.tables	Extract table names, row estimates, and size from pg_catalog
postgres.metadata.triggers	Extract trigger metadata from information_schema.triggers
postgres.metadata.views	Extract view definitions from information_schema.views

Operations

Probe	Description
postgres.operations.activity	Table access patterns: seq/idx scans, inserts, updates, deletes

Profiling

Probe	Description
postgres.profiling.column_stats	Column statistics: distinct values, most common values, histogram bounds

Quality

Probe	Description
postgres.quality.freshness	Check table freshness via pg_stat_user_tables last analyze/vacuum timestamps
postgres.quality.null_ratio	Null percentage per column from pg_stats (no table scan)
postgres.quality.row_counts	Estimated row counts and dead tuple ratio from pg_stat_user_tables

Schema_History

Probe	Description
postgres.schema_history.recent_changes	DDL event log from pg_event_trigger or object age analysis