postgresql-extensions

name	postgresql-extensions
description	Essential PostgreSQL extensions - pg_stat_statements, pg_trgm, PostGIS
version	3.0.0
sasmp_version	1.3.0
bonded_agent	05-postgresql-advanced
bond_type	SECONDARY_BOND
category	database
difficulty	intermediate
estimated_time	2h

PostgreSQL Extensions Skill

Atomic skill for essential extensions

Overview

Production-ready patterns for installing and using key PostgreSQL extensions.

Prerequisites

• PostgreSQL 16+
• Superuser or extension privileges
• Extension packages installed

Parameters

parameters:
  operation:
    type: string
    required: true
    enum: [install, configure, use]
  extension:
    type: string
    enum: [pg_stat_statements, pg_trgm, uuid_ossp, hstore, postgis]

Quick Reference

Install Extensions

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
CREATE EXTENSION IF NOT EXISTS pg_trgm;
CREATE EXTENSION IF NOT EXISTS uuid_ossp;
CREATE EXTENSION IF NOT EXISTS hstore;

-- Check installed
SELECT extname, extversion FROM pg_extension;

pg_stat_statements

-- Top queries
SELECT query, calls, mean_exec_time
FROM pg_stat_statements
ORDER BY total_exec_time DESC LIMIT ;


 pg_stat_statements_reset();