Extension versions for Amazon Aurora PostgreSQL - Amazon Aurora
Extensions for PostgreSQL 16Extensions for PostgreSQL 15Extensions for PostgreSQL 14Extensions for PostgreSQL 13Extensions for PostgreSQL 12Extensions for PostgreSQL 11Extensions for PostgreSQL 10Extensions for PostgreSQL 9.6apg_plan_mgmt extension versions

Extension versions for Amazon Aurora PostgreSQL

Following, you can find version information for each extension supported by currently available Amazon Aurora PostgreSQL releases.

To upgrade an extension in your Aurora PostgreSQL DB cluster, see Upgrading PostgreSQL extensions in the Amazon Aurora User Guide.

For information about installing extensions, see Working with extensions and foreign data wrappers in the Amazon Aurora User Guide.

Extensions supported for Aurora PostgreSQL 16

The following table shows the PostgreSQL extension versions that are currently supported on Aurora PostgreSQL 16 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension in the PostgreSQL documentation.

Extension 16.1
address_standardizer 3.4.0
address_standardizer_data_us 3.4.0

amcheck

 1.3

apg_plan_mgmt

 2.4
aurora_stat_utils 1.0
auto_explain Yes

autoinc (contrib-spi)

 1.0
aws_commons 1.2
aws_lambda 1.0

aws_ml

 1.0

aws_s3

 1.2
bloom 1.0
bool_plperl 1.3
btree_gin 1.3
btree_gist 1.6
citext 1.6
cube 1.5
dblink 1.2
dict_int 1.0
dict_xsyn 1.0
earthdistance 1.1
fuzzystrmatch 1.1
hll 2.18
hstore 1.8
hstore_plperl 1.0
hypopg 1.4.0
ICU module 60.2

insert_username (contrib-spi)

 1.0
intagg 1.1
intarray 1.5
ip4r 2.4
isn 1.2
jsonb_plperl 1.0
lo 1.1
log_fdw 1.3
ltree 1.2

moddatetime (contrib-spi)

 1.0
mysql_fdw 2.9.1
oracle_fdw 2.6.0
orafce 4.6.0

pg_ad_mapping

 0.1
pg_bigm 1.2
pg_buffercache 1.3
pg_cron 1.6.0
pg_freespacemap 1.2
pg_hint_plan 1.6.0
pg_partman 4.7.3
pg_prewarm 1.2
pg_proctab 0.0.10
pg_repack 1.4.8
pg_similarity 1.0
pg_stat_statements 1.10
pg_tle 1.2.0
pg_trgm 1.6
pg_visibility 1.2
pgAudit 16.0
pgcrypto 1.3

pgdam

 1.7
pglogical 2.4.4

pglogical_origin

 1.0.0
pgrouting 3.4.1
pgrowlocks 1.2
pgstattuple 1.5
pgtap 1.3.0
pgvector 0.5.1
plcoffee 3.1.6
plls 3.1.6
plperl 1.0
plpgsql 1.0
plprofiler 4.2.4
pltcl 1.0
plv8 3.1.8
PostGIS 3.4.0
postgis_raster 3.4.0
postgis_tiger_geocoder 3.4.0
postgis_topology 3.4.0
postgres_fdw 1.1
prefix 1.2.1
rdkit 4.4.0
rds_tools 1.0

refint (contrib-spi)

 1.0
SEG 1.0
sslinfo 1.2
tablefunc 1.0
TCN 1.0
tds_fdw 2.0.3
tsm_system_rows 1.0
tsm_system_time 1.0
unaccent 1.1
uuid-ossp 1.1
wal2json 2.5

Extensions supported for Aurora PostgreSQL 15

The following table shows the PostgreSQL extension versions that are currently supported on Aurora PostgreSQL 15 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension in the PostgreSQL documentation.

Extension 15.5 15.4 15.3 15.2
address_standardizer 3.4.0 3.3.3 3.3.2 3.3.2
address_standardizer_data_us 3.4.0 3.3.3 3.3.2 3.3.2

amcheck

 1.3 1.3 1.3 1.3

apg_plan_mgmt

 2.4 2.4 2.4 2.4
aurora_stat_utils 1.0 1.0 1.0 1.0
auto_explain Yes Yes Yes Yes

autoinc (contrib-spi)

 1.0 1.0 1.0 1.0
aws_commons 1.2 1.2 1.2 1.2
aws_lambda 1.0 1.0 1.0 1.0

aws_ml

 2.0 1.0 1.0 1.0

aws_s3

1.2 1.2 1.1 1.1
bloom 1.0 1.0 1.0 1.0
bool_plperl 1.3 1.3 1.3 1.3
btree_gin 1.3 1.3 1.3 1.3
btree_gist 1.6 1.6 1.6 1.6
citext 1.6 1.6 1.6 1.6
cube 1.5 1.5 1.5 1.5
dblink 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1
h3-pg 4.1.3 N/A N/A N/A
h3-postgis 4.1.3 N/A N/A N/A
hll 2.17 2.17 2.17 2.17
hstore 1.8 1.8 1.8 1.8
hstore_plperl 1.0 1.0 1.0 1.0
hypopg 1.4.0 N/A N/A N/A
ICU module 60.2 60.2 60.2 60.2

insert_username (contrib-spi)

 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1
intarray 1.5 1.5 1.5 1.5
ip4r 2.4 2.4 2.4 2.4
isn 1.2 1.2 1.2 1.2
jsonb_plperl 1.0 1.0 1.0 1.0
lo 1.1 1.1 1.1 1.1
log_fdw 1.3 1.3 1.3 1.3
ltree 1.2 1.2 1.2 1.2

moddatetime (contrib-spi)

 1.0 1.0 1.0 1.0
mysql_fdw 2.9.1 2.9.0 N/A N/A
oracle_fdw 2.6.0 2.5.0 2.5.0 2.5.0
orafce 4.6.0 4.3.0 4.0.0 4.0.0

pg_ad_mapping

 0.1 N/A N/A N/A
pg_bigm 1.2 1.2 1.2 1.2
pg_buffercache 1.3 1.3 1.3 1.3
pg_cron 1.6.0 1.5 1.5 1.4.2
pg_freespacemap 1.2 1.2 1.2 1.2
pg_hint_plan 1.5.1 1.5.0 1.5.0 1.5.0
pg_partman 4.7.3 4.7.3 4.7.3 4.6.0
pg_prewarm 1.2 1.2 1.2 1.2
pg_proctab 0.0.10 0.0.9 0.0.9 0.0.9
pg_repack 1.4.8 1.4.8 1.4.8 1.4.8
pg_similarity 1.0 1.0 1.0 1.0
pg_stat_statements 1.10 1.10 1.10 1.10
pg_tle 1.2.0 1.1.1 1.0.3 1.0.1
pg_trgm 1.6 1.6 1.6 1.6
pg_visibility 1.2 1.2 1.2 1.2
pgAudit 1.7.0 1.7.0 1.7.0 1.7.0
pgcrypto 1.3 1.3 1.3 1.3
pglogical 2.4.3 2.4.3 2.4.2 2.4.2

pglogical_origin

 1.0.0 1.0.0 1.0.0 1.0.0
pgrouting 3.4.1 3.4.1 3.4.1 3.4.1
pgrowlocks 1.2 1.2 1.2 1.2
pgstattuple 1.5 1.5 1.5 1.5
pgtap 1.2.0 1.2.0 1.2.0 1.2.0
pgvector 0.5.1 0.5.0 0.4.1 N/A
plcoffee 3.1.8 3.1.6 3.1.6 3.1.4
plls 3.1.8 3.1.6 3.1.6 3.1.4
plperl 1.0 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0
plprofiler 4.1 4.1 4.1 4.1
pltcl 1.0 1.0 1.0 1.0
plv8 3.1.8 3.1.6 3.1.6 3.1.4
PostGIS 3.4.0 3.3.3 3.3.2 3.3.2
postgis_raster 3.4.0 3.3.3 3.3.2 3.3.2
postgis_tiger_geocoder 3.4.0 3.3.3 3.3.2 3.3.2
postgis_topology 3.4.0 3.3.3 3.3.2 3.3.2
postgres_fdw 1.1 1.1 1.1 1.1
prefix 1.2.10 1.2.0 1.2.0 1.2.0
rdkit 4.4.0 (Release_2023_09_1) 4.3 4.2 4.2
rds_activity_stream 1.6 1.6 1.6 1.6
rds_tools 1.0 1.0 1.0 1.0

refint (contrib-spi)

 1.0 1.0 1.0 1.0
SEG 1.4 1.4 1.4 1.4
sslinfo 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0
TCN 1.0 1.0 1.0 1.0
tds_fdw 2.0.3 2.0.3 2.0.3 2.0.3
tsm_system_rows 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1
wal2json 2.5 2.5 2.5 2.5

Extensions supported for Aurora PostgreSQL 14

The following table shows the PostgreSQL extension versions that are currently supported on Aurora PostgreSQL 14 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension in the PostgreSQL documentation.

Extension 14.10 14.9 14.8 14.7 14.6 14.5 14.4 14.3
address_standardizer 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.2.3 3.1.7
address_standardizer_data_us 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.2.3 3.1.7

amcheck

 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3

apg_plan_mgmt

 2.4 2.4 2.4 2.4 2.4 2.3 2.2 2.2
aurora_stat_utils 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
auto_explain Yes Yes Yes Yes Yes Yes Yes Yes

