Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

We upgraded our PG version from 9.1.3 to 9.2.6. After that, noticed a huge jump in the memory consumed by PG backend process during a delete query on one of our DB tables. The heap memory as reported in /proc/PID/smaps increased from 25MB to 600 MB. There are quite a few triggers setup on this table and I determined that the jump happens when one particular trigger function (SQL function) is exceuted. The queries executed in this function (around 3000 line SQL function) are quite complex, quite a few unions, joins on tables containing around 100K records. The function is created using the syntax:

CREATE OR REPLACE FUNCTION FUNC1 (p_old TABLETYPE, p_new TABLETYPE, p_id character(50), p_event_type text)
  RETURNS integer AS
$BODY$

......
......
......

$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;


The memory gets released once the backend process exits but in our application we have multiple threads opening connections to PG and executing these delete queries. Connection pooling is being used and this memory is not getting released when the connection is idle; so at one point the machine goes OOM.

For the upgrade, we have migrated the data used pg_dump and pg_restore.

System Configuration:
CentOS release 5.6 (Final)
Mem: 9 GB
CPU : 4 core - Intel(R) Xeon(R) CPU E5620  @ 2.40GHz

PostgresQL configuration:
max_connections = 250
shared_buffers = 1536MB
work_mem = 12MB
maintenance_work_mem = 384MB
effective_cache_size = 3072MB

I have used psql to test the delete queries and used /proc/PID/smaps to check the memory usage of the launched backend.

The heap in 'smaps' is shown as below:
04e3c000-29a70000 rw-p 04e3c000 00:00 0                                  [heap]
Size:            602320 kB
Rss:             596596 kB
Shared_Clean:         0 kB
Shared_Dirty:        60 kB
Private_Clean:        0 kB
Private_Dirty:   596536 kB
Swap:                 0 kB
Pss:             596544 kB


We are using the RHEL-5 64-bit PotgresQL RPMs present on the PG website:
postgresql92-9.2.6-1PGDG.rhel5.x86_64.rpm
postgresql92-contrib-9.2.6-1PGDG.rhel5.x86_64.rpm
postgresql92-libs-9.2.6-1PGDG.rhel5.x86_64.rpm
postgresql92-server-9.2.6-1PGDG.rhel5.x86_64.rpm

I have now compiled the PG source code and installed a version with debug symbols on the same machine. But I do not know how to determine what is taking up so much memory. Is there any data, that I can collect by connecting gdb, which will help ?

I tried getting the memory stats (enabled SHOW_MEMORY_STATS) and captured the attached data but I do not know how to interpret this data and also not sure whether this statistics captures the heap memory used by the SQL function.

Queries I have are:

1. Has there been any change in the way memory is allocated/released when SQL functions are triggered in a backend?

2. How can I determine what is taking up so much memory; basically how do I proceed further on this one?

3. I guess it is some data which is cached when the SQL function runs the first time in the backend because if I delete another row of the same table in the same PSQL session the memory does not jump again by that amount. Is there a way to indicate that such caching should not be done?

