PG COLLECTOR V2.6

DB INFO

PG Hostname / PG RDS ENDPOINT: testdb-instance-1.cimdlffuw.us-west-2.rds.amazonaws.com

Date DB_START_DATE UP_TIME DB_connected user_name DB_PORT DB_Version block_size
2020-10-16 02:15:46.166516+00 2020-10-11 09:06:39.141468+00 4 days 17:09:07.025048 testdb sys 8200 PostgreSQL 10.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit 8192


List of databases
Name Owner Encoding Collate Ctype Access privileges
testdb sys UTF8 en_US.UTF-8 en_US.UTF-8 =Tc/sys
sys=CTc/sys
iam_testdb=c/sys
test_testdb=c/sys
app_ro=c/sys
app_rw=c/sys
postgres sys UTF8 en_US.UTF-8 en_US.UTF-8  
rdsadmin rdsadmin UTF8 en_US.UTF-8 en_US.UTF-8 rdsadmin=CTc/rdsadmin
template0 rdsadmin UTF8 en_US.UTF-8 en_US.UTF-8 =c/rdsadmin
rdsadmin=CTc/rdsadmin
template1 sys UTF8 en_US.UTF-8 en_US.UTF-8 =c/sys
sys=CTc/sys

database_name database_is_template database_allow_connections database_connection_limit datlastsysoid datfrozenxid datminmxid
template0 t f -1 13933 549 1
rdsadmin f t -1 13933 549 1
template1 t t -1 13933 549 1
postgres f t -1 13933 549 1
testdb f t -1 13933 549 1


INFO
Database size DB parameters Transaction ID TXID Table Size
Index Size Vacuum & Statistics Extensions Memory setting
pg_stat_statements extension Users & Roles Info schema Info Tablespaces Info
Tabel Access Profile Unused Indexes Index Access Profile Fragmentation (Bloat)
Toast Tables Mapping Replication slot active sessions monitor Orphaned prepare transactions
PK or FK using numeric or integer data type public Schema invalid indexes Default access privileges
pgaudit extension Unlogged Tables Access privileges ******



Database size
database_name database_size
template0 7817 kB
rdsadmin 8786 kB
template1 7954 kB
postgres 7951 kB
testdb 14 GB
[Top]

Transaction ID TXID

oldest_current_xid
18873751

database_name oldest_current_xid_per_db
template0 18873751
rdsadmin 18873751
template1 18873751
postgres 18873751
testdb 18873751

oldest_current_xid percent_towards_wraparound percent_towards_emergency_autovac
18873751 1 9

which tables are aging :

relation_name age table_size relkind
pg_attribute 18873751 520 kB r
pg_user_mapping 18873751 0 bytes r
pg_statistic 18873751 440 kB r
pg_subscription 18873751 0 bytes r
pg_toast.pg_toast_2604 18873751 0 bytes t
pg_toast.pg_toast_2606 18873751 0 bytes t
pg_toast.pg_toast_2609 18873751 0 bytes t
pg_toast.pg_toast_1255 18873751 0 bytes t
pg_type 18873751 120 kB r
pg_toast.pg_toast_3596 18873751 0 bytes t
pg_toast.pg_toast_2619 18873751 56 kB t
pg_toast.pg_toast_3381 18873751 0 bytes t
pg_toast.pg_toast_2620 18873751 0 bytes t
pg_toast.pg_toast_2396 18873751 0 bytes t
pg_toast.pg_toast_2964 18873751 0 bytes t
pg_toast.pg_toast_3592 18873751 0 bytes t
pg_policy 18873751 0 bytes r
pg_authid 18873751 40 kB r
pg_toast.pg_toast_2618 18873751 456 kB t
pg_proc 18873751 664 kB r
[Top]

Table Size


Table Size order by schema name and table name:

oid table_schema table_name row_estimate total_bytes index_bytes toast_bytes table_bytes total_pretty index_pretty toast_pretty table_pretty
32867 app_schema app_data_table 30000 504299520 502939648   1359872 481 MB 480 MB   1328 kB
32841 app_schema test 0 0 0   0 0 bytes 0 bytes   0 bytes
32844 app_schema test_2 0 0 0   0 0 bytes 0 bytes   0 bytes
32848 app_schema test_3 0 0 0   0 0 bytes 0 bytes   0 bytes
13769 information_schema sql_features 671 98304 0 8192 90112 96 kB 0 bytes 8192 bytes 88 kB
13774 information_schema sql_implementation_info 12 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13779 information_schema sql_languages 4 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13784 information_schema sql_packages 10 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13789 information_schema sql_parts 9 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13794 information_schema sql_sizing 23 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13799 information_schema sql_sizing_profiles 0 8192 0 8192 0 8192 bytes 0 bytes 8192 bytes 0 bytes
2600 pg_catalog pg_aggregate 138 65536 16384   49152 64 kB 16 kB   48 kB
2601 pg_catalog pg_am 6 73728 32768   40960 72 kB 32 kB   40 kB
2602 pg_catalog pg_amop 709 196608 114688   81920 192 kB 112 kB   80 kB
2603 pg_catalog pg_amproc 411 131072 65536   65536 128 kB 64 kB   64 kB
2604 pg_catalog pg_attrdef 0 57344 32768 8192 16384 56 kB 32 kB 8192 bytes 16 kB
1249 pg_catalog pg_attribute 3002 770048 237568   532480 752 kB 232 kB   520 kB
1261 pg_catalog pg_auth_members 3 73728 32768   40960 72 kB 32 kB   40 kB
1260 pg_catalog pg_authid 6 73728 32768   40960 72 kB 32 kB   40 kB
2605 pg_catalog pg_cast 219 81920 32768   49152 80 kB 32 kB   48 kB
1259 pg_catalog pg_class 341 245760 122880   122880 240 kB 120 kB   120 kB
3456 pg_catalog pg_collation 1645 614400 163840   450560 600 kB 160 kB   440 kB
2606 pg_catalog pg_constraint 2 114688 65536 8192 40960 112 kB 64 kB 8192 bytes 40 kB
2607 pg_catalog pg_conversion 132 106496 49152   57344 104 kB 48 kB   56 kB
1262 pg_catalog pg_database 2 73728 32768   40960 72 kB 32 kB   40 kB
2964 pg_catalog pg_db_role_setting 0 40960 16384 8192 16384 40 kB 16 kB 8192 bytes 16 kB
826 pg_catalog pg_default_acl 0 40960 32768   8192 40 kB 32 kB   8192 bytes
2608 pg_catalog pg_depend 7327 1261568 761856   499712 1232 kB 744 kB   488 kB
2609 pg_catalog pg_description 4635 565248 196608 8192 360448 552 kB 192 kB 8192 bytes 352 kB
3501 pg_catalog pg_enum 0 24576 24576   0 24 kB 24 kB   0 bytes
3466 pg_catalog pg_event_trigger 0 49152 32768   16384 48 kB 32 kB   16 kB
3079 pg_catalog pg_extension 1 73728 32768   40960 72 kB 32 kB   40 kB
2328 pg_catalog pg_foreign_data_wrapper 0 49152 32768   16384 48 kB 32 kB   16 kB
1417 pg_catalog pg_foreign_server 0 49152 32768   16384 48 kB 32 kB   16 kB
3118 pg_catalog pg_foreign_table 0 32768 16384   16384 32 kB 16 kB   16 kB
2610 pg_catalog pg_index 134 98304 32768   65536 96 kB 32 kB   64 kB
2611 pg_catalog pg_inherits 0 16384 16384   0 16 kB 16 kB   0 bytes
3394 pg_catalog pg_init_privs 149 65536 16384   49152 64 kB 16 kB   48 kB
2612 pg_catalog pg_language 4 73728 32768   40960 72 kB 32 kB   40 kB
2613 pg_catalog pg_largeobject 0 8192 8192   0 8192 bytes 8192 bytes   0 bytes
2995 pg_catalog pg_largeobject_metadata 0 8192 8192   0 8192 bytes 8192 bytes   0 bytes
2615 pg_catalog pg_namespace 6 73728 32768   40960 72 kB 32 kB   40 kB
2616 pg_catalog pg_opclass 133 90112 32768   57344 88 kB 32 kB   56 kB
2617 pg_catalog pg_operator 787 245760 90112   155648 240 kB 88 kB   152 kB
2753 pg_catalog pg_opfamily 115 81920 32768   49152 80 kB 32 kB   48 kB
3350 pg_catalog pg_partitioned_table 0 8192 8192   0 8192 bytes 8192 bytes   0 bytes
1136 pg_catalog pg_pltemplate 8 57344 16384   40960 56 kB 16 kB   40 kB
3256 pg_catalog pg_policy 0 16384 16384   0 16 kB 16 kB   0 bytes
1255 pg_catalog pg_proc 2894 1032192 352256 8192 671744 1008 kB 344 kB 8192 bytes 656 kB
6104 pg_catalog pg_publication 0 40960 32768   8192 40 kB 32 kB   8192 bytes
6106 pg_catalog pg_publication_rel 0 40960 32768   8192 40 kB 32 kB   8192 bytes
3541 pg_catalog pg_range 6 57344 16384   40960 56 kB 16 kB   40 kB
6000 pg_catalog pg_replication_origin 0 16384 16384   0 16 kB 16 kB   0 bytes
2618 pg_catalog pg_rewrite 121 655360 32768 483328 139264 640 kB 32 kB 472 kB 136 kB
3596 pg_catalog pg_seclabel 0 16384 8192 8192 0 16 kB 8192 bytes 8192 bytes 0 bytes
2224 pg_catalog pg_sequence 0 32768 16384   16384 32 kB 16 kB   16 kB
1214 pg_catalog pg_shdepend 80 73728 32768   40960 72 kB 32 kB   40 kB
2396 pg_catalog pg_shdescription 1 65536 16384 8192 40960 64 kB 16 kB 8192 bytes 40 kB
3592 pg_catalog pg_shseclabel 0 16384 8192 8192 0 16 kB 8192 bytes 8192 bytes 0 bytes
2619 pg_catalog pg_statistic 191 483328 32768 73728 376832 472 kB 32 kB 72 kB 368 kB
3381 pg_catalog pg_statistic_ext 0 32768 24576 8192 0 32 kB 24 kB 8192 bytes 0 bytes
6100 pg_catalog pg_subscription 0 16384 16384   0 16 kB 16 kB   0 bytes
6102 pg_catalog pg_subscription_rel 0 8192 8192   0 8192 bytes 8192 bytes   0 bytes
1213 pg_catalog pg_tablespace 2 73728 32768   40960 72 kB 32 kB   40 kB
3576 pg_catalog pg_transform 0 16384 16384   0 16 kB 16 kB   0 bytes
2620 pg_catalog pg_trigger 0 32768 24576 8192 0 32 kB 24 kB 8192 bytes 0 bytes
3602 pg_catalog pg_ts_config 16 73728 32768   40960 72 kB 32 kB   40 kB
3603 pg_catalog pg_ts_config_map 304 81920 32768   49152 80 kB 32 kB   48 kB
3600 pg_catalog pg_ts_dict 16 73728 32768   40960 72 kB 32 kB   40 kB
3601 pg_catalog pg_ts_parser 1 73728 32768   40960 72 kB 32 kB   40 kB
3764 pg_catalog pg_ts_template 5 73728 32768   40960 72 kB 32 kB   40 kB
1247 pg_catalog pg_type 375 196608 73728   122880 192 kB 72 kB   120 kB
1418 pg_catalog pg_user_mapping 0 16384 16384   0 16 kB 16 kB   0 bytes
20503 public autovac_demo 10362 1662976 753664   909312 1624 kB 736 kB   888 kB
32780 public big_table_apg 208973152 14575501312 4904402944   9671098368 14 GB 4677 MB   9223 MB
28782 public idx_test 2 40960 32768   8192 40 kB 32 kB   8192 bytes
32862 public pg_acct_management 0 8192 0   8192 8192 bytes 0 bytes   8192 bytes

biggest 50 tables in the DB:


oid table_schema table_name row_estimate total_bytes index_bytes toast_bytes table_bytes total_pretty index_pretty toast_pretty table_pretty
32780 public big_table_apg 208973152 14575501312 4904402944   9671098368 14 GB 4677 MB   9223 MB
32867 app_schema app_data_table 30000 504299520 502939648   1359872 481 MB 480 MB   1328 kB
20503 public autovac_demo 10362 1662976 753664   909312 1624 kB 736 kB   888 kB
2608 pg_catalog pg_depend 7327 1261568 761856   499712 1232 kB 744 kB   488 kB
1255 pg_catalog pg_proc 2894 1032192 352256 8192 671744 1008 kB 344 kB 8192 bytes 656 kB
1249 pg_catalog pg_attribute 3002 770048 237568   532480 752 kB 232 kB   520 kB
2618 pg_catalog pg_rewrite 121 655360 32768 483328 139264 640 kB 32 kB 472 kB 136 kB
3456 pg_catalog pg_collation 1645 614400 163840   450560 600 kB 160 kB   440 kB
2609 pg_catalog pg_description 4635 565248 196608 8192 360448 552 kB 192 kB 8192 bytes 352 kB
2619 pg_catalog pg_statistic 191 483328 32768 73728 376832 472 kB 32 kB 72 kB 368 kB
2617 pg_catalog pg_operator 787 245760 90112   155648 240 kB 88 kB   152 kB
1259 pg_catalog pg_class 341 245760 122880   122880 240 kB 120 kB   120 kB
1247 pg_catalog pg_type 375 196608 73728   122880 192 kB 72 kB   120 kB
2602 pg_catalog pg_amop 709 196608 114688   81920 192 kB 112 kB   80 kB
2603 pg_catalog pg_amproc 411 131072 65536   65536 128 kB 64 kB   64 kB
2606 pg_catalog pg_constraint 2 114688 65536 8192 40960 112 kB 64 kB 8192 bytes 40 kB
2607 pg_catalog pg_conversion 132 106496 49152   57344 104 kB 48 kB   56 kB
2610 pg_catalog pg_index 134 98304 32768   65536 96 kB 32 kB   64 kB
13769 information_schema sql_features 671 98304 0 8192 90112 96 kB 0 bytes 8192 bytes 88 kB
2616 pg_catalog pg_opclass 133 90112 32768   57344 88 kB 32 kB   56 kB
2605 pg_catalog pg_cast 219 81920 32768   49152 80 kB 32 kB   48 kB
3603 pg_catalog pg_ts_config_map 304 81920 32768   49152 80 kB 32 kB   48 kB
2753 pg_catalog pg_opfamily 115 81920 32768   49152 80 kB 32 kB   48 kB
3602 pg_catalog pg_ts_config 16 73728 32768   40960 72 kB 32 kB   40 kB
1260 pg_catalog pg_authid 6 73728 32768   40960 72 kB 32 kB   40 kB
2601 pg_catalog pg_am 6 73728 32768   40960 72 kB 32 kB   40 kB
2612 pg_catalog pg_language 4 73728 32768   40960 72 kB 32 kB   40 kB
2615 pg_catalog pg_namespace 6 73728 32768   40960 72 kB 32 kB   40 kB
1262 pg_catalog pg_database 2 73728 32768   40960 72 kB 32 kB   40 kB
1213 pg_catalog pg_tablespace 2 73728 32768   40960 72 kB 32 kB   40 kB
1261 pg_catalog pg_auth_members 3 73728 32768   40960 72 kB 32 kB   40 kB
1214 pg_catalog pg_shdepend 80 73728 32768   40960 72 kB 32 kB   40 kB
3600 pg_catalog pg_ts_dict 16 73728 32768   40960 72 kB 32 kB   40 kB
3601 pg_catalog pg_ts_parser 1 73728 32768   40960 72 kB 32 kB   40 kB
3764 pg_catalog pg_ts_template 5 73728 32768   40960 72 kB 32 kB   40 kB
3079 pg_catalog pg_extension 1 73728 32768   40960 72 kB 32 kB   40 kB
3394 pg_catalog pg_init_privs 149 65536 16384   49152 64 kB 16 kB   48 kB
2600 pg_catalog pg_aggregate 138 65536 16384   49152 64 kB 16 kB   48 kB
2396 pg_catalog pg_shdescription 1 65536 16384 8192 40960 64 kB 16 kB 8192 bytes 40 kB
1136 pg_catalog pg_pltemplate 8 57344 16384   40960 56 kB 16 kB   40 kB
2604 pg_catalog pg_attrdef 0 57344 32768 8192 16384 56 kB 32 kB 8192 bytes 16 kB
3541 pg_catalog pg_range 6 57344 16384   40960 56 kB 16 kB   40 kB
3466 pg_catalog pg_event_trigger 0 49152 32768   16384 48 kB 32 kB   16 kB
13789 information_schema sql_parts 9 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13779 information_schema sql_languages 4 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13774 information_schema sql_implementation_info 12 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13784 information_schema sql_packages 10 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
13794 information_schema sql_sizing 23 49152 0 8192 40960 48 kB 0 bytes 8192 bytes 40 kB
2328 pg_catalog pg_foreign_data_wrapper 0 49152 32768   16384 48 kB 32 kB   16 kB
1417 pg_catalog pg_foreign_server 0 49152 32768   16384 48 kB 32 kB   16 kB
[Top]

Index_Size


Index Size order by schema name :

