postgres:17-alpine + system_stats extension

Dockerfile

FROM postgres:17-alpine

# Install required dependencies
RUN apk add --no-cache gcc musl-dev make g++ postgresql-dev git clang llvm llvm-dev

# Clone the system_stats repository from EnterpriseDB GitHub
RUN git clone --depth 1 https://github.com/EnterpriseDB/system_stats.git /build/system_stats

# Build and install the system_stats extension
WORKDIR /build/system_stats
RUN make && make install

# Clean up unnecessary dependencies
RUN apk del gcc musl-dev make g++ git \
    && rm -rf /build/system_stats /var/cache/apk/*

# Restore default working directory
WORKDIR /

run post install:

CREATE EXTENSION system_stats;