Thanks,
Datta.
2013-12-24 08:15:10 PST[22604]DEBUG:  postmaster: PostmasterMain: initial environment dump:
2013-12-24 08:15:10 PST[22604]DEBUG:  -----------------------------------------
2013-12-24 08:15:10 PST[22604]DEBUG:  	CONFIG_ENV=/opt/Avaya/Mgmt/6.3.8/snmp/
2013-12-24 08:15:10 PST[22604]DEBUG:  	HOSTNAME=porobd-dev16-smgr.sv.avaya.com
2013-12-24 08:15:10 PST[22604]DEBUG:  	SRVC_HOME=/sbin
2013-12-24 08:15:10 PST[22604]DEBUG:  	NET_SNMP_HOME=/opt/Avaya/Mgmt/6.3.8/snmp/net-snmp5.3.1
2013-12-24 08:15:10 PST[22604]DEBUG:  	SHELL=/bin/bash
2013-12-24 08:15:10 PST[22604]DEBUG:  	TERM=xterm
2013-12-24 08:15:10 PST[22604]DEBUG:  	HISTSIZE=1000
2013-12-24 08:15:10 PST[22604]DEBUG:  	IPTCM_HOME=/opt/Avaya/IPTCM/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	PG_HOME=/var/lib/pgsql/data/
2013-12-24 08:15:10 PST[22604]DEBUG:  	JBOSS_HOME=/opt/Avaya/JBoss/6.1.0/jboss-as
2013-12-24 08:15:10 PST[22604]DEBUG:  	MGMT_HOME=/opt/Avaya/Mgmt/6.3.8/
2013-12-24 08:15:10 PST[22604]DEBUG:  	USER=postgres
2013-12-24 08:15:10 PST[22604]DEBUG:  	LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
2013-12-24 08:15:10 PST[22604]DEBUG:  	LD_LIBRARY_PATH=/usr/local/lib::/opt/Avaya/Mgmt/6.3.8/snmp/net-snmp5.3.1/lib:/opt/Avaya/Mgmt/6.3.8/snmp/net-snmp5.3.1/lib
2013-12-24 08:15:10 PST[22604]DEBUG:  	SYM_HOME=/opt/Avaya/JBoss/6.1.0/jboss-as/server/avmgmt/deploy/symmetricds.war
2013-12-24 08:15:10 PST[22604]DEBUG:  	TMOUT=600
2013-12-24 08:15:10 PST[22604]DEBUG:  	SPIRIT_HOME=/opt/Avaya/SPIRIT/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	AVAYA_NRP=/var/avaya/nrp
2013-12-24 08:15:10 PST[22604]DEBUG:  	SMGR_INSTALL_DIR=/opt/Avaya
2013-12-24 08:15:10 PST[22604]DEBUG:  	AVAYA_LOG=/var/log/Avaya
2013-12-24 08:15:10 PST[22604]DEBUG:  	MAIL=/var/spool/mail/postgres
2013-12-24 08:15:10 PST[22604]DEBUG:  	PATH=/usr/kerberos/bin:/usr/local/pgsql/bin:/sbin:/sbin:/usr/java/jdk1.7.0_17/bin:/usr/local/bin:/bin:/usr/bin:%{AvayaBin}:/bin:/usr/pgsql-9.2/bin:/usr/pgsql-9.2/bin:/bin
2013-12-24 08:15:10 PST[22604]DEBUG:  	SPIRIT_CONFIG_LOCATION=/opt/Avaya/Mgmt/6.3.8/SpiritEnterprise/config
2013-12-24 08:15:10 PST[22604]DEBUG:  	INPUTRC=/etc/inputrc
2013-12-24 08:15:10 PST[22604]DEBUG:  	PWD=/var/lib/pgsql
2013-12-24 08:15:10 PST[22604]DEBUG:  	MESSAGING_HOME=/opt/Avaya/MESSAGING/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	JAVA_HOME=/usr/java/jdk1.7.0_17
2013-12-24 08:15:10 PST[22604]DEBUG:  	LANG=en_US.UTF-8
2013-12-24 08:15:10 PST[22604]DEBUG:  	PG_INSTALL_DIR=/opt/Avaya/Postgres/9.2.6/
2013-12-24 08:15:10 PST[22604]DEBUG:  	PERLLIB=/opt/nortel/base/lib:
2013-12-24 08:15:10 PST[22604]DEBUG:  	REPORTS_HOME=/opt/Avaya/REPORTS/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	DRS_HOME=/opt/Avaya/Mgmt/6.3.8/drs
2013-12-24 08:15:10 PST[22604]DEBUG:  	POSTGRESQL_JDBC_DRIVER=/opt/Avaya/JBoss/6.1.0/jboss-as/server/avmgmt/lib/postgresql-9.2-1003.jdbc4.jar
2013-12-24 08:15:10 PST[22604]DEBUG:  	SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
2013-12-24 08:15:10 PST[22604]DEBUG:  	SHLVL=1
2013-12-24 08:15:10 PST[22604]DEBUG:  	HOME=/var/lib/pgsql
2013-12-24 08:15:10 PST[22604]DEBUG:  	AUS_HOME=/opt/Avaya/AUS
2013-12-24 08:15:10 PST[22604]DEBUG:  	LOGNAME=postgres
2013-12-24 08:15:10 PST[22604]DEBUG:  	SPIRIT_LOG_DIR=/var/log/Avaya/mgmt/spirit
2013-12-24 08:15:10 PST[22604]DEBUG:  	SMEM_HOME=/opt/Avaya/Session_Manager
2013-12-24 08:15:10 PST[22604]DEBUG:  	INVENTORY_HOME=/opt/Avaya/INVENTORY/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	LESSOPEN=|/usr/bin/lesspipe.sh %s
2013-12-24 08:15:10 PST[22604]DEBUG:  	SUM_HOME=/opt/Avaya/SUM/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	ABG_HOME=/opt/Avaya/ABG/6.3.8
2013-12-24 08:15:10 PST[22604]DEBUG:  	G_BROKEN_FILENAMES=1
2013-12-24 08:15:10 PST[22604]DEBUG:  	_=/usr/local/pgsql/bin/postmaster
2013-12-24 08:15:10 PST[22604]DEBUG:  	PGSYSCONFDIR=/usr/local/pgsql/etc
2013-12-24 08:15:10 PST[22604]DEBUG:  	LC_COLLATE=en_US.UTF-8
2013-12-24 08:15:10 PST[22604]DEBUG:  	LC_CTYPE=en_US.UTF-8
2013-12-24 08:15:10 PST[22604]DEBUG:  	LC_MESSAGES=en_US.UTF-8
2013-12-24 08:15:10 PST[22604]DEBUG:  	LC_MONETARY=C
2013-12-24 08:15:10 PST[22604]DEBUG:  	LC_NUMERIC=C
2013-12-24 08:15:10 PST[22604]DEBUG:  	LC_TIME=C
2013-12-24 08:15:10 PST[22604]DEBUG:  -----------------------------------------
2013-12-24 08:15:10 PST[22604]DEBUG:  invoking IpcMemoryCreate(size=1670340608)
2013-12-24 08:15:10 PST[22604]DEBUG:  SlruScanDirectory invoking callback on pg_notify/0000
2013-12-24 08:15:10 PST[22604]DEBUG:  removing file "pg_notify/0000"
2013-12-24 08:15:10 PST[22604]DEBUG:  max_safe_fds = 984, usable_fds = 1000, already_open = 6
TopMemoryContext: 85072 total in 12 blocks; 21968 free (65 chunks); 63104 used
  TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
  Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496 used
  Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used
  MessageContext: 516096 total in 6 blocks; 129648 free (4 chunks); 386448 used
  Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  smgr relation table: 24576 total in 2 blocks; 9808 free (4 chunks); 14768 used
  TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used
  Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  PortalMemory: 8192 total in 1 blocks; 8160 free (1 chunks); 32 used
  Relcache by OID: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used
  CacheMemoryContext: 4487856 total in 23 blocks; 1252656 free (5 chunks); 3235200 used
    pg_toast_2619_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_trigger_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_trigger_tgconstraint_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_index_indrelid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_db_role_setting_databaseid_rol_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_user_mapping_user_server_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_user_mapping_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_type_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_type_typname_nsp_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_ts_template_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_template_tmplname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_parser_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_parser_prsname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_dict_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_dict_dictname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_config_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_config_cfgname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_config_map_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_tablespace_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_statistic_relid_att_inh_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_class_relname_nsp_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_range_rngtypid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_proc_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_proc_proname_args_nsp_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_opfamily_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_opfamily_am_name_nsp_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_operator_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_operator_oprname_l_r_n_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_namespace_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_namespace_nspname_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_language_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_language_name_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_table_relid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_server_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_server_name_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_data_wrapper_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_data_wrapper_name_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_enum_typid_label_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_enum_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_default_acl_role_nsp_obj_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_conversion_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_constraint_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_conversion_name_nsp_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_conversion_default_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_collation_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_collation_name_enc_nsp_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_opclass_am_name_nsp_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_cast_source_target_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_auth_members_role_member_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_attribute_relid_attnam_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_amop_fam_strat_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_amop_opr_fam_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_aggregate_fnoid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_auth_members_member_role_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_authid_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_authid_rolname_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_database_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_database_datname_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_trigger_tgrelid_tgname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_rewrite_rel_rulename_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_amproc_fam_proc_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_opclass_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_index_indexrelid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_attribute_relid_attnum_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_class_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
  MdSmgr: 8192 total in 1 blocks; 6624 free (0 chunks); 1568 used
  tokenize file cxt: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  hba parser context: 3072 total in 2 blocks; 512 free (2 chunks); 2560 used
  LOCALLOCK hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used
  ErrorContext: 8192 total in 1 blocks; 8160 free (9 chunks); 32 used
