Skip to main content

Extension

Short Description

Waiting in an extension.

Additional Information

The Extension wait is seen when waiting on a PostgreSQL extension such as TimescaleDB, PostGIS, pg_stat_statements, ZomboDB or Postgres_fdw.

How to reduce this wait

Little information is available regarding this wait state. Have you seen it? Let us know.

Ensure you use the minimum number of extensions needed for your database to run.

See the Stack Overflow and Stack Exchange articles to see if materialized view refresh or analysis of foreign tables is responsible.

Stack Overflow - Postgres Refresh materialized view showing wait_event_type Extension for a 2+ hours

Stack Exchange - https://dba.stackexchange.com/questions/244150/postgres-wait-event-type-extension

PostgreSQL documentation - The Statistics Collector

Timescale blog - Top 5 PostgreSQL Extensions

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.