This gives us a funnel. At the top — 1,600 candidates. If we cut the long tail, the number drops fast. In the middle, about 500 are already cataloged, packaged, and delivered. We can split this by source: about 330 from the Pigsty repo, and 160 from PGDG — with some overlap between the two. At the very bottom, 71 contrib extensions shipped with Postgres itself. The point is the shape. Discovery is broad. Delivery is narrower. Usage is narrower again.

Part II : The Ecosystem Landscape

The Extension Funnel

PIGSTY

Extension delivery funnel: 1,617 discovered extension candidates, 511 delivered extensions, 162 PGDG second-party extensions, and 71 PostgreSQL contrib first-party extensions; Pigsty is shown as third-party delivery.