TopMemoryContext: 301136 total in 38 blocks; 60528 free (254 chunks); 240608 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 2300048 total in 21 blocks; 231024 free (3 chunks); 2069024 used
  PL/pgSQL function context: 122880 total in 4 blocks; 69952 free (6 chunks); 52928 used
  PL/pgSQL function context: 2300048 total in 21 blocks; 231280 free (3 chunks); 2068768 used
  PL/pgSQL function context: 122880 total in 4 blocks; 69952 free (6 chunks); 52928 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11552 free (2 chunks); 13024 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11552 free (2 chunks); 13024 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11552 free (2 chunks); 13024 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11552 free (2 chunks); 13024 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11552 free (2 chunks); 13024 used
  PL/pgSQL function context: 2300048 total in 21 blocks; 231024 free (3 chunks); 2069024 used
  PL/pgSQL function context: 122880 total in 4 blocks; 69920 free (6 chunks); 52960 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11504 free (2 chunks); 13072 used
  PL/pgSQL function context: 24576 total in 2 blocks; 16296 free (2 chunks); 8280 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11504 free (2 chunks); 13072 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11504 free (2 chunks); 13072 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 2300048 total in 21 blocks; 231280 free (3 chunks); 2068768 used
  PL/pgSQL function context: 122880 total in 4 blocks; 69984 free (6 chunks); 52896 used
  PL/pgSQL function context: 2300048 total in 21 blocks; 229152 free (3 chunks); 2070896 used
  PL/pgSQL function context: 122880 total in 4 blocks; 69952 free (6 chunks); 52928 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11536 free (2 chunks); 13040 used
  CFuncHash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  Rendezvous variable hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  PLpgSQL function cache: 24520 total in 2 blocks; 3744 free (0 chunks); 20776 used
  TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
  Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496 used
  Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used
  MessageContext: 65536 total in 4 blocks; 50808 free (31 chunks); 14728 used
  Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  smgr relation table: 24576 total in 2 blocks; 5696 free (4 chunks); 18880 used
  TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used
  Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  PortalMemory: 8192 total in 1 blocks; 8160 free (2 chunks); 32 used
  Relcache by OID: 24576 total in 2 blocks; 11792 free (3 chunks); 12784 used
  CacheMemoryContext: 4934408 total in 37 blocks; 584072 free (1 chunks); 4350336 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 57456 free (3 chunks); 72592 used
      CachedPlanQuery: 261120 total in 8 blocks; 78712 free (0 chunks); 182408 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1840 free (2 chunks); 1232 used
      CachedPlanQuery: 1024 total in 1 blocks; 320 free (0 chunks); 704 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 53808 free (1 chunks); 76240 used
      CachedPlanQuery: 261120 total in 8 blocks; 81200 free (0 chunks); 179920 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 15360 total in 4 blocks; 3480 free (1 chunks); 11880 used
      CachedPlanQuery: 31744 total in 5 blocks; 8192 free (1 chunks); 23552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
    CachedPlanSource: 3072 total in 2 blocks; 1816 free (2 chunks); 1256 used
      CachedPlanQuery: 1024 total in 1 blocks; 296 free (0 chunks); 728 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
    CachedPlanSource: 3072 total in 2 blocks; 1512 free (2 chunks); 1560 used
      CachedPlanQuery: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
    CachedPlanSource: 3072 total in 2 blocks; 48 free (1 chunks); 3024 used
      CachedPlanQuery: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 57456 free (3 chunks); 72592 used
      CachedPlanQuery: 261120 total in 8 blocks; 78712 free (0 chunks); 182408 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1840 free (2 chunks); 1232 used
      CachedPlanQuery: 1024 total in 1 blocks; 320 free (0 chunks); 704 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 53808 free (1 chunks); 76240 used
      CachedPlanQuery: 261120 total in 8 blocks; 81200 free (0 chunks); 179920 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 15360 total in 4 blocks; 3480 free (1 chunks); 11880 used
      CachedPlanQuery: 31744 total in 5 blocks; 8192 free (1 chunks); 23552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
    CachedPlanSource: 3072 total in 2 blocks; 1816 free (2 chunks); 1256 used
      CachedPlanQuery: 1024 total in 1 blocks; 296 free (0 chunks); 728 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
    CachedPlanSource: 3072 total in 2 blocks; 1512 free (2 chunks); 1560 used
      CachedPlanQuery: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
    CachedPlanSource: 3072 total in 2 blocks; 48 free (1 chunks); 3024 used
      CachedPlanQuery: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1168 free (1 chunks); 6000 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1168 free (1 chunks); 6000 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 5992 free (0 chunks); 9368 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4776 free (0 chunks); 10584 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6040 free (0 chunks); 9320 used
    CachedPlanSource: 7168 total in 3 blocks; 1168 free (1 chunks); 6000 used
      CachedPlanQuery: 15360 total in 4 blocks; 4824 free (0 chunks); 10536 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1168 free (1 chunks); 6000 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1168 free (1 chunks); 6000 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 57280 free (2 chunks); 72768 used
      CachedPlanQuery: 261120 total in 8 blocks; 78664 free (0 chunks); 182456 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1840 free (2 chunks); 1232 used
      CachedPlanQuery: 1024 total in 1 blocks; 320 free (0 chunks); 704 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 53808 free (1 chunks); 76240 used
      CachedPlanQuery: 261120 total in 8 blocks; 81200 free (0 chunks); 179920 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 15360 total in 4 blocks; 3480 free (1 chunks); 11880 used
      CachedPlanQuery: 31744 total in 5 blocks; 8192 free (1 chunks); 23552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
    CachedPlanSource: 3072 total in 2 blocks; 1816 free (2 chunks); 1256 used
      CachedPlanQuery: 1024 total in 1 blocks; 296 free (0 chunks); 728 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
    CachedPlanSource: 3072 total in 2 blocks; 1512 free (2 chunks); 1560 used
      CachedPlanQuery: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
    CachedPlanSource: 3072 total in 2 blocks; 48 free (1 chunks); 3024 used
      CachedPlanQuery: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 5592 free (0 chunks); 9768 used
    CachedPlanSource: 7168 total in 3 blocks; 976 free (1 chunks); 6192 used
      CachedPlanQuery: 15360 total in 4 blocks; 4760 free (0 chunks); 10600 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
    CachedPlanSource: 3072 total in 2 blocks; 1816 free (2 chunks); 1256 used
      CachedPlanQuery: 1024 total in 1 blocks; 296 free (0 chunks); 728 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    CachedPlanSource: 3072 total in 2 blocks; 1440 free (1 chunks); 1632 used
      CachedPlanQuery: 1024 total in 1 blocks; 112 free (0 chunks); 912 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 5592 free (0 chunks); 9768 used
    CachedPlanSource: 7168 total in 3 blocks; 976 free (1 chunks); 6192 used
      CachedPlanQuery: 15360 total in 4 blocks; 4760 free (0 chunks); 10600 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 5592 free (0 chunks); 9768 used
    CachedPlanSource: 7168 total in 3 blocks; 976 free (1 chunks); 6192 used
      CachedPlanQuery: 15360 total in 4 blocks; 4760 free (0 chunks); 10600 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 57456 free (3 chunks); 72592 used
      CachedPlanQuery: 261120 total in 8 blocks; 78712 free (0 chunks); 182408 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1840 free (2 chunks); 1232 used
      CachedPlanQuery: 1024 total in 1 blocks; 320 free (0 chunks); 704 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 53808 free (1 chunks); 76240 used
      CachedPlanQuery: 261120 total in 8 blocks; 81200 free (0 chunks); 179920 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 15360 total in 4 blocks; 3480 free (1 chunks); 11880 used
      CachedPlanQuery: 31744 total in 5 blocks; 8192 free (1 chunks); 23552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
    CachedPlanSource: 3072 total in 2 blocks; 1816 free (2 chunks); 1256 used
      CachedPlanQuery: 1024 total in 1 blocks; 296 free (0 chunks); 728 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
    CachedPlanSource: 3072 total in 2 blocks; 1512 free (2 chunks); 1560 used
      CachedPlanQuery: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
    CachedPlanSource: 3072 total in 2 blocks; 80 free (1 chunks); 2992 used
      CachedPlanQuery: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 130048 total in 7 blocks; 57456 free (3 chunks); 72592 used
      CachedPlanQuery: 261120 total in 8 blocks; 78712 free (0 chunks); 182408 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1840 free (2 chunks); 1232 used
      CachedPlanQuery: 1024 total in 1 blocks; 320 free (0 chunks); 704 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    cscontactaddress_cscontactid_idx: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontactaddress_pkey: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontact_csuser_idx: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontact_pkey: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontact_displayname_key: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    csprivatecontactinfo_pkey: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    csprivatecontactinfo_cspersonid_key: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    cscontactlistmember_cshandle_idx: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontactlistmember_cscontactaddress_idx: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontactlistmember_contactlist_idx: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscontactlistmember_pkey: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscontactlistmember_cspersonid_key: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    cscontactlist_csuser_id: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscontactlist_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscontactlist_name_key: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    csuser_lower_displayname_idx: 2048 total in 1 blocks; 312 free (0 chunks); 1736 used
    csuser_csdefaultcompprofilesetid_idx: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    csuser_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    csuser_loginname_key: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cscommprofileset_csuser_idx: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscommprofileset_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscommprofileset_commprofilesetname_key: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    CachedPlanSource: 130048 total in 7 blocks; 53808 free (1 chunks); 76240 used
      CachedPlanQuery: 261120 total in 8 blocks; 81200 free (0 chunks); 179920 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    cscommprofile_cscommprofileset_id_idx: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscommprofile_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    cscommprofile_commprofiletype_cscommprofilesetid_key: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    asmcommprofile_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    asminstance_sipentity_id_key: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    asminstance_pkey: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    asminstance_managementaccesspointhostname_key: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    CachedPlanSource: 15360 total in 4 blocks; 3480 free (1 chunks); 11880 used
      CachedPlanQuery: 31744 total in 5 blocks; 8192 free (1 chunks); 23552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
    CachedPlanSource: 3072 total in 2 blocks; 1816 free (2 chunks); 1256 used
      CachedPlanQuery: 1024 total in 1 blocks; 296 free (0 chunks); 728 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
    CachedPlanSource: 3072 total in 2 blocks; 1512 free (2 chunks); 1560 used
      CachedPlanQuery: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
    CachedPlanSource: 3072 total in 2 blocks; 1392 free (1 chunks); 1680 used
      CachedPlanQuery: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
    CachedPlanSource: 3072 total in 2 blocks; 48 free (1 chunks); 3024 used
      CachedPlanQuery: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    pg_toast_1255_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    idx_de_batchid_nodeid: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    idx_de_batched_nodeid_channel: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    sym_data_event_pkey: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    CachedPlan: 15360 total in 4 blocks; 6024 free (0 chunks); 9336 used
    sym_node_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    CachedPlanSource: 7168 total in 3 blocks; 1152 free (1 chunks); 6016 used
      CachedPlanQuery: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    idx_data_create_time: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    sym_data_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    CachedPlanSource: 7168 total in 3 blocks; 1784 free (1 chunks); 5384 used
      CachedPlanQuery: 7168 total in 3 blocks; 1512 free (0 chunks); 5656 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
    CachedPlanSource: 3072 total in 2 blocks; 1168 free (1 chunks); 1904 used
      CachedPlanQuery: 3072 total in 2 blocks; 1552 free (0 chunks); 1520 used
    SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
    cmcommprofile_stationid_idx: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    cmcommprofile_pkey: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_attrdef_adrelid_adnum_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_toast_2619_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_trigger_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_trigger_tgconstraint_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_index_indrelid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_db_role_setting_databaseid_rol_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_user_mapping_user_server_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_user_mapping_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_type_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_type_typname_nsp_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_ts_template_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_template_tmplname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_parser_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_parser_prsname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_dict_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_dict_dictname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_config_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_ts_config_cfgname_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_ts_config_map_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_tablespace_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_statistic_relid_att_inh_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_class_relname_nsp_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_range_rngtypid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_proc_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_proc_proname_args_nsp_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_opfamily_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_opfamily_am_name_nsp_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_operator_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_operator_oprname_l_r_n_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_namespace_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_namespace_nspname_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_language_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_language_name_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_table_relid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_server_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_server_name_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_data_wrapper_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_foreign_data_wrapper_name_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_enum_typid_label_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_enum_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_default_acl_role_nsp_obj_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_conversion_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_constraint_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_conversion_name_nsp_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_conversion_default_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_collation_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_collation_name_enc_nsp_index: 2048 total in 1 blocks; 280 free (0 chunks); 1768 used
    pg_opclass_am_name_nsp_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_cast_source_target_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_auth_members_role_member_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_attribute_relid_attnam_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_amop_fam_strat_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_amop_opr_fam_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_aggregate_fnoid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_auth_members_member_role_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_authid_oid_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_authid_rolname_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_database_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_database_datname_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used
    pg_trigger_tgrelid_tgname_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_rewrite_rel_rulename_index: 2048 total in 1 blocks; 576 free (0 chunks); 1472 used
    pg_amproc_fam_proc_index: 2048 total in 1 blocks; 232 free (0 chunks); 1816 used
    pg_opclass_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_index_indexrelid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
    pg_attribute_relid_attnum_index: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used
    pg_class_oid_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used
  MdSmgr: 8192 total in 1 blocks; 4672 free (0 chunks); 3520 used
  tokenize file cxt: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  hba parser context: 3072 total in 2 blocks; 512 free (2 chunks); 2560 used
  LOCALLOCK hash: 24576 total in 2 blocks; 13920 free (4 chunks); 10656 used
  Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used
  ErrorContext: 8192 total in 1 blocks; 8160 free (6 chunks); 32 used
-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux