Re: Postgresql service stopped automatically after restart

[Kalai R <softlinne.kv@xxxxxxxxx>]

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