schemaname Table indexname pg_relation_size index_size
app_schema app_data_table app_data_table_value_idx 252805120 241 MB
app_schema app_data_table app_data_table_pkey 250085376 239 MB
pg_catalog pg_depend pg_depend_reference_index 393216 384 kB
pg_catalog pg_depend pg_depend_depender_index 368640 360 kB
pg_catalog pg_proc pg_proc_proname_args_nsp_index 270336 264 kB
pg_catalog pg_description pg_description_o_c_o_index 196608 192 kB
pg_catalog pg_attribute pg_attribute_relid_attnam_index 139264 136 kB
pg_catalog pg_collation pg_collation_name_enc_nsp_index 106496 104 kB
pg_catalog pg_attribute pg_attribute_relid_attnum_index 98304 96 kB
pg_catalog pg_proc pg_proc_oid_index 81920 80 kB
pg_catalog pg_collation pg_collation_oid_index 57344 56 kB
pg_catalog pg_operator pg_operator_oprname_l_r_n_index 49152 48 kB
pg_catalog pg_class pg_class_relname_nsp_index 49152 48 kB
pg_catalog pg_type pg_type_typname_nsp_index 40960 40 kB
pg_catalog pg_class pg_class_tblspc_relfilenode_index 40960 40 kB
pg_catalog pg_operator pg_operator_oid_index 40960 40 kB
pg_catalog pg_amop pg_amop_fam_strat_index 40960 40 kB
pg_catalog pg_amop pg_amop_opr_fam_index 40960 40 kB
pg_catalog pg_statistic pg_statistic_relid_att_inh_index 32768 32 kB
pg_catalog pg_amop pg_amop_oid_index 32768 32 kB
pg_catalog pg_amproc pg_amproc_fam_proc_index 32768 32 kB
pg_catalog pg_amproc pg_amproc_oid_index 32768 32 kB
pg_catalog pg_type pg_type_oid_index 32768 32 kB
pg_catalog pg_class pg_class_oid_index 32768 32 kB
pg_catalog pg_ts_config_map pg_ts_config_map_index 32768 32 kB
pg_catalog pg_foreign_server pg_foreign_server_name_index 16384 16 kB
pg_catalog pg_aggregate pg_aggregate_fnoid_index 16384 16 kB
pg_catalog pg_am pg_am_name_index 16384 16 kB
pg_catalog pg_am pg_am_oid_index 16384 16 kB
pg_catalog pg_attrdef pg_attrdef_adrelid_adnum_index 16384 16 kB
pg_catalog pg_attrdef pg_attrdef_oid_index 16384 16 kB
pg_catalog pg_authid pg_authid_rolname_index 16384 16 kB
pg_catalog pg_authid pg_authid_oid_index 16384 16 kB
pg_catalog pg_auth_members pg_auth_members_role_member_index 16384 16 kB
pg_catalog pg_auth_members pg_auth_members_member_role_index 16384 16 kB
pg_catalog pg_cast pg_cast_oid_index 16384 16 kB
pg_catalog pg_cast pg_cast_source_target_index 16384 16 kB
pg_catalog pg_constraint pg_constraint_conname_nsp_index 16384 16 kB
pg_catalog pg_constraint pg_constraint_conrelid_index 16384 16 kB
pg_catalog pg_constraint pg_constraint_contypid_index 16384 16 kB
pg_catalog pg_constraint pg_constraint_oid_index 16384 16 kB
pg_catalog pg_conversion pg_conversion_default_index 16384 16 kB
pg_catalog pg_conversion pg_conversion_name_nsp_index 16384 16 kB
pg_catalog pg_conversion pg_conversion_oid_index 16384 16 kB
pg_catalog pg_database pg_database_datname_index 16384 16 kB
pg_catalog pg_database pg_database_oid_index 16384 16 kB
pg_catalog pg_shdescription pg_shdescription_o_c_index 16384 16 kB
pg_catalog pg_index pg_index_indrelid_index 16384 16 kB
pg_catalog pg_index pg_index_indexrelid_index 16384 16 kB
pg_catalog pg_init_privs pg_init_privs_o_c_o_index 16384 16 kB
pg_catalog pg_language pg_language_name_index 16384 16 kB
pg_catalog pg_language pg_language_oid_index 16384 16 kB
pg_catalog pg_namespace pg_namespace_nspname_index 16384 16 kB
pg_catalog pg_namespace pg_namespace_oid_index 16384 16 kB
pg_catalog pg_opclass pg_opclass_am_name_nsp_index 16384 16 kB
pg_catalog pg_opclass pg_opclass_oid_index 16384 16 kB
pg_catalog pg_opfamily pg_opfamily_am_name_nsp_index 16384 16 kB
pg_catalog pg_opfamily pg_opfamily_oid_index 16384 16 kB
pg_catalog pg_pltemplate pg_pltemplate_name_index 16384 16 kB
pg_catalog pg_rewrite pg_rewrite_oid_index 16384 16 kB
pg_catalog pg_rewrite pg_rewrite_rel_rulename_index 16384 16 kB
pg_catalog pg_sequence pg_sequence_seqrelid_index 16384 16 kB
pg_catalog pg_shdepend pg_shdepend_depender_index 16384 16 kB
pg_catalog pg_shdepend pg_shdepend_reference_index 16384 16 kB
pg_catalog pg_tablespace pg_tablespace_oid_index 16384 16 kB
pg_catalog pg_tablespace pg_tablespace_spcname_index 16384 16 kB
pg_catalog pg_event_trigger pg_event_trigger_evtname_index 16384 16 kB
pg_catalog pg_event_trigger pg_event_trigger_oid_index 16384 16 kB
pg_catalog pg_ts_config pg_ts_config_cfgname_index 16384 16 kB
pg_catalog pg_ts_config pg_ts_config_oid_index 16384 16 kB
pg_catalog pg_ts_dict pg_ts_dict_dictname_index 16384 16 kB
pg_catalog pg_ts_dict pg_ts_dict_oid_index 16384 16 kB
pg_catalog pg_ts_parser pg_ts_parser_prsname_index 16384 16 kB
pg_catalog pg_ts_parser pg_ts_parser_oid_index 16384 16 kB
pg_catalog pg_ts_template pg_ts_template_tmplname_index 16384 16 kB
pg_catalog pg_ts_template pg_ts_template_oid_index 16384 16 kB
pg_catalog pg_foreign_data_wrapper pg_foreign_data_wrapper_oid_index 16384 16 kB
pg_catalog pg_foreign_data_wrapper pg_foreign_data_wrapper_name_index 16384 16 kB
pg_catalog pg_foreign_server pg_foreign_server_oid_index 16384 16 kB
pg_catalog pg_foreign_table pg_foreign_table_relid_index 16384 16 kB
pg_catalog pg_default_acl pg_default_acl_role_nsp_obj_index 16384 16 kB
pg_catalog pg_default_acl pg_default_acl_oid_index 16384 16 kB
pg_catalog pg_db_role_setting pg_db_role_setting_databaseid_rol_index 16384 16 kB
pg_catalog pg_extension pg_extension_oid_index 16384 16 kB
pg_catalog pg_extension pg_extension_name_index 16384 16 kB
pg_catalog pg_range pg_range_rngtypid_index 16384 16 kB
pg_catalog pg_publication pg_publication_oid_index 16384 16 kB
pg_catalog pg_publication pg_publication_pubname_index 16384 16 kB
pg_catalog pg_publication_rel pg_publication_rel_oid_index 16384 16 kB
pg_catalog pg_publication_rel pg_publication_rel_prrelid_prpubid_index 16384 16 kB
pg_catalog pg_policy pg_policy_oid_index 8192 8192 bytes
pg_catalog pg_policy pg_policy_polrelid_polname_index 8192 8192 bytes
pg_catalog pg_replication_origin pg_replication_origin_roiident_index 8192 8192 bytes
pg_catalog pg_partitioned_table pg_partitioned_table_partrelid_index 8192 8192 bytes
pg_catalog pg_enum pg_enum_oid_index 8192 8192 bytes
pg_catalog pg_enum pg_enum_typid_label_index 8192 8192 bytes
pg_catalog pg_enum pg_enum_typid_sortorder_index 8192 8192 bytes
pg_catalog pg_inherits pg_inherits_relid_seqno_index 8192 8192 bytes
pg_catalog pg_inherits pg_inherits_parent_index 8192 8192 bytes
pg_catalog pg_largeobject pg_largeobject_loid_pn_index 8192 8192 bytes
pg_catalog pg_largeobject_metadata pg_largeobject_metadata_oid_index 8192 8192 bytes
pg_catalog pg_statistic_ext pg_statistic_ext_oid_index 8192 8192 bytes
pg_catalog pg_statistic_ext pg_statistic_ext_name_index 8192 8192 bytes
pg_catalog pg_statistic_ext pg_statistic_ext_relid_index 8192 8192 bytes
pg_catalog pg_subscription pg_subscription_oid_index 8192 8192 bytes
pg_catalog pg_subscription pg_subscription_subname_index 8192 8192 bytes
pg_catalog pg_subscription_rel pg_subscription_rel_srrelid_srsubid_index 8192 8192 bytes
pg_catalog pg_user_mapping pg_user_mapping_oid_index 8192 8192 bytes
pg_catalog pg_user_mapping pg_user_mapping_user_server_index 8192 8192 bytes
pg_catalog pg_seclabel pg_seclabel_object_index 8192 8192 bytes
pg_catalog pg_shseclabel pg_shseclabel_object_index 8192 8192 bytes
pg_catalog pg_transform pg_transform_oid_index 8192 8192 bytes
pg_catalog pg_transform pg_transform_type_lang_index 8192 8192 bytes
pg_catalog pg_trigger pg_trigger_tgconstraint_index 8192 8192 bytes
pg_catalog pg_trigger pg_trigger_tgrelid_tgname_index 8192 8192 bytes
pg_catalog pg_trigger pg_trigger_oid_index 8192 8192 bytes
pg_catalog pg_replication_origin pg_replication_origin_roname_index 8192 8192 bytes
pg_toast pg_toast_2618 pg_toast_2618_index 16384 16 kB
pg_toast pg_toast_2619 pg_toast_2619_index 16384 16 kB
pg_toast pg_toast_13774 pg_toast_13774_index 8192 8192 bytes
pg_toast pg_toast_3592 pg_toast_3592_index 8192 8192 bytes
pg_toast pg_toast_2964 pg_toast_2964_index 8192 8192 bytes
pg_toast pg_toast_2396 pg_toast_2396_index 8192 8192 bytes
pg_toast pg_toast_13784 pg_toast_13784_index 8192 8192 bytes
pg_toast pg_toast_2620 pg_toast_2620_index 8192 8192 bytes
pg_toast pg_toast_3381 pg_toast_3381_index 8192 8192 bytes
pg_toast pg_toast_13789 pg_toast_13789_index 8192 8192 bytes
pg_toast pg_toast_13794 pg_toast_13794_index 8192 8192 bytes
pg_toast pg_toast_13779 pg_toast_13779_index 8192 8192 bytes
pg_toast pg_toast_13799 pg_toast_13799_index 8192 8192 bytes
pg_toast pg_toast_2609 pg_toast_2609_index 8192 8192 bytes
pg_toast pg_toast_2606 pg_toast_2606_index 8192 8192 bytes
pg_toast pg_toast_2604 pg_toast_2604_index 8192 8192 bytes
pg_toast pg_toast_1255 pg_toast_1255_index 8192 8192 bytes
pg_toast pg_toast_13769 pg_toast_13769_index 8192 8192 bytes
pg_toast pg_toast_3596 pg_toast_3596_index 8192 8192 bytes
public big_table_apg big_table_apg_pkey 4904402944 4677 MB
public autovac_demo autovac_demo_pkey 753664 736 kB
public idx_test idx_test_value 16384 16 kB
public idx_test idx_test_id_key 16384 16 kB

biggest 50 Index in the DB :


schemaname Table indexname pg_relation_size index_size
public big_table_apg big_table_apg_pkey 4904402944 4677 MB
app_schema app_data_table app_data_table_value_idx 252805120 241 MB
app_schema app_data_table app_data_table_pkey 250085376 239 MB
public autovac_demo autovac_demo_pkey 753664 736 kB
pg_catalog pg_depend pg_depend_reference_index 393216 384 kB
pg_catalog pg_depend pg_depend_depender_index 368640 360 kB
pg_catalog pg_proc pg_proc_proname_args_nsp_index 270336 264 kB
pg_catalog pg_description pg_description_o_c_o_index 196608 192 kB
pg_catalog pg_attribute pg_attribute_relid_attnam_index 139264 136 kB
pg_catalog pg_collation pg_collation_name_enc_nsp_index 106496 104 kB
pg_catalog pg_attribute pg_attribute_relid_attnum_index 98304 96 kB
pg_catalog pg_proc pg_proc_oid_index 81920 80 kB
pg_catalog pg_collation pg_collation_oid_index 57344 56 kB
pg_catalog pg_operator pg_operator_oprname_l_r_n_index 49152 48 kB
pg_catalog pg_class pg_class_relname_nsp_index 49152 48 kB
pg_catalog pg_amop pg_amop_opr_fam_index 40960 40 kB
pg_catalog pg_type pg_type_typname_nsp_index 40960 40 kB
pg_catalog pg_amop pg_amop_fam_strat_index 40960 40 kB
pg_catalog pg_class pg_class_tblspc_relfilenode_index 40960 40 kB
pg_catalog pg_operator pg_operator_oid_index 40960 40 kB
pg_catalog pg_amproc pg_amproc_oid_index 32768 32 kB
pg_catalog pg_amproc pg_amproc_fam_proc_index 32768 32 kB
pg_catalog pg_amop pg_amop_oid_index 32768 32 kB
pg_catalog pg_statistic pg_statistic_relid_att_inh_index 32768 32 kB
pg_catalog pg_ts_config_map pg_ts_config_map_index 32768 32 kB
pg_catalog pg_class pg_class_oid_index 32768 32 kB
pg_catalog pg_type pg_type_oid_index 32768 32 kB
pg_catalog pg_cast pg_cast_oid_index 16384 16 kB
pg_catalog pg_auth_members pg_auth_members_member_role_index 16384 16 kB
pg_catalog pg_aggregate pg_aggregate_fnoid_index 16384 16 kB
pg_catalog pg_auth_members pg_auth_members_role_member_index 16384 16 kB
pg_catalog pg_authid pg_authid_oid_index 16384 16 kB
pg_toast pg_toast_2618 pg_toast_2618_index 16384 16 kB
pg_catalog pg_opclass pg_opclass_am_name_nsp_index 16384 16 kB
pg_catalog pg_authid pg_authid_rolname_index 16384 16 kB
pg_catalog pg_namespace pg_namespace_nspname_index 16384 16 kB
pg_catalog pg_shdescription pg_shdescription_o_c_index 16384 16 kB
pg_catalog pg_attrdef pg_attrdef_oid_index 16384 16 kB
pg_catalog pg_namespace pg_namespace_oid_index 16384 16 kB
pg_catalog pg_opclass pg_opclass_oid_index 16384 16 kB
pg_catalog pg_attrdef pg_attrdef_adrelid_adnum_index 16384 16 kB
pg_catalog pg_database pg_database_datname_index 16384 16 kB
pg_catalog pg_conversion pg_conversion_oid_index 16384 16 kB
pg_catalog pg_init_privs pg_init_privs_o_c_o_index 16384 16 kB
pg_catalog pg_database pg_database_oid_index 16384 16 kB
pg_catalog pg_conversion pg_conversion_name_nsp_index 16384 16 kB
pg_catalog pg_conversion pg_conversion_default_index 16384 16 kB
pg_catalog pg_constraint pg_constraint_oid_index 16384 16 kB
pg_catalog pg_constraint pg_constraint_contypid_index 16384 16 kB
pg_catalog pg_index pg_index_indexrelid_index 16384 16 kB
[Top]

Vacuum & Statistics


Autovacuum Parameters :

name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline pending_restart
autovacuum on   Autovacuum Starts the autovacuum subprocess.   sighup bool default       on on     f
autovacuum_analyze_scale_factor 0.05   Autovacuum Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.   sighup real configuration file 0 100   0.1 0.05 /rdsdbdata/config/postgresql.conf 27 f
autovacuum_analyze_threshold 50   Autovacuum Minimum number of tuple inserts, updates, or deletes prior to analyze.   sighup integer default 0 2147483647   50 50     f
autovacuum_freeze_max_age 200000000   Autovacuum Age at which to autovacuum a table to prevent transaction ID wraparound.   postmaster integer default 100000 2000000000   200000000 200000000     f
autovacuum_max_workers 3   Autovacuum Sets the maximum number of simultaneously running autovacuum worker processes.   postmaster integer configuration file 1 262143   3 3 /rdsdbdata/config/postgresql.conf 69 f
autovacuum_multixact_freeze_max_age 400000000   Autovacuum Multixact age at which to autovacuum a table to prevent multixact wraparound.   postmaster integer default 10000 2000000000   400000000 400000000     f
autovacuum_naptime 5 s Autovacuum Time to sleep between autovacuum runs.   sighup integer configuration file 1 2147483   60 5 /rdsdbdata/config/postgresql.conf 7 f
autovacuum_vacuum_cost_delay 5 ms Autovacuum Vacuum cost delay in milliseconds, for autovacuum.   sighup integer configuration file -1 100   20 5 /rdsdbdata/config/postgresql.conf 85 f
autovacuum_vacuum_cost_limit -1   Autovacuum Vacuum cost amount available before napping, for autovacuum.   sighup integer default -1 10000   -1 -1     f
autovacuum_vacuum_scale_factor 0.1   Autovacuum Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.   sighup real configuration file 0 100   0.2 0.1 /rdsdbdata/config/postgresql.conf 55 f
autovacuum_vacuum_threshold 50   Autovacuum Minimum number of tuple updates or deletes prior to vacuum.   sighup integer default 0 2147483647   50 50     f

name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline pending_restart
rds.force_autovacuum_logging_level warning   Customized Options Emit autovacuum log messages irrespective of other logging configuration. Each level includes all the levels that follow it.Set to disabled to disable this feature and fall back to using log_min_messages. sighup enum configuration file     {debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic,disabled} disabled warning /rdsdbdata/config/postgresql.conf 28 f
log_autovacuum_min_duration 0 ms Reporting and Logging / What to Log Sets the minimum execution time above which autovacuum actions will be logged. Zero prints all actions. -1 turns autovacuum logging off. sighup integer configuration file -1 2147483647   -1 0 /rdsdbdata/config/postgresql.conf 72 f

currnt running autovacuum porecess:

datname usename state query duration wait_event

Vacuum porgress:

pid duration waiting mode database table phase table_size total_size scanned vacuumed scanned_pct vacuumed_pct index_vacuum_count dead_pct

Autovacuum progress per day :

to_char count
  96

Autoanalyze progress per day :

to_char count
  96

Which tables are currently eligible for autovacuum based on curret parameters :

relation table_size xid_age autovacuum_freeze_max_age autovacuum_vacuum_tuples dead_tuples

Check if the statistics collector is enabled (track_counts is on) :

name setting
track_counts on

Number of dead rows for the top 50 table :

relname n_live_tup n_tup_upd n_tup_del n_dead_tup last_vacuum last_autovacuum last_analyze last_autoanalyze
pg_db_role_setting 0 1 0 1        
pg_init_privs 0 0 0 0        
pg_amop 0 0 0 0        
sql_features 0 0 0 0        
pg_toast_2618 0 0 0 0        
pg_namespace 0 0 0 0        
pg_toast_2619 0 0 0 0        
pg_toast_3596 0 0 0 0        
big_table_apg 0 0 0 0        
pg_toast_2964 0 0 0 0        
pg_range 0 0 0 0        
pg_shdepend 0 0 0 0        
pg_ts_dict 0 0 0 0        
pg_ts_template 0 0 0 0        
pg_proc 0 0 0 0        
pg_index 0 0 0 0        
pg_tablespace 0 0 0 0        
pg_database 0 0 0 0        
pg_class 0 0 0 0        
pg_operator 0 0 0 0        
pg_amproc 0 0 0 0        
pg_toast_2620 0 0 0 0        
pg_description 0 0 0 0        
pg_transform 0 0 0 0        
pg_am 0 0 0 0        
pg_attribute 0 0 0 0        
pg_inherits 0 0 0 0        
pg_pltemplate 0 0 0 0        
pg_statistic_ext 0 0 0 0        
pg_conversion 0 0 0 0        
pg_toast_2606 0 0 0 0        
pg_toast_2609 0 0 0 0        
sql_sizing 0 0 0 0        
test_2 0 0 0 0        
pg_user_mapping 0 0 0 0        
pg_toast_1255 0 0 0 0        
pg_publication_rel 0 0 0 0        
pg_toast_2396 0 0 0 0        
pg_replication_origin 0 0 0 0        
sql_parts 0 0 0 0        
pg_collation 0 0 0 0        
pg_cast 0 0 0 0        
pg_statistic 0 0 0 0        
pg_largeobject_metadata 0 0 0 0        
pg_partitioned_table 0 0 0 0        
pg_toast_3381 0 0 0 0        
pg_toast_13779 0 0 0 0        
pg_language 0 0 0 0        
pg_toast_13784 0 0 0 0        
pg_event_trigger 0 0 0 0        

Tables have more than 20% dead rows :

schemaname relname last_vacuum last_autovacuum n_live_tup n_dead_tup n_dead_tup_%

pg_stat_all_tables :

relname schemaname last_vacuum last_autovacuum last_analyze last_autoanalyze vacuum_count autovacuum_count analyze_count autoanalyze_count
test_2 app_schema         0 0 0 0
app_data_table app_schema         0 0 0 0
test app_schema         0 0 0 0
test_3 app_schema         0 0 0 0
sql_sizing information_schema         0 0 0 0
sql_parts information_schema         0 0 0 0
sql_languages information_schema         0 0 0 0
sql_implementation_info information_schema         0 0 0 0
sql_packages information_schema         0 0 0 0
sql_sizing_profiles information_schema         0 0 0 0
sql_features information_schema         0 0 0 0
pg_acct_management public         0 0 0 0
idx_test public         0 0 0 0
autovac_demo public         0 0 0 0
big_table_apg public         0 0 0 0

pg_stat_all_tables order by autovacuum_count :

relname schemaname last_vacuum last_autovacuum last_analyze last_autoanalyze vacuum_count autovacuum_count analyze_count autoanalyze_count
sql_sizing information_schema         0 0 0 0
test_2 app_schema         0 0 0 0
sql_parts information_schema         0 0 0 0
pg_acct_management public         0 0 0 0
sql_languages information_schema         0 0 0 0
app_data_table app_schema         0 0 0 0
sql_implementation_info information_schema         0 0 0 0
test_3 app_schema         0 0 0 0
idx_test public         0 0 0 0
sql_packages information_schema         0 0 0 0
sql_sizing_profiles information_schema         0 0 0 0
test app_schema         0 0 0 0
autovac_demo public         0 0 0 0
sql_features information_schema         0 0 0 0
big_table_apg public         0 0 0 0

pg_stat_all_tables order by autoanalyze_count:

relname schemaname last_vacuum last_autovacuum last_analyze last_autoanalyze vacuum_count autovacuum_count analyze_count autoanalyze_count
sql_sizing information_schema         0 0 0 0
test_2 app_schema         0 0 0 0
sql_parts information_schema         0 0 0 0
pg_acct_management public         0 0 0 0
sql_languages information_schema         0 0 0 0
app_data_table app_schema         0 0 0 0
sql_implementation_info information_schema         0 0 0 0
test_3 app_schema         0 0 0 0
idx_test public         0 0 0 0
sql_packages information_schema         0 0 0 0
sql_sizing_profiles information_schema         0 0 0 0
test app_schema         0 0 0 0
autovac_demo public         0 0 0 0
sql_features information_schema         0 0 0 0
big_table_apg public         0 0 0 0

tables without auto analyze :

