Re: Postgresql service stopped automatically after restart

Hi,

Yesterday the psql service stopped in our two customers's machines

Windows OS ---> Windows XP
We re-installed the postgresql to solve the problem.
We use postgresql *silent* installation method to install psql from Our
application

Psql Log for one machine

2014-06-01 18:29:48 IST LOG: database system was interrupted; last known
up at 2014-06-01 18:23:19 IST
2014-06-01 18:29:49 IST LOG: database system was not properly shut down;
automatic recovery in progress
2014-06-01 18:29:49 IST LOG: record with zero length at 0/5C44778
2014-06-01 18:29:49 IST LOG: redo is not required
2014-06-01 18:29:50 IST LOG: database system is ready to accept connections
2014-06-01 18:29:50 IST LOG: autovacuum launcher started
2014-06-01 18:33:21 IST ERROR: canceling statement due to user request
2014-06-01 18:33:21 IST ERROR: canceling statement due to user request
2014-06-01 18:33:21 IST LOG: received fast shutdown request
2014-06-01 18:33:21 IST LOG: aborting any active transactions
2014-06-01 18:33:21 IST ERROR: canceling statement due to user request
2014-06-01 18:33:21 IST ERROR: canceling statement due to user request
2014-06-01 18:33:21 IST LOG: autovacuum launcher shutting down
2014-06-01 18:33:21 IST LOG: shutting down
2014-06-01 18:33:22 IST LOG: database system is shut down

psql log for another one machine

2014-06-02 09:50:52 IST FATAL: the database system is starting up
2014-06-02 09:50:52 IST LOG: database system was shut down at 2014-06-01
17:04:03 IST
2014-06-02 09:50:53 IST FATAL: the database system is starting up
2014-06-02 09:50:53 IST FATAL: the database system is starting up
2014-06-02 09:50:53 IST LOG: database system is ready to accept connections
2014-06-02 09:50:53 IST LOG: autovacuum launcher started
2014-06-02 10:22:56 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 10:22:56 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 10:23:54 IST ERROR: syntax error at or near ")" at character 515
2014-06-02 10:23:54 IST STATEMENT: select mrp,batchno,expdate,totalstock,
salesrate, info from( select to_char(s.mrp,'FMFM9,99,99,99,990.00') as
mrp,s.batchno,s.expdate, case when mu.units > 1 then div(cast (sum(stock)
as numeric),mu.units) else sum(stock) end || case when mu.units > 1 and
(cast(sum(stock) as numeric) % mu.units) <> 0 then '.' ||
abs(cast(sum(stock) as numeric) % mu.units) else '' end as totalstock,
salesrate,info from stock s left join pricelist p on (s.itemno=p.itemno and
s.mrp=p.mrp and s.batchno=p.batchno and p.itemno=),items i,measureunits mu
where s.itemno= and mu.unitno=i.unitno and i.itemno=s.itemno group by
s.mrp,s.batchno,s.expdate,salesrate,info,mu.units) as t where
cast(totalstock as double precision) > 0 order by mrp,batchno,expdate
2014-06-02 10:47:53 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 11:07:59 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 11:33:16 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 11:59:43 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 12:00:41 IST ERROR: update or delete on table "items" violates
foreign key constraint "sales2_itemno_fk" on table "sales2"
2014-06-02 12:00:41 IST DETAIL: Key (itemno)=(509) is still referenced
from table "sales2".
2014-06-02 12:00:41 IST CONTEXT: SQL statement "delete from items where
itemno=$1[1].itemno"
PL/pgSQL function
public.fn_items(public.items[],integer,public.itembarcode[],integer,text,integer)
line 79 at SQL statement
2014-06-02 12:00:41 IST STATEMENT: select
public.fn_items(array[row(509,'ANODIESED DLX+ 5
LIT','20351','','',0,1,29,5,1,1,'N',0,0,'Y','N','N','','N','',0,'',0,1,1,0,'V','Y',0,0,0,'0',0,'','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','','','','','','','','True')::public.items],1,'{}',0,'D',1)
2014-06-02 12:20:59 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 14:44:50 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 16:14:20 IST LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.

2014-06-02 16:32:54 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 000004D8: error code 1455
2014-06-02 16:32:54 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:55 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 000004D0: error code 1455
2014-06-02 16:32:55 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:56 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 00000474: error code 1455
2014-06-02 16:32:56 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:57 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 000004A4: error code 1455
2014-06-02 16:32:57 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:58 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:32:58 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:59 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:32:59 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:00 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 0000008C: error code 1455
2014-06-02 16:33:00 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:01 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 000004DC: error code 1455
2014-06-02 16:33:01 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:02 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:33:02 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:03 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:33:03 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:04 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:33:04 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:05 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:33:05 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:06 IST LOG: CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)
2014-06-02 16:33:06 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:07 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 000004E8: error code 1455
2014-06-02 16:33:07 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:08 IST LOG: could not reserve shared memory region
(addr=029D0000) for child 000004EC: error code 1455
2014-06-02 16:33:08 IST LOG: could not fork autovacuum worker process: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

TopMemoryContext: 246368 total in 31 blocks; 16528 free (120 chunks);
229840 used
TopTransactionContext: 8192 total in 1 blocks; 7696 free (0 chunks); 496
used
PL/pgSQL function context: 24576 total in 2 blocks; 14768 free (1
chunks); 9808 used
PL/pgSQL function context: 24576 total in 2 blocks; 10488 free (2
chunks); 14088 used
PL/pgSQL function context: 24576 total in 2 blocks; 4448 free (3 chunks);
20128 used
PL/pgSQL function context: 57344 total in 3 blocks; 11680 free (3
chunks); 45664 used
PL/pgSQL function context: 24576 total in 2 blocks; 3544 free (2 chunks);
21032 used
Record information cache: 8192 total in 1 blocks; 1800 free (0 chunks);
6392 used
PL/pgSQL function context: 122880 total in 4 blocks; 21568 free (2
chunks); 101312 used
RI compare cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used
RI query cache: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
RI constraint cache: 73536 total in 3 blocks; 5904 free (0 chunks); 67632
used
PL/pgSQL function context: 122880 total in 4 blocks; 56928 free (2
chunks); 65952 used
PL/pgSQL function context: 57344 total in 3 blocks; 29248 free (3
chunks); 28096 used
PL/pgSQL function context: 122880 total in 4 blocks; 62848 free (2
chunks); 60032 used
PL/pgSQL function context: 57344 total in 3 blocks; 7448 free (3 chunks);
49896 used
PL/pgSQL function context: 253952 total in 5 blocks; 43672 free (2
chunks); 210280 used
CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
Rendezvous variable hash: 8192 total in 1 blocks; 3848 free (0 chunks);
4344 used
PLpgSQL function cache: 24200 total in 2 blocks; 5904 free (0 chunks);
18296 used
Type information cache: 24576 total in 2 blocks; 14072 free (6 chunks);
10504 used
TableSpace cache: 8192 total in 1 blocks; 5640 free (0 chunks); 2552 used
Operator lookup cache: 57344 total in 3 blocks; 38624 free (14 chunks);
18720 used
MessageContext: 1048576 total in 8 blocks; 432824 free (4 chunks); 615752
used
JoinRelHashTable: 8192 total in 1 blocks; 4864 free (0 chunks); 3328
used
Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320
used
smgr relation table: 24576 total in 2 blocks; 6848 free (4 chunks); 17728
used
ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used
hba parser context: 7168 total in 3 blocks; 4280 free (2 chunks); 2888
used
TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks);
16 used
Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
PortalMemory: 8192 total in 1 blocks; 8040 free (2 chunks); 152 used
PortalHeapMemory: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
ExecutorState: 180560 total in 9 blocks; 1576 free (3 chunks); 178984
used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
AggContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 8192 total in 1 blocks; 256 free (0 chunks); 7936 used
CacheMemoryContext: 2259528 total in 23 blocks; 48120 free (5 chunks);
2211408 used
CachedPlan: 64512 total in 6 blocks; 17320 free (0 chunks); 47192 used
CachedPlan: 31744 total in 5 blocks; 3416 free (0 chunks); 28328 used
CachedPlan: 31744 total in 5 blocks; 10040 free (0 chunks); 21704 used
purchase3_txnorowkeystockpointno_pk: 1024 total in 1 blocks; 312 free
(0 chunks); 712 used
CachedPlan: 7168 total in 3 blocks; 2928 free (0 chunks); 4240 used
CachedPlan: 31744 total in 5 blocks; 15976 free (0 chunks); 15768 used
purchase2_rowkey_uq: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
purchase2_txnoslno_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
CachedPlanSource: 3072 total in 2 blocks; 1688 free (0 chunks); 1384
used
CachedPlanQuery: 7168 total in 3 blocks; 4072 free (1 chunks); 3096
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
acvnosetup_vtnomonth_pk: 1024 total in 1 blocks; 480 free (0 chunks);
544 used
acvnosetup_vtnoprestartsuffix_uq: 3072 total in 2 blocks; 1840 free (0
chunks); 1232 used
CachedPlanSource: 3072 total in 2 blocks; 1256 free (0 chunks); 1816
used
CachedPlanQuery: 3072 total in 2 blocks; 496 free (1 chunks); 2576
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
CachedPlanSource: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456
used
CachedPlanQuery: 7168 total in 3 blocks; 2528 free (1 chunks); 4640
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456
used
CachedPlanQuery: 3072 total in 2 blocks; 680 free (1 chunks); 2392
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 15360 total in 4 blocks; 400 free (0 chunks); 14960
used
CachedPlanQuery: 15360 total in 4 blocks; 2240 free (1 chunks); 13120
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 1720 free (0 chunks); 1352 used
CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616
used
CachedPlanQuery: 3072 total in 2 blocks; 1784 free (1 chunks); 1288
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
CachedPlanSource: 3072 total in 2 blocks; 1648 free (0 chunks); 1424
used
CachedPlanQuery: 1024 total in 1 blocks; 24 free (1 chunks); 1000 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 328 free (1 chunks); 696 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanSource: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
CachedPlanQuery: 1024 total in 1 blocks; 328 free (1 chunks); 696 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1112 free (0 chunks); 1960
used
CachedPlanQuery: 3072 total in 2 blocks; 336 free (1 chunks); 2736
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 864 free (0 chunks); 2208 used
CachedPlan: 7168 total in 3 blocks; 3552 free (0 chunks); 3616 used
CachedPlan: 7168 total in 3 blocks; 160 free (0 chunks); 7008 used
CachedPlan: 7168 total in 3 blocks; 3008 free (0 chunks); 4160 used
CachedPlan: 7168 total in 3 blocks; 1968 free (0 chunks); 5200 used
CachedPlan: 7168 total in 3 blocks; 1384 free (0 chunks); 5784 used
CachedPlan: 7168 total in 3 blocks; 3000 free (0 chunks); 4168 used
stock_stockpointnoitemnonpr_pk: 3072 total in 2 blocks; 2000 free (0
chunks); 1072 used
CachedPlan: 7168 total in 3 blocks; 2920 free (0 chunks); 4248 used
CachedPlan: 3072 total in 2 blocks; 72 free (0 chunks); 3000 used
pricelist_itemnomrpbatchno_pk: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
CachedPlan: 7168 total in 3 blocks; 2992 free (0 chunks); 4176 used
CachedPlan: 3072 total in 2 blocks; 640 free (0 chunks); 2432 used
CachedPlan: 3072 total in 2 blocks; 1592 free (0 chunks); 1480 used
CachedPlan: 3072 total in 2 blocks; 384 free (0 chunks); 2688 used
CachedPlan: 3072 total in 2 blocks; 1592 free (0 chunks); 1480 used
CachedPlan: 3072 total in 2 blocks; 176 free (0 chunks); 2896 used
CachedPlan: 7168 total in 3 blocks; 2112 free (0 chunks); 5056 used
CachedPlan: 7168 total in 3 blocks; 2112 free (0 chunks); 5056 used
CachedPlan: 7168 total in 3 blocks; 2112 free (0 chunks); 5056 used
CachedPlan: 7168 total in 3 blocks; 1888 free (0 chunks); 5280 used
CachedPlan: 31744 total in 5 blocks; 7664 free (0 chunks); 24080 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 7168 total in 3 blocks; 2808 free (1 chunks); 4360
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 7168 total in 3 blocks; 2808 free (1 chunks); 4360
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlan: 15360 total in 4 blocks; 8072 free (0 chunks); 7288 used
CachedPlan: 7168 total in 3 blocks; 2624 free (0 chunks); 4544 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 7168 total in 3 blocks; 2808 free (1 chunks); 4360
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlan: 15360 total in 4 blocks; 1696 free (0 chunks); 13664 used
CachedPlan: 7168 total in 3 blocks; 2912 free (0 chunks); 4256 used
CachedPlan: 31744 total in 5 blocks; 10040 free (0 chunks); 21704 used
CachedPlan: 31744 total in 5 blocks; 9792 free (0 chunks); 21952 used
purchase1_vtnoprefixidnosuffix_uq: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
purchase1_txno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
purchase1: 56320 total in 9 blocks; 5776 free (0 chunks); 50544 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
itemsuppliers_itemnoacno_pk: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
CachedPlan: 7168 total in 3 blocks; 2576 free (0 chunks); 4592 used
CachedPlan: 3072 total in 2 blocks; 1080 free (0 chunks); 1992 used
CachedPlan: 3072 total in 2 blocks; 1632 free (1 chunks); 1440 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 7168 total in 3 blocks; 2424 free (1 chunks); 4744
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 512 free (0 chunks); 2560 used
CachedPlanQuery: 3072 total in 2 blocks; 344 free (1 chunks); 2728
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 31744 total in 5 blocks; 7736 free (0 chunks); 24008 used
CachedPlan: 15360 total in 4 blocks; 5568 free (0 chunks); 9792 used
CachedPlan: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used
CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used
CachedPlan: 7168 total in 3 blocks; 2952 free (0 chunks); 4216 used
CachedPlan: 3072 total in 2 blocks; 992 free (0 chunks); 2080 used
CachedPlan: 7168 total in 3 blocks; 3448 free (0 chunks); 3720 used
pricelistreview_edateitemnomrpbatchno_pk: 1024 total in 1 blocks; 312
free (0 chunks); 712 used
CachedPlan: 3072 total in 2 blocks; 984 free (1 chunks); 2088 used
CachedPlanSource: 3072 total in 2 blocks; 504 free (0 chunks); 2568 used
CachedPlanQuery: 3072 total in 2 blocks; 344 free (1 chunks); 2728
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 1448 free (0 chunks); 5720 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 7168 total in 3 blocks; 2424 free (1 chunks); 4744
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlan: 7168 total in 3 blocks; 704 free (0 chunks); 6464 used
CachedPlan: 7168 total in 3 blocks; 2184 free (0 chunks); 4984 used
CachedPlan: 7168 total in 3 blocks; 1616 free (0 chunks); 5552 used
CachedPlan: 7168 total in 3 blocks; 2344 free (0 chunks); 4824 used
CachedPlan: 3072 total in 2 blocks; 152 free (0 chunks); 2920 used
CachedPlan: 7168 total in 3 blocks; 3800 free (0 chunks); 3368 used
CachedPlan: 7168 total in 3 blocks; 3360 free (0 chunks); 3808 used
CachedPlan: 3072 total in 2 blocks; 984 free (1 chunks); 2088 used
CachedPlan: 3072 total in 2 blocks; 376 free (0 chunks); 2696 used
CachedPlan: 3072 total in 2 blocks; 136 free (1 chunks); 2936 used
CachedPlan: 7168 total in 3 blocks; 2360 free (0 chunks); 4808 used
CachedPlan: 3072 total in 2 blocks; 576 free (0 chunks); 2496 used
CachedPlan: 3072 total in 2 blocks; 16 free (0 chunks); 3056 used
CachedPlan: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
CachedPlan: 31744 total in 5 blocks; 7384 free (0 chunks); 24360 used
CachedPlan: 7168 total in 3 blocks; 3928 free (0 chunks); 3240 used
CachedPlan: 3072 total in 2 blocks; 1032 free (0 chunks); 2040 used
CachedPlan: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used
items_itemno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
items_itemname_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736 used
items: 89088 total in 13 blocks; 1112 free (0 chunks); 87976 used
CachedPlan: 7168 total in 3 blocks; 3752 free (0 chunks); 3416 used
CachedPlan: 7168 total in 3 blocks; 3248 free (0 chunks); 3920 used
CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used
CachedPlan: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used
CachedPlan: 7168 total in 3 blocks; 1552 free (0 chunks); 5616 used
CachedPlan: 7168 total in 3 blocks; 4064 free (1 chunks); 3104 used
CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used
CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used
CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 712 free (0 chunks); 2360 used
CachedPlanQuery: 3072 total in 2 blocks; 1144 free (1 chunks); 1928
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 3768 free (0 chunks); 3400 used
CachedPlan: 7168 total in 3 blocks; 4056 free (1 chunks); 3112 used
CachedPlan: 7168 total in 3 blocks; 1552 free (0 chunks); 5616 used
CachedPlan: 7168 total in 3 blocks; 1528 free (0 chunks); 5640 used
CachedPlan: 7168 total in 3 blocks; 1552 free (0 chunks); 5616 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
taxsetup_taxtrans_pk: 3072 total in 2 blocks; 2000 free (0 chunks);
1072 used
CachedPlan: 3072 total in 2 blocks; 1272 free (0 chunks); 1800 used
CachedPlanSource: 3072 total in 2 blocks; 208 free (0 chunks); 2864 used
CachedPlanQuery: 7168 total in 3 blocks; 3544 free (1 chunks); 3624
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 216 free (0 chunks); 808 used
CachedPlanSource: 3072 total in 2 blocks; 1824 free (2 chunks); 1248
used
CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 216 free (0 chunks); 808 used
CachedPlanSource: 3072 total in 2 blocks; 1872 free (2 chunks); 1200
used
CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
CachedPlanSource: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 200 free (0 chunks); 2872 used
CachedPlanQuery: 3072 total in 2 blocks; 168 free (1 chunks); 2904
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 880 free (0 chunks); 2192 used
CachedPlan: 3072 total in 2 blocks; 1080 free (0 chunks); 1992 used
CachedPlan: 7168 total in 3 blocks; 936 free (0 chunks); 6232 used
CachedPlan: 7168 total in 3 blocks; 3136 free (0 chunks); 4032 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 2280 free (0 chunks); 4888 used
CachedPlanSource: 7168 total in 3 blocks; 1672 free (0 chunks); 5496
used
CachedPlanQuery: 7168 total in 3 blocks; 2504 free (1 chunks); 4664
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1608 free (0 chunks); 1464
used
CachedPlanQuery: 3072 total in 2 blocks; 368 free (1 chunks); 2704
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 7168 total in 3 blocks; 3608 free (0 chunks); 3560
used
CachedPlanQuery: 7168 total in 3 blocks; 3528 free (1 chunks); 3640
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 464 free (0 chunks); 560 used
CachedPlanQuery: 3072 total in 2 blocks; 1568 free (1 chunks); 1504
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 408 free (0 chunks); 616 used
CachedPlanSource: 1024 total in 1 blocks; 208 free (0 chunks); 816 used
CachedPlanQuery: 1024 total in 1 blocks; 392 free (1 chunks); 632 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
CachedPlanSource: 3072 total in 2 blocks; 1848 free (1 chunks); 1224
used
CachedPlanQuery: 1024 total in 1 blocks; 72 free (1 chunks); 952 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
CachedPlanSource: 3072 total in 2 blocks; 1848 free (1 chunks); 1224
used
CachedPlanQuery: 1024 total in 1 blocks; 72 free (1 chunks); 952 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 31744 total in 5 blocks; 13408 free (0 chunks); 18336
used
CachedPlanQuery: 31744 total in 5 blocks; 9088 free (1 chunks); 22656
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanQuery: 3072 total in 2 blocks; 1872 free (1 chunks); 1200
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 1912 free (0 chunks); 5256 used
CachedPlanSource: 7168 total in 3 blocks; 1144 free (0 chunks); 6024
used
CachedPlanQuery: 7168 total in 3 blocks; 1944 free (1 chunks); 5224
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 15360 total in 4 blocks; 5360 free (0 chunks); 10000 used
CachedPlanSource: 3072 total in 2 blocks; 552 free (0 chunks); 2520 used
CachedPlanQuery: 15360 total in 4 blocks; 7944 free (1 chunks); 7416
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 96 free (0 chunks); 928 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 560 free (0 chunks); 2512 used
CachedPlanQuery: 7168 total in 3 blocks; 1152 free (1 chunks); 6016
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 3872 free (2 chunks); 3296
used
CachedPlanQuery: 7168 total in 3 blocks; 3288 free (1 chunks); 3880
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
CachedPlanQuery: 3072 total in 2 blocks; 1376 free (1 chunks); 1696
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 168 free (0 chunks); 856 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 384 free (0 chunks); 640 used
CachedPlanSource: 1024 total in 1 blocks; 160 free (0 chunks); 864 used
CachedPlanQuery: 1024 total in 1 blocks; 368 free (1 chunks); 656 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 160 free (0 chunks); 864 used
CachedPlanSource: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
CachedPlanQuery: 1024 total in 1 blocks; 144 free (1 chunks); 880 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 384 free (0 chunks); 640 used
CachedPlanSource: 1024 total in 1 blocks; 160 free (0 chunks); 864 used
CachedPlanQuery: 1024 total in 1 blocks; 368 free (1 chunks); 656 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 160 free (0 chunks); 864 used
CachedPlanSource: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
CachedPlanQuery: 1024 total in 1 blocks; 144 free (1 chunks); 880 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1408 free (0 chunks); 1664
used
CachedPlanQuery: 7168 total in 3 blocks; 2032 free (1 chunks); 5136
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
CachedPlanSource: 3072 total in 2 blocks; 1848 free (1 chunks); 1224
used
CachedPlanQuery: 1024 total in 1 blocks; 72 free (1 chunks); 952 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
itembarcode_itemnobarcode_pk: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
itembarcode_barcode_uq: 1024 total in 1 blocks; 328 free (0 chunks);
696 used
consume2_txnoitemnonpr_uq: 1024 total in 1 blocks; 8 free (0 chunks);
1016 used
consume2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0 chunks); 504
used
salesorder2_ponoitemno_pk: 1024 total in 1 blocks; 520 free (0 chunks);
504 used
purchasertn2_rowkey_uq: 1024 total in 1 blocks; 520 free (0 chunks);
504 used
purchasertn2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0 chunks);
504 used
salesrtn2_rowkey_uq: 1024 total in 1 blocks; 520 free (0 chunks); 504
used
salesrtn2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0 chunks); 504
used
sales2_rowkey_uq: 1024 total in 1 blocks; 480 free (0 chunks); 544 used
sales2_txnoslno_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
partyopeningstock_partyacnoitemnonpr_pk: 1024 total in 1 blocks; 8 free
(0 chunks); 1016 used
materialoutward2_txnoitemnonpr_uq: 1024 total in 1 blocks; 8 free (0
chunks); 1016 used
materialoutward2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
materialinward2_txnoitemnonpr_uq: 1024 total in 1 blocks; 8 free (0
chunks); 1016 used
materialinward2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
transfer2_txnoitemnonpr_uq: 1024 total in 1 blocks; 8 free (0 chunks);
1016 used
transfer2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0 chunks); 504
used
stockadj2_txnoitemnonpr_uq: 3072 total in 2 blocks; 2000 free (0
chunks); 1072 used
stockadj2_txnoslno_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
production2_txnoslno_pk: 1024 total in 1 blocks; 520 free (0 chunks);
504 used
openingstock_stockpointnoitemnonpr_pk: 3072 total in 2 blocks; 2000
free (0 chunks); 1072 used
itemgroup3_groupno3_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
itemgroup3_groupname3_uq: 1024 total in 1 blocks; 288 free (0 chunks);
736 used
itemgroup2_groupno2_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
itemgroup2_groupname2_uq: 1024 total in 1 blocks; 288 free (0 chunks);
736 used
itemgroup1_groupno1_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
itemgroup1_groupname1_uq: 1024 total in 1 blocks; 288 free (0 chunks);
736 used
masteritems_masteritemno_pk: 1024 total in 1 blocks; 552 free (0
chunks); 472 used
masteritems_masteritemname_uq: 1024 total in 1 blocks; 288 free (0
chunks); 736 used
commodity_commodityno_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
commodity_commodityname_uq: 1024 total in 1 blocks; 288 free (0
chunks); 736 used
commodity: 7168 total in 3 blocks; 3944 free (0 chunks); 3224 used
configitems_idno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
featurescompany_compno_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
configpricelist_idno_pk: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
CachedPlanSource: 3072 total in 2 blocks; 1128 free (0 chunks); 1944
used
CachedPlanQuery: 3072 total in 2 blocks; 1960 free (1 chunks); 1112
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 896 free (0 chunks); 2176 used
CachedPlanQuery: 3072 total in 2 blocks; 424 free (1 chunks); 2648
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1120 free (0 chunks); 1952
used
CachedPlanQuery: 3072 total in 2 blocks; 1272 free (1 chunks); 1800
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168
used
CachedPlanQuery: 1024 total in 1 blocks; 136 free (1 chunks); 888 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1112 free (0 chunks); 1960
used
CachedPlanQuery: 3072 total in 2 blocks; 592 free (1 chunks); 2480
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 880 free (0 chunks); 2192 used
CachedPlanSource: 3072 total in 2 blocks; 384 free (0 chunks); 2688 used
CachedPlanQuery: 3072 total in 2 blocks; 984 free (1 chunks); 2088
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 536 free (0 chunks); 2536 used
CachedPlanQuery: 3072 total in 2 blocks; 304 free (1 chunks); 2768
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanSource: 3072 total in 2 blocks; 1600 free (0 chunks); 1472
used
CachedPlanQuery: 3072 total in 2 blocks; 2024 free (1 chunks); 1048
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 408 free (0 chunks); 616 used
CachedPlanSource: 3072 total in 2 blocks; 1944 free (2 chunks); 1128
used
CachedPlanQuery: 1024 total in 1 blocks; 392 free (1 chunks); 632 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
CachedPlanSource: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 536 free (0 chunks); 2536 used
CachedPlanQuery: 3072 total in 2 blocks; 744 free (1 chunks); 2328
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 15360 total in 4 blocks; 5080 free (0 chunks); 10280
used
CachedPlanQuery: 31744 total in 5 blocks; 9744 free (1 chunks); 22000
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
packingsetup_transprimepackingitemno_pk: 1024 total in 1 blocks; 352
free (0 chunks); 672 used
CachedPlanSource: 7168 total in 3 blocks; 3432 free (3 chunks); 3736
used
CachedPlanQuery: 3072 total in 2 blocks; 152 free (1 chunks); 2920
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 15360 total in 4 blocks; 6304 free (2 chunks); 9056
used
CachedPlanQuery: 15360 total in 4 blocks; 3944 free (1 chunks); 11416
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 536 free (0 chunks); 488 used
CachedPlanSource: 1024 total in 1 blocks; 80 free (0 chunks); 944 used
CachedPlanQuery: 1024 total in 1 blocks; 352 free (1 chunks); 672 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1848 free (1 chunks); 1224
used
CachedPlanQuery: 3072 total in 2 blocks; 1064 free (1 chunks); 2008
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanQuery: 1024 total in 1 blocks; 280 free (1 chunks); 744 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanQuery: 1024 total in 1 blocks; 280 free (1 chunks); 744 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanQuery: 1024 total in 1 blocks; 280 free (1 chunks); 744 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 504 free (0 chunks); 2568 used
CachedPlanQuery: 3072 total in 2 blocks; 344 free (1 chunks); 2728
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanQuery: 1024 total in 1 blocks; 280 free (1 chunks); 744 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 256 free (0 chunks); 2816 used
CachedPlanQuery: 7168 total in 3 blocks; 3264 free (1 chunks); 3904
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 136 free (0 chunks); 888 used
CachedPlanSource: 3072 total in 2 blocks; 1832 free (2 chunks); 1240
used
CachedPlanQuery: 1024 total in 1 blocks; 120 free (1 chunks); 904 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 144 free (0 chunks); 880 used
CachedPlanSource: 3072 total in 2 blocks; 1832 free (2 chunks); 1240
used
CachedPlanQuery: 1024 total in 1 blocks; 128 free (1 chunks); 896 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanSource: 3072 total in 2 blocks; 1936 free (2 chunks); 1136
used
CachedPlanQuery: 1024 total in 1 blocks; 312 free (1 chunks); 712 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 328 free (1 chunks); 696 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 1984 free (1 chunks); 1088 used
CachedPlanSource: 3072 total in 2 blocks; 1632 free (0 chunks); 1440
used
CachedPlanQuery: 3072 total in 2 blocks; 1968 free (1 chunks); 1104
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 136 free (0 chunks); 888 used
CachedPlanSource: 3072 total in 2 blocks; 1832 free (2 chunks); 1240
used
CachedPlanQuery: 1024 total in 1 blocks; 120 free (1 chunks); 904 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 3968 free (3 chunks); 3200
used
CachedPlanQuery: 7168 total in 3 blocks; 1856 free (1 chunks); 5312
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 168 free (0 chunks); 856 used
CachedPlanSource: 3072 total in 2 blocks; 1896 free (3 chunks); 1176
used
CachedPlanQuery: 1024 total in 1 blocks; 152 free (1 chunks); 872 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 3848 free (2 chunks); 3320
used
CachedPlanQuery: 15360 total in 4 blocks; 3984 free (1 chunks); 11376
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456
used
CachedPlanQuery: 7168 total in 3 blocks; 2528 free (1 chunks); 4640
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 7168 total in 3 blocks; 3520 free (0 chunks); 3648
used
CachedPlanQuery: 7168 total in 3 blocks; 3272 free (1 chunks); 3896
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 3752 free (0 chunks); 3416 used
CachedPlanSource: 3072 total in 2 blocks; 480 free (1 chunks); 2592 used
CachedPlanQuery: 7168 total in 3 blocks; 3736 free (1 chunks); 3432
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used
CachedPlanSource: 7168 total in 3 blocks; 2264 free (0 chunks); 4904
used
CachedPlanQuery: 7168 total in 3 blocks; 3160 free (1 chunks); 4008
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 3072 total in 2 blocks; 1896 free (3 chunks); 1176
used
CachedPlanQuery: 1024 total in 1 blocks; 392 free (1 chunks); 632 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 2920 free (1 chunks); 4248
used
CachedPlanQuery: 15360 total in 4 blocks; 6912 free (1 chunks); 8448
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1608 free (0 chunks); 1464
used
CachedPlanQuery: 3072 total in 2 blocks; 368 free (1 chunks); 2704
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 7168 total in 3 blocks; 3376 free (1 chunks); 3792
used
CachedPlanQuery: 7168 total in 3 blocks; 3208 free (1 chunks); 3960
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1576 free (0 chunks); 1496
used
CachedPlanQuery: 3072 total in 2 blocks; 1160 free (1 chunks); 1912
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
purchaseorder2_ponoitemno_pk: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 368 free (0 chunks); 656 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 352 free (1 chunks); 672 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 1064 free (1 chunks); 2008 used
CachedPlanSource: 3072 total in 2 blocks; 256 free (1 chunks); 2816 used
CachedPlanQuery: 3072 total in 2 blocks; 1168 free (2 chunks); 1904
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
CachedPlanSource: 3072 total in 2 blocks; 1696 free (0 chunks); 1376
used
CachedPlanQuery: 1024 total in 1 blocks; 72 free (1 chunks); 952 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 656 free (0 chunks); 2416 used
CachedPlanQuery: 7168 total in 3 blocks; 112 free (1 chunks); 7056
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1856 free (0 chunks); 1216
used
CachedPlanQuery: 3072 total in 2 blocks; 1912 free (1 chunks); 1160
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728
used
CachedPlanQuery: 3072 total in 2 blocks; 1496 free (1 chunks); 1576
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1176 free (0 chunks); 1896
used
CachedPlanQuery: 7168 total in 3 blocks; 2592 free (1 chunks); 4576
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 31744 total in 5 blocks; 16000 free (2 chunks); 15744
used
CachedPlanQuery: 31744 total in 5 blocks; 16256 free (1 chunks);
15488 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 1752 free (0 chunks); 1320 used
CachedPlanSource: 3072 total in 2 blocks; 1296 free (0 chunks); 1776
used
CachedPlanQuery: 3072 total in 2 blocks; 1672 free (1 chunks); 1400
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1768 free (0 chunks); 1304
used
CachedPlanQuery: 3072 total in 2 blocks; 272 free (1 chunks); 2800
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 96 free (0 chunks); 928 used
CachedPlanQuery: 3072 total in 2 blocks; 928 free (1 chunks); 2144
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456
used
CachedPlanQuery: 7168 total in 3 blocks; 2528 free (1 chunks); 4640
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 7168 total in 3 blocks; 864 free (0 chunks); 6304 used
CachedPlanQuery: 7168 total in 3 blocks; 936 free (1 chunks); 6232
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
CachedPlanQuery: 1024 total in 1 blocks; 280 free (1 chunks); 744 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 96 free (0 chunks); 928 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1728 free (2 chunks); 1344
used
CachedPlanQuery: 7168 total in 3 blocks; 2592 free (1 chunks); 4576
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1432 free (0 chunks); 1640
used
CachedPlanQuery: 3072 total in 2 blocks; 400 free (1 chunks); 2672
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 3072 total in 2 blocks; 1856 free (2 chunks); 1216
used
CachedPlanQuery: 1024 total in 1 blocks; 208 free (1 chunks); 816 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 3072 total in 2 blocks; 992 free (1 chunks); 2080
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456
used
CachedPlanQuery: 7168 total in 3 blocks; 2528 free (1 chunks); 4640
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 168 free (0 chunks); 2904 used
CachedPlanQuery: 7168 total in 3 blocks; 3760 free (1 chunks); 3408
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
CachedPlanQuery: 1024 total in 1 blocks; 280 free (1 chunks); 744 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456
used
CachedPlanQuery: 3072 total in 2 blocks; 680 free (1 chunks); 2392
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
user1_userno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
users_userid_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736 used
users_username_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736 used
CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432
used
CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
user1: 7168 total in 3 blocks; 2880 free (0 chunks); 4288 used
CachedPlanSource: 7168 total in 3 blocks; 2808 free (0 chunks); 4360
used
CachedPlanQuery: 7168 total in 3 blocks; 3192 free (1 chunks); 3976
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1800 free (1 chunks); 1272
used
CachedPlanQuery: 3072 total in 2 blocks; 1064 free (1 chunks); 2008
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 512 free (0 chunks); 512 used
CachedPlanSource: 3072 total in 2 blocks; 1936 free (2 chunks); 1136
used
CachedPlanQuery: 1024 total in 1 blocks; 392 free (1 chunks); 632 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1392 free (0 chunks); 1680
used
CachedPlanQuery: 3072 total in 2 blocks; 344 free (1 chunks); 2728
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
configpurchase1_vtno_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
CachedPlanSource: 3072 total in 2 blocks; 1320 free (0 chunks); 1752
used
CachedPlanQuery: 3072 total in 2 blocks; 104 free (1 chunks); 2968
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
configpurchase1: 7168 total in 3 blocks; 1824 free (0 chunks); 5344 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 208 free (0 chunks); 816 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 56 free (0 chunks); 968 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 1752 free (0 chunks); 1320 used
CachedPlanSource: 3072 total in 2 blocks; 1296 free (0 chunks); 1776
used
CachedPlanQuery: 3072 total in 2 blocks; 1672 free (1 chunks); 1400
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1024 free (0 chunks); 2048
used
CachedPlanQuery: 7168 total in 3 blocks; 3288 free (1 chunks); 3880
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
CachedPlanQuery: 1024 total in 1 blocks; 336 free (1 chunks); 688 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 3072 total in 2 blocks; 1272 free (1 chunks); 1800
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 3072 total in 2 blocks; 1528 free (1 chunks); 1544
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968
used
CachedPlanQuery: 3072 total in 2 blocks; 1432 free (1 chunks); 1640
used
SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used
acvoucher3_txnoacnoslacno_pk: 1024 total in 1 blocks; 352 free (0
chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 31744 total in 5 blocks; 14216 free (1 chunks);
17528 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 15360 total in 4 blocks; 3240 free (0 chunks); 12120
used
CachedPlanQuery: 15360 total in 4 blocks; 3624 free (1 chunks); 11736
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
packingitemsautopost_tmnotranstypetxnoslno_pk: 1024 total in 1 blocks;
352 free (0 chunks); 672 used
CachedPlanSource: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
CachedPlanQuery: 3072 total in 2 blocks; 680 free (1 chunks); 2392
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1296 free (0 chunks); 1776
used
CachedPlanQuery: 3072 total in 2 blocks; 840 free (1 chunks); 2232
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728
used
CachedPlanQuery: 3072 total in 2 blocks; 1496 free (1 chunks); 1576
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 1800 free (1 chunks); 1272
used
CachedPlanQuery: 7168 total in 3 blocks; 2880 free (1 chunks); 4288
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 384 free (0 chunks); 640 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 368 free (1 chunks); 656 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 384 free (0 chunks); 640 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 368 free (1 chunks); 656 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 368 free (0 chunks); 656 used
CachedPlanQuery: 7168 total in 3 blocks; 3768 free (1 chunks); 3400
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 3672 free (0 chunks); 3496
used
CachedPlanQuery: 7168 total in 3 blocks; 2304 free (1 chunks); 4864
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 3072 total in 2 blocks; 264 free (0 chunks); 2808 used
CachedPlanQuery: 7168 total in 3 blocks; 3800 free (1 chunks); 3368
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanSource: 3072 total in 2 blocks; 1720 free (1 chunks); 1352
used
CachedPlanQuery: 1024 total in 1 blocks; 88 free (1 chunks); 936 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
CachedPlanSource: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
CachedPlanSource: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 3920 free (3 chunks); 3248
used
CachedPlanQuery: 7168 total in 3 blocks; 3768 free (1 chunks); 3400
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 15360 total in 4 blocks; 1552 free (0 chunks); 13808 used
configcompany_compno_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
CachedPlanSource: 3072 total in 2 blocks; 24 free (0 chunks); 3048 used
CachedPlanQuery: 7168 total in 3 blocks; 1144 free (1 chunks); 6024
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used
CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 7168 total in 3 blocks; 2192 free (0 chunks); 4976 used
CachedPlanSource: 7168 total in 3 blocks; 1688 free (0 chunks); 5480
used
CachedPlanQuery: 7168 total in 3 blocks; 2224 free (1 chunks); 4944
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 3072 total in 2 blocks; 1896 free (3 chunks); 1176
used
CachedPlanQuery: 1024 total in 1 blocks; 392 free (1 chunks); 632 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 7168 total in 3 blocks; 2920 free (1 chunks); 4248
used
CachedPlanQuery: 15360 total in 4 blocks; 6912 free (1 chunks); 8448
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 56 free (1 chunks); 968 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanSource: 3072 total in 2 blocks; 2016 free (3 chunks); 1056
used
CachedPlanQuery: 1024 total in 1 blocks; 216 free (1 chunks); 808 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 368 free (0 chunks); 656 used
CachedPlanQuery: 3072 total in 2 blocks; 1376 free (1 chunks); 1696
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 384 free (0 chunks); 640 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 368 free (1 chunks); 656 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 368 free (0 chunks); 656 used
CachedPlanQuery: 3072 total in 2 blocks; 1368 free (1 chunks); 1704
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 368 free (0 chunks); 656 used
CachedPlanQuery: 3072 total in 2 blocks; 1688 free (1 chunks); 1384
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 1024 total in 1 blocks; 368 free (0 chunks); 656 used
CachedPlanQuery: 3072 total in 2 blocks; 1536 free (1 chunks); 1536
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
CachedPlanSource: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
CachedPlanQuery: 1024 total in 1 blocks; 528 free (1 chunks); 496 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
CachedPlanSource: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanQuery: 1024 total in 1 blocks; 528 free (1 chunks); 496 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
CachedPlanSource: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanQuery: 1024 total in 1 blocks; 528 free (1 chunks); 496 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
CachedPlanSource: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
CachedPlanQuery: 1024 total in 1 blocks; 528 free (1 chunks); 496 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlanSource: 17408 total in 2 blocks; 8176 free (0 chunks); 9232
used
CachedPlanQuery: 15360 total in 4 blocks; 2528 free (1 chunks); 12832
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
CachedPlanSource: 1024 total in 1 blocks; 104 free (0 chunks); 920 used
CachedPlanQuery: 1024 total in 1 blocks; 376 free (1 chunks); 648 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (1 chunks); 1256
used
CachedPlanQuery: 1024 total in 1 blocks; 72 free (1 chunks); 952 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 3072 total in 2 blocks; 1880 free (0 chunks); 1192 used
CachedPlanSource: 3072 total in 2 blocks; 1528 free (0 chunks); 1544
used
CachedPlanQuery: 3072 total in 2 blocks; 1800 free (1 chunks); 1272
used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used
CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
CachedPlan: 1024 total in 1 blocks; 560 free (0 chunks); 464 used
CachedPlanSource: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
CachedPlanQuery: 1024 total in 1 blocks; 544 free (1 chunks); 480 used
SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used
pg_toast_1255_index: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
companygroup_compgroupno_pk: 1024 total in 1 blocks; 552 free (0
chunks); 472 used
companygroup_compgroupname_uq: 1024 total in 1 blocks; 288 free (0
chunks); 736 used
company2_compnoacyear_pk: 1024 total in 1 blocks; 480 free (0 chunks);
544 used
company1_compno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
company1_shortname_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736
used
company1_compname_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736
used
company1: 121856 total in 17 blocks; 5352 free (0 chunks); 116504 used
configpurchase2_vtnoadnlacno_pk: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
customfields_customfieldno_pk: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
customfields_customfieldname_uq: 1024 total in 1 blocks; 328 free (0
chunks); 696 used
purchase5_txnocustomfieldno_pk: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
purchase4_txnoadnlacno_pk: 1024 total in 1 blocks; 480 free (0 chunks);
544 used
pg_toast_2619_index: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
measureunits_unitno_pk: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
measureunits_unitname_uq: 1024 total in 1 blocks; 288 free (0 chunks);
736 used
acvoucher5_txnorowkeyslno_pk: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
acvouchertype_vtno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
acvouchertype_vtcode_uq: 1024 total in 1 blocks; 288 free (0 chunks);
736 used
acvouchertype_vtname_uq: 1024 total in 1 blocks; 288 free (0 chunks);
736 used
acvouchertype: 7168 total in 3 blocks; 2848 free (0 chunks); 4320 used
purchase6_txnoagainstponoitemno_pk: 1024 total in 1 blocks; 352 free (0
chunks); 672 used
purchaseorder1_acyearidno_uq: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
purchaseorder1_pono_pk: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
purchaseorder1: 15360 total in 4 blocks; 5640 free (0 chunks); 9720 used
acvoucher2_txnorowkey_uq: 1024 total in 1 blocks; 480 free (0 chunks);
544 used
acvoucher2_txnoslcno_pk: 1024 total in 1 blocks; 480 free (0 chunks);
544 used
acledgerbal_acno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
acduebills_billno_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
gracknowledge1_txno_pk: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
gracknowledge1: 7168 total in 3 blocks; 3576 free (0 chunks); 3592 used
stockpoint_stockpointno_pk: 1024 total in 1 blocks; 552 free (0
chunks); 472 used
stockpoint_stockpointcode_uq: 1024 total in 1 blocks; 288 free (0
chunks); 736 used
stockpoint_stockpointname_uq: 1024 total in 1 blocks; 288 free (0
chunks); 736 used
acvoucher1_txno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
acvoucher1_vtnopreidnosuf_uq: 3072 total in 2 blocks; 1840 free (0
chunks); 1232 used
acledger_acno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
acledger_acname_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736
used
acgroup_groupno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
acgroup_groupname_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736
used
pg_index_indrelid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
acvoucher1: 15360 total in 4 blocks; 4808 free (0 chunks); 10552 used
stockpoint: 15360 total in 4 blocks; 5584 free (0 chunks); 9776 used
pg_toast_2618_index: 1024 total in 1 blocks; 480 free (0 chunks); 544
used
acledger: 56320 total in 9 blocks; 1816 free (0 chunks); 54504 used
pg_constraint_conrelid_index: 1024 total in 1 blocks; 552 free (0
chunks); 472 used
pg_db_role_setting_databaseid_rol_index: 1024 total in 1 blocks; 480
free (0 chunks); 544 used
pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
pg_foreign_data_wrapper_name_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_enum_oid_index: 1024 total in 1 blocks; 592 free (0 chunks); 432 used
pg_class_relname_nsp_index: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
pg_foreign_server_oid_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_statistic_relid_att_inh_index: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
pg_cast_source_target_index: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
pg_language_name_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_collation_oid_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_amop_fam_strat_index: 1024 total in 1 blocks; 312 free (0 chunks);
712 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_ts_template_tmplname_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_ts_config_map_index: 1024 total in 1 blocks; 352 free (0 chunks);
672 used
pg_opclass_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
pg_foreign_data_wrapper_oid_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_event_trigger_evtname_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_ts_dict_oid_index: 1024 total in 1 blocks; 592 free (0 chunks); 432
used
pg_event_trigger_oid_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_conversion_default_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used
pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
pg_enum_typid_label_index: 1024 total in 1 blocks; 520 free (0 chunks);
504 used
pg_ts_config_oid_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_user_mapping_oid_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_opfamily_am_name_nsp_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used
pg_foreign_table_relid_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_type_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_constraint_oid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
pg_ts_parser_prsname_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_ts_config_cfgname_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_ts_parser_oid_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_operator_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
pg_namespace_nspname_index: 1024 total in 1 blocks; 552 free (0
chunks); 472 used
pg_ts_template_oid_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_amop_opr_fam_index: 1024 total in 1 blocks; 312 free (0 chunks); 712
used
pg_default_acl_role_nsp_obj_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used
pg_collation_name_enc_nsp_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used
pg_range_rngtypid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_ts_dict_dictname_index: 1024 total in 1 blocks; 520 free (0 chunks);
504 used
pg_type_typname_nsp_index: 1024 total in 1 blocks; 480 free (0 chunks);
544 used
pg_opfamily_oid_index: 1024 total in 1 blocks; 592 free (0 chunks); 432
used
pg_class_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 312 free (0
chunks); 712 used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 480 free (0
chunks); 544 used
pg_proc_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472 used
pg_language_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
pg_namespace_oid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_amproc_fam_proc_index: 1024 total in 1 blocks; 312 free (0 chunks);
712 used
pg_foreign_server_name_index: 1024 total in 1 blocks; 592 free (0
chunks); 432 used
pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_conversion_oid_index: 1024 total in 1 blocks; 592 free (0 chunks);
432 used
pg_user_mapping_user_server_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_conversion_name_nsp_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_authid_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_tablespace_oid_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_database_datname_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
pg_auth_members_role_member_index: 1024 total in 1 blocks; 520 free (0
chunks); 504 used
pg_database_oid_index: 1024 total in 1 blocks; 552 free (0 chunks); 472
used
pg_authid_rolname_index: 1024 total in 1 blocks; 552 free (0 chunks);
472 used
MdSmgr: 8192 total in 1 blocks; 4240 free (1 chunks); 3952 used
LOCALLOCK hash: 24576 total in 2 blocks; 15136 free (3 chunks); 9440 used
Timezones: 79320 total in 2 blocks; 5968 free (0 chunks); 73352 used
ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
2014-06-02 16:33:08 IST ERROR: out of memory
2014-06-02 16:33:08 IST DETAIL: Failed on request of size 7456.
2014-06-02 16:33:08 IST STATEMENT: select
itemno,i.masteritemno,itemname,itemcode,i.aliasname,aliasnamelanguage,
mi.masteritemname,ig1.groupname1 as gp1,ig2.groupname2 as gp2,
ig3.groupname3 as gp3,i.groupno1,i.groupno2,i.groupno3,cy.commodityno,
cy.commodityname,cy.lst,mu.unitno,mu.unitname as unitname, (select
mu.unitname from measureunits mu where mu.unitno=i.altunitno) as
altunitname, mu.unit1,mu.unit2,mu.units,decimals,i.altunitno,decimals,
weight,weighttype,
i.includestockrep,minstock,minstockunit,i.recordowner,i.lastmodified,
i.act,i.crdate,i.stdprofit1,i.stdprofit2,i.reqmrp,i.reqbatch,i.reqmfrdate,i.mfrdateformat,
i.reqexpdate,i.expdateformat,i.expdays1,i.expdays2,i.expinfodays,i.stdsaleratemethod,
actpurchaseorder,actpurchase,actpurchasereturn,actsalesorder,actsales,actsalesreturn,
actreceiptnote,actdeliverynote,actconsumption,actproduction,actestimate,notifypurchaseorder,
notifypurchase,notifypurchasereturn,notifysalesorder,notifysales,notifysalesreturn,notifyreceiptnote,
notifydeliverynote,notifyconsumption,notifyproduction,notifyestimate,minsaleqtynos,
minsaleqtyunit,description,remarks,salesrateper from items i,commodity
cy,measureunits mu,masteritems mi, itemgroup1 ig1,itemgroup2 ig2,itemgroup3
ig3 where ig1.groupno1=i.groupno1 and ig2.groupno2=i.groupno2 and
ig3.groupno3=i.groupno3 and cy.commodityno=i.commodityno and
mu.unitno=i.unitno and i.masteritemno=mi.masteritemno and i.itemno =
(select case when count(itemno) = 0 then (select min(itemno) from items
where itemno>709) else 709 end from items where itemno=709)
2014-06-02 16:33:09 IST LOG: server process (PID 5844) was terminated by
exception 0xC000012D
2014-06-02 16:33:09 IST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2014-06-02 16:33:09 IST LOG: terminating any other active server processes
2014-06-02 16:33:09 IST WARNING: terminating connection because of crash
of another server process
2014-06-02 16:33:09 IST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2014-06-02 16:33:09 IST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2014-06-02 16:33:09 IST WARNING: terminating connection because of crash
of another server process
2014-06-02 16:33:09 IST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2014-06-02 16:33:09 IST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2014-06-02 16:33:10 IST WARNING: terminating connection because of crash
of another server process
2014-06-02 16:33:10 IST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2014-06-02 16:33:10 IST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2014-06-02 16:33:13 IST WARNING: terminating connection because of crash
of another server process
2014-06-02 16:33:13 IST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2014-06-02 16:33:13 IST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2014-06-02 16:33:14 IST LOG: all server processes terminated;
reinitializing
2014-06-02 16:33:14 IST FATAL: could not create shared memory segment:
error code 1455
2014-06-02 16:33:14 IST DETAIL: Failed system call was
CreateFileMapping(size=145850368, name=Global/PostgreSQL:C:/Program
Files/PostgreSQL/9.3/data).

Thanks in Advance

On Fri, May 30, 2014 at 7:23 AM, David G Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> Kalai R wrote
> > I have checked no problem in pg_hba.conf file.
> >
> > Also I have disabled AV software checks for the Postgres Directories.
> >
> > But Problem remains
>
> Disabling AV won't magically make the system start working if it's already
> broken. You disable it to avoid breaking the system in the first place.
>
> David J.
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Postgresql-service-stopped-automatically-after-restart-tp5805424p5805513.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>