autoinc (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
aws_commons 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
aws_lambda 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_ml

 2.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_s3

1.2 1.2 1.1 1.1 1.1 1.1 1.1 1.1
bloom 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
bool_plperl 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
btree_gin 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
btree_gist 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
citext 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
cube 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
dblink 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
h3-pg 4.1.3 N/A N/A N/A N/A N/A N/A N/A
h3-postgis 4.1.3 N/A N/A N/A N/A N/A N/A N/A
hll 2.17 2.17 2.17 2.17 2.16 2.16 2.16 2.16
hstore 1.8 1.8 1.8 1.8 1.8 1.8 1.8 1.8
hstore_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
hypopg 1.4.0 N/A N/A N/A N/A N/A N/A N/A
ICU module 60.2 60.2 60.2 60.2 60.2 60.2 60.2 60.2

insert_username (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
intarray 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
ip4r 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4
isn 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
jsonb_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
lo 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
log_fdw 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
ltree 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2

moddatetime (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
mysql_fdw 2.9.1 2.9.0 N/A N/A N/A N/A N/A N/A
oracle_fdw 2.6.0 2.5.0 2.5.0 2.5.0 2.4.0 2.4.0 2.4.0 2.4.0
orafce 4.6.0 4.3.0 4.0.0 4.0.0 3.16 3.16 3.16 3.16

pg_ad_mapping

 0.1 N/A N/A N/A N/A N/A N/A N/A
pg_bigm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_buffercache 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_cron 1.6.0 1.5 1.5 1.4.2 1.4 1.4 1.4 1.4
pg_freespacemap 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_hint_plan 1.4.1 1.4.1 1.4.1 1.4.1 1.4 1.4 1.4 1.4
pg_partman 4.7.3 4.7.3 4.7.3 4.6.0 4.6.0 4.6.0 4.6.0 4.6.0
pg_prewarm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_proctab 0.0.10 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9
pg_repack 1.4.7 1.4.7 1.4.7 1.4.7 1.4.7 1.4.7 1.4.7 1.4.7
pg_similarity 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
pg_stat_statements 1.9 1.9 1.9 1.9 1.9 1.9 1.9 1.9
pg_tle 1.2.0 1.1.1 1.0.3 1.0.1 1.0.1 1.0.1 N/A N/A
pg_trgm 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
pg_visibility 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgAudit 1.6.1 1.6.1 1.6.1 1.6.1 1.6.1 1.6.1 1.6.1 1.6.1
pgcrypto 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pglogical 2.4.3 2.4.3 2.4.2 2.4.2 2.4.1 2.4.1 2.4.1 2.4.1

pglogical_origin

 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0
pgrouting 3.4.1 3.4.1 3.4.1 3.4.1 3.2.0 3.2.0 3.2.0 3.2.0
pgrowlocks 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgstattuple 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
pgtap 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0
pgvector 0.5.1 0.5.0 0.4.1 N/A N/A N/A N/A N/A
plcoffee 3.1.8 3.1.6 3.1.6 3.1.4 3.0.0 3.0.0 3.0.0 2.3.15
plls 3.1.8 3.1.6 3.1.6 3.1.4 3.0.0 3.0.0 3.0.0 2.3.15
plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plprofiler 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1
pltcl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plv8 3.1.8 3.1.6 3.1.6 3.1.4 3.0.0 3.0.0 3.0.0 2.3.15
PostGIS 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.2.3 3.1.7
postgis_raster 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.2.3 3.1.7
postgis_tiger_geocoder 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.2.3 3.1.7
postgis_topology 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.2.3 3.1.7
postgres_fdw 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
prefix 1.2.10 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0
rdkit 4.4.0 (Release_2023_09_1) 4.3 4.2 4.2 4.2 3.8 3.8 3.8
rds_activity_stream 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
rds_tools 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

refint (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
SEG 1.4 1.4 1.4 1.4 NA NA NA NA
sslinfo 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
TCN 1.0 1.0 1.0 1.0 NA NA NA NA
tds_fdw 2.0.3 2.0.3 2.0.3 2.0.2 2.0.2 2.0.2 2.0.2 2.0.2
tsm_system_rows 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
wal2json 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.4

Extensions supported for Aurora PostgreSQL 13

The following table shows the PostgreSQL extension versions that are currently supported on Aurora PostgreSQL 13 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension in the PostgreSQL documentation.

Extension 13.13 13.12 13.11 13.10 13.9 13.8 13.7 13.6 13.5 13.4
address_standardizer 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1.7
address_standardizer_data_us 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1.7

amcheck

 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2

apg_plan_mgmt

 2.4 2.4 2.4 2.4 2.4 2.3 2.2 2.2 2.2 2.2
aurora_stat_utils 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

autoinc (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

auto_explain

 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
aws_commons 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
aws_lambda 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_ml

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_s3

 1.2 1.2 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
bloom 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
bool_plperl 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
btree_gin 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
btree_gist 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
citext 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
cube 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
dblink 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
h3-pg 4.1.3 N/A N/A N/A N/A N/A N/A N/A N/A N/A
h3-postgis 4.1.3 N/A N/A N/A N/A N/A N/A N/A N/A N/A
hll 2.17 2.17 2.17 2.17 2.15 2.15 2.15 2.15 2.15 2.15
hstore 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7
hstore_plperl 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.0 1.0
hypopg 1.4.0 N/A N/A N/A N/A N/A N/A N/A N/A N/A

insert_username (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
intarray 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
ip4r 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4
isn 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
jsonb_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
lo 1.1 1.1 1.1 1.1 1.1 1.1 1.1 NA NA NA
log_fdw 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
ltree 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2

moddatetime (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
mysql_fdw 2.9.1 N/A N/A N/A N/A N/A N/A N/A N/A N/A
oracle_fdw 2.6.0 2.5.0 2.5.0 2.5.0 2.3.0 2.3.0 2.3.0 2.3.0 2.3.0 2.3.0
orafce 4.6.0 4.3.0 4.0.0 4.0.0 3.16 3.16 3.16 3.16 3.16 3.16
pg_bigm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_buffercache 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_cron 1.6.0 1.5 1.5 1.4.2 1.4 1.4 1.4 1.4 1.4 1.3
pg_freespacemap 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_hint_plan 1.3.9 1.3.8 1.3.8 1.3.8 1.3.7 1.3.7 1.3.7 1.3.7 1.3.7 1.3.7
pg_partman 4.7.3 4.7.3 4.7.3 4.5.1 4.5.1 4.5.1 4.5.1 4.5.1 4.5.1 4.5.1
pg_prewarm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_proctab 0.0.10 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9
pg_repack 1.4.7 1.4.7 1.4.7 1.4.7 1.4.6 1.4.6 1.4.6 1.4.6 1.4.6 1.4.6
pg_similarity 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
pg_stat_statements 1.8 1.8 1.8 1.8 1.8 1.8 1.8 1.8 1.8 1.8
pg_trgm 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
pg_visibility 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgAudit 1.5.1 1.5.1 1.5.1 1.5.1 1.5.1 1.5.1 1.5.1 1.5.1 1.5 1.5
pgcrypto 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pglogical 2.4.3 2.4.3 2.4.2 2.4.2 2.4.1 2.4.1 2.4.1 2.4.0 2.4.0 2.4.0

pglogical_origin

 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0
pgrouting 3.4.1 3.4.1 3.4.1 3.4.1 3.1.3 3.1.3 3.1.3 3.1.3 3.1.3 3.1.0
pgrowlocks 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgstattuple 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
pgtap 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0
pgvector 0.5.1 0.5.0 0.4.1 N/A N/A N/A N/A N/A N/A N/A
plcoffee 3.1.8 3.1.6 3.1.6 3.1.4 3.0.0 3.0.0 2.3.15 2.3.15 2.3.15 2.3.15
plls 3.1.8 3.1.6 3.1.6 3.1.4 3.0.0 3.0.0 2.3.15 2.3.15 2.3.15 2.3.15
plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plprofiler 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1
pltcl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plv8 3.1.8 3.1.6 3.1.6 3.1.4 3.0.0 3.0.0 2.3.15 2.3.15 2.3.15 2.3.15
PostGIS 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1.7
postgis_raster 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1.7
postgis_tiger_geocoder 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1.7
postgis_topology 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1.7
postgres_fdw 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
prefix 1.2.10 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0
rdkit 4.4.0 (Release_2023_09_1) 4.3 4.2 4.2 4.2 3.8 3.8 3.8 3.8 3.8
rds_activity_stream 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.3 1.3 1.3
rds_tools 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

refint (contrib-spi)

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
SEG 1.3 1.3 1.3 1.3 NA NA NA NA NA NA
sslinfo 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
TCN 1.0 1.0 1.0 1.0 NA NA NA NA NA NA
tds_fdw 2.0.3 2.0.3 2.0.3 2.0.2 2.0.2 2.0.2 2.0.2 2.0.2 N/A N/A
tsm_system_rows 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
wal2json 2.5 2.4 2.4 2.4 2.4 2.4 2.4 2.3 2.3 2.3

Extensions supported for Aurora PostgreSQL 12

The following table shows the PostgreSQL extension versions that are currently supported on Aurora PostgreSQL 12 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension in the PostgreSQL documentation.

Extension 12.17 12.16 12.15 12.14 12.13 12.12 12.11 12.10 12.9 12.8
address_standardizer 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
address_standardizer_data_us 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
amcheck 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2

apg_plan_mgmt

 2.4 2.4 2.4 2.4 2.4 2.3 2.2 2.2 2.2 2.2
aurora_stat_utils 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
auto_explain Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
aws_commons 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
aws_lambda 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_ml

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_s3

 1.2 1.2 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
bloom 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
btree_gin 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
btree_gist 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
citext 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
cube 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
dblink 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
hll 2.17 2.17 2.17 2.17 2.14 2.14 2.14 2.14 2.14 2.14
hstore 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
hstore_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
intarray 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
ip4r 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4
isn 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
jsonb_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
lo 1.1 1.1 1.1 1.1 1.1 1.1 1.1 NA NA NA
log_fdw 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
ltree 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
mysql_fdw 2.9.1 N/A N/A N/A N/A N/A N/A N/A N/A N/A
oracle_fdw 2.6.0 2.5.0 2.5.0 2.5.0 2.3.0 2.3.0 2.3.0 2.3.0 2.3.0 2.3.0
orafce 4.6.0 4.3.0 4.0.0 4.0.0 3.16 3.16 3.16 3.16 3.16 3.16
pg_bigm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_buffercache 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_cron 1.6.0 1.5 1.5 1.4.2 1.4.1 1.4.1 1.4.1 1.4.1 1.4.1 1.3.1
pg_freespacemap 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_hint_plan 1.3.9 1.3.8 1.3.8 1.3.8 1.3.7 1.3.7 1.3.7 1.3.7 1.3.5 1.3.5
pg_partman 4.7.3 4.7.3 4.7.3 4.5.1 4.5.1 4.5.1 4.5.1 4.5.1 4.5.1 4.5.1
pg_prewarm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_proctab 0.0.10 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9
pg_repack 1.4.7 1.4.7 1.4.7 1.4.7 1.4.5 1.4.5 1.4.5 1.4.5 1.4.5 1.4.5
pg_similarity 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
pg_stat_statements 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7
pg_trgm 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
pg_visibility 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgAudit 1.4.2 1.4.2 1.4.2 1.4.2 1.4.2 1.4.2 1.4.2 1.4 1.4 1.4
pgcrypto 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pglogical 2.4.3 2.4.3 2.4.2 2.4.2 2.4.1 2.4.1 2.4.0 2.4.0 2.4.0 2.3.2

pglogical_origin

 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0
pgrouting 3.4.1 3.4.1 3.4.1 3.4.1 3.0.3 3.0.3 3.0.3 3.0.3 3.0.3 3.0.3
pgrowlocks 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgstattuple 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
pgTAP 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0
pgvector 0.5.1 0.5.0 0.4.1 N/A N/A N/A N/A N/A N/A N/A
plcoffee 3.1.8 3.1.6 2.3.15 2.3.15 2.3.15 2.3.15 2.3.15 2.3.14 2.3.14 2.3.14
plls 3.1.8 3.1.6 2.3.15 2.3.15 2.3.15 2.3.15 2.3.15 2.3.14 2.3.14 2.3.14
plperl 1.2 1.2 1.2 1.2 1.2 1.2 1.0 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plprofiler 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1
pltcl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plv8 3.1.8 3.1.6 2.3.15 2.3.15 2.3.15 2.3.15 2.3.15 2.3.14 2.3.14 2.3.14
PostGIS 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgis_raster 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgis_tiger_geocoder 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgis_topology 3.4.0 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgres_fdw 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
prefix 1.2.10 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0
rdkit 4.4.0 (Release_2023_09_1) 4.3 4.2 4.2 4.2 3.8 3.8 3.8 3.8 3.8
rds_activity_stream 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
SEG 1.3 1.3 1.3 1.3 NA NA NA NA NA NA
sslinfo 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
TCN 1.0 1.0 1.0 1.0 NA NA NA NA NA NA
tds_fdw 2.0.3 2.0.3 2.0.3 N/A N/A N/A N/A N/A N/A N/A
tsm_system_rows 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
wal2json 2.5 2.5 2.5 2.5 2.4 2.4 2.4 2.3 2.3 2.3

Extensions supported for Aurora PostgreSQL 11

The following table shows PostgreSQL extension versions currently supported on Aurora PostgreSQL 11 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension.

Extension 11.21 11.20 11.19 11.18 11.17 11.16 11.15 11.14 11.13
address_standardizer 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
address_standardizer_data_us 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1

amcheck

 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
apg_plan_mgmt 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1
aurora_stat_utils 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
auto_explain Yes Yes Yes Yes Yes Yes Yes Yes Yes
aws_commons 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
aws_lambda 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_ml

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

aws_s3

1.2 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
bloom 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
btree_gin 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
btree_gist 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
citext 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
cube 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
dblink 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
hll 2.17 2.17 2.17 2.11 2.11 2.11 2.11 2.11 2.11
hstore 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
hstore_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
intarray 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
ip4r 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2
isn 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
jsonb_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
lo 1.1 1.1 1.1 1.1 1.1 1.1 NA NA NA
log_fdw 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
ltree 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
orafce 4.3.0 4.0.0 4.0.0 3.16 3.16 3.16 3.16 3.16 3.16
pg_bigm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_buffercache 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_freespacemap 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_hint_plan 1.3.8 1.3.8 1.3.8 1.3.7 1.3.7 1.3.7 1.3.7 1.3.7 1.3.5
pg_prewarm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_proctab 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9 0.0.9
pg_repack 1.4.6 1.4.6 1.4.6 1.4.4 1.4.4 1.4.4 1.4.4 1.4.4 1.4.4
pg_similarity 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
pg_stat_statements 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6
pg_trgm 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
pg_visibility 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgAudit 1.3.3 1.3.3 1.3.3 1.3.3 1.3.3 1.3.3 1.3.3 1.3.1 1.3.1
pgcrypto 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pglogical 2.4.3 2.4.2 2.4.2 2.4.1 2.4.1 2.4.1 2.4.0 2.4.0 2.4.0

pglogical_origin

 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0
pgrouting 3.4.1 3.4.1 3.4.1 2.6.3 2.6.3 2.6.3 2.6.3 2.6.3 2.6.3
pgrowlocks 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgstattuple 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
pgTAP 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0 1.1.0
plcoffee 3.1.6 2.3.15 2.3.15 2.3.15 2.3.15 2.3.15 2.3.14 2.3.14 2.3.14
plls 3.1.6 2.3.15 2.3.15 2.3.15 2.3.15 2.3.15 2.3.14 2.3.14 2.3.14
plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plprofiler 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1
pltcl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plv8 3.1.6 2.3.15 2.3.15 2.3.15 2.3.15 2.3.15 2.3.14 2.3.14 2.3.14
PostGIS 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgis_tiger_geocoder 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgis_topology 3.3.3 3.3.2 3.3.2 3.2.3 3.2.3 3.1.7 3.1.7 3.1.7 3.1
postgres_fdw 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
prefix 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0
rdkit 4.3 4.2 4.2 4.2 3.8 3.8 3.8 3.8 3.8
rds_activity_stream 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
SEG 1.0 1.0 1.0 NA NA NA NA NA NA
sslinfo 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
TCN 1.0 1.0 1.0 NA NA NA NA NA NA
tds_fdw 2.0.3 2.0.3 N/A N/A N/A N/A N/A N/A N/A
tsm_system_rows 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
wal2json 2.5 2.5 2.5 2.4 2.4 2.4 2.3 2.3 2.3

Extensions supported for Aurora PostgreSQL 10

The following table shows PostgreSQL extension versions currently supported on Aurora PostgreSQL 10 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension.

Note

  • The adminpack extension is no longer supported because it accesses the file system.

  • The plperlu extension is no longer supported because it is an untrusted language extension.

  • The pltclu extension is no longer supported because it is an untrusted language extension.

Extension 10.21 10.20 10.19 10.18 10.17 10.16 10.14 10.13 10.12 10.11 10.7 10.6 10.5 10.4
address_standardizer 3.1.7 3.1.7 3.1.7 3.1 2.4.7 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4
address_standardizer_data_us 3.1.7 3.1.7 3.1.7 3.1 2.4.7 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4

adminpack

 NA NA NA NA NA NA NA NA NA NA NA 1.1 1.1 1.1

amcheck

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
apg_plan_mgmt 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 1.0.1 1.0.1 1.0.1 0.1

aurora_stat_utils

 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

auto_explain

 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

aws_commons

 1.2 1.2 1.2 1.2 1.2 1.2 1.1 1.1 1.1 1.1 1.0 1.0 NA NA
aws_ml 1.0 1.0 1.0 1.0 1.0 1.0 1.0 NA NA NA NA NA NA NA

aws_s3

1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.0 1.0 NA NA
bloom 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
btree_gin 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
btree_gist 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
chkpass 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
citext 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
cube 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dblink 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
hll 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10
hstore 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
hstore_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
hstore_plperlu 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
intarray 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
ip4r 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1
isn 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
lo 1.1 NA NA NA NA NA NA NA NA NA NA NA NA NA
log_fdw 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
ltree 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
orafce 3.16 3.16 3.16 3.16 3.16 3.8 3.8 3.8 3.8 3.6 3.6 3.6 3.6 3.6
pg_buffercache 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_freespacemap 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_hint_plan 1.3.6 1.3.6 1.3.6 1.3.5 1.3.5 1.3.5 1.3.5 1.3.5 1.3.3 1.3.3 1.3.1 1.3.1 1.3.1 1.3.0
pg_prewarm 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
pg_repack 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3
pg_similarity 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 NA
pg_stat_statements 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.5 1.5
pg_trgm 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_visibility 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgAudit 1.2.3 1.2.3 1.2.1 1.2.1 1.2.1 1.2.1 1.2.1 1.2.1 1.2 1.2 1.2 1.2 1.2 1.2
pgcrypto 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pglogical 2.4.1 2.4.0 2.4.0 2.4.0 2.2.2 2.2.2 2.2.2 2.2.2 NA NA NA NA NA NA
pglogical_origin 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 1.0.0 NA NA NA NA NA NA
pgrouting 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2 2.5.2
pgrowlocks 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgstattuple 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
plcoffee 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2
plls 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2
plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plperlu NA NA NA NA NA NA NA NA NA NA NA 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plprofiler 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 NA NA NA NA
pltcl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
pltclu NA NA NA NA NA NA NA NA NA NA NA 1.0 1.0 1.0
plv8 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.3.14 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2
PostGIS 3.1.7 3.1.7 3.1.7 3.1 2.4.7 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4
postgis_tiger_geocoder 3.1.7 3.1.7 3.1.7 3.1 2.4.7 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4
postgis_topology 3.1.7 3.1.7 3.1.7 3.1 2.4.7 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4 2.4.4
postgres_fdw 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
prefix 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0
rdkit 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 NA NA NA NA NA NA
rds_activity_stream 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 NA
sslinfo 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsearch2 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_rows 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
wal2json 2.4 2.3 2.3 2.3 2.3 2.3 2.3 2.3 2.3 2.1 2.1 NA NA NA

Extensions supported for Aurora PostgreSQL 9.6

The following table shows PostgreSQL extension versions supported on Aurora PostgreSQL 9.6 versions. "NA" indicates that the extension isn't available for that PostgreSQL version. For more information about PostgreSQL extensions, see Packaging Related Objects into an Extension.

Note

  • The apgcc RDS for PostgreSQL internal extension is no longer supported.

  • The apgunit RDS for PostgreSQL internal extension is no longer supported.

  • The pageinspect extension is no longer publicly supported by RDS for PostgreSQL.

  • The xml2 extension is no longer supported by PostgreSQL.

Extension 9.6.22 9.6.21 9.6.19 9.6.18 9.6.17 9.6.16 9.6.12 9.6.11 9.6.0 9.6.8 9.6.6 9.6.3
address_standardizer 2.3.9 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.4 2.3.4 2.3.4
address_standardizer_data_us 2.3.9 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.4 2.3.4 2.3.4
apg_plan_mgmt 1.0.1 1.0.1 2.0 2.0 2.0 2.0 2.0 2.0 NA NA NA 0.1
apgcc NA NA NA NA NA NA NA NA NA NA 1.0 1.0
apgunit NA NA NA NA NA NA NA NA NA NA 1.0 1.0
aurora_stat_utils 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
auto_explain Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
bloom 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
btree_gin 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
btree_gist 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
chkpass 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
citext 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
cube 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dblink 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
dict_int 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
dict_xsyn 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
earthdistance 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
fuzzystrmatch 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
hll 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 2.10 NA
hstore 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
hstore_plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
intagg 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
intarray 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
ip4r 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.0 2.0 2.0
isn 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
log_fdw 1.0 1.0 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
ltree 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
orafce 3.6 3.6 3.6 3.6 3.6 3.6 3.8 3.8 3.8 3.8 3.16 NA
pageinspect NA NA NA NA NA NA NA NA NA NA 1.5 1.5
pg_buffercache 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pg_freespacemap 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
pg_hint_plan 1.2.2 1.2.2 1.2.3 1.2.3 1.2.5 1.2.5 1.2.6 1.2.6 1.2.6 1.2.6 1.1.3 1.1.3
pg_prewarm 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
pg_repack 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.3 1.4.2 1.4.2 1.4.0
pg_similarity 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 NA NA NA NA
pg_stat_statements 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
pg_trgm 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pg_visibility 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
pgAudit 1.1.1 1.1.1 1.1.1 1.1.1 1.1.1 1.1.1 1.1.2 1.1.2 1.1.2 1.0 1.0 1.0
pgcrypto 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3
pgrouting 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2 2.4.2
pgrowlocks 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
pgstattuple 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
plcoffee 2.3.14 2.3.14 2.3.14 2.3.14 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2 2.1.0 1.5.3 1.5.3
plls 2.3.14 2.3.14 2.3.14 2.3.14 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2 2.1.0 1.5.3 1.5.3
plperl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plpgsql 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
pltcl 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
plv8 2.3.14 2.3.14 2.3.14 2.3.14 2.1.2 2.1.2 2.1.2 2.1.2 2.1.2 2.1.0 1.5.3 1.5.3
PostGIS 2.3.9 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.4 2.3.4 2.3.4
postgis_tiger_geocoder 2.3.9 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.4 2.3.4 2.3.4
postgis_topology 2.3.9 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.7 2.3.4 2.3.4 2.3.4
postgres_fdw 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
prefix 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 1.2.0 NA
sslinfo 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2
tablefunc 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsearch2 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_rows 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
tsm_system_time 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
unaccent 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
uuid-ossp 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1
xml2 NA NA NA NA NA NA NA NA NA NA 1.1 1.1

Aurora PostgreSQL apg_plan_mgmt extension versions

The AWS apg_plan_mgmt extension provides your Aurora PostgreSQL DB cluster with the query plan management feature. It allows you to manage the query execution plans generated by the optimizer for your SQL applications for better stability and to prevent regressions. For more information, see Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.

Version 2.6 of the Aurora PostgreSQL apg_plan_mgmt extension

Improvements to the apg_plan_mgmt extension in version 2.6 include the following:

New extension features in Aurora PostgreSQL 16.1, 15.5 and 14.10

  • Plan outlines will be updated to the latest format version as part of the update_plan_hash action for apg_plan_mgmt.validate_plans function.

  • Added support for parallel Append enforcement as a part of Parallel Query Enforcement. To enforce parallel append nodes correctly, you must do the following:

    1. Set apg_plan_mgmt.plan_hash_version to 5.

    2. Call apg_plan_mgmt.validate_plans('update_plan_hash').

Extension improvements in Aurora PostgreSQL 16.1, 15.5 and 14.10

  • Performance improvement in plan hash calculation.

  • Enhanced memory utilization for plan outlines that contain repetitive subplans.

  • Fixed an issue in parallel query enforcement where GatherMerge could not be enforced.

  • Fixed an issue where estimated cost of enforced plan was incorrect.

  • Fixed an issue in enforcement of approved plans where the outline contains partitioned tables and subplans.

New extension features in Aurora PostgreSQL 13.13

  • Plan outlines will be updated to the latest format version as part of the update_plan_hash action for apg_plan_mgmt.validate_plans function.

  • Added support for parallel Append enforcement as a part of Parallel Query Enforcement. To enforce parallel append nodes correctly, you must do the following:

    1. Set apg_plan_mgmt.plan_hash_version to 5.

    2. Call apg_plan_mgmt.validate_plans('update_plan_hash').

Extension improvements in Aurora PostgreSQL 13.13

  • Enhanced memory utilization for plan outlines that contain repetitive subplans.

  • Fixed an issue in parallel query enforcement where GatherMerge could not be enforced.

  • Fixed an issue where estimated cost of enforced plan was incorrect.

  • Fixed an issue in enforcement of approved plans where the outline contains partitioned tables and subplans.

New extension features in Aurora PostgreSQL 12.17

  • Plan outlines will be updated to the latest format version as part of the update_plan_hash action for apg_plan_mgmt.validate_plans function.

Version 2.5 of the Aurora PostgreSQL apg_plan_mgmt extension

Improvements to the apg_plan_mgmt extension in version 2.5 include the following:

New extension features in Aurora PostgreSQL 15.4 and 14.9

  • QPM can enforce query plans to have parallel operators except Parallel Append node. To enforce parallel query plans correctly, you must do the following after upgrading to 15.4 or 14.9:

    • Set apg_plan_mgmt.plan_hash_version to 4 or above.

    • Call apg_plan_mgmt.validate_plans('update_plan_hash').

    • Re-capture approved plans that has Gather node in plan_outline.

  • QPM can enforce query plans with Materialize nodes. To enforce Materialize nodes, you must do the following after upgrading to 15.4 or 14.9:

    • Set apg_plan_mgmt.plan_hash_version to 4 or above.

    • Call apg_plan_mgmt.validate_plans('update_plan_hash').

  • To capture query plans from Replicas, you must update apg_plan_mgmt extension by calling ALTER EXTENSION apg_plan_mgmt UPDATE.

  • You need to specify apg_plan_mgmt.plan_capture_threshold in order to not allow QPM to capture any query plans.

Extension improvements in Aurora PostgreSQL 15.4 and 14.9

  • Performance improvement on plan_hash calculation

New extension features in Aurora PostgreSQL 13.12

  • QPM can enforce query plans to have parallel operators except Parallel Append node. To enforce parallel query plans correctly, you must do the following after upgrading to 15.4 or 14.9:

    • Set apg_plan_mgmt.plan_hash_version to 4 or above.

    • Call apg_plan_mgmt.validate_plans('update_plan_hash').

    • Re-capture approved plans that has Gather node in plan_outline.

  • To capture query plans from Replicas, you must update apg_plan_mgmt extension by calling ALTER EXTENSION apg_plan_mgmt UPDATE.

  • You need to specify apg_plan_mgmt.plan_capture_threshold in order to not allow QPM to capture any query plans.

New extension features in Aurora PostgreSQL 12.16

  • To capture query plans from Replicas, you must update apg_plan_mgmt extension by calling ALTER EXTENSION apg_plan_mgmt UPDATE.

  • You need to specify apg_plan_mgmt.plan_capture_threshold in order to not allow QPM to capture any query plans.

Version 2.4 of the Aurora PostgreSQL apg_plan_mgmt extension

Improvements to the apg_plan_mgmt extension in version 2.4 include the following:

New extension features in Aurora PostgreSQL 15.3 and 14.8

  • Introduced a new GUC auto_explain.hashes. When it is set to true (default: false), sql_hash and plan_hash are shown at the end of auto explain result.

  • Introduced a new GUC apg_plan_mgmt.explain_hashes. When it is set to true (default: false), EXPLAIN result shows sql_hash and plan_hash even without hashes true option.

  • Introduced a new GUC apg_plan_mgmt.log_plan_enforcement_result. Depending on its value (default: none), plan enforcement results are written to Postgres log files.

  • Introduced a new plan hash calculation version to support partitioned tables. Users need to set apg_plan_mgmt.plan_hash_version to 3 and call apg_plan_mgmt.validate_plans('update_plan_hash') in each database with apg_plan_mgmt installed and entries in the plans table.

  • QPM can enforce query plans with Memoize nodes.

Extension improvements in Aurora PostgreSQL 15.3 and 14.8

  • Fixed an issue with JDBC prepared statements plan enforcement.

  • Improved parity regarding queryid between pg_stat_statements and apg_plan_mgmt.dba_plans.

  • Fixed a plan enforcement issue when index names end with digits.

New extension features in Aurora PostgreSQL 13.11

  • Introduced a new GUC auto_explain.hashes. When it is set to true (default: false), sql_hash and plan_hash are shown at the end of auto explain result.

  • Introduced a new GUC apg_plan_mgmt.explain_hashes. When it is set to true (default: false), EXPLAIN result shows sql_hash and plan_hash even without hashes true option.

  • Introduced a new GUC apg_plan_mgmt.log_plan_enforcement_result. Depending on its value (default: none), plan enforcement results are written to Postgres log files.

  • Introduced a new plan hash calculation version to support partitioned tables. Users need to set apg_plan_mgmt.plan_hash_version to 3 and call apg_plan_mgmt.validate_plans('update_plan_hash') in each database with apg_plan_mgmt installed and entries in the plans table.

Extension improvements in Aurora PostgreSQL 13.11

  • Fixed an issue with JDBC prepared statements plan enforcement.

  • Fixed a plan enforcement issue when index names end with digits.

New extension features in Aurora PostgreSQL 12.15

  • Introduced a new GUC auto_explain.hashes. When it is set to true (default: false), sql_hash and plan_hash are shown at the end of auto explain result.

  • Introduced a new GUC apg_plan_mgmt.explain_hashes. When it is set to true (default: false), EXPLAIN result shows sql_hash and plan_hash even without hashes true option.

  • Introduced a new GUC apg_plan_mgmt.log_plan_enforcement_result. Depending on its value (default: none), plan enforcement results are written to Postgres log files.

Extension improvements in Aurora PostgreSQL 12.15

  • Fixed an issue with JDBC prepared statements plan enforcement.

  • Fixed a plan enforcement issue when index names end with digits.

Improvements to the apg_plan_mgmt extension in version 2.4 prior to Aurora PostgreSQL 15.3, 14.8, 13.11, and 12.15 includes the following:

New extension features

  • The apg_plan_mgmt.copy_outline function can take a new 5th argument, force_update_target_plan_hash. If it is set to true, the target plan hash will be updated even though the source plan isn't reproducible for the target sql_hash.

Extension improvements

  • The apg_plan_mgmt.copy_outline function now copies environment_variables.

  • The minimum value of apg_plan_mgmt.plan_retention_period changes to 1 from 32.

  • The query plan management can now save plans for queries in read-only transactions from the writer nodes.

  • Fixed an issue in the apg_plan_mgmt.evolve_plan_baselines function.

  • Fixed an issue that could cause unavailability when the apg_plan_mgmt is enabled.

To learn how to install, upgrade, and use the apg_plan_mgmt extension, see Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.

Version 2.3 of the Aurora PostgreSQL apg_plan_mgmt extension

Improvements to the apg_plan_mgmt extension in version 2.3 includes the following:

New extension features

  • Support for a new function, the apg_plan_mgmt.copy_outline function. This function allows you to copy a plan hash and a plan outline from one SQL hash and plan hash to another. Use this function when you want to copy a plan that uses hints to other similar statements without using the in-line hint statement at every occurrence. If the update to the query results in an invalid plan, the function raises an error and rolls back the update. For more information, see Function reference for Aurora PostgreSQL query plan management in the Amazon Aurora User Guide.

Extension improvements

  • The query plan management feature now saves plans for queries that are inside procedures and DO-blocks. For versions of apg_plan_mgmt older than version 2.3, this has been a limitation.

To learn how to install, upgrade, and use the apg_plan_mgmt extension, see Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.

Version 2.1 of the Aurora PostgreSQL apg_plan_mgmt extension

Improvements to the apg_plan_mgmt extension in version 2.1 for Aurora PostgreSQL 11.20 includes the following:

New extension features in Aurora PostgreSQL 11.20

  • Introduced a new GUC apg_plan_mgmt.log_plan_enforcement_result. Depending on its value (default: none), plan enforcement results are written to Postgres log files.

Extension improvements in Aurora PostgreSQL 11.20

  • Fixed an issue with JDBC prepared statements plan enforcement.

To learn how to install, upgrade, and use the apg_plan_mgmt extension, see Managing query execution plans for Aurora PostgreSQL in the Amazon Aurora User Guide.

Version 2.0 of the Aurora PostgreSQL apg_plan_mgmt extension

The apg_plan_mgmt extension changes for version 2.0 include the following:

New extension features

  1. You can now manage all queries inside SQL functions, whether they have parameters or not.

  2. You can now manage all queries inside PL/pgSQL functions, whether they have parameters or not.

  3. You can now manage queries in generic plans, whether they have parameters or not. To learn more about generic plans versus custom plans, see the PREPARE statement in the PostgreSQL documentation.

  4. You can now use query plan management to enforce the use of specific types of aggregate methods in query plans.

Extension improvements

  1. You can now save plans with a size up to 8KB times the setting of the max_worker_processes parameter. Previously the maximum plan size was 8KB.

  2. Fixed bugs for unnamed prepared statements such as those from JDBC.

  3. Previously, when you tried to do CREATE EXTENSION apg_plan_mgmt when it is not loaded in the shared_preload_libraries, the PostgreSQL backend connection was dropped. Now, an error message prints and the connection is not dropped.

  4. The default value of the cardinality_error in the apg_plan_mgmt.plans table is NULL, but it can be set to -1 during the apg_plan_mgmt.evolve_plan_baselines function. NULL is now used consistently.

  5. Plans are now saved for queries that refer to temporary tables.

  6. The default maximum number of plans is increased from 1000 to 10000.

  7. The following pgss parameters are deprecated because the automatic plan capture mode should be used instead of those parameters.

    • apg_plan_mgmt.pgss_min_calls

    • apg_plan_mgmt.pgss_min_mean_time_ms

    • apg_plan_mgmt.pgss_min_stddev_time_ms

    • apg_plan_mgmt.pgss_min_total_time_ms

Version 1.0.1 of the Aurora PostgreSQL apg_plan_mgmt extension

The apg_plan_mgmt extension changes for version 1.0.1 include the following:

New extension features

  1. The validate_plans function has a new action value called update_plan_hash. This action updates the plan_hash ID for plans that can't be reproduced exactly. The update_plan_hash value also allows you to fix a plan by rewriting the SQL. You can then register the good plan as an Approved plan for the original SQL. Following is an example of using the update_plan_hash action.

    UPDATE apg_plan_mgmt.plans SET plan_hash = new _plan_hash, plan_outline = good_plan_outline
   WHERE sql_hash = bad_plan_sql_hash AND plan_hash = bad_plan_plan_hash;
SELECT apg_plan_mgmt.validate_plans(bad_plan_sql_hash, bad_plan_plan_hash, 'update_plan_hash');
SELECT apg_plan_mgmt.reload();

  2. A new get_explain_stmt function is available that generates the text of an EXPLAIN statement for the specified SQL statement. It includes the parameters sql_hash, plan_hash and explain_options.

    The parameter explain_options can be any comma-separated list of valid EXPLAIN options, as shown following.

    analyze,verbose,buffers,hashes,format json

    If the parameter explain_options is NULL or an empty string, the get_explain_stmt function generates a simple EXPLAIN statement.

    To create an EXPLAIN script for your workload or a portion of it, use the \a , \t, and \o options to redirect the output to a file. For example, you can create an EXPLAIN script for the top-ranked (top-K) statements by using the PostgreSQL pg_stat_statements view sorted by total_time in DESC order.

  3. The precise location of the Gather parallel query operator is determined by costing, and may change slightly over time. To prevent these differences from invalidating the entire plan, query plan management now computes the same plan_hash even if the Gather operators move to different places in the plan tree.

  4. Support is added for nonparameterized statements inside pl/pgsql functions.

  5. Overhead is reduced when the apg_plan_mgmt extension is installed on multiple databases in the same cluster while two or more databases are being accessed concurrently. Also, this release fixed a bug in this area that caused plans to not be stored in shared memory.

Extension improvements

  1. Improvements to the evolve_plan_baselines function.

    1. The evolve_plan_baselines function now computes a cardinality_error metric over all nodes in the plan. Using this metric, you can identify any plan where the cardinality estimation error is large, and the plan quality is more doubtful. Long-running statements with high cardinality_error values are high-priority candidates for query tuning.

    2. Reports generated by evolve_plan_baselines now include sql_hash, plan_hash, and the plan status.

    3. You can now allow evolve_plan_baselines to approve previously Rejected plans.

    4. The meaning of speedup_factor for evolve_plan_baselines is now always relative to the baseline plan. For example, a value of 1.1 now means 10 percent faster than the baseline plan. A value of 0.9 means 10 percent slower than the baseline plan. The comparison is made using running time alone instead of total time.

    5. The evolve_plan_baselines function now warms the cache in a new way. It does this by running the baseline plan, then running the baseline plan one more time, and then running the candidate plan once. Previously, evolve_plan_baselines ran the candidate plan twice. This approach added significantly to running time, especially for slow candidate plans. However, running the candidate plan twice is more reliable when the candidate plan uses an index that isn't used in the baseline plan.

  2. Query plan management no longer saves plans that refer to system tables or views, temporary tables, or the query plan management's own tables.

  3. Bug fixes include caching a plan immediately when saved and fixing a bug that caused the back end to terminate.