relname schemaname last_vacuum last_autovacuum last_analyze last_autoanalyze
test_2 app_schema        
test app_schema        
app_data_table app_schema        
test_3 app_schema        
sql_parts information_schema        
sql_packages information_schema        
sql_implementation_info information_schema        
sql_languages information_schema        
sql_sizing_profiles information_schema        
sql_sizing information_schema        
sql_features information_schema        
pg_foreign_server pg_catalog        
pg_user_mapping pg_catalog        
pg_sequence pg_catalog        
pg_foreign_data_wrapper pg_catalog        
pg_shdescription pg_catalog        
pg_aggregate pg_catalog        
pg_am pg_catalog        
pg_amop pg_catalog        
pg_amproc pg_catalog        
pg_attrdef pg_catalog        
pg_cast pg_catalog        
pg_constraint pg_catalog        
pg_conversion pg_catalog        
pg_depend pg_catalog        
pg_description pg_catalog        
pg_index pg_catalog        
pg_inherits pg_catalog        
pg_language pg_catalog        
pg_largeobject pg_catalog        
pg_namespace pg_catalog        
pg_opclass pg_catalog        
pg_operator pg_catalog        
pg_rewrite pg_catalog        
pg_statistic pg_catalog        
pg_trigger pg_catalog        
pg_opfamily pg_catalog        
pg_db_role_setting pg_catalog        
pg_largeobject_metadata pg_catalog        
pg_extension pg_catalog        
pg_foreign_table pg_catalog        
pg_policy pg_catalog        
pg_partitioned_table pg_catalog        
pg_statistic_ext pg_catalog        
pg_init_privs pg_catalog        
pg_collation pg_catalog        
pg_event_trigger pg_catalog        
pg_enum pg_catalog        
pg_range pg_catalog        
pg_transform pg_catalog        
pg_shseclabel pg_catalog        
pg_seclabel pg_catalog        
pg_ts_dict pg_catalog        
pg_ts_parser pg_catalog        
pg_ts_config pg_catalog        
pg_ts_config_map pg_catalog        
pg_ts_template pg_catalog        
pg_subscription_rel pg_catalog        
pg_pltemplate pg_catalog        
pg_tablespace pg_catalog        
pg_shdepend pg_catalog        
pg_type pg_catalog        
pg_attribute pg_catalog        
pg_proc pg_catalog        
pg_class pg_catalog        
pg_authid pg_catalog        
pg_auth_members pg_catalog        
pg_database pg_catalog        
pg_replication_origin pg_catalog        
pg_subscription pg_catalog        
pg_default_acl pg_catalog        
pg_publication pg_catalog        
pg_publication_rel pg_catalog        
pg_toast_2620 pg_toast        
pg_toast_3596 pg_toast        
pg_toast_13769 pg_toast        
pg_toast_3381 pg_toast        
pg_toast_13774 pg_toast        
pg_toast_2964 pg_toast        
pg_toast_13779 pg_toast        
pg_toast_2396 pg_toast        
pg_toast_13784 pg_toast        
pg_toast_2619 pg_toast        
pg_toast_13789 pg_toast        
pg_toast_2618 pg_toast        
pg_toast_13794 pg_toast        
pg_toast_1255 pg_toast        
pg_toast_13799 pg_toast        
pg_toast_3592 pg_toast        
pg_toast_2609 pg_toast        
pg_toast_2606 pg_toast        
pg_toast_2604 pg_toast        
autovac_demo public        
idx_test public        
big_table_apg public        
pg_acct_management public        

tables without auto vacuum :

relname schemaname last_vacuum last_autovacuum last_analyze last_autoanalyze
test_2 app_schema        
test app_schema        
app_data_table app_schema        
test_3 app_schema        
sql_parts information_schema        
sql_packages information_schema        
sql_implementation_info information_schema        
sql_languages information_schema        
sql_sizing_profiles information_schema        
sql_sizing information_schema        
sql_features information_schema        
pg_foreign_server pg_catalog        
pg_user_mapping pg_catalog        
pg_sequence pg_catalog        
pg_foreign_data_wrapper pg_catalog        
pg_shdescription pg_catalog        
pg_aggregate pg_catalog        
pg_am pg_catalog        
pg_amop pg_catalog        
pg_amproc pg_catalog        
pg_attrdef pg_catalog        
pg_cast pg_catalog        
pg_constraint pg_catalog        
pg_conversion pg_catalog        
pg_depend pg_catalog        
pg_description pg_catalog        
pg_index pg_catalog        
pg_inherits pg_catalog        
pg_language pg_catalog        
pg_largeobject pg_catalog        
pg_namespace pg_catalog        
pg_opclass pg_catalog        
pg_operator pg_catalog        
pg_rewrite pg_catalog        
pg_statistic pg_catalog        
pg_trigger pg_catalog        
pg_opfamily pg_catalog        
pg_db_role_setting pg_catalog        
pg_largeobject_metadata pg_catalog        
pg_extension pg_catalog        
pg_foreign_table pg_catalog        
pg_policy pg_catalog        
pg_partitioned_table pg_catalog        
pg_statistic_ext pg_catalog        
pg_init_privs pg_catalog        
pg_collation pg_catalog        
pg_event_trigger pg_catalog        
pg_enum pg_catalog        
pg_range pg_catalog        
pg_transform pg_catalog        
pg_shseclabel pg_catalog        
pg_seclabel pg_catalog        
pg_ts_dict pg_catalog        
pg_ts_parser pg_catalog        
pg_ts_config pg_catalog        
pg_ts_config_map pg_catalog        
pg_ts_template pg_catalog        
pg_subscription_rel pg_catalog        
pg_pltemplate pg_catalog        
pg_tablespace pg_catalog        
pg_shdepend pg_catalog        
pg_type pg_catalog        
pg_attribute pg_catalog        
pg_proc pg_catalog        
pg_class pg_catalog        
pg_authid pg_catalog        
pg_auth_members pg_catalog        
pg_database pg_catalog        
pg_replication_origin pg_catalog        
pg_subscription pg_catalog        
pg_default_acl pg_catalog        
pg_publication pg_catalog        
pg_publication_rel pg_catalog        
pg_toast_2620 pg_toast        
pg_toast_3596 pg_toast        
pg_toast_13769 pg_toast        
pg_toast_3381 pg_toast        
pg_toast_13774 pg_toast        
pg_toast_2964 pg_toast        
pg_toast_13779 pg_toast        
pg_toast_2396 pg_toast        
pg_toast_13784 pg_toast        
pg_toast_2619 pg_toast        
pg_toast_13789 pg_toast        
pg_toast_2618 pg_toast        
pg_toast_13794 pg_toast        
pg_toast_1255 pg_toast        
pg_toast_13799 pg_toast        
pg_toast_3592 pg_toast        
pg_toast_2609 pg_toast        
pg_toast_2606 pg_toast        
pg_toast_2604 pg_toast        
autovac_demo public        
idx_test public        
big_table_apg public        
pg_acct_management public        

tables without auto analyze,auto vacuum,vacuum and analyze :

relname schemaname last_vacuum last_autovacuum last_analyze last_autoanalyze
pg_default_acl pg_catalog        
pg_pltemplate pg_catalog        
pg_tablespace pg_catalog        
pg_shdepend pg_catalog        
pg_type pg_catalog        
pg_attribute pg_catalog        
pg_proc pg_catalog        
pg_class pg_catalog        
pg_authid pg_catalog        
pg_auth_members pg_catalog        
pg_database pg_catalog        
pg_foreign_server pg_catalog        
pg_user_mapping pg_catalog        
pg_sequence pg_catalog        
pg_foreign_data_wrapper pg_catalog        
pg_toast_2620 pg_toast        
pg_shdescription pg_catalog        
pg_aggregate pg_catalog        
pg_am pg_catalog        
pg_amop pg_catalog        
pg_amproc pg_catalog        
pg_attrdef pg_catalog        
pg_cast pg_catalog        
pg_constraint pg_catalog        
pg_conversion pg_catalog        
pg_depend pg_catalog        
pg_description pg_catalog        
pg_index pg_catalog        
pg_inherits pg_catalog        
pg_language pg_catalog        
pg_largeobject pg_catalog        
pg_namespace pg_catalog        
pg_opclass pg_catalog        
pg_operator pg_catalog        
pg_rewrite pg_catalog        
pg_statistic pg_catalog        
pg_trigger pg_catalog        
pg_opfamily pg_catalog        
pg_toast_2604 pg_toast        
pg_toast_2606 pg_toast        
pg_toast_2609 pg_toast        
pg_toast_1255 pg_toast        
pg_toast_2618 pg_toast        
pg_toast_2619 pg_toast        
pg_toast_2396 pg_toast        
pg_db_role_setting pg_catalog        
pg_toast_2964 pg_toast        
pg_largeobject_metadata pg_catalog        
pg_extension pg_catalog        
pg_foreign_table pg_catalog        
pg_policy pg_catalog        
pg_partitioned_table pg_catalog        
pg_statistic_ext pg_catalog        
pg_init_privs pg_catalog        
pg_toast_3381 pg_toast        
pg_collation pg_catalog        
pg_event_trigger pg_catalog        
pg_enum pg_catalog        
pg_range pg_catalog        
pg_transform pg_catalog        
pg_shseclabel pg_catalog        
pg_seclabel pg_catalog        
pg_toast_3596 pg_toast        
pg_ts_dict pg_catalog        
pg_ts_parser pg_catalog        
pg_ts_config pg_catalog        
pg_ts_config_map pg_catalog        
pg_ts_template pg_catalog        
pg_toast_3592 pg_toast        
pg_replication_origin pg_catalog        
pg_subscription pg_catalog        
pg_subscription_rel pg_catalog        
pg_publication pg_catalog        
pg_publication_rel pg_catalog        
sql_features information_schema        
pg_toast_13769 pg_toast        
sql_implementation_info information_schema        
pg_toast_13774 pg_toast        
sql_languages information_schema        
pg_toast_13779 pg_toast        
sql_packages information_schema        
pg_toast_13784 pg_toast        
sql_parts information_schema        
pg_toast_13789 pg_toast        
sql_sizing information_schema        
pg_toast_13794 pg_toast        
sql_sizing_profiles information_schema        
pg_toast_13799 pg_toast        
autovac_demo public        
idx_test public        
big_table_apg public        
test app_schema        
test_2 app_schema        
test_3 app_schema        
pg_acct_management public        
app_data_table app_schema        

Tables that have specific table-level parameters set :

relname reloptions
autovac_demo {autovacuum_vacuum_scale_factor=0,autovacuum_vacuum_threshold=100}
app_data_table {autovacuum_vacuum_scale_factor=0,autovacuum_vacuum_threshold=100}
pg_stats {security_barrier=true}
[Top]

Extensions


shared_preload_libraries parameter:

shared_preload_libraries
rdsutils,pg_stat_statements,pgaudit,apg_plan_mgmt

Installed extension :

Extension Name Version Schema owner Description relocatable to another schema extconfig extcondition
dblink 1.2 public rdsadmin connect to other PostgreSQL databases from within a database t    
log_fdw 1.1 public rdsadmin foreign-data wrapper for Postgres log file access t    
pg_stat_statements 1.4 public rdsadmin track execution statistics of all SQL statements executed t    
pgaudit 1.2 public rdsadmin provides auditing functionality t    
plpgsql 1.0 pg_catalog rdsadmin PL/pgSQL procedural language f    

Available Extension versions that are available to upgarde the instaelled Extension:

extension_name version installed
pg_stat_statements 1.5 f
pg_stat_statements 1.6 f

Latest Extension version that is available to upgarde the instaelled Extension:

extension_name latest_version
pg_stat_statements 1.6

Available extensions:

name version installed superuser relocatable schema requires comment
address_standardizer 2.4.4 f t t     Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer 2.4.4next f t t     Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us 2.4.4 f t t     Address Standardizer US dataset example
address_standardizer_data_us 2.4.4next f t t     Address Standardizer US dataset example
amcheck 1.0 f t t     functions for verifying relation integrity
apg_plan_mgmt 1.0 f t f apg_plan_mgmt   Amazon Aurora with PostgreSQL compatibility Query Plan Management
apg_plan_mgmt 1.0.1 f t f apg_plan_mgmt   Amazon Aurora with PostgreSQL compatibility Query Plan Management
apg_plan_mgmt 2.0 f t f apg_plan_mgmt   Amazon Aurora with PostgreSQL compatibility Query Plan Management
aurora_stat_utils 1.0 f t f     Statistics utility functions
aws_commons 1.1 f t f     Common data types across AWS services
aws_ml 1.0 f t t   {aws_commons} ml integration
aws_s3 1.1 f t t   {aws_commons} AWS S3 extension for importing data from S3
bloom 1.0 f t t     bloom access method - signature file based index
btree_gin 1.0 f t t     support for indexing common datatypes in GIN
btree_gin 1.1 f t t     support for indexing common datatypes in GIN
btree_gin 1.2 f t t     support for indexing common datatypes in GIN
btree_gist 1.2 f t t     support for indexing common datatypes in GiST
btree_gist 1.3 f t t     support for indexing common datatypes in GiST
btree_gist 1.4 f t t     support for indexing common datatypes in GiST
btree_gist 1.5 f t t     support for indexing common datatypes in GiST
chkpass 1.0 f t t     data type for auto-encrypted passwords
citext 1.4 f t t     data type for case-insensitive character strings
cube 1.2 f t t     data type for multidimensional cubes
dblink 1.2 t t t     connect to other PostgreSQL databases from within a database
dict_int 1.0 f t t     text search dictionary template for integers
dict_xsyn 1.0 f t t     text search dictionary template for extended synonym processing
earthdistance 1.1 f t t   {cube} calculate great-circle distances on the surface of the Earth
fuzzystrmatch 1.1 f t t     determine similarities and distance between strings
hll 2.10 f t f     type for storing hyperloglog data
hstore 1.4 f t t     data type for storing sets of (key, value) pairs
hstore_plperl 1.0 f t t   {hstore,plperl} transform between hstore and plperl
intagg 1.1 f t t     integer aggregator and enumerator (obsolete)
intarray 1.2 f t t     functions, operators, and index support for 1-D arrays of integers
ip4r 2.1 f t t      
isn 1.1 f t t     data types for international product numbering standards
log_fdw 1.1 t t t     foreign-data wrapper for Postgres log file access
ltree 1.1 f t t     data type for hierarchical tree-like structures
orafce 3.6 f t f     Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
orafce 3.7 f t f     Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
orafce 3.8 f t f     Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pg_buffercache 1.2 f t t     examine the shared buffer cache
pg_buffercache 1.3 f t t     examine the shared buffer cache
pg_freespacemap 1.1 f t t     examine the free space map (FSM)
pg_freespacemap 1.2 f t t     examine the free space map (FSM)
pg_hint_plan 1.3.3 f t f hint_plan    
pg_prewarm 1.1 f t t     prewarm relation data
pg_repack 1.4.3 f t f     Reorganize tables in PostgreSQL databases with minimal locks
pg_similarity 1.0 f t t     support similarity queries
pg_stat_statements 1.4 t t t     track execution statistics of all SQL statements executed
pg_stat_statements 1.5 f t t     track execution statistics of all SQL statements executed
pg_stat_statements 1.6 f t t     track execution statistics of all SQL statements executed
pg_trgm 1.3 f t t     text similarity measurement and index searching based on trigrams
pg_visibility 1.1 f t t     examine the visibility map (VM) and page-level visibility info
pg_visibility 1.2 f t t     examine the visibility map (VM) and page-level visibility info
pgaudit 1.2 t t t     provides auditing functionality
pgcrypto 1.3 f t t     cryptographic functions
pgrouting 2.5.2 f t t   {postgis} pgRouting Extension
pgrowlocks 1.2 f t t     show row-level locking information
pgstattuple 1.4 f t t     show tuple-level statistics
pgstattuple 1.5 f t t     show tuple-level statistics
plcoffee 2.1.2 f t f pg_catalog   PL/CoffeeScript (v8) trusted procedural language
plls 2.1.2 f t f pg_catalog   PL/LiveScript (v8) trusted procedural language
plperl 1.0 f f f pg_catalog   PL/Perl procedural language
plpgsql 1.0 t f f pg_catalog   PL/pgSQL procedural language
plprofiler 4.1 f t t     server-side support for profiling PL/pgSQL functions
pltcl 1.0 f f f pg_catalog   PL/Tcl procedural language
plv8 2.1.2 f t f pg_catalog   PL/JavaScript (v8) trusted procedural language
postgis 2.4.4 f t f     PostGIS geometry, geography, and raster spatial types and functions
postgis 2.4.4next f t f     PostGIS geometry, geography, and raster spatial types and functions
postgis_tiger_geocoder 2.4.4 f t f tiger {postgis,fuzzystrmatch} PostGIS tiger geocoder and reverse geocoder
postgis_tiger_geocoder 2.4.4next f t f tiger {postgis,fuzzystrmatch} PostGIS tiger geocoder and reverse geocoder
postgis_topology 2.4.4 f t f topology {postgis} PostGIS topology spatial types and functions
postgis_topology 2.4.4next f t f topology {postgis} PostGIS topology spatial types and functions
postgres_fdw 1.0 f t t     foreign-data wrapper for remote PostgreSQL servers
prefix 1.1 f t t     Prefix Range module for PostgreSQL
prefix 1.2.0 f t t     Prefix Range module for PostgreSQL
rds_activity_stream 1.2 f t t     RDS ACTIVITY Agent
sslinfo 1.2 f t t     information about SSL certificates
tablefunc 1.0 f t t     functions that manipulate whole tables, including crosstab
test_parser 1.0 f t t     example of a custom parser for full-text search
tsearch2 1.0 f t f     compatibility package for pre-8.3 text search functions
tsm_system_rows 1.0 f t t     TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time 1.0 f t t     TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent 1.1 f t t     text search dictionary that removes accents
uuid-ossp 1.1 f t t     generate universally unique identifiers (UUIDs)
[Top]

Memory setting

parameter_name setting unit size_MB size_GB pg_size_pretty
effective_cache_size 1304235 8kB 10189 9 10189 MB
shared_buffers 1304235 8kB 10189 9 10189 MB
maintenance_work_mem 260096 kB 254 0 254 MB
wal_buffers 2048 8kB 16 0 16 MB
work_mem 4096 kB 4 0 4096 kB
[Top]

pg_stat_statements extension


pg_stat_statements extension configuration:

Extension Name Version Schema owner Description relocatable to another schema extconfig extcondition
pg_stat_statements 1.4 public rdsadmin track execution statistics of all SQL statements executed t    
parameter_name setting
pg_stat_statements.max 5000
pg_stat_statements.save on
pg_stat_statements.track all
pg_stat_statements.track_utility on
shared_preload_libraries rdsutils,pg_stat_statements,pgaudit,apg_plan_mgmt

Top SQL order by total_time:

