Adding Postgres extensions ========================== Default Postgres extensions --------------------------- By default, TPA adds the following extensions to every Postgres database (and if needed, automatically adds the corresponding entries into shared preload libraries) - pg_stat_statements - pg_freespacemap - pg_visibility - pageinspect - pgstattuple User defined extensions ----------------------- Additional extensions can be configured within ``config.yml`` , by specifying the extension name, any required shared preload entries and the package containing the extension. - :ref:`Reconciling changes made outside of TPA ` - :ref:`Creating Postgres databases ` - :ref:`shared_preload_libraries ` - :ref:`Installing Postgres-related packages ` TPA recognized extensions ------------------------- The following list of extensions only require the extension name to be added in ``config.yml`` (either to ``extra_postgres_extensions`` OR to the ``extensions`` list of a database specified in ``postgres_databases`` ) and TPA will automatically include the correct package and any required entries to shared_preload_libraries. - edb_pg_tuner - query_advisor - edb_wait_states - sql_profiler - autocluster - refdata