Postgres
========

**17 probes**


Governance
----------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - 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
--------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - 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
----------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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

Profiling
---------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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

Quality
-------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - 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
--------------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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