query calls total_time_msec total_time_sec avg_time_msec avg_time_sec standard_deviation_time_msec standard_deviation_time_sec rows_per_exec percent
select sum(blks_read), sum(blks_hit) from pg_stat_database 6789 67820.95 67.82 9.99 0.01 3.91 0.00 1.00 14.6898
select sum(numbackends) numbackends, sum(xact_commit) xact_c 6789 64537.41 64.54 9.51 0.01 3.01 0.00 1.00 13.9786
select confl_lock from pg_stat_database_conflicts where datn 6786 62421.55 62.42 9.20 0.01 3.03 0.00 1.00 13.5203
WITH upsert AS (UPDATE public.rds_heartbeat2 SET value=$1 WH 606820 44324.51 44.32 0.07 0.00 0.16 0.00 0.00 9.6005
SELECT coalesce(sum(used_bytes),$1) FROM aurora_stat_file() 13577 26144.50 26.14 1.93 0.00 2.11 0.00 1.00 5.6628
select queryid, calls, total_time, rows, shared_blks_hit, sh 5988 17728.12 17.73 2.96 0.00 0.66 0.00 20.00 3.8398
SELECT n_tables_eligible_for_autovacuum from
( WITH vbt AS 		6786 16946.12 16.95 2.50 0.00 1.19 0.00 1.00 3.6705
select count (*) from pg_stat_activity where state = $1 27144 9587.07 9.59 0.35 0.00 0.10 0.00 1.00 2.0765
select round(sum(pg_database_size(pg_database.datname))/$1/$ 6786 9022.60 9.02 1.33 0.00 0.26 0.00 1.00 1.9543
SELECT setting::float AS max_connections FROM pg_settings WH 13572 8779.20 8.78 0.65 0.00 0.20 0.00 1.00 1.9015
select tup_updated from pg_stat_database where datname = (s 6786 7610.31 7.61 1.12 0.00 3.07 0.00 1.00 1.6484
select tup_deleted from pg_stat_database where datname = (s 6786 7290.87 7.29 1.07 0.00 3.01 0.00 1.00 1.5792
select tup_fetched from pg_stat_database where datname = (s 6786 7149.82 7.15 1.05 0.00 2.98 0.00 1.00 1.5486
select tup_inserted from pg_stat_database where datname = ( 6786 6922.59 6.92 1.02 0.00 2.93 0.00 1.00 1.4994
select count(*) from pg_stat_all_tables where to_char(las 20358 5939.60 5.94 0.29 0.00 0.79 0.00 1.00 1.2865
select tup_returned from pg_stat_database where datname = ( 6786 5870.45 5.87 0.87 0.00 2.71 0.00 1.00 1.2715
select count(distinct transactionid::varchar) active_transac 6789 5808.85 5.81 0.86 0.00 0.08 0.00 1.00 1.2582
SELECT coalesce(count(*),$1) as "not_granted_lock" FROM pg_l 6786 5718.35 5.72 0.84 0.00 0.22 0.00 1.00 1.2386
select row_to_json(t) from(select array_to_json(array_agg(ro 6786 5624.90 5.62 0.83 0.00 0.19 0.00 1.00 1.2183
select checkpoints_req as "checkpoints_requested" from pg_st 6786 5570.91 5.57 0.82 0.00 2.65 0.00 1.00 1.2066

Top SQL order by avg_time:

query calls total_time_msec total_time_sec avg_time_msec avg_time_sec standard_deviation_time_msec standard_deviation_time_sec rows_per_exec percent
select substring(query,$1,$2) as query , calls,
round(total_		 1 32.69 0.03 32.69 0.03 0.00 0.00 20.00 0.0071
select substring(query,$1,$2) as query , calls,
round(total		 2 64.88 0.06 32.44 0.03 1.20 0.00 20.00 0.0141
select substring(query,$1,$2) as query , calls,
round(total		 1 31.35 0.03 31.35 0.03 0.00 0.00 20.00 0.0068
select substring(query,$1,$2) as query , calls,
round(total_		 1 30.37 0.03 30.37 0.03 0.00 0.00 20.00 0.0066
with table_size_info as
(SELECT
schemaname as schema_name,r		 1 22.28 0.02 22.28 0.02 0.00 0.00 34.00 0.0048
select b.name as extension_name , b.version as version ,b.in 2 27.52 0.03 13.76 0.01 0.02 0.00 2.00 0.0060
select * from pg_available_extension_versions order by name, 2 27.50 0.03 13.75 0.01 0.00 0.00 85.00 0.0060
select name as extension_name , max(version) as latest_versi 2 27.19 0.03 13.60 0.01 0.01 0.00 1.00 0.0059
select sum(blks_read), sum(blks_hit) from pg_stat_database 6789 67820.95 67.82 9.99 0.01 3.91 0.00 1.00 14.6887
select sum(numbackends) numbackends, sum(xact_commit) xact_c 6789 64537.41 64.54 9.51 0.01 3.01 0.00 1.00 13.9775
select confl_lock from pg_stat_database_conflicts where datn 6786 62421.55 62.42 9.20 0.01 3.03 0.00 1.00 13.5193
MOVE ALL IN "query-cursor_6786" 1 7.98 0.01 7.98 0.01 0.00 0.00 0.00 0.0017
MOVE ALL IN "query-cursor_6788" 1 7.07 0.01 7.07 0.01 0.00 0.00 0.00 0.0015
MOVE ALL IN "query-cursor_6789" 1 6.36 0.01 6.36 0.01 0.00 0.00 0.00 0.0014
MOVE ALL IN "query-cursor_6787" 1 6.26 0.01 6.26 0.01 0.00 0.00 0.00 0.0014
MOVE ALL IN "query-cursor_6785" 1 6.19 0.01 6.19 0.01 0.00 0.00 0.00 0.0013
MOVE ALL IN "query-cursor_6782" 1 6.12 0.01 6.12 0.01 0.00 0.00 0.00 0.0013
MOVE ALL IN "query-cursor_6778" 1 6.10 0.01 6.10 0.01 0.00 0.00 0.00 0.0013
MOVE ALL IN "query-cursor_6784" 1 6.04 0.01 6.04 0.01 0.00 0.00 0.00 0.0013
MOVE ALL IN "query-cursor_6772" 1 6.03 0.01 6.03 0.01 0.00 0.00 0.00 0.0013

Top SQL order by percent of total DB time percent:

query calls total_time_msec total_time_sec avg_time_msec avg_time_sec standard_deviation_time_msec standard_deviation_time_sec rows_per_exec percent
select sum(blks_read), sum(blks_hit) from pg_stat_database 6789 67820.95 67.82 9.99 0.01 3.91 0.00 1.00 14.6877
select sum(numbackends) numbackends, sum(xact_commit) xact_c 6789 64537.41 64.54 9.51 0.01 3.01 0.00 1.00 13.9766
select confl_lock from pg_stat_database_conflicts where datn 6786 62421.55 62.42 9.20 0.01 3.03 0.00 1.00 13.5184
WITH upsert AS (UPDATE public.rds_heartbeat2 SET value=$1 WH 606820 44324.51 44.32 0.07 0.00 0.16 0.00 0.00 9.5992
SELECT coalesce(sum(used_bytes),$1) FROM aurora_stat_file() 13577 26144.50 26.14 1.93 0.00 2.11 0.00 1.00 5.6620
select queryid, calls, total_time, rows, shared_blks_hit, sh 5988 17728.12 17.73 2.96 0.00 0.66 0.00 20.00 3.8393
SELECT n_tables_eligible_for_autovacuum from
( WITH vbt AS 		6786 16946.12 16.95 2.50 0.00 1.19 0.00 1.00 3.6699
select count (*) from pg_stat_activity where state = $1 27144 9587.07 9.59 0.35 0.00 0.10 0.00 1.00 2.0762
select round(sum(pg_database_size(pg_database.datname))/$1/$ 6786 9022.60 9.02 1.33 0.00 0.26 0.00 1.00 1.9540
SELECT setting::float AS max_connections FROM pg_settings WH 13572 8779.20 8.78 0.65 0.00 0.20 0.00 1.00 1.9013
select tup_updated from pg_stat_database where datname = (s 6786 7610.31 7.61 1.12 0.00 3.07 0.00 1.00 1.6481
select tup_deleted from pg_stat_database where datname = (s 6786 7290.87 7.29 1.07 0.00 3.01 0.00 1.00 1.5790
select tup_fetched from pg_stat_database where datname = (s 6786 7149.82 7.15 1.05 0.00 2.98 0.00 1.00 1.5484
select tup_inserted from pg_stat_database where datname = ( 6786 6922.59 6.92 1.02 0.00 2.93 0.00 1.00 1.4992
select count(*) from pg_stat_all_tables where to_char(las 20358 5939.60 5.94 0.29 0.00 0.79 0.00 1.00 1.2863
select tup_returned from pg_stat_database where datname = ( 6786 5870.45 5.87 0.87 0.00 2.71 0.00 1.00 1.2713
select count(distinct transactionid::varchar) active_transac 6789 5808.85 5.81 0.86 0.00 0.08 0.00 1.00 1.2580
SELECT coalesce(count(*),$1) as "not_granted_lock" FROM pg_l 6786 5718.35 5.72 0.84 0.00 0.22 0.00 1.00 1.2384
select row_to_json(t) from(select array_to_json(array_agg(ro 6786 5624.90 5.62 0.83 0.00 0.19 0.00 1.00 1.2182
select checkpoints_req as "checkpoints_requested" from pg_st 6786 5570.91 5.57 0.82 0.00 2.65 0.00 1.00 1.2065

Top SQL order by number of execution (CALLs):

query calls total_time_msec total_time_sec avg_time avg_time standard_deviation_time_msec standard_deviation_time_sec rows_per_exec percent
WITH upsert AS (UPDATE public.rds_heartbeat2 SET value=$1 WH 606820 44324.51 44.32 0.07 0.00 0.16 0.00 0.00 9.5985
begin transaction 291798 149.48 0.15 0.00 0.00 0.00 0.00 0.00 0.0324
SET statement_timeout = 10000 291798 1967.99 1.97 0.01 0.00 0.01 0.00 0.00 0.4262
commit 291798 165.28 0.17 0.00 0.00 0.00 0.00 0.00 0.0358
SELECT server_id, durable_lsn, current_read_lsn, last_update 203671 3884.09 3.88 0.02 0.00 0.01 0.00 2.00 0.8411
COMMIT 108623 68.97 0.07 0.00 0.00 0.02 0.00 0.00 0.0149
BEGIN 108623 110.11 0.11 0.00 0.00 0.00 0.00 0.00 0.0238
SELECT $1 40734 187.80 0.19 0.00 0.00 0.01 0.00 1.00 0.0407
select count (*) from pg_stat_activity where state = $1 27144 9587.07 9.59 0.35 0.00 0.10 0.00 1.00 2.0761
SELECT count(*) FROM pg_catalog.pg_class c JOIN pg_catalog.p 20366 808.66 0.81 0.04 0.00 0.30 0.00 1.00 0.1751
select count(*) from pg_stat_all_tables where to_char(last 20358 4828.34 4.83 0.24 0.00 0.56 0.00 1.00 1.0456
select count(*) from pg_stat_all_tables where to_char(las 20358 5939.60 5.94 0.29 0.00 0.79 0.00 1.00 1.2862
select max(age(datfrozenxid)) max_used_xact_ids from pg_data 13691 163.98 0.16 0.01 0.00 0.08 0.00 1.00 0.0355
SELECT coalesce(sum(used_bytes),$1) FROM aurora_stat_file() 13577 26144.50 26.14 1.93 0.00 2.11 0.00 1.00 5.6616
select count (*) from pg_replication_slots where active = $1 13572 167.49 0.17 0.01 0.00 0.01 0.00 1.00 0.0363
select coalesce(round((hs + ms + s)::numeric,$1),$2) as max_ 13572 5393.32 5.39 0.40 0.00 0.17 0.00 1.00 1.1679
SELECT setting::float AS max_connections FROM pg_settings WH 13572 8779.20 8.78 0.65 0.00 0.20 0.00 1.00 1.9011
select sum(blks_read), sum(blks_hit) from pg_stat_database 6789 67820.95 67.82 9.99 0.01 3.91 0.00 1.00 14.6867
SELECT count(*) from pg_catalog.pg_proc where proname=$1 and 6789 138.73 0.14 0.02 0.00 0.09 0.00 1.00 0.0300
select extract($1 from current_timestamp - pg_postmaster_sta 6789 47.83 0.05 0.01 0.00 0.00 0.00 1.00 0.0104
[Top]

Users & Roles Info


List of roles
Role name Attributes Member of
app_ro   {}
app_rw   {}
app_schema No inheritance, Cannot login {}
iam_testdb 2 connections {pg_monitor,rds_iam}
pg_monitor Cannot login {pg_read_all_settings,pg_read_all_stats,pg_stat_scan_tables}
pg_read_all_settings Cannot login {}
pg_read_all_stats Cannot login {}
pg_signal_backend Cannot login {}
pg_stat_scan_tables Cannot login {}
rds_ad Cannot login {}
rds_iam Cannot login {}
rds_password Cannot login {}
rds_pgaudit Cannot login {}
rds_replication Cannot login {}
rds_superuser Cannot login {pg_monitor,pg_signal_backend,rds_replication,rds_password}
rdsadmin Superuser, Create role, Create DB, Replication
Password valid until infinity		 {}
replicauser   {rds_replication}
sys Create role, Create DB
Password valid until infinity		 {rds_superuser,app_schema}
test_testdb 2 connections {pg_monitor}

List of settings
Role Database Settings
app_ro   search_path=app_schema, pg_catalog
app_rw   search_path=app_schema, pg_catalog
rdsadmin rdsadmin log_min_messages=panic
rdsadmin   TimeZone=utc
log_statement=all
log_min_error_statement=debug5
log_min_messages=panic
exit_on_error=0
statement_timeout=0
role=rdsadmin
auto_explain.log_min_duration=-1
temp_file_limit=-1
search_path=pg_catalog, public
pg_hint_plan.enable_hint=off
default_transaction_read_only=off
replicauser   search_path=app_schema, pg_catalog
test_testdb   pgaudit.log=all
  rdsadmin auto_explain.log_min_duration=-1

usename usesysid usecreatedb usesuper userepl usebypassrls passwd valuntil useconfig
sys 16394 t f f f ******** infinity  
iam_testdb 20499 f f f f ********    
test_testdb 20500 f f f f ********   {pgaudit.log=all}
replicauser 32788 f f f f ********   {"search_path=app_schema, pg_catalog"}
app_ro 32838 f f f f ********   {"search_path=app_schema, pg_catalog"}
app_rw 32840 f f f f ********   {"search_path=app_schema, pg_catalog"}
rdsadmin 10 t t t t ******** infinity {TimeZone=utc,log_statement=all,log_min_error_statement=debug5,log_min_messages=panic,exit_on_error=0,statement_timeout=0,role=rdsadmin,auto_explain.log_min_duration=-1,temp_file_limit=-1,"search_path=pg_catalog, public",pg_hint_plan.enable_hint=off,default_transaction_read_only=off}
[Top]

Schema Info


List of schemas
Name Owner Access privileges Description
admin sys    
app_schema app_schema app_schema=UC/app_schema
app_ro=U/app_schema
app_rw=U/app_schema
replicauser=U/app_schema		  
public sys sys=UC/sys
=UC/sys		 standard public schema
[Top]

Tablespaces Info


List of tablespaces
Name Owner Location
pg_default rdsadmin  
pg_global rdsadmin  

Tablsapces Location :

spclocation spcname
/rdsdbdata/db/base/ pg_default
/rdsdbdata/db/global/ pg_global
[Top]

Tabel Access Profile


schema_name Table_Name Table_Size total_fts_scan total_fts_num_rows_reads fts_rows_per_read total_idx_scan total_idx_num_rows_read idx_rows_per_read IDX_scan_% FTS_scan_% access_profile n_live_tup n_dead_tup dead_tup_% n_tup_ins n_tup_upd n_tup_del tup_ins_% tup_upd_% tup_del_%
public big_table_apg 9221 MB 0 0   0 0       IDX 0 0   0 0 0      
app_schema app_data_table 1304 kB 0 0   0 0       IDX 0 0   0 0 0      
public autovac_demo 856 kB 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_2618 424 kB 0 0   20462 47837 2 100.00 0.00 IDX 0 0   0 0 0      
information_schema sql_features 56 kB 0 0             IDX 0 0   0 0 0      
pg_toast pg_toast_2619 24 kB 0 0   20 27 1 100.00 0.00 IDX 0 0   0 0 0      
public pg_acct_management 8192 bytes 0 0             IDX 0 0   0 0 0      
information_schema sql_sizing 8192 bytes 0 0             IDX 0 0   0 0 0      
information_schema sql_parts 8192 bytes 0 0             IDX 0 0   0 0 0      
information_schema sql_languages 8192 bytes 0 0             IDX 0 0   0 0 0      
information_schema sql_implementation_info 8192 bytes 0 0             IDX 0 0   0 0 0      
public idx_test 8192 bytes 0 0   0 0       IDX 0 0   0 0 0      
information_schema sql_packages 8192 bytes 0 0             IDX 0 0   0 0 0      
pg_toast pg_toast_13799 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_3381 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_13779 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_13784 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_2620 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
app_schema test 0 bytes 0 0             IDX 0 0   0 0 0      
pg_toast pg_toast_2964 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_3592 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_3596 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
app_schema test_3 0 bytes 0 0             IDX 0 0   0 0 0      
pg_toast pg_toast_13789 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_13794 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_13769 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_2604 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
information_schema sql_sizing_profiles 0 bytes 0 0             IDX 0 0   0 0 0      
pg_toast pg_toast_2606 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_2609 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_13774 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
app_schema test_2 0 bytes 0 0             IDX 0 0   0 0 0      
pg_toast pg_toast_1255 0 bytes 0 0   0 0       IDX 0 0   0 0 0      
pg_toast pg_toast_2396 0 bytes 0 0   0 0       IDX 0 0   0 0 0      

Tables have more full table scan than index scan :

schema_name Table_Name Table_Size total_fts_scan total_fts_num_rows_reads fts_rows_per_read total_idx_scan total_idx_num_rows_read idx_rows_per_read IDX_scan_% FTS_scan_% access_profile n_live_tup n_dead_tup dead_tup_% n_tup_ins n_tup_upd n_tup_del tup_ins_% tup_upd_% tup_del_%
[Top]

Unused Indexes


schemaname tablename indexname idx_scan index_size pretty_index_size
public big_table_apg big_table_apg_pkey 0 4904402944 4677 MB
app_schema app_data_table app_data_table_value_idx 0 252805120 241 MB
app_schema app_data_table app_data_table_pkey 0 250085376 239 MB
public autovac_demo autovac_demo_pkey 0 753664 736 kB
public idx_test idx_test_id_key 0 16384 16 kB
public idx_test idx_test_value 0 16384 16 kB
pg_toast pg_toast_2620 pg_toast_2620_index 0 8192 8192 bytes
pg_toast pg_toast_2396 pg_toast_2396_index 0 8192 8192 bytes
pg_toast pg_toast_2964 pg_toast_2964_index 0 8192 8192 bytes
pg_toast pg_toast_3592 pg_toast_3592_index 0 8192 8192 bytes
pg_toast pg_toast_2604 pg_toast_2604_index 0 8192 8192 bytes
pg_toast pg_toast_13774 pg_toast_13774_index 0 8192 8192 bytes
pg_toast pg_toast_13779 pg_toast_13779_index 0 8192 8192 bytes
pg_toast pg_toast_13784 pg_toast_13784_index 0 8192 8192 bytes
pg_toast pg_toast_13789 pg_toast_13789_index 0 8192 8192 bytes
pg_toast pg_toast_13794 pg_toast_13794_index 0 8192 8192 bytes
pg_toast pg_toast_13799 pg_toast_13799_index 0 8192 8192 bytes
pg_toast pg_toast_13769 pg_toast_13769_index 0 8192 8192 bytes
pg_toast pg_toast_2606 pg_toast_2606_index 0 8192 8192 bytes
pg_toast pg_toast_2609 pg_toast_2609_index 0 8192 8192 bytes
pg_toast pg_toast_1255 pg_toast_1255_index 0 8192 8192 bytes
pg_toast pg_toast_3596 pg_toast_3596_index 0 8192 8192 bytes
pg_toast pg_toast_3381 pg_toast_3381_index 0 8192 8192 bytes
[Top]

Index Access Profile


schemaname Table_Name indexname index_size idx_scan idx_tup_read idx_tup_fetch
pg_toast pg_toast_2619 pg_toast_2619_index 16 kB 20 27 27
pg_toast pg_toast_2618 pg_toast_2618_index 16 kB 20462 47837 47837
[Top]

Fragmentation (Bloat)


Tables and indexes Bloat [Fragmentation] order by table wasted size :

current_database schemaname tablename table_bloat_% wastedbytes table_wasted_size index_nam Index_bloat_% wastedibytes index_wasted_size
testdb public big_table_apg 1.1 940343296 897 MB big_table_apg_pkey 0.9 0 0 bytes
testdb public autovac_demo 2.1 458752 448 kB autovac_demo_pkey 3.1 507904 496 kB
testdb app_schema app_data_table 1.1 131072 128 kB app_data_table_value_idx 346.7 252076032 240 MB
testdb app_schema app_data_table 1.1 131072 128 kB app_data_table_pkey 343.0 249356288 238 MB
testdb pg_catalog pg_description 1.1 24576 24 kB pg_description_o_c_o_index 0.9 0 0 bytes
testdb pg_catalog pg_depend 1.1 24576 24 kB pg_depend_reference_index 1.4 98304 96 kB
testdb pg_catalog pg_depend 1.1 24576 24 kB pg_depend_depender_index 1.2 65536 64 kB
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_oid_index 0.5 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_relname_nsp_index 0.8 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_tblspc_relfilenode_index 0.6 0 0 bytes
testdb pg_catalog pg_rewrite 1.1 8192 8192 bytes pg_rewrite_rel_rulename_index 0.2 0 0 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_fam_strat_index 1.3 8192 8192 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_opr_fam_index 1.3 8192 8192 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_amproc 1.3 8192 8192 bytes pg_amproc_fam_proc_index 2.0 16384 16 kB
testdb pg_catalog pg_amproc 1.3 8192 8192 bytes pg_amproc_oid_index 2.0 16384 16 kB
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_default_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_opclass 1.5 8192 8192 bytes pg_opclass_am_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_opclass 1.5 8192 8192 bytes pg_opclass_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_operator 1.1 8192 8192 bytes pg_operator_oid_index 0.4 0 0 bytes
testdb pg_catalog pg_operator 1.1 8192 8192 bytes pg_operator_oprname_l_r_n_index 0.5 0 0 bytes
testdb pg_catalog pg_rewrite 1.1 8192 8192 bytes pg_rewrite_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_parser 1.0 0 0 bytes pg_ts_parser_prsname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_parser 1.0 0 0 bytes pg_ts_parser_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_template 1.0 0 0 bytes pg_ts_template_tmplname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_database 1.0 0 0 bytes pg_database_datname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_database 1.0 0 0 bytes pg_database_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_auth_members 1.0 0 0 bytes pg_auth_members_role_member_index 2.0 8192 8192 bytes
testdb pg_catalog pg_attribute 0.9 0 0 bytes pg_attribute_relid_attnum_index 0.2 0 0 bytes
testdb pg_catalog pg_attribute 0.9 0 0 bytes pg_attribute_relid_attnam_index 0.3 0 0 bytes
testdb pg_catalog pg_extension 1.0 0 0 bytes pg_extension_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_extension 1.0 0 0 bytes pg_extension_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_index 0.8 0 0 bytes pg_index_indrelid_index 0.7 0 0 bytes
testdb pg_catalog pg_index 0.8 0 0 bytes pg_index_indexrelid_index 0.7 0 0 bytes
testdb pg_catalog pg_init_privs 1.0 0 0 bytes pg_init_privs_o_c_o_index 1.0 0 0 bytes
testdb pg_catalog pg_language 1.0 0 0 bytes pg_language_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_language 1.0 0 0 bytes pg_language_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_namespace 1.0 0 0 bytes pg_namespace_nspname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_namespace 1.0 0 0 bytes pg_namespace_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_template 1.0 0 0 bytes pg_ts_template_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_type 1.0 0 0 bytes pg_type_oid_index 0.3 0 0 bytes
testdb pg_catalog pg_type 1.0 0 0 bytes pg_type_typname_nsp_index 0.7 0 0 bytes
testdb pg_catalog pg_am 1.0 0 0 bytes pg_am_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_opfamily 1.0 0 0 bytes pg_opfamily_am_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_opfamily 1.0 0 0 bytes pg_opfamily_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_pltemplate 1.0 0 0 bytes pg_pltemplate_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_proc 0.9 0 0 bytes pg_proc_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_proc 0.9 0 0 bytes pg_proc_proname_args_nsp_index 0.5 0 0 bytes
testdb pg_catalog pg_range 1.0 0 0 bytes pg_range_rngtypid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_aggregate 1.0 0 0 bytes pg_aggregate_fnoid_index 1.0 0 0 bytes
testdb pg_catalog pg_am 1.0 0 0 bytes pg_am_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdepend 1.0 0 0 bytes pg_shdepend_depender_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdepend 1.0 0 0 bytes pg_shdepend_reference_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdescription 1.0 0 0 bytes pg_shdescription_o_c_index 2.0 8192 8192 bytes
testdb pg_catalog pg_tablespace 1.0 0 0 bytes pg_tablespace_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_tablespace 1.0 0 0 bytes pg_tablespace_spcname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config 1.0 0 0 bytes pg_ts_config_cfgname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config 1.0 0 0 bytes pg_ts_config_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config_map 1.0 0 0 bytes pg_ts_config_map_index 2.0 16384 16 kB
testdb pg_catalog pg_ts_dict 1.0 0 0 bytes pg_ts_dict_dictname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_dict 1.0 0 0 bytes pg_ts_dict_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_cast 1.0 0 0 bytes pg_cast_source_target_index 2.0 8192 8192 bytes
testdb pg_catalog pg_cast 1.0 0 0 bytes pg_cast_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_auth_members 1.0 0 0 bytes pg_auth_members_member_role_index 2.0 8192 8192 bytes
testdb pg_catalog pg_collation 1.0 0 0 bytes pg_collation_name_enc_nsp_index 0.3 0 0 bytes
testdb pg_catalog pg_collation 1.0 0 0 bytes pg_collation_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_conname_nsp_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_conrelid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_contypid_index 2.0 8192 8192 bytes

Tables and indexes Bloat [Fragmentation] order by table wasted % :

current_database schemaname tablename table_bloat_% wastedbytes table_wasted_size index_nam Index_bloat_% wastedibytes index_wasted_size
testdb public autovac_demo 2.1 458752 448 kB autovac_demo_pkey 3.1 507904 496 kB
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_default_index 1.0 0 0 bytes
testdb pg_catalog pg_opclass 1.5 8192 8192 bytes pg_opclass_am_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_opclass 1.5 8192 8192 bytes pg_opclass_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_amproc 1.3 8192 8192 bytes pg_amproc_fam_proc_index 2.0 16384 16 kB
testdb pg_catalog pg_amproc 1.3 8192 8192 bytes pg_amproc_oid_index 2.0 16384 16 kB
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_tblspc_relfilenode_index 0.6 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_oid_index 0.5 0 0 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_fam_strat_index 1.3 8192 8192 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_opr_fam_index 1.3 8192 8192 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_relname_nsp_index 0.8 0 0 bytes
testdb pg_catalog pg_rewrite 1.1 8192 8192 bytes pg_rewrite_rel_rulename_index 0.2 0 0 bytes
testdb app_schema app_data_table 1.1 131072 128 kB app_data_table_pkey 343.0 249356288 238 MB
testdb pg_catalog pg_depend 1.1 24576 24 kB pg_depend_depender_index 1.2 65536 64 kB
testdb pg_catalog pg_depend 1.1 24576 24 kB pg_depend_reference_index 1.4 98304 96 kB
testdb pg_catalog pg_description 1.1 24576 24 kB pg_description_o_c_o_index 0.9 0 0 bytes
testdb pg_catalog pg_operator 1.1 8192 8192 bytes pg_operator_oid_index 0.4 0 0 bytes
testdb pg_catalog pg_operator 1.1 8192 8192 bytes pg_operator_oprname_l_r_n_index 0.5 0 0 bytes
testdb pg_catalog pg_rewrite 1.1 8192 8192 bytes pg_rewrite_oid_index 0.2 0 0 bytes
testdb app_schema app_data_table 1.1 131072 128 kB app_data_table_value_idx 346.7 252076032 240 MB
testdb public big_table_apg 1.1 940343296 897 MB big_table_apg_pkey 0.9 0 0 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_contypid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_auth_members 1.0 0 0 bytes pg_auth_members_role_member_index 2.0 8192 8192 bytes
testdb pg_catalog pg_auth_members 1.0 0 0 bytes pg_auth_members_member_role_index 2.0 8192 8192 bytes
testdb pg_catalog pg_collation 1.0 0 0 bytes pg_collation_name_enc_nsp_index 0.3 0 0 bytes
testdb pg_catalog pg_collation 1.0 0 0 bytes pg_collation_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_conname_nsp_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_conrelid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_database 1.0 0 0 bytes pg_database_datname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_database 1.0 0 0 bytes pg_database_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_parser 1.0 0 0 bytes pg_ts_parser_prsname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_parser 1.0 0 0 bytes pg_ts_parser_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_template 1.0 0 0 bytes pg_ts_template_tmplname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_extension 1.0 0 0 bytes pg_extension_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_extension 1.0 0 0 bytes pg_extension_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_init_privs 1.0 0 0 bytes pg_init_privs_o_c_o_index 1.0 0 0 bytes
testdb pg_catalog pg_language 1.0 0 0 bytes pg_language_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_language 1.0 0 0 bytes pg_language_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_namespace 1.0 0 0 bytes pg_namespace_nspname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_namespace 1.0 0 0 bytes pg_namespace_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_am 1.0 0 0 bytes pg_am_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_am 1.0 0 0 bytes pg_am_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_template 1.0 0 0 bytes pg_ts_template_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_type 1.0 0 0 bytes pg_type_oid_index 0.3 0 0 bytes
testdb pg_catalog pg_opfamily 1.0 0 0 bytes pg_opfamily_am_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_opfamily 1.0 0 0 bytes pg_opfamily_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_pltemplate 1.0 0 0 bytes pg_pltemplate_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_range 1.0 0 0 bytes pg_range_rngtypid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_type 1.0 0 0 bytes pg_type_typname_nsp_index 0.7 0 0 bytes
testdb pg_catalog pg_aggregate 1.0 0 0 bytes pg_aggregate_fnoid_index 1.0 0 0 bytes
testdb pg_catalog pg_shdepend 1.0 0 0 bytes pg_shdepend_depender_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdepend 1.0 0 0 bytes pg_shdepend_reference_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdescription 1.0 0 0 bytes pg_shdescription_o_c_index 2.0 8192 8192 bytes
testdb pg_catalog pg_tablespace 1.0 0 0 bytes pg_tablespace_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_tablespace 1.0 0 0 bytes pg_tablespace_spcname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config 1.0 0 0 bytes pg_ts_config_cfgname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config 1.0 0 0 bytes pg_ts_config_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config_map 1.0 0 0 bytes pg_ts_config_map_index 2.0 16384 16 kB
testdb pg_catalog pg_ts_dict 1.0 0 0 bytes pg_ts_dict_dictname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_dict 1.0 0 0 bytes pg_ts_dict_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_cast 1.0 0 0 bytes pg_cast_source_target_index 2.0 8192 8192 bytes
testdb pg_catalog pg_cast 1.0 0 0 bytes pg_cast_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_attribute 0.9 0 0 bytes pg_attribute_relid_attnum_index 0.2 0 0 bytes
testdb pg_catalog pg_attribute 0.9 0 0 bytes pg_attribute_relid_attnam_index 0.3 0 0 bytes
testdb pg_catalog pg_proc 0.9 0 0 bytes pg_proc_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_proc 0.9 0 0 bytes pg_proc_proname_args_nsp_index 0.5 0 0 bytes
testdb pg_catalog pg_index 0.8 0 0 bytes pg_index_indexrelid_index 0.7 0 0 bytes
testdb pg_catalog pg_index 0.8 0 0 bytes pg_index_indrelid_index 0.7 0 0 bytes

Tables and indexes Bloat [Fragmentation] order by index wasted % :

current_database schemaname tablename table_bloat_% wastedbytes table_wasted_size index_nam Index_bloat_% wastedibytes index_wasted_size
testdb app_schema app_data_table 1.1 131072 128 kB app_data_table_value_idx 346.7 252076032 240 MB
testdb app_schema app_data_table 1.1 131072 128 kB app_data_table_pkey 343.0 249356288 238 MB
testdb public autovac_demo 2.1 458752 448 kB autovac_demo_pkey 3.1 507904 496 kB
testdb pg_catalog pg_am 1.0 0 0 bytes pg_am_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_namespace 1.0 0 0 bytes pg_namespace_nspname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdepend 1.0 0 0 bytes pg_shdepend_depender_index 2.0 8192 8192 bytes
testdb pg_catalog pg_am 1.0 0 0 bytes pg_am_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_extension 1.0 0 0 bytes pg_extension_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_dict 1.0 0 0 bytes pg_ts_dict_dictname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config_map 1.0 0 0 bytes pg_ts_config_map_index 2.0 16384 16 kB
testdb pg_catalog pg_language 1.0 0 0 bytes pg_language_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_language 1.0 0 0 bytes pg_language_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdepend 1.0 0 0 bytes pg_shdepend_reference_index 2.0 8192 8192 bytes
testdb pg_catalog pg_namespace 1.0 0 0 bytes pg_namespace_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config 1.0 0 0 bytes pg_ts_config_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_config 1.0 0 0 bytes pg_ts_config_cfgname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_pltemplate 1.0 0 0 bytes pg_pltemplate_name_index 2.0 8192 8192 bytes
testdb pg_catalog pg_tablespace 1.0 0 0 bytes pg_tablespace_spcname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_tablespace 1.0 0 0 bytes pg_tablespace_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_range 1.0 0 0 bytes pg_range_rngtypid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_shdescription 1.0 0 0 bytes pg_shdescription_o_c_index 2.0 8192 8192 bytes
testdb pg_catalog pg_amproc 1.3 8192 8192 bytes pg_amproc_fam_proc_index 2.0 16384 16 kB
testdb pg_catalog pg_amproc 1.3 8192 8192 bytes pg_amproc_oid_index 2.0 16384 16 kB
testdb pg_catalog pg_auth_members 1.0 0 0 bytes pg_auth_members_role_member_index 2.0 8192 8192 bytes
testdb pg_catalog pg_auth_members 1.0 0 0 bytes pg_auth_members_member_role_index 2.0 8192 8192 bytes
testdb pg_catalog pg_cast 1.0 0 0 bytes pg_cast_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_cast 1.0 0 0 bytes pg_cast_source_target_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_template 1.0 0 0 bytes pg_ts_template_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_template 1.0 0 0 bytes pg_ts_template_tmplname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_parser 1.0 0 0 bytes pg_ts_parser_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_parser 1.0 0 0 bytes pg_ts_parser_prsname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_ts_dict 1.0 0 0 bytes pg_ts_dict_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_conname_nsp_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_conrelid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_contypid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_constraint 1.0 0 0 bytes pg_constraint_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_database 1.0 0 0 bytes pg_database_datname_index 2.0 8192 8192 bytes
testdb pg_catalog pg_database 1.0 0 0 bytes pg_database_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_extension 1.0 0 0 bytes pg_extension_oid_index 2.0 8192 8192 bytes
testdb pg_catalog pg_depend 1.1 24576 24 kB pg_depend_reference_index 1.4 98304 96 kB
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_fam_strat_index 1.3 8192 8192 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_opr_fam_index 1.3 8192 8192 bytes
testdb pg_catalog pg_depend 1.1 24576 24 kB pg_depend_depender_index 1.2 65536 64 kB
testdb pg_catalog pg_opfamily 1.0 0 0 bytes pg_opfamily_am_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_amop 1.2 8192 8192 bytes pg_amop_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_opfamily 1.0 0 0 bytes pg_opfamily_oid_index 1.0 0 0 bytes
testdb pg_catalog pg_init_privs 1.0 0 0 bytes pg_init_privs_o_c_o_index 1.0 0 0 bytes
testdb pg_catalog pg_conversion 1.5 8192 8192 bytes pg_conversion_default_index 1.0 0 0 bytes
testdb pg_catalog pg_aggregate 1.0 0 0 bytes pg_aggregate_fnoid_index 1.0 0 0 bytes
testdb pg_catalog pg_opclass 1.5 8192 8192 bytes pg_opclass_am_name_nsp_index 1.0 0 0 bytes
testdb pg_catalog pg_opclass 1.5 8192 8192 bytes pg_opclass_oid_index 1.0 0 0 bytes
testdb public big_table_apg 1.1 940343296 897 MB big_table_apg_pkey 0.9 0 0 bytes
testdb pg_catalog pg_description 1.1 24576 24 kB pg_description_o_c_o_index 0.9 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_relname_nsp_index 0.8 0 0 bytes
testdb pg_catalog pg_type 1.0 0 0 bytes pg_type_typname_nsp_index 0.7 0 0 bytes
testdb pg_catalog pg_index 0.8 0 0 bytes pg_index_indexrelid_index 0.7 0 0 bytes
testdb pg_catalog pg_index 0.8 0 0 bytes pg_index_indrelid_index 0.7 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_tblspc_relfilenode_index 0.6 0 0 bytes
testdb pg_catalog pg_class 1.2 16384 16 kB pg_class_oid_index 0.5 0 0 bytes
testdb pg_catalog pg_operator 1.1 8192 8192 bytes pg_operator_oprname_l_r_n_index 0.5 0 0 bytes
testdb pg_catalog pg_proc 0.9 0 0 bytes pg_proc_proname_args_nsp_index 0.5 0 0 bytes
testdb pg_catalog pg_operator 1.1 8192 8192 bytes pg_operator_oid_index 0.4 0 0 bytes
testdb pg_catalog pg_attribute 0.9 0 0 bytes pg_attribute_relid_attnam_index 0.3 0 0 bytes
testdb pg_catalog pg_collation 1.0 0 0 bytes pg_collation_name_enc_nsp_index 0.3 0 0 bytes
testdb pg_catalog pg_type 1.0 0 0 bytes pg_type_oid_index 0.3 0 0 bytes
testdb pg_catalog pg_collation 1.0 0 0 bytes pg_collation_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_rewrite 1.1 8192 8192 bytes pg_rewrite_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_proc 0.9 0 0 bytes pg_proc_oid_index 0.2 0 0 bytes
testdb pg_catalog pg_rewrite 1.1 8192 8192 bytes pg_rewrite_rel_rulename_index 0.2 0 0 bytes
testdb pg_catalog pg_attribute 0.9 0 0 bytes pg_attribute_relid_attnum_index 0.2 0 0 bytes
[Top]

Toast Tables Mapping

table_name toast_name toast_size
pg_proc pg_toast_1255 0 bytes
sql_features pg_toast_13769 0 bytes
sql_implementation_info pg_toast_13774 0 bytes
sql_languages pg_toast_13779 0 bytes
sql_packages pg_toast_13784 0 bytes
sql_parts pg_toast_13789 0 bytes
sql_sizing pg_toast_13794 0 bytes
sql_sizing_profiles pg_toast_13799 0 bytes
pg_shdescription pg_toast_2396 0 bytes
pg_attrdef pg_toast_2604 0 bytes
pg_constraint pg_toast_2606 0 bytes
pg_description pg_toast_2609 0 bytes
pg_rewrite pg_toast_2618 424 kB
pg_statistic pg_toast_2619 24 kB
pg_trigger pg_toast_2620 0 bytes
pg_db_role_setting pg_toast_2964 0 bytes
pg_statistic_ext pg_toast_3381 0 bytes
pg_shseclabel pg_toast_3592 0 bytes
pg_seclabel pg_toast_3596 0 bytes
[Top]

Replication slot

Active replication slots :

slot_name plugin slot_type datoid database temporary active active_pid xmin catalog_xmin restart_lsn confirmed_flush_lsn
rpg_testdb_logical pgoutput logical 16400 testdb f t 18642   18874219 4/7CDB5230 4/7CDB85C8

Inactive replication slots :

slot_name plugin slot_type datoid database temporary active active_pid xmin catalog_xmin restart_lsn confirmed_flush_lsn

Note:

RDS Postgres instance storage may get full because inactive replication slots were not removed after DMS task completed

If replication slot is created and it becomes in-active, then transaction logs wont recycle from master instance. So eventually storage gets full

These replication slots can be cleaned as below


Drop inactive replication slot :

Use the below SQL to Generate SQL to drop the inactive slots

select select pg_drop_replication_slot('||slot_name||'); from pg_replication_slots where active = false;

then Verify the CLoudWatch metrics Free Storage Space to confirm that disk space was released

[Top]

active sessions monitor

usename pid xact_duration query_duration query state wait_event
[Top]

Orphaned prepared transactions

gid prepared owner database xmin

Note:

During two-phase commit, a distributed transaction is first prepared with the PREPARE statement and then committed with the COMMIT PREPARED statement

Once a transaction has been prepared, it is kept “hanging around” until it is committed or aborted. It

even has to survive a server restart! Normally, transactions don’t remain in the prepared state for long,

but sometimes things go wrong and a prepared transaction has to be removed manually by an administrator.

any Orphaned prepared transactions will prevent the VACUUM to remove the dead rows

EXAMPLE: DETAIL: 50000 dead row versions cannot be removed yet,oldest xmin: 22300


Use the ROLLBACK PREPARED transaction_id SQL statement to remove prepared transactions

[Top]

PK or FK using numeric or integer data type

table_schema table_name constraint_name constraint_type position column_name data_type
app_schema app_data_table app_data_table_pkey PRIMARY KEY 1 id integer
public autovac_demo autovac_demo_pkey PRIMARY KEY 1 id integer
public big_table_apg big_table_apg_pkey PRIMARY KEY 1 id integer
[Top]

public Schema

schema_name object_type object_count
public index 4
public sequence 3
public table 4
public view 3
schema owner object_name object_type
public rdsadmin dblink_pkey_results TYPE
public rdsadmin pg_stat_statements VIEW
public sys pglog_2020_05_2157 f
public sys pglog f
public sys pglog_2020-05-27-2300 f
public sys postgresql.log.2020-05-27-2300.csv f
public sys postgresql.log.2020-05-28-0400.csv f
public sys postgresql.log.2020-05-27-2157.csv f
public sys postgresql.log.2020-05-28-0100.csv f
public sys postgresql.log.2020-05-28-0600.csv f
public sys postgresql.log.2020-05-28-0200.csv f
public sys postgresql.log.2020-05-28-0000.csv f
public sys postgresql.log.2020-05-28-0700.csv f
public sys postgresql.log.2020-05-27-2100 f
public sys 2020-05-27-2100 f
public sys 2020_05_27_2100 f
public sys pglog_2020_05_27_2100 f
public sys postgresql.log.2020-05-27-2200.csv f
public sys postgresql.log.2020-05-28-0500.csv f
public sys postgresql.log.2020-05-28-0300.csv f
public sys big_table_apg_pkey INDEX
public sys idx_test_id_key INDEX
public sys autovac_demo_pkey INDEX
public sys idx_test_value INDEX
public sys autovac_demo_id_seq SEQUENCE
public sys big_table_apg_id_seq SEQUENCE
public sys idx_test_id_seq SEQUENCE
public sys pg_acct_management TABLE
public sys big_table_apg TABLE
public sys idx_test TABLE
public sys autovac_demo TABLE
public sys lock VIEW
public sys lock_tree VIEW
schema owner function_name
public rds_superuser create_foreign_table_for_log_file
public rds_superuser log_fdw_handler
public rds_superuser log_fdw_validator
public rds_superuser list_postgres_log_files
public rdsadmin dblink_connect_u
public rdsadmin dblink_connect_u
public rdsadmin dblink_disconnect
public rdsadmin dblink_disconnect
public rdsadmin dblink_open
public rdsadmin dblink_open
public rdsadmin dblink_open
public rdsadmin dblink_open
public rdsadmin dblink_fetch
public rdsadmin dblink_fetch
public rdsadmin dblink_fetch
public rdsadmin dblink_fetch
public rdsadmin dblink_close
public rdsadmin dblink_close
public rdsadmin dblink_close
public rdsadmin dblink_close
public rdsadmin pg_stat_statements_reset
public rdsadmin pgaudit_sql_drop
public rdsadmin dblink_connect
public rdsadmin dblink_connect
public rdsadmin pgaudit_ddl_command_end
public rdsadmin dblink
public rdsadmin dblink
public rdsadmin dblink
public rdsadmin dblink
public rdsadmin dblink_exec
public rdsadmin dblink_exec
public rdsadmin dblink_exec
public rdsadmin dblink_exec
public rdsadmin dblink_get_pkey
public rdsadmin dblink_build_sql_insert
public rdsadmin dblink_build_sql_delete
public rdsadmin dblink_build_sql_update
public rdsadmin dblink_current_query
public rdsadmin dblink_send_query
public rdsadmin dblink_is_busy
public rdsadmin dblink_get_result
public rdsadmin dblink_get_result
public rdsadmin dblink_get_connections
public rdsadmin dblink_cancel_query
public rdsadmin dblink_error_message
public rdsadmin dblink_get_notify
public rdsadmin dblink_get_notify
public rdsadmin dblink_fdw_validator
public rdsadmin pg_stat_statements
public sys table_privs
schema table_name trigger_schema trigger_name event activation condition definition
[Top]

invalid indexes

count_of_invalid_indxes
0
indx_id index_name table_name schema_name owner_id indx_is_valid
[Top]

Default access privileges

Owner Schema Type Access privileges
app_schema app_schema table app_ro=r/app_schema
app_rw=r/app_schema
sys app_schema table replicauser=r/sys
app_ro=r/sys
app_rw=arwd/sys
[Top]

pgaudit extension

Extension Name Version Schema owner Description relocatable to another schema extconfig extcondition
pgaudit 1.2 public rdsadmin provides auditing functionality t    

parameter_name setting
pgaudit.log ddl,role
pgaudit.log_catalog on
pgaudit.log_client off
pgaudit.log_level log
pgaudit.log_parameter on
pgaudit.log_relation off
pgaudit.log_statement_once off
pgaudit.role rds_pgaudit
shared_preload_libraries rdsutils,pg_stat_statements,pgaudit,apg_plan_mgmt

pgaudit user level configuration :

user_name user_config
test_testdb {pgaudit.log=all}
[Top]

Unlogged Tables

Number of Unlogged Tables :

count
0

table_name relpersistence
[Top]

Access privileges

Schema Name Type Access privileges Column access privileges
public 2020-05-27-2100 foreign table    
public 2020_05_27_2100 foreign table    
public pglog foreign table    
public pglog_2020-05-27-2300 foreign table    
public pglog_2020_05_2157 foreign table    
public pglog_2020_05_27_2100 foreign table    
public postgresql.log.2020-05-27-2100 foreign table    
public postgresql.log.2020-05-27-2157.csv foreign table    
public postgresql.log.2020-05-27-2200.csv foreign table    
public postgresql.log.2020-05-27-2300.csv foreign table    
public postgresql.log.2020-05-28-0000.csv foreign table    
public postgresql.log.2020-05-28-0100.csv foreign table    
public postgresql.log.2020-05-28-0200.csv foreign table    
public postgresql.log.2020-05-28-0300.csv foreign table    
public postgresql.log.2020-05-28-0400.csv foreign table    
public postgresql.log.2020-05-28-0500.csv foreign table    
public postgresql.log.2020-05-28-0600.csv foreign table    
public postgresql.log.2020-05-28-0700.csv foreign table    
public autovac_demo_id_seq sequence    
public big_table_apg_id_seq sequence    
public idx_test_id_seq sequence    
public autovac_demo table    
public big_table_apg table sys=arwdDxt/sys
replicauser=r/sys		  
public idx_test table    
public pg_acct_management table    
public lock view    
public lock_tree view    
public pg_stat_statements view rdsadmin=arwdDxt/rdsadmin
=r/rdsadmin		  
[Top]

DB parameters

name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline pending_restart
autovacuum_analyze_scale_factor 0.05   Autovacuum Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.   sighup real configuration file 0 100   0.1 0.05 /rdsdbdata/config/postgresql.conf 27 f
autovacuum_analyze_threshold 50   Autovacuum Minimum number of tuple inserts, updates, or deletes prior to analyze.   sighup integer default 0 2147483647   50 50     f
autovacuum_freeze_max_age 200000000   Autovacuum Age at which to autovacuum a table to prevent transaction ID wraparound.   postmaster integer default 100000 2000000000   200000000 200000000     f
autovacuum_max_workers 3   Autovacuum Sets the maximum number of simultaneously running autovacuum worker processes.   postmaster integer configuration file 1 262143   3 3 /rdsdbdata/config/postgresql.conf 69 f
autovacuum_multixact_freeze_max_age 400000000   Autovacuum Multixact age at which to autovacuum a table to prevent multixact wraparound.   postmaster integer default 10000 2000000000   400000000 400000000     f
autovacuum_naptime 5 s Autovacuum Time to sleep between autovacuum runs.   sighup integer configuration file 1 2147483   60 5 /rdsdbdata/config/postgresql.conf 7 f
autovacuum_vacuum_cost_delay 5 ms Autovacuum Vacuum cost delay in milliseconds, for autovacuum.   sighup integer configuration file -1 100   20 5 /rdsdbdata/config/postgresql.conf 85 f
autovacuum_vacuum_cost_limit -1   Autovacuum Vacuum cost amount available before napping, for autovacuum.   sighup integer default -1 10000   -1 -1     f
autovacuum_vacuum_scale_factor 0.1   Autovacuum Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.   sighup real configuration file 0 100   0.2 0.1 /rdsdbdata/config/postgresql.conf 55 f
autovacuum_vacuum_threshold 50   Autovacuum Minimum number of tuple updates or deletes prior to vacuum.   sighup integer default 0 2147483647   50 50     f
autovacuum on   Autovacuum Starts the autovacuum subprocess.   sighup bool default       on on     f
extra_float_digits 0   Client Connection Defaults / Locale and Formatting Sets the number of digits displayed for floating-point values. This affects real, double precision, and geometric data types. The parameter value is added to the standard number of digits (FLT_DIG or DBL_DIG as appropriate). user integer default -15 3   0 0     f
lc_messages     Client Connection Defaults / Locale and Formatting Sets the language in which messages are displayed.   superuser string default               f
lc_monetary C   Client Connection Defaults / Locale and Formatting Sets the locale for formatting monetary amounts.   user string default       C C     f
lc_numeric C   Client Connection Defaults / Locale and Formatting Sets the locale for formatting numbers.   user string default       C C     f
lc_time C   Client Connection Defaults / Locale and Formatting Sets the locale for formatting date and time values.   user string default       C C     f
DateStyle ISO, MDY   Client Connection Defaults / Locale and Formatting Sets the display format for date and time values. Also controls interpretation of ambiguous date inputs. user string default       ISO, MDY ISO, MDY     f
server_encoding UTF8   Client Connection Defaults / Locale and Formatting Sets the server (database) character set encoding.   internal string override       SQL_ASCII UTF8     f
client_encoding UTF8   Client Connection Defaults / Locale and Formatting Sets the client's character set encoding.   user string client       SQL_ASCII UTF8     f
IntervalStyle postgres   Client Connection Defaults / Locale and Formatting Sets the display format for interval values.   user enum default     {postgres,postgres_verbose,sql_standard,iso_8601} postgres postgres     f
lc_collate en_US.UTF-8   Client Connection Defaults / Locale and Formatting Shows the collation order locale.   internal string override       C en_US.UTF-8     f
timezone_abbreviations Default   Client Connection Defaults / Locale and Formatting Selects a file of time zone abbreviations.   user string default         Default     f
TimeZone UTC   Client Connection Defaults / Locale and Formatting Sets the time zone for displaying and interpreting time stamps.   user string configuration file       GMT UTC /rdsdbdata/config/postgresql.conf 63 f
lc_ctype en_US.UTF-8   Client Connection Defaults / Locale and Formatting Shows the character classification and case conversion locale.   internal string override       C en_US.UTF-8     f
default_text_search_config pg_catalog.simple   Client Connection Defaults / Locale and Formatting Sets default text search configuration.   user string default       pg_catalog.simple pg_catalog.simple     f
gin_fuzzy_search_limit 0   Client Connection Defaults / Other Defaults Sets the maximum allowed result for exact search by GIN.   user integer default 0 2147483647   0 0     f
dynamic_library_path $libdir   Client Connection Defaults / Other Defaults Sets the path for dynamically loadable modules. If a dynamically loadable module needs to be opened and the specified name does not have a directory component (i.e., the name does not contain a slash), the system will search this path for the specified file. superuser string default       $libdir $libdir     f
tcp_keepalives_count 2   Client Connection Defaults / Other Defaults Maximum number of TCP keepalive retransmits. This controls the number of consecutive keepalive retransmits that can be lost before a connection is considered dead. A value of 0 uses the system default. user integer configuration file 0 2147483647   0 2 /rdsdbdata/config/postgresql.conf 45 f
tcp_keepalives_idle 300 s Client Connection Defaults / Other Defaults Time between issuing TCP keepalives. A value of 0 uses the system default. user integer configuration file 0 2147483647   0 300 /rdsdbdata/config/postgresql.conf 40 f
tcp_keepalives_interval 30 s Client Connection Defaults / Other Defaults Time between TCP keepalive retransmits. A value of 0 uses the system default. user integer configuration file 0 2147483647   0 30 /rdsdbdata/config/postgresql.conf 51 f
session_preload_libraries     Client Connection Defaults / Shared Library Preloading Lists shared libraries to preload into each backend.   superuser string default               f
shared_preload_libraries rdsutils,pg_stat_statements,pgaudit,apg_plan_mgmt   Client Connection Defaults / Shared Library Preloading Lists shared libraries to preload into server.   postmaster string configuration file         rdsutils,pg_stat_statements,pgaudit,apg_plan_mgmt /rdsdbdata/config/postgresql.conf 97 f
local_preload_libraries     Client Connection Defaults / Shared Library Preloading Lists unprivileged shared libraries to preload into each backend.   superuser string default               f
gin_pending_list_limit 4096 kB Client Connection Defaults / Statement Behavior Sets the maximum size of the pending list for GIN index.   user integer default 64 2147483647   4096 4096     f
xmloption content   Client Connection Defaults / Statement Behavior Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.   user enum default     {content,document} content content     f
xmlbinary base64   Client Connection Defaults / Statement Behavior Sets how binary values are to be encoded in XML.   user enum default     {base64,hex} base64 base64     f
vacuum_multixact_freeze_table_age 150000000   Client Connection Defaults / Statement Behavior Multixact age at which VACUUM should scan whole table to freeze tuples.   user integer default 0 2000000000   150000000 150000000     f
vacuum_multixact_freeze_min_age 5000000   Client Connection Defaults / Statement Behavior Minimum age at which VACUUM should freeze a MultiXactId in a table row.   user integer default 0 1000000000   5000000 5000000     f
vacuum_freeze_table_age 150000000   Client Connection Defaults / Statement Behavior Age at which VACUUM should scan whole table to freeze tuples.   user integer default 0 2000000000   150000000 150000000     f
vacuum_freeze_min_age 50000000   Client Connection Defaults / Statement Behavior Minimum age at which VACUUM should freeze a table row.   user integer default 0 1000000000   50000000 50000000     f
transaction_read_only off   Client Connection Defaults / Statement Behavior Sets the current transaction's read-only status.   user bool override       off off     f
transaction_isolation read committed   Client Connection Defaults / Statement Behavior Sets the current transaction's isolation level.   user string override       default default     f
transaction_deferrable off   Client Connection Defaults / Statement Behavior Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.   user bool override       off off     f
temp_tablespaces     Client Connection Defaults / Statement Behavior Sets the tablespace(s) to use for temporary tables and sort files.   user string default               f
statement_timeout 0 ms Client Connection Defaults / Statement Behavior Sets the maximum allowed duration of any statement. A value of 0 turns off the timeout. user integer default 0 2147483647   0 0     f
bytea_output hex   Client Connection Defaults / Statement Behavior Sets the output format for bytea.   user enum default     {escape,hex} hex hex     f
check_function_bodies on   Client Connection Defaults / Statement Behavior Check function bodies during CREATE FUNCTION.   user bool default       on on     f
client_min_messages notice   Client Connection Defaults / Statement Behavior Sets the message levels that are sent to the client. Each level includes all the levels that follow it. The later the level, the fewer messages are sent. user enum default     {debug5,debug4,debug3,debug2,debug1,log,notice,warning,error} notice notice     f
session_replication_role origin   Client Connection Defaults / Statement Behavior Sets the session's behavior for triggers and rewrite rules.   rds_superuser enum default     {origin,replica,local} origin origin     f
search_path "$user", public   Client Connection Defaults / Statement Behavior Sets the schema search order for names that are not schema-qualified.   user string default       "$user", public "$user", public     f
rds.global_db_rpo -1   Client Connection Defaults / Statement Behavior (s) Recovery point objective threshold, in seconds, that blocks user commits when it is violated.   sighup integer default -1 2147483647   -1 -1     f
rds.enable_global_db_rpo on   Client Connection Defaults / Statement Behavior Enables Aurora Global DB Recovery point objective enforcement feature.   sighup bool default       on on     f
default_tablespace     Client Connection Defaults / Statement Behavior Sets the default tablespace to create tables and indexes in. An empty string selects the database's default tablespace. user string default               f
default_transaction_deferrable off   Client Connection Defaults / Statement Behavior Sets the default deferrable status of new transactions.   user bool default       off off     f
default_transaction_isolation read committed   Client Connection Defaults / Statement Behavior Sets the transaction isolation level of each new transaction.   user enum default     {serializable,"repeatable read","read committed","read uncommitted"} read committed read committed     f
default_transaction_read_only off   Client Connection Defaults / Statement Behavior Sets the default read-only status of new transactions.   user bool default       off off     f
lock_timeout 0 ms Client Connection Defaults / Statement Behavior Sets the maximum allowed duration of any wait for a lock. A value of 0 turns off the timeout. user integer default 0 2147483647   0 0     f
idle_in_transaction_session_timeout 0 ms Client Connection Defaults / Statement Behavior Sets the maximum allowed duration of any idling transaction. A value of 0 turns off the timeout. user integer default 0 2147483647   0 0     f
port 8200   Connections and Authentication / Connection Settings Sets the TCP port the server listens on.   postmaster integer configuration file 1 65535   5432 8200 /rdsdbdata/config/postgresql.conf 56 f
unix_socket_permissions 0706   Connections and Authentication / Connection Settings Sets the access permissions of the Unix-domain socket. Unix-domain sockets use the usual Unix file system permission set. The parameter value is expected to be a numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).) postmaster integer command line 0 511   511 454     t
max_connections 1710   Connections and Authentication / Connection Settings Sets the maximum number of concurrent connections.   postmaster integer configuration file 1 262143   100 1710 /rdsdbdata/config/postgresql.conf 29 f
unix_socket_directories /tmp   Connections and Authentication / Connection Settings Sets the directories where Unix-domain sockets will be created.   postmaster string configuration file       /tmp /tmp /rdsdbdata/config/postgresql.conf 17 f
unix_socket_group rdsdb   Connections and Authentication / Connection Settings Sets the owning group of the Unix-domain socket. The owning user of the socket is always the user that starts the server. postmaster string configuration file         rdsdb /rdsdbdata/config/postgresql.conf 3 f
superuser_reserved_connections 3   Connections and Authentication / Connection Settings Sets the number of connection slots reserved for superusers.   postmaster integer configuration file 0 262143   3 3 /rdsdbdata/config/postgresql.conf 73 f
rds.rds_superuser_reserved_connections 2   Connections and Authentication / Connection Settings Sets the number of connection slots reserved for rds_superusers.   postmaster integer configuration file 0 262143   2 2 /rdsdbdata/config/postgresql.conf 66 f
bonjour off   Connections and Authentication / Connection Settings Enables advertising the server via Bonjour.   postmaster bool default       off off     f
bonjour_name     Connections and Authentication / Connection Settings Sets the Bonjour service name.   postmaster string default               f
listen_addresses *   Connections and Authentication / Connection Settings Sets the host name or IP address(es) to listen to.   postmaster string command line       localhost *     f
authentication_timeout 60 s Connections and Authentication / Security and Authentication Sets the maximum allowed time to complete client authentication.   sighup integer default 1 600   60 60     f
ssl_cert_file /rdsdbdata/rds-metadata/server-cert.pem   Connections and Authentication / Security and Authentication Location of the SSL server certificate file.   sighup string configuration file       server.crt /rdsdbdata/rds-metadata/server-cert.pem /rdsdbdata/config/postgresql.conf 68 f
ssl_key_file /rdsdbdata/rds-metadata/server-key.pem   Connections and Authentication / Security and Authentication Location of the SSL server private key file.   sighup string configuration file       server.key /rdsdbdata/rds-metadata/server-key.pem /rdsdbdata/config/postgresql.conf 81 f
ssl_ecdh_curve prime256v1   Connections and Authentication / Security and Authentication Sets the curve to use for ECDH.   sighup string default       prime256v1 prime256v1     f
ssl_ca_file /rdsdbdata/rds-metadata/ca-cert.pem   Connections and Authentication / Security and Authentication Location of the SSL certificate authority file.   sighup string configuration file         /rdsdbdata/rds-metadata/ca-cert.pem /rdsdbdata/config/postgresql.conf 50 f
ssl_dh_params_file     Connections and Authentication / Security and Authentication Location of the SSL DH parameters file.   sighup string default               f
ssl on   Connections and Authentication / Security and Authentication Enables SSL connections.   sighup bool configuration file       off on /rdsdbdata/config/postgresql.conf 5 f
ssl_crl_file     Connections and Authentication / Security and Authentication Location of the SSL certificate revocation list file.   sighup string default               f
db_user_namespace off   Connections and Authentication / Security and Authentication Enables per-database user names.   sighup bool default       off off     f
krb_server_keyfile /rdsdbdata/config/keytab   Connections and Authentication / Security and Authentication Sets the location of the Kerberos server key file.   sighup string configuration file       FILE:/local/p4clients/pkgbuild-Y1cyE/workspace/build/RDSManfred/RDSManfred-2.0.208244.0/RHEL5_64/DEV.STD.PTHREAD/build/etc/postgresql/krb5.keytab /rdsdbdata/config/keytab /rdsdbdata/config/postgresql.conf 32 f
krb_caseins_users off   Connections and Authentication / Security and Authentication Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.   sighup bool default       off off     f
ssl_ciphers HIGH:MEDIUM:+3DES:!aNULL   Connections and Authentication / Security and Authentication Sets the list of allowed SSL ciphers.   sighup string default       HIGH:MEDIUM:+3DES:!aNULL HIGH:MEDIUM:+3DES:!aNULL     f
row_security on   Connections and Authentication / Security and Authentication Enable row security. When enabled, row security will be applied to all users. user bool default       on on     f
password_encryption md5   Connections and Authentication / Security and Authentication Encrypt passwords. When a password is specified in CREATE USER or ALTER USER without writing either ENCRYPTED or UNENCRYPTED, this parameter determines whether the password is to be encrypted. user enum configuration file     {md5,scram-sha-256} md5 md5 /rdsdbdata/config/postgresql.conf 79 f
ssl_prefer_server_ciphers on   Connections and Authentication / Security and Authentication Give priority to server ciphersuite order.   sighup bool default       on on     f
pgaudit.log_client off   Customized Options Specifies whether audit messages should be visible to the client. This setting should generally be left disabled but may be useful for debugging or other purposes.   rds_superuser bool default       off off     f
pgaudit.log ddl,role   Customized Options Specifies which classes of statements will be logged by session audit logging. Multiple classes can be provided using a comma-separated list and classes can be subtracted by prefacing the class with a - sign.   rds_superuser string configuration file       none ddl,role /rdsdbdata/config/postgresql.conf 47 f
pg_stat_statements.track_utility on   Customized Options Selects whether utility commands are tracked by pg_stat_statements.   superuser bool configuration file       on on /rdsdbdata/config/postgresql.conf 15 f
pg_stat_statements.track all   Customized Options Selects which statements are tracked by pg_stat_statements.   superuser enum configuration file     {none,top,all} top all /rdsdbdata/config/postgresql.conf 62 f
pg_stat_statements.save on   Customized Options Save pg_stat_statements statistics across server shutdowns.   sighup bool default       on on     f
pg_stat_statements.max 5000   Customized Options Sets the maximum number of statements tracked by pg_stat_statements.   postmaster integer default 100 2147483647   5000 5000     f
apg_buffer_invalid_lookup_strategy on   Customized Options Use the lookup strategy to invalidate the buffers Use the lookup strategy instead of the linear buffer scan to invalidate the buffers sighup bool default       on on     f
apg_plan_mgmt.verify_sql_hash 0   Customized Options SQL hash of an Approved (or Preferred) and enabled plan to override and verify, or 0 to not override SQL hash.   user integer default -2147483648 2147483647   0 0     f
apg_plan_mgmt.max_plans 1000   Customized Options Sets the maximum number of plans that may be cached by apg_plan_mgmt.   postmaster integer configuration file 10 2147483647   10000 1000 /rdsdbdata/config/postgresql.conf 88 f
apg_plan_mgmt.max_databases 10   Customized Options Sets the maximum number of databases that that may manage queries using apg_plan_mgmt.   postmaster integer configuration file 10 2147483647   256 10 /rdsdbdata/config/postgresql.conf 87 f
pgaudit.log_catalog on   Customized Options Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog. Disabling this setting will reduce noise in the log from tools like psql and PgAdmin that query the catalog heavily.   rds_superuser bool default       on on     f
apg_plan_mgmt.verify_plan_hash 0   Customized Options Plan hash of an Approved (or Preferred) and enabled plan to verify, or 0 to disable verification.   user integer default -2147483648 2147483647   0 0     f
apg_plan_mgmt.ignore_plan_mismatch off   Customized Options Force best approved plan to be evaluated when the plan hash does not match.   user bool default       off off     f
apg_plan_mgmt.use_plan_baselines on   Customized Options Use only approved or preferred plans for managed statements   user bool configuration file       off on /rdsdbdata/config/postgresql.conf 84 f
apg_plan_mgmt.evolve_plan_history off   Customized Options This parameter has been deprecated, and will be removed in a future release   user bool default       off off     f
apg_plan_mgmt.update_last_used on   Customized Options Update last_used date in memory when a statement is executed.   user bool default       on on     f
apg_plan_mgmt.unapproved_plan_execution_threshold 0   Customized Options Estimated total plan cost below which an Unapproved plan will be executed.   user integer configuration file 0 2147483647   0 0 /rdsdbdata/config/postgresql.conf 20 f
apg_plan_mgmt.enable_autonomous_commit on   Customized Options Insert rows into the dba_plans view asynchronously, in an autonomous transaction   user bool default       on on     f
rds.superuser_variables session_replication_role   Customized Options Variables whitelisted for modification by rds_superuser.   superuser string configuration file         session_replication_role /rdsdbdata/config/postgresql.conf 16 f
rds.restrict_password_commands off   Customized Options Restricts password-related commands to members of rds_password.   postmaster bool default       off off     f
apg_plan_mgmt.plans_update_interval 3600   Customized Options Time in seconds between background worker updates to plans table.   postmaster integer default 1 2147483647   3600 3600     f
rds.logical_replication on   Customized Options Enables logical decoding.   postmaster bool configuration file       off on /rdsdbdata/config/postgresql.conf 100 f
rds.internal_databases rdsadmin   Customized Options Special RDS internal use databases that are protected.   superuser string configuration file       rdsadmin,template0 rdsadmin /rdsdbdata/config/postgresql.conf 103 f
apg_plan_mgmt.capture_plan_baselines automatic   Customized Options Capture plan baseline mode. True or Manual - enable plan capture for any SQL statement, False - disable plan capture, Automatic - enable plan capture for for statements in pg_stat_statements that satisfy the eligibility criteria.   user enum configuration file     {manual,automatic,on,off} off automatic /rdsdbdata/config/postgresql.conf 59 f
rds.force_autovacuum_logging_level warning   Customized Options Emit autovacuum log messages irrespective of other logging configuration. Each level includes all the levels that follow it.Set to disabled to disable this feature and fall back to using log_min_messages. sighup enum configuration file     {debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic,disabled} disabled warning /rdsdbdata/config/postgresql.conf 28 f
rds.force_admin_logging_level disabled   Customized Options Emit log messages from the RDS admin user irrespective of other logging configuration. Each level includes all the levels that follow it.Set to disabled to disable this feature and fall back to using log_min_messages. sighup enum default     {debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic,disabled} disabled disabled     f
apg_plan_mgmt.avg_cardinality_error 0   Customized Options Average absolute value of log(estimated_rows) - log(actual_rows).   user real default -1 6.048e+08   0 0     f
apg_plan_mgmt.plan_retention_period 32   Customized Options Maximum number of days since a plan was last_used before a plan will be automatically deleted.   user integer configuration file 32 2147483647   32 32 /rdsdbdata/config/postgresql.conf 10 f
apg_enable_batch_mode_function_execution on   Customized Options Enables batch-mode functions to process sets of rows at a time.   user bool default       on on     f
pgaudit.role rds_pgaudit   Customized Options Specifies the master role to use for object audit logging. Muliple audit roles can be defined by granting them to the master role. This allows multiple groups to be in charge of different aspects of audit logging.   rds_superuser string configuration file         rds_pgaudit /rdsdbdata/config/postgresql.conf 4 f
apg_plan_mgmt.message_level info   Customized Options Message level of debug messages.   user enum default     {debug5,debug4,debug3,debug2,debug1,log,info,notice,warning,error} info info     f
pgaudit.log_statement_once off   Customized Options Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry. Disabling this setting will result in less verbose logging but may make it more difficult to determine the statement that generated a log entry, though the statement/substatement pair along with the process id should suffice to identify the statement text logged with a previous entry.   rds_superuser bool default       off off     f
pgaudit.log_relation off   Customized Options Specifies whether session audit logging should create a separate log entry for each relation referenced in a SELECT or DML statement. This is a useful shortcut for exhaustive logging without using object audit logging.   rds_superuser bool default       off off     f
pgaudit.log_parameter on   Customized Options Specifies that audit logging should include the parameters that were passed with the statement. When parameters are present they will be be included in CSV format after the statement text.   rds_superuser bool configuration file       off on /rdsdbdata/config/postgresql.conf 43 f
pgaudit.log_level log   Customized Options Specifies the log level that will be used for log entries. This setting is used for regression testing and may also be useful to end users for testing or other purposes. It is not intended to be used in a production environment as it may leak which statements are being logged to the user.   rds_superuser string default       log log     f
allow_system_table_mods off   Developer Options Allows modifications of the structure of system tables.   postmaster bool default       off off     f
ignore_checksum_failure off   Developer Options Continues processing after a checksum failure. Detection of a checksum failure normally causes PostgreSQL to report an error, aborting the current transaction. Setting ignore_checksum_failure to true causes the system to ignore the failure (but still report a warning), and continue processing. This behavior could cause crashes or other serious problems. Only has an effect if checksums are enabled. superuser bool default       off off     f
ignore_system_indexes off   Developer Options Disables reading from system indexes. It does not prevent updating the indexes, so it is safe to use. The worst consequence is slowness. backend bool default       off off     f
post_auth_delay 0 s Developer Options Waits N seconds on connection startup after authentication. This allows attaching a debugger to the process. backend integer default 0 2147   0 0     f
pre_auth_delay 0 s Developer Options Waits N seconds on connection startup before authentication. This allows attaching a debugger to the process. sighup integer default 0 60   0 0     f
trace_notify off   Developer Options Generates debugging output for LISTEN and NOTIFY.   user bool default       off off     f
trace_recovery_messages log   Developer Options Enables logging of recovery-related debugging information. Each level includes all the levels that follow it. The later the level, the fewer messages are sent. sighup enum default     {debug5,debug4,debug3,debug2,debug1,log,notice,warning,error} log log     f
trace_sort off   Developer Options Emit information about resource usage in sorting.   user bool default       off off     f
wal_consistency_checking     Developer Options Sets the WAL resource managers for which WAL consistency checks are done. Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay. superuser string default               f
zero_damaged_pages off   Developer Options Continues processing past damaged page headers. Detection of a damaged page header normally causes PostgreSQL to report an error, aborting the current transaction. Setting zero_damaged_pages to true causes the system to instead report a warning, zero out the damaged page, and continue processing. This behavior will destroy data, namely all the rows on the damaged page. superuser bool default       off off     f
exit_on_error off   Error Handling Terminate session on any error.   user bool default       off off     f
data_sync_retry off   Error Handling Whether to continue running after a failure to sync data files.   postmaster bool default       off off     f
restart_after_crash on   Error Handling Reinitialize server after backend crash.   sighup bool default       on on     f
data_directory /rdsdbdata/db   File Locations Sets the server's data directory.   postmaster string override         /rdsdbdata/db     f
external_pid_file     File Locations Writes the postmaster PID to the specified file.   postmaster string default               f
hba_file /rdsdbdata/config/pg_hba.conf   File Locations Sets the server's "hba" configuration file.   postmaster string override         /rdsdbdata/config/pg_hba.conf     f
config_file /rdsdbdata/config/postgresql.conf   File Locations Sets the server's main configuration file.   postmaster string override         /rdsdbdata/config/postgresql.conf     f
ident_file /rdsdbdata/config/pg_ident.conf   File Locations Sets the server's "ident" configuration file.   postmaster string override         /rdsdbdata/config/pg_ident.conf     f
max_pred_locks_per_transaction 64   Lock Management Sets the maximum number of predicate locks per transaction. The shared predicate lock table is sized on the assumption that at most max_pred_locks_per_transaction * max_connections distinct objects will need to be locked at any one time. postmaster integer default 10 2147483647   64 64     f
max_pred_locks_per_page 2   Lock Management Sets the maximum number of predicate-locked tuples per page. If more than this number of tuples on the same page are locked by a connection, those locks are replaced by a page-level lock. sighup integer default 0 2147483647   2 2     f
max_locks_per_transaction 64   Lock Management Sets the maximum number of locks per transaction. The shared lock table is sized on the assumption that at most max_locks_per_transaction * max_connections distinct objects will need to be locked at any one time. postmaster integer configuration file 10 2147483647   64 64 /rdsdbdata/config/postgresql.conf 78 f
deadlock_timeout 3000 ms Lock Management Sets the time to wait on a lock before checking for deadlock.   superuser integer configuration file 1 2147483647   1000 3000 /rdsdbdata/config/postgresql.conf 53 f
max_pred_locks_per_relation -2   Lock Management Sets the maximum number of predicate-locked pages and tuples per relation. If more than this total of pages and tuples in the same relation are locked by a connection, those locks are replaced by a relation-level lock. sighup integer default -2147483648 2147483647   -2 -2     f
data_checksums off   Preset Options Shows whether data checksums are turned on for this cluster.   internal bool default       off off     f
block_size 8192   Preset Options Shows the size of a disk block.   internal integer default 8192 8192   8192 8192     f
wal_segment_size 2048 8kB Preset Options Shows the number of pages per write ahead log segment.   internal integer default 2048 2048   2048 2048     f
debug_assertions off   Preset Options Shows whether the running server has assertion checks enabled.   internal bool default       off off     f
server_version 10.12   Preset Options Shows the server version.   internal string default       10.12 10.12     f
max_index_keys 32   Preset Options Shows the maximum number of index keys.   internal integer default 32 32   32 32     f
max_function_args 100   Preset Options Shows the maximum number of function arguments.   internal integer default 100 100   100 100     f
server_version_num 100012   Preset Options Shows the server version as an integer.   internal integer default 100012 100012   100012 100012     f
wal_block_size 8192   Preset Options Shows the block size in the write ahead log.   internal integer default 8192 8192   8192 8192     f
segment_size 131072 8kB Preset Options Shows the number of pages per disk file.   internal integer default 131072 131072   131072 131072     f
integer_datetimes on   Preset Options Datetimes are integer based.   internal bool default       on on     f
max_identifier_length 63   Preset Options Shows the maximum identifier length.   internal integer default 63 63   63 63     f
update_process_title on   Process Title Updates the process title to show the active SQL command. Enables updating of the process title every time a new SQL command is received by the server. superuser bool default       on on     f
cluster_name     Process Title Sets the name of the cluster, which is included in the process title.   postmaster string default               f
geqo_effort 5   Query Tuning / Genetic Query Optimizer GEQO: effort is used to set the default for other GEQO parameters.   user integer default 1 10   5 5     f
geqo on   Query Tuning / Genetic Query Optimizer Enables genetic query optimization. This algorithm attempts to do planning without exhaustive searching. user bool default       on on     f
geqo_generations 0   Query Tuning / Genetic Query Optimizer GEQO: number of iterations of the algorithm. Zero selects a suitable default value. user integer default 0 2147483647   0 0     f
geqo_pool_size 0   Query Tuning / Genetic Query Optimizer GEQO: number of individuals in the population. Zero selects a suitable default value. user integer default 0 2147483647   0 0     f
geqo_threshold 12   Query Tuning / Genetic Query Optimizer Sets the threshold of FROM items beyond which GEQO is used.   user integer default 2 2147483647   12 12     f
geqo_selection_bias 2   Query Tuning / Genetic Query Optimizer GEQO: selective pressure within the population.   user real default 1.5 2   2 2     f
geqo_seed 0   Query Tuning / Genetic Query Optimizer GEQO: seed for random path selection.   user real default 0 1   0 0     f
join_collapse_limit 8   Query Tuning / Other Planner Options Sets the FROM-list size beyond which JOIN constructs are not flattened. The planner will flatten explicit JOIN constructs into lists of FROM items whenever a list of no more than this many items would result. user integer default 1 2147483647   8 8     f
constraint_exclusion partition   Query Tuning / Other Planner Options Enables the planner to use constraints to optimize queries. Table scans will be skipped if their constraints guarantee that no rows match the query. user enum default     {partition,on,off} partition partition     f
force_parallel_mode off   Query Tuning / Other Planner Options Forces use of parallel query facilities. If possible, run query using a parallel worker and with parallel restrictions. user enum default     {off,on,regress} off off     f
from_collapse_limit 8   Query Tuning / Other Planner Options Sets the FROM-list size beyond which subqueries are not collapsed. The planner will merge subqueries into upper queries if the resulting FROM list would have no more than this many items. user integer default 1 2147483647   8 8     f
default_statistics_target 100   Query Tuning / Other Planner Options Sets the default statistics target. This applies to table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS. user integer default 1 10000   100 100     f
cursor_tuple_fraction 0.1   Query Tuning / Other Planner Options Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.   user real default 0 1   0.1 0.1     f
min_parallel_index_scan_size 64 8kB Query Tuning / Planner Cost Constants Sets the minimum amount of index data for a parallel scan. If the planner estimates that it will read a number of index pages too small to reach this limit, a parallel scan will not be considered. user integer default 0 715827882   64 64     f
seq_page_cost 1   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of a sequentially fetched disk page.   user real default 0 1.79769e+308   1 1     f
cpu_operator_cost 0.0025   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of processing each operator or function call.   user real default 0 1.79769e+308   0.0025 0.0025     f
random_page_cost 4   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of a nonsequentially fetched disk page.   user real default 0 1.79769e+308   4 4     f
effective_cache_size 1304235 8kB Query Tuning / Planner Cost Constants Sets the planner's assumption about the total size of the data caches. That is, the total size of the caches (kernel cache and shared buffers) used for PostgreSQL data files. This is measured in disk pages, which are normally 8 kB each. user integer configuration file 1 2147483647   524288 1304235 /rdsdbdata/config/postgresql.conf 83 f
parallel_tuple_cost 0.1   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.   user real default 0 1.79769e+308   0.1 0.1     f
cpu_index_tuple_cost 0.005   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of processing each index entry during an index scan.   user real default 0 1.79769e+308   0.005 0.005     f
parallel_setup_cost 1000   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of starting up worker processes for parallel query.   user real default 0 1.79769e+308   1000 1000     f
cpu_tuple_cost 0.01   Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of processing each tuple (row).   user real default 0 1.79769e+308   0.01 0.01     f
min_parallel_table_scan_size 1024 8kB Query Tuning / Planner Cost Constants Sets the minimum amount of table data for a parallel scan. If the planner estimates that it will read a number of table pages too small to reach this limit, a parallel scan will not be considered. user integer default 0 715827882   1024 1024     f
apg_enable_not_in_transform on   Query Tuning / Planner Method Configuration Enables the planner to transform NOT IN subquery to ANTI JOIN when possible.   user bool default       on on     f
enable_tidscan on   Query Tuning / Planner Method Configuration Enables the planner's use of TID scan plans.   user bool default       on on     f
enable_sort on   Query Tuning / Planner Method Configuration Enables the planner's use of explicit sort steps.   user bool default       on on     f
enable_seqscan on   Query Tuning / Planner Method Configuration Enables the planner's use of sequential-scan plans.   user bool default       on on     f
apg_enable_correlated_any_transform on   Query Tuning / Planner Method Configuration Enables the planner to transform correlated ANY Sublink (IN/NOT IN subquery) to JOIN when possible.   user bool default       on on     f
apg_enable_function_migration on   Query Tuning / Planner Method Configuration Enables the planner to migrate eligible scalar functions to the FROM clause.   user bool default       on on     f
enable_nestloop on   Query Tuning / Planner Method Configuration Enables the planner's use of nested-loop join plans.   user bool default       on on     f
enable_mergejoin on   Query Tuning / Planner Method Configuration Enables the planner's use of merge join plans.   user bool default       on on     f
enable_material on   Query Tuning / Planner Method Configuration Enables the planner's use of materialization.   user bool default       on on     f
enable_indexscan on   Query Tuning / Planner Method Configuration Enables the planner's use of index-scan plans.   user bool default       on on     f
enable_indexonlyscan on   Query Tuning / Planner Method Configuration Enables the planner's use of index-only-scan plans.   user bool default       on on     f
enable_hashjoin on   Query Tuning / Planner Method Configuration Enables the planner's use of hash join plans.   user bool default       on on     f
enable_hashagg on   Query Tuning / Planner Method Configuration Enables the planner's use of hashed aggregation plans.   user bool default       on on     f
enable_gathermerge on   Query Tuning / Planner Method Configuration Enables the planner's use of gather merge plans.   user bool default       on on     f
enable_bitmapscan on   Query Tuning / Planner Method Configuration Enables the planner's use of bitmap-scan plans.   user bool default       on on     f
apg_enable_remove_redundant_inner_joins off   Query Tuning / Planner Method Configuration Enables the planner to remove redundant inner joins.   user bool default       off off     f
track_commit_timestamp off   Replication Collects transaction commit time.   postmaster bool default       off off     f
synchronous_standby_names     Replication / Master Server Number of synchronous standbys and list of names of potential synchronous ones.   sighup string default               f
vacuum_defer_cleanup_age 0   Replication / Master Server Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.   sighup integer default 0 1000000   0 0     f
max_replication_slots 10   Replication / Sending Servers Sets the maximum number of simultaneously defined replication slots.   postmaster integer configuration file 0 262143   10 10 /rdsdbdata/config/postgresql.conf 93 f
rds.restrict_logical_slot_creation off   Replication / Sending Servers Restrict logical slot creation over streaming replication protocol.   superuser bool default       off off     f
wal_keep_segments 0   Replication / Sending Servers Sets the number of WAL files held for standby servers.   sighup integer default 0 2147483647   0 0     f
wal_sender_timeout 30000 ms Replication / Sending Servers Sets the maximum time to wait for WAL replication.   sighup integer configuration file 0 2147483647   60000 30000 /rdsdbdata/config/postgresql.conf 42 f
max_wal_senders 10   Replication / Sending Servers Sets the maximum number of simultaneously running WAL sender processes.   postmaster integer configuration file 0 262143   10 10 /rdsdbdata/config/postgresql.conf 94 f
hot_standby off   Replication / Standby Servers Allows connections and queries during recovery.   postmaster bool configuration file       on off /rdsdbdata/config/postgresql.conf 92 f
wal_receiver_status_interval 10 s Replication / Standby Servers Sets the maximum interval between WAL receiver status reports to the primary.   sighup integer default 0 2147483   10 10     f
wal_retrieve_retry_interval 5000 ms Replication / Standby Servers Sets the time to wait before retrying to retrieve WAL after a failed attempt.   sighup integer default 1 2147483647   5000 5000     f
wal_receiver_timeout 30000 ms Replication / Standby Servers Sets the maximum wait time to receive data from the primary.   sighup integer configuration file 0 2147483647   60000 30000 /rdsdbdata/config/postgresql.conf 48 f
hot_standby_feedback on   Replication / Standby Servers Allows feedback from a hot standby to the primary that will avoid query conflicts.   postmaster bool configuration file       off on /rdsdbdata/config/postgresql.conf 11 f
max_standby_archive_delay 30000 ms Replication / Standby Servers Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.   sighup integer default -1 2147483647   30000 30000     f
max_standby_streaming_delay 30000 ms Replication / Standby Servers Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.   sighup integer default -1 2147483647   30000 30000     f
max_sync_workers_per_subscription 2   Replication / Subscribers Maximum number of table synchronization workers per subscription.   sighup integer default 0 262143   2 2     f
max_logical_replication_workers 4   Replication / Subscribers Maximum number of logical replication worker processes.   postmaster integer default 0 262143   4 4     f
log_timezone UTC   Reporting and Logging / What to Log Sets the time zone to use in log messages.   sighup string configuration file       GMT UTC /rdsdbdata/config/postgresql.conf 71 f
log_duration off   Reporting and Logging / What to Log Logs the duration of each completed SQL statement.   rds_superuser bool default       off off     f
log_statement ddl   Reporting and Logging / What to Log Sets the type of statements logged.   rds_superuser enum configuration file     {none,ddl,mod,all} none ddl /rdsdbdata/config/postgresql.conf 39 f
log_replication_commands off   Reporting and Logging / What to Log Logs each replication command.   rds_superuser bool default       off off     f
log_disconnections on   Reporting and Logging / What to Log Logs end of a session, including duration.   superuser-backend bool configuration file       off on /rdsdbdata/config/postgresql.conf 13 f
log_connections on   Reporting and Logging / What to Log Logs each successful connection.   superuser-backend bool configuration file       off on /rdsdbdata/config/postgresql.conf 82 f
log_checkpoints off   Reporting and Logging / What to Log Logs each checkpoint.   sighup bool default       off off     f
log_autovacuum_min_duration 0 ms Reporting and Logging / What to Log Sets the minimum execution time above which autovacuum actions will be logged. Zero prints all actions. -1 turns autovacuum logging off. sighup integer configuration file -1 2147483647   -1 0 /rdsdbdata/config/postgresql.conf 72 f
application_name psql   Reporting and Logging / What to Log Sets the application name to be reported in statistics and logs.   user string client         psql     f
log_lock_waits on   Reporting and Logging / What to Log Logs long lock waits.   rds_superuser bool configuration file       off on /rdsdbdata/config/postgresql.conf 77 f
log_line_prefix %t:%r:%u@%d:[%p]:   Reporting and Logging / What to Log Controls information prefixed to each log line. If blank, no prefix is used. sighup string configuration file       %m [%p] %t:%r:%u@%d:[%p]: /rdsdbdata/config/postgresql.conf 90 f
debug_print_rewritten off   Reporting and Logging / What to Log Logs each query's rewritten parse tree.   user bool default       off off     f
debug_print_plan off   Reporting and Logging / What to Log Logs each query's execution plan.   user bool default       off off     f
debug_print_parse off   Reporting and Logging / What to Log Logs each query's parse tree.   user bool default       off off     f
debug_pretty_print on   Reporting and Logging / What to Log Indents parse and plan tree displays.   user bool default       on on     f
log_hostname on   Reporting and Logging / What to Log Logs the host name in the connection logs. By default, connection logs only show the IP address of the connecting host. If you want them to show the host name you can turn this on, but depending on your host name resolution setup it might impose a non-negligible performance penalty. sighup bool configuration file       off on /rdsdbdata/config/postgresql.conf 74 f
log_error_verbosity default   Reporting and Logging / What to Log Sets the verbosity of logged messages.   rds_superuser enum default     {terse,default,verbose} default default     f
log_temp_files -1 kB Reporting and Logging / What to Log Log the use of temporary files larger than this number of kilobytes. Zero logs all files. The default is -1 (turning this feature off). rds_superuser integer default -1 2147483647   -1 -1     f
log_min_error_statement error   Reporting and Logging / When to Log Causes all statements generating error at or above this level to be logged. Each level includes all the levels that follow it. The later the level, the fewer messages are sent. rds_superuser enum default     {debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic} error error     f
log_min_duration_statement -1 ms Reporting and Logging / When to Log Sets the minimum execution time above which statements will be logged. Zero prints all queries. -1 turns this feature off. rds_superuser integer default -1 2147483647   -1 -1     f
log_min_messages warning   Reporting and Logging / When to Log Sets the message levels that are logged. Each level includes all the levels that follow it. The later the level, the fewer messages are sent. rds_superuser enum default     {debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic} warning warning     f
event_source PostgreSQL   Reporting and Logging / Where to Log Sets the application name used to identify PostgreSQL messages in the event log.   postmaster string default       PostgreSQL PostgreSQL     f
log_destination stderr,csvlog   Reporting and Logging / Where to Log Sets the destination for server log output. Valid values are combinations of "stderr", "syslog", "csvlog", and "eventlog", depending on the platform. sighup string configuration file       stderr stderr,csvlog /rdsdbdata/config/postgresql.conf 102 f
logging_collector on   Reporting and Logging / Where to Log Start a subprocess to capture stderr output and/or csvlogs into log files.   postmaster bool configuration file       off on /rdsdbdata/config/postgresql.conf 49 f
syslog_split_messages on   Reporting and Logging / Where to Log Split messages sent to syslog by lines and to fit into 1024 bytes.   sighup bool default       on on     f
syslog_sequence_numbers on   Reporting and Logging / Where to Log Add sequence number to syslog messages to avoid duplicate suppression.   sighup bool default       on on     f
log_truncate_on_rotation off   Reporting and Logging / Where to Log Truncate existing log files of same name during log rotation.   sighup bool configuration file       off off /rdsdbdata/config/postgresql.conf 24 f
log_directory /rdsdbdata/log/error   Reporting and Logging / Where to Log Sets the destination directory for log files. Can be specified as relative to the data directory or as absolute path. sighup string configuration file       log /rdsdbdata/log/error /rdsdbdata/config/postgresql.conf 1 f
log_rotation_age 60 min Reporting and Logging / Where to Log Automatic log file rotation will occur after N minutes.   sighup integer configuration file 0 35791394   1440 60 /rdsdbdata/config/postgresql.conf 61 f
syslog_ident postgres   Reporting and Logging / Where to Log Sets the program name used to identify PostgreSQL messages in syslog.   sighup string default       postgres postgres     f
log_filename postgresql.log.%Y-%m-%d-%H%M   Reporting and Logging / Where to Log Sets the file name pattern for log files.   sighup string configuration file       postgresql-%Y-%m-%d_%H%M%S.log postgresql.log.%Y-%m-%d-%H%M /rdsdbdata/config/postgresql.conf 76 f
log_rotation_size 100000 kB Reporting and Logging / Where to Log Automatic log file rotation will occur after N kilobytes.   sighup integer configuration file 0 2097151   10240 100000 /rdsdbdata/config/postgresql.conf 64 f
log_file_mode 0644   Reporting and Logging / Where to Log Sets the file permissions for log files. The parameter value is expected to be a numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).) sighup integer configuration file 0 511   384 420 /rdsdbdata/config/postgresql.conf 21 f
syslog_facility local0   Reporting and Logging / Where to Log Sets the syslog "facility" to be used when syslog enabled.   sighup enum default     {local0,local1,local2,local3,local4,local5,local6,local7} local0 local0     f
old_snapshot_threshold -1 min Resource Usage / Asynchronous Behavior Time before a snapshot is too old to read pages changed after the snapshot was taken. A value of -1 disables this feature. postmaster integer default -1 86400   -1 -1     f
max_parallel_workers 8   Resource Usage / Asynchronous Behavior Sets the maximum number of parallel workers that can be active at one time.   user integer default 0 1024   8 8     f
max_parallel_workers_per_gather 2   Resource Usage / Asynchronous Behavior Sets the maximum number of parallel processes per executor node.   user integer default 0 1024   2 2     f
max_worker_processes 8   Resource Usage / Asynchronous Behavior Maximum number of concurrent worker processes.   postmaster integer configuration file 0 262143   8 8 /rdsdbdata/config/postgresql.conf 8 f
effective_io_concurrency 256   Resource Usage / Asynchronous Behavior Number of simultaneous requests that can be handled efficiently by the disk subsystem. For RAID arrays, this should be approximately the number of drive spindles in the array. user integer default 0 256   256 256     f
backend_flush_after 0 8kB Resource Usage / Asynchronous Behavior Number of pages after which previously performed writes are flushed to disk.   user integer default 0 256   0 0     f
bgwriter_delay 200 ms Resource Usage / Background Writer Background writer sleep time between rounds.   sighup integer default 10 10000   200 200     f
bgwriter_lru_maxpages 100   Resource Usage / Background Writer Background writer maximum number of LRU pages to flush per round.   sighup integer default 0 1073741823   100 100     f
bgwriter_flush_after 0 8kB Resource Usage / Background Writer Number of pages after which previously performed writes are flushed to disk.   sighup integer default 0 256   0 0     f
bgwriter_lru_multiplier 2   Resource Usage / Background Writer Multiple of the average buffer usage to free per round.   sighup real default 0 10   2 2     f
vacuum_cost_delay 0 ms Resource Usage / Cost-Based Vacuum Delay Vacuum cost delay in milliseconds.   user integer default 0 100   0 0     f
vacuum_cost_page_hit 1   Resource Usage / Cost-Based Vacuum Delay Vacuum cost for a page found in the buffer cache.   user integer default 0 10000   1 1     f
vacuum_cost_page_miss 0   Resource Usage / Cost-Based Vacuum Delay Vacuum cost for a page not found in the buffer cache.   user integer configuration file 0 10000   10 0 /rdsdbdata/config/postgresql.conf 86 f
vacuum_cost_page_dirty 20   Resource Usage / Cost-Based Vacuum Delay Vacuum cost for a page dirtied by vacuum.   user integer default 0 10000   20 20     f
vacuum_cost_limit 200   Resource Usage / Cost-Based Vacuum Delay Vacuum cost amount available before napping.   user integer default 1 10000   200 200     f
temp_file_limit -1 kB Resource Usage / Disk Limits the total size of all temporary files used by each process. -1 means no limit. rds_superuser integer default -1 2147483647   -1 -1     f
max_files_per_process 1000   Resource Usage / Kernel Resources Sets the maximum number of simultaneously open files for each server process.   postmaster integer default 25 2147483647   1000 1000     f
dynamic_shared_memory_type posix   Resource Usage / Memory Selects the dynamic shared memory implementation used.   postmaster enum default     {posix,sysv,mmap,none} posix posix     f
multixact_offsets_cache_size 8   Resource Usage / Memory Sets the number of SLRU cache entries used by multixact offsets.   postmaster integer default 8 65536   8 8     f
subtrans_cache_size 32   Resource Usage / Memory Sets the max per-backend cached subtransaction pages.   postmaster integer default 32 65536   32 32     f
survivable_cache_mode on   Resource Usage / Memory Survivable cache recovery mode.   postmaster enum default     {off,skip_recovery,verify} on on     f
slru_cache_mode on   Resource Usage / Memory SLRU cache mode.   postmaster enum default     {off} on on     f
shared_buffers 1304235 8kB Resource Usage / Memory Sets the number of shared memory buffers used by the server.   postmaster integer configuration file 16 1073741823   1024 1304235 /rdsdbdata/config/postgresql.conf 41 f
replacement_sort_tuples 150000   Resource Usage / Memory Sets the maximum number of tuples to be sorted using replacement selection. When more tuples than this are present, quicksort will be used. user integer default 0 2147483647   150000 150000     f
maintenance_work_mem 260096 kB Resource Usage / Memory Sets the maximum memory to be used for maintenance operations. This includes operations such as VACUUM and CREATE INDEX. user integer configuration file 1024 2147483647   65536 260096 /rdsdbdata/config/postgresql.conf 35 f
temp_buffers 1024 8kB Resource Usage / Memory Sets the maximum number of temporary buffers used by each session.   user integer default 100 1073741823   1024 1024     f
huge_pages on   Resource Usage / Memory Use of huge pages on Linux.   postmaster enum configuration file     {off,on} off on /rdsdbdata/config/postgresql.conf 65 f
autovacuum_work_mem -1 kB Resource Usage / Memory Sets the maximum memory to be used by each autovacuum worker process.   sighup integer default -1 2147483647   -1 -1     f
async_notifications_cache_size 8   Resource Usage / Memory Sets the number of SLRU cache entries used by async notifications.   postmaster integer default 8 65536   8 8     f
work_mem 4096 kB Resource Usage / Memory Sets the maximum memory to be used for query workspaces. This much memory can be used by each internal sort operation and hash table before switching to temporary disk files. user integer default 64 2147483647   4096 4096     f
track_activity_query_size 4096   Resource Usage / Memory Sets the size reserved for pg_stat_activity.query, in bytes.   postmaster integer configuration file 100 102400   1024 4096 /rdsdbdata/config/postgresql.conf 37 f
max_prepared_transactions 0   Resource Usage / Memory Sets the maximum number of simultaneously prepared transactions.   postmaster integer configuration file 0 262143   0 0 /rdsdbdata/config/postgresql.conf 67 f
max_stack_depth 6144 kB Resource Usage / Memory Sets the maximum stack depth, in kilobytes.   superuser integer configuration file 100 2147483647   100 6144 /rdsdbdata/config/postgresql.conf 14 f
multixact_members_cache_size 16   Resource Usage / Memory Sets the number of SLRU cache entries used by multixact members.   postmaster integer default 16 65536   16 16     f
commit_timestamp_cache_size 16   Resource Usage / Memory Sets the number of SLRU cache entries used by commit timestamp.   postmaster integer default 16 65536   16 16     f
eventpoints_mode off   Resource Usage / Memory Enable event points using the apgdbcc extension.   superuser enum default     {on,persist} off off     f
log_planner_stats off   Statistics / Monitoring Writes planner performance statistics to the server log.   rds_superuser bool default       off off     f
log_executor_stats off   Statistics / Monitoring Writes executor performance statistics to the server log.   rds_superuser bool default       off off     f
log_parser_stats off   Statistics / Monitoring Writes parser performance statistics to the server log.   rds_superuser bool default       off off     f
log_statement_stats off   Statistics / Monitoring Writes cumulative performance statistics to the server log.   rds_superuser bool default       off off     f
track_activities on   Statistics / Query and Index Statistics Collector Collects information about executing commands. Enables the collection of information on the currently executing command of each session, along with the time at which that command began execution. rds_superuser bool default       on on     f
track_counts on   Statistics / Query and Index Statistics Collector Collects statistics on database activity.   rds_superuser bool default       on on     f
track_functions none   Statistics / Query and Index Statistics Collector Collects function-level statistics on database activity.   rds_superuser enum default     {none,pl,all} none none     f
track_io_timing off   Statistics / Query and Index Statistics Collector Collects timing statistics for database I/O activity.   rds_superuser bool default       off off     f
stats_temp_directory /rdsdbdata/db/pg_stat_tmp   Statistics / Query and Index Statistics Collector Writes temporary statistics files to the specified directory.   sighup string configuration file       pg_stat_tmp /rdsdbdata/db/pg_stat_tmp /rdsdbdata/config/postgresql.conf 99 f
ansi_qualified_update_set_target off   Version and Platform Compatibility / Other Platforms and Clients Support table and schema qualifiers in UPDATE ... SET statements. e.g. UPDATE t SET s.t.c = v WHERE p.off provides community PostgreSQL semantics and on provides this feature. When turned on, the UPDATE ... SET syntax is consistent with what's allowed by Oracle and SQL/Server, and can reduce migration effort. PostgreSQL allows composite types subfields to be set using syntax that is potentially ambiguous with respect to the syntax that Oracle and SQL/Server accept. In cases where the syntax is ambiguous, an ERROR message will be raised to inform the user that the SET target is ambiguous. rds_superuser bool default       off off     f
transform_null_equals off   Version and Platform Compatibility / Other Platforms and Clients Treats "expr=NULL" as "expr IS NULL". When turned on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct behavior of expr = NULL is to always return null (unknown). user bool default       off off     f
ansi_constraint_trigger_ordering off   Version and Platform Compatibility / Other Platforms and Clients Change the firing order of constraint triggers to be compatible with the ANSI SQL standard. When turned on, the firing order of constraint triggers in the after trigger queue is modified to be compatible with the ANSI SQL standard, while to the extent possible, while not changing the semantics of PostgreSQL applications that would have complied with the SQL standard without the parameter being turned on. Internal constraint triggers are fired first in alphabetical order, followed by user-defined constraint triggers in alphabetical order, followed by firing any other triggers, in alphabetical order. sighup bool default       off off     f
ansi_force_foreign_key_checks off   Version and Platform Compatibility / Other Platforms and Clients Ensure referential actions such as cascaded delete or cascaded update will always occur regardless of the various trigger contexs that exist for the action. When turned on, Ensure referential actions such as cascaded delete or cascaded update will always occur regardless of the various trigger contexs that exist for the action. sighup bool default       off off     f
array_nulls on   Version and Platform Compatibility / Previous PostgreSQL Versions Enable input of NULL elements in arrays. When turned on, unquoted NULL in an array input value means a null value; otherwise it is taken literally. user bool default       on on     f
standard_conforming_strings on   Version and Platform Compatibility / Previous PostgreSQL Versions Causes '...' strings to treat backslashes literally.   user bool default       on on     f
synchronize_seqscans on   Version and Platform Compatibility / Previous PostgreSQL Versions Enable synchronized sequential scans.   user bool default       on on     f
quote_all_identifiers off   Version and Platform Compatibility / Previous PostgreSQL Versions When generating SQL fragments, quote all identifiers.   user bool default       off off     f
backslash_quote safe_encoding   Version and Platform Compatibility / Previous PostgreSQL Versions Sets whether "\'" is allowed in string literals.   user enum default     {safe_encoding,on,off} safe_encoding safe_encoding     f
default_with_oids off   Version and Platform Compatibility / Previous PostgreSQL Versions Create new tables with OIDs by default.   user bool default       off off     f
operator_precedence_warning off   Version and Platform Compatibility / Previous PostgreSQL Versions Emit a warning for constructs that changed meaning since PostgreSQL 9.4.   user bool default       off off     f
lo_compat_privileges off   Version and Platform Compatibility / Previous PostgreSQL Versions Enables backward compatibility mode for privilege checks on large objects. Skips privilege checks when reading or modifying large objects, for compatibility with PostgreSQL releases prior to 9.0. superuser bool configuration file       off off /rdsdbdata/config/postgresql.conf 6 f
escape_string_warning on   Version and Platform Compatibility / Previous PostgreSQL Versions Warn about backslash escapes in ordinary string literals.   user bool default       on on     f
archive_command (disabled)   Write-Ahead Log / Archiving Sets the shell command that will be called to archive a WAL file.   sighup string configuration file         /etc/rds/dbbin/pgscripts/rds_wal_archive %p /rdsdbdata/config/postgresql.conf 22 f
archive_mode off   Write-Ahead Log / Archiving Allows archiving of WAL files using archive_command.   postmaster enum configuration file     {always,on,off} off off /rdsdbdata/config/postgresql.conf 98 f
archive_timeout 300 s Write-Ahead Log / Archiving Forces a switch to the next WAL file if a new file has not been started within N seconds.   sighup integer configuration file 0 1073741823   0 300 /rdsdbdata/config/postgresql.conf 19 f
max_wal_size 1024 MB Write-Ahead Log / Checkpoints Sets the WAL size that triggers a checkpoint.   sighup integer default 2 2147483647   1024 1024     f
checkpoint_completion_target 0.5   Write-Ahead Log / Checkpoints Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.   sighup real default 0 1   0.5 0.5     f
checkpoint_flush_after 0 8kB Write-Ahead Log / Checkpoints Number of pages after which previously performed writes are flushed to disk.   sighup integer default 0 256   0 0     f
checkpoint_timeout 60 s Write-Ahead Log / Checkpoints Sets the maximum time between automatic WAL checkpoints.   sighup integer configuration file 30 86400   300 60 /rdsdbdata/config/postgresql.conf 70 f
checkpoint_warning 30 s Write-Ahead Log / Checkpoints Enables warnings if checkpoint segments are filled more frequently than this. Write a message to the server log if checkpoints caused by the filling of checkpoint segment files happens more frequently than this number of seconds. Zero turns off the warning. sighup integer default 0 2147483647   30 30     f
min_wal_size 80 MB Write-Ahead Log / Checkpoints Sets the minimum size to shrink the WAL to.   sighup integer default 2 2147483647   80 80     f
wal_writer_flush_after 128 8kB Write-Ahead Log / Settings Amount of WAL written out by WAL writer that triggers a flush.   sighup integer default 0 2147483647   128 128     f
wal_writer_delay 200 ms Write-Ahead Log / Settings Time between WAL flushes performed in the WAL writer.   sighup integer default 1 10000   200 200     f
synchronous_commit on   Write-Ahead Log / Settings Sets the current transaction's synchronization level.   user enum configuration file     {local,remote_write,remote_apply,on,off} on on /rdsdbdata/config/postgresql.conf 75 f
commit_delay 0   Write-Ahead Log / Settings Sets the delay in microseconds between transaction commit and flushing WAL to disk.   superuser integer default 0 100000   0 0     f
wal_buffers 2048 8kB Write-Ahead Log / Settings Sets the number of disk-page buffers in shared memory for WAL.   postmaster integer override -1 262143   -1 2048     f
fsync on   Write-Ahead Log / Settings Forces synchronization of updates to disk. The server will use the fsync() system call in several places to make sure that updates are physically written to disk. This insures that a database cluster will recover to a consistent state after an operating system or hardware crash. sighup bool default       on on     f
full_page_writes off   Write-Ahead Log / Settings Writes full pages to WAL when first modified after a checkpoint. A page write in process during an operating system crash might be only partially written to disk. During recovery, the row changes stored in WAL are not enough to recover. This option writes pages when first modified after a checkpoint to WAL so full recovery is possible. sighup bool default       off off     f
wal_compression off   Write-Ahead Log / Settings Compresses full-page writes written in WAL file.   superuser bool default       off off     f
commit_siblings 5   Write-Ahead Log / Settings Sets the minimum concurrent open transactions before performing commit_delay.   user integer default 0 1000   5 5     f
wal_sync_method fdatasync   Write-Ahead Log / Settings Selects the method used for forcing WAL updates to disk.   sighup enum default     {fsync,fdatasync,open_sync} fdatasync fdatasync     f
wal_level logical   Write-Ahead Log / Settings Set the level of information written to the WAL.   postmaster enum configuration file     {minimal,replica,logical} replica logical /rdsdbdata/config/postgresql.conf 101 f
wal_log_hints off   Write-Ahead Log / Settings Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modifications.   postmaster bool default       off off     f
name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline pending_restart
rds.extensions amcheck,address_standardizer,address_standardizer_data_us,apg_plan_mgmt,aurora_stat_utils,aws_commons,aws_ml,aws_s3,bloom,btree_gin,btree_gist,chkpass,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,fuzzystrmatch,hll,hstore,hstore_plperl,intagg,intarray,ip4r,isn,log_fdw,ltree,orafce,pgaudit,pgcrypto,pgrouting,pgrowlocks,pgstattuple,pg_buffercache,pg_freespacemap,pg_hint_plan,pg_similarity,pg_prewarm,pg_repack,pg_stat_statements,pg_trgm,pg_visibility,plcoffee,plls,plperl,plpgsql,plprofiler,pltcl,plv8,postgis,postgis_tiger_geocoder,postgis_topology,postgres_fdw,prefix,sslinfo,tablefunc,test_parser,tsearch2,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp   Customized Options Extensions whitelisted for use by rds_superuser.   superuser string configuration file         amcheck,address_standardizer,address_standardizer_data_us,apg_plan_mgmt,aurora_stat_utils,aws_commons,aws_ml,aws_s3,bloom,btree_gin,btree_gist,chkpass,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,fuzzystrmatch,hll,hstore,hstore_plperl,intagg,intarray,ip4r,isn,log_fdw,ltree,orafce,pgaudit,pgcrypto,pgrouting,pgrowlocks,pgstattuple,pg_buffercache,pg_freespacemap,pg_hint_plan,pg_similarity,pg_prewarm,pg_repack,pg_stat_statements,pg_trgm,pg_visibility,plcoffee,plls,plperl,plpgsql,plprofiler,pltcl,plv8,postgis,postgis_tiger_geocoder,postgis_topology,postgres_fdw,prefix,sslinfo,tablefunc,test_parser,tsearch2,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp /rdsdbdata/config/postgresql.conf 26 f
[Top]

*****

[Top]