Search Postgresql Archives

Re: Postgresql service stopped automatically after restart

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

 



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.g.johnston@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux