Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.03.2021 01:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17568680 kB
MemAvailable 31609336 kB
Buffers 0 kB
Cached 14137956 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-14 01:27:22
DTS_END                         2021-03-14 01:27:22.9870
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35792
TRN_ID                          246905
ATT_ID                          641
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9156.34 24726 1098761
customer order: creation 176.14 384 21137
customer order: refuse 15.54 364 1865
order to supplier: creation 46.65 1411 5598
order to supplier: removal 3.34 102034 401
invoice (draft): creation 47.68 3516 5722
invoice (draft): removal 51.58 815 6189
invoice accept: apply 42.57 18253 5108
invoice accept: cancel 46.96 812 5635
customer reserve: creation 3805.14 187 456617
customer reserve: removal 4612.50 59 553500
realization accept: apply 87.01 196 10441
realization accept: cancel 86.43 105 10372
payment from customer: creation 62.63 110 7515
payment from customer: removal 5.95 73 714
payment to supplier: creation 50.01 146 6001
payment to supplier: removal 3.43 55 412
service: total inventory turnovers 5.22 922 626
service: total monetary turnovers 6.76 29 811
service: aggregate perf. data 0.78 21947 93
service: refresh index statistics 0.03 343097 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 14-03-2021 01:28:58 to 14-03-2021 01:29:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5443
TEST_TIME 2 4328
TEST_TIME 3 5043
TEST_TIME 4 4650
TEST_TIME 5 5032
TEST_TIME 6 6090
TEST_TIME 7 6356
TEST_TIME 8 6149
TEST_TIME 9 6113
TEST_TIME 10 6190
TEST_TIME 11 6653
TEST_TIME 12 6744
TEST_TIME 13 6758
TEST_TIME 14 6838
TEST_TIME 15 7097
TEST_TIME 16 7176
TEST_TIME 17 7179
TEST_TIME 18 7412
TEST_TIME 19 7540
TEST_TIME 20 7662
TEST_TIME 21 7584
TEST_TIME 22 7661
TEST_TIME 23 7670
TEST_TIME 24 8189
TEST_TIME 25 8327
TEST_TIME 26 8686
TEST_TIME 27 9633
TEST_TIME 28 10143
TEST_TIME 29 10240
TEST_TIME 30 10062
TEST_TIME 31 9866
TEST_TIME 32 9763
TEST_TIME 33 9716
TEST_TIME 34 9620
TEST_TIME 35 9561
TEST_TIME 36 9440
TEST_TIME 37 9343
TEST_TIME 38 9471
TEST_TIME 39 9558
TEST_TIME 40 9412
TEST_TIME 41 9238
TEST_TIME 42 9320
TEST_TIME 43 9172
TEST_TIME 44 9309
TEST_TIME 45 9396
TEST_TIME 46 9356
TEST_TIME 47 9365
TEST_TIME 48 9376
TEST_TIME 49 9363
TEST_TIME 50 9488
TEST_TIME 51 9514
TEST_TIME 52 9541
TEST_TIME 53 9564
TEST_TIME 54 9588
TEST_TIME 55 9667
TEST_TIME 56 9736
TEST_TIME 57 9709
TEST_TIME 58 9711
TEST_TIME 59 9608
TEST_TIME 60 9614
TEST_TIME 61 9535
TEST_TIME 62 9475
TEST_TIME 63 9519
TEST_TIME 64 9411
TEST_TIME 65 9327
TEST_TIME 66 9400
TEST_TIME 67 9419
TEST_TIME 68 9412
TEST_TIME 69 9426
TEST_TIME 70 9423
TEST_TIME 71 9438
TEST_TIME 72 9442
TEST_TIME 73 9469
TEST_TIME 74 9384
TEST_TIME 75 9359
TEST_TIME 76 9498
TEST_TIME 77 9533
TEST_TIME 78 9587
TEST_TIME 79 9544
TEST_TIME 80 9521
TEST_TIME 81 9462
TEST_TIME 82 9405
TEST_TIME 83 9352
TEST_TIME 84 9289
TEST_TIME 85 9284
TEST_TIME 86 9305
TEST_TIME 87 9248
TEST_TIME 88 9303
TEST_TIME 89 9258
TEST_TIME 90 9214
TEST_TIME 91 9224
TEST_TIME 92 9280
TEST_TIME 93 9267
TEST_TIME 94 9336
TEST_TIME 95 9316
TEST_TIME 96 9300
TEST_TIME 97 9290
TEST_TIME 98 9350
TEST_TIME 99 9315
TEST_TIME 100 9377
TEST_TIME 101 9365
TEST_TIME 102 9394
TEST_TIME 103 9415
TEST_TIME 104 9416
TEST_TIME 105 9441
TEST_TIME 106 9369
TEST_TIME 107 9333
TEST_TIME 108 9270
TEST_TIME 109 9307
TEST_TIME 110 9274
TEST_TIME 111 9246
TEST_TIME 112 9223
TEST_TIME 113 9209
TEST_TIME 114 9139
TEST_TIME 115 9188
TEST_TIME 116 9193
TEST_TIME 117 9164
TEST_TIME 118 9161
TEST_TIME 119 9205
TEST_TIME 120 9158

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-03-2021 01:29:02 to 14-03-2021 01:29:06.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1522639 1522639 0 0.00 0 21939 6 0 0
doc_list_biud 1522638 1522638 0 0.00 0 47739 27 0 0
sp_add_invoice_to_stock 5196 5108 88 1.69 34 160546 18253 0 88
sp_cancel_adding_invoice 5635 5635 0 0.00 4 74079 812 0 0
sp_cancel_client_order 1865 1865 0 0.00 4 33694 365 0 0
sp_cancel_customer_reserve 553500 553500 0 0.00 1 47741 59 0 0
sp_cancel_pay_from_customer 714 714 0 0.00 3 5238 73 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 2 930 56 0 0
sp_cancel_supplier_invoice 6196 6189 7 0.11 1 17747 815 0 7
sp_cancel_supplier_order 401 401 0 0.00 7 1046779 102034 0 0
sp_cancel_write_off 10372 10372 0 0.00 1 13362 105 0 0
sp_client_order 21137 21137 0 0.00 3 40741 384 0 0
sp_customer_reserve 456617 456617 0 0.00 0 111167 187 0 0
sp_fill_shopping_cart 32436 32436 0 0.00 1 23013 38 0 0
sp_fill_shopping_cart_clo_res 456615 456615 0 0.00 0 22502 12 0 0
sp_get_clo_for_invoice 5106 5106 0 0.00 0 22917 296 0 0
sp_kill_cost_storno 17133 17133 0 0.00 0 13342 50 0 0
sp_kill_qstorno_ret_qs2qd 1123962 1123962 0 0.00 0 47736 32 0 0
sp_kill_qty_storno 593509 593509 0 0.00 0 47738 70 0 0
sp_lock_selected_doc 21513 21513 0 0.00 0 7190 4 0 0
sp_make_cost_storno 29063 29063 0 0.00 0 20927 58 0 0
sp_multiply_rows_for_pdistr 29063 29063 0 0.00 0 8534 29 0 0
sp_multiply_rows_for_qdistr 21137 21137 0 0.00 0 40714 182 0 0
sp_pay_from_customer 7515 7515 0 0.00 4 14124 111 0 0
sp_pay_to_supplier 6001 6001 0 0.00 4 16609 146 0 0
sp_payment_common 13516 13516 0 0.00 1 11762 33 0 0
sp_qd_handle_on_cancel_clo 1865 1865 0 0.00 0 24941 329 0 0
sp_qd_handle_on_invoice_upd_sts 10741 10741 0 0.00 0 42880 323 0 0
sp_qd_handle_on_reserve_upd_sts 10441 10441 0 0.00 0 20437 69 0 0
sp_reserve_write_off 10441 10441 0 0.00 6 21951 196 0 0
sp_supplier_invoice 5722 5722 0 0.00 6 97005 3517 0 0
sp_supplier_order 5598 5598 0 0.00 5 47614 1412 0 0
srv_aggregate_perf_data 93 93 0 0.00 3103 595194 21948 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1360 136502 32566 0 0
srv_find_qd_qs_mism 1050763 1050763 0 0.00 0 11326 6 0 0
srv_make_invnt_saldo 626 626 0 0.00 30 52183 922 0 0
srv_make_money_saldo 811 811 0 0.00 0 7948 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 214585 554844 343097 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5108 5108 0 0.00 0 24720 171 0 0
t$perf-norm:sp_cancel_adding_invoice 437 437 0 0.00 0 7749 104 0 0
t$perf-norm:sp_cancel_client_order 1865 1865 0 0.00 0 2256 17 0 0
t$perf-norm:sp_cancel_customer_reserve 732 732 0 0.00 0 3202 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 714 714 0 0.00 0 3739 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 1843 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 3018 32 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 24953 1585 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 3294 10 0 0
t$perf-norm:sp_client_order 21137 21137 0 0.00 0 9751 19 0 0
t$perf-norm:sp_customer_reserve 1058 1058 0 0.00 0 2194 11 0 0
t$perf-norm:sp_pay_from_customer 7515 7515 0 0.00 0 10050 14 0 0
t$perf-norm:sp_pay_to_supplier 6001 6001 0 0.00 0 6435 14 0 0
t$perf-norm:sp_reserve_write_off 10441 10441 0 0.00 0 13002 13 0 0
t$perf-norm:sp_supplier_invoice 5722 5722 0 0.00 0 10481 24 0 0
t$perf-norm:sp_supplier_order 5598 5598 0 0.00 0 4375 16 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 282 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 297 5 0 0
t$perf-norm:srv_make_invnt_saldo 626 626 0 0.00 0 2601 25 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 905 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10386 10210 176 1.69 0 5187 16 0 176
v_all_customers 38608 38608 0 0.00 0 23 1 0 0
v_all_suppliers 30864 30864 0 0.00 0 20 1 0 0
v_all_wares 42272 42272 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 874 874 0 0.00 0 1407 9 0 0
v_cancel_client_order 3730 3730 0 0.00 0 8743 9 0 0
v_cancel_customer_prepayment 1428 1428 0 0.00 0 1824 6 0 0
v_cancel_customer_reserve 1464 1464 0 0.00 0 1370 4 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 509 3 0 0
v_cancel_supplier_invoice 784 770 14 1.78 0 478 15 0 14
v_cancel_supplier_order 802 802 0 0.00 0 3404 16 0 0
v_cancel_write_off 2042 2042 0 0.00 0 3093 14 0 0
v_max_id_clo_ord 5598 5598 0 0.00 0 4841 2 0 0
v_max_id_clo_res 1058 1058 0 0.00 0 3644 15 0 0
v_max_id_ord_sup 5702 5702 0 0.00 0 12817 5 0 0
v_max_non_paid_invoice 1869 1869 0 0.00 0 455 3 0 0
v_max_non_paid_realizn 3967 3967 0 0.00 0 5131 5 0 0
v_min_id_clo_ord 5598 5598 0 0.00 0 9781 7 0 0
v_min_id_clo_res 1058 1058 0 0.00 0 5496 14 0 0
v_min_id_ord_sup 5702 5702 0 0.00 0 6620 11 0 0
v_min_non_paid_invoice 6001 6001 0 0.00 0 10031 20 0 0
v_min_non_paid_realizn 7515 7515 0 0.00 0 11267 20 0 0
v_our_firm 10760 10760 0 0.00 0 12 1 0 0
v_reserve_write_off 20882 20882 0 0.00 0 15324 7 0 0
x_lock_depdocs_on_canc_invoice 11439 11439 0 0.00 0 18993 109 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 10822 317 0 0
x_make_qstorno_1000_1200 5598 5598 0 0.00 2 47608 1333 0 0
x_make_qstorno_1200_2000 5722 5722 0 0.00 2 96981 3379 0 0
x_make_qstorno_2100_3300 456617 456617 0 0.00 0 111165 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2021 01:29:07 to 14-03-2021 01:29:11.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:25 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 22837 8192000000 10277262464 10585501696 951818672 10.409 75 54 110 0 973206256 2831632 18555952
22:58:03 13392 8192000000 10317830816 10630799360 1384674624 14.458 100 92 184 0 1418878352 4429136 29774592
22:58:26 33391 8192000000 10369834688 10688483328 1417803680 14.753 100 87 174 0 1453020544 5946208 29270656
22:59:08 30529 8192000000 10390384960 10712903680 1441858480 14.966 100 92 184 0 1478968144 7078000 30031664
22:59:46 12465 8192000000 10403090848 10728927232 1455773568 15.089 100 88 176 0 1492115840 7993824 28348448
23:00:12 15257 8192000000 10416556656 10745643008 1474833344 15.256 100 87 174 0 1511090160 8685776 27571040
23:00:37 19474 8192000000 10436360864 10768416768 1489526608 15.385 100 87 174 2 1525849952 8837824 27485520
23:01:08 13924 8192000000 10461977120 10799284224 1511822096 15.579 100 84 168 0 1547589328 9539744 26227488
23:01:38 21960 8192000000 10491179072 10836492288 1540087216 15.824 100 83 166 0 1575499280 9742720 25669344
23:02:10 15898 8192000000 10533671712 10882273280 1587546912 16.233 100 85 170 2 1624292224 10739392 26005920
23:02:35 11511 8192000000 10553646016 10907447296 1611960912 16.441 100 83 164 3 1647829712 11364096 24504704
23:02:57 12183 8192000000 10578013552 10934767616 1633946640 16.628 100 83 165 2 1670303904 11648896 24708368
23:03:18 8990 8192000000 10597674208 10957959168 1655461664 16.811 100 86 172 1 1693537296 12630608 25445024
23:03:35 5692 8192000000 10615533504 10976509952 1674225472 16.969 100 86 172 1 1712020448 12637440 25157536
23:03:47 9191 8192000000 10624887472 10990915584 1689179264 17.094 100 79 158 1 1723500240 11847904 22473072
23:04:04 8736 8192000000 10656516048 11027378176 1711182832 17.279 100 84 168 0 1748536064 12846176 24507056
23:04:19 7099 8192000000 10667863840 11038183424 1721750016 17.367 100 85 168 3 1759718272 13589808 24378448
23:04:34 7932 8192000000 10673926688 11048763392 1732336208 17.455 100 74 145 0 1765563696 12776976 20450512
23:04:49 6213 8192000000 10686232528 11062505472 1749538560 17.598 100 76 153 3 1783348272 12289408 21520304
23:05:02 5148 8192000000 10688560208 11067404288 1756684640 17.657 100 77 154 1 1791569680 12797648 22087392
23:05:14 5852 8192000000 10708924320 11085074432 1765981280 17.734 100 77 154 0 1800544944 12805088 21758576
23:05:28 5381 8192000000 10708769312 11089690624 1776538256 17.821 100 85 169 0 1813278880 13377680 23362944
23:05:40 4425 8192000000 10726909344 11107004416 1784606336 17.887 100 85 170 0 1822468048 13584096 24277616
23:05:51 4140 8192000000 10733604704 11109330944 1794581280 17.969 100 88 177 0 1833312416 13889280 24841856
23:06:02 3327 8192000000 10734279120 11113189376 1797600384 17.994 100 87 174 0 1836267040 14647312 24019344
23:06:12 3553 8192000000 10738816400 11121541120 1803618400 18.044 100 86 172 1 1842545248 14283600 24643248
23:06:22 2547 8192000000 10757339728 11136647168 1808912688 18.087 100 95 190 2 1850702736 15217056 26572992
23:06:31 2591 8192000000 10761854768 11140136960 1816978752 18.153 100 87 171 2 1855336496 14718608 23639136
23:06:41 5658 8192000000 10754863024 11136929792 1816468656 18.149 100 82 164 2 1852980944 14311792 22200496
23:06:54 1858 8192000000 10758517712 11144081408 1818702912 18.167 100 81 163 0 1855027664 13872496 22452256
23:07:02 2295 8192000000 10773430896 11157516288 1833343744 18.287 100 90 180 1 1872403840 13252928 25807168
23:07:11 1959 8192000000 10782677920 11167346688 1844511104 18.378 100 93 187 1 1884346304 13356480 26478720
23:07:20 2918 8192000000 10791412240 11176484864 1846230768 18.391 100 92 183 1 1885392864 13898912 25263184
23:07:29 1557 8192000000 10798972720 11182084096 1851513184 18.434 100 91 182 0 1890853168 13953920 25386064
23:07:37 2611 8192000000 10796278816 11181785088 1855937200 18.470 100 91 182 2 1895818240 14245728 25635312
23:07:45 2503 8192000000 10802685808 11187429376 1857937328 18.487 100 89 179 3 1896275264 12689904 25648032
23:07:54 1637 8192000000 10808130288 11194540032 1863811552 18.534 100 96 193 1 1905059936 12740368 28508016
23:08:02 1414 8192000000 10801286720 11192688640 1863168416 18.529 100 84 169 1 1898196736 10932048 24096272
23:08:10 1381 8192000000 10814546496 11201257472 1867032000 18.560 100 85 168 1 1904457184 13045728 24379456
23:08:18 17789 8192000000 10797850016 11197837312 1865645072 18.549 100 65 128 1 1895274320 11414976 18214272
23:08:42 1829 8192000000 10795671904 11203305472 1867514096 18.564 100 74 149 0 1899678432 11125712 21038624
23:08:51 2423 8192000000 10795571104 11201482752 1862679168 18.525 100 45 89 2 1884934912 9865008 12390736
23:09:01 1994 8192000000 10805583568 11202994176 1874059344 18.617 100 68 134 1 1902586736 9040912 19486480
23:09:10 4161 8192000000 10793712752 11205455872 1874675264 18.622 100 49 98 0 1898494112 10580608 13238240
23:09:23 5444 8192000000 10785113184 11205259264 1872916304 18.608 100 35 70 3 1891933424 9403728 9613392
23:09:38 4327 8192000000 10791136528 11207995392 1875826800 18.631 100 50 100 2 1898032416 7465200 14740416
23:09:48 6480 8192000000 10774688144 11207557120 1873250048 18.611 100 22 44 1 1886680064 7164128 6265888
23:10:01 10602 8192000000 10784470000 11214413824 1880074064 18.666 100 23 46 1 1892211680 5326448 6811168
23:10:21 43147 8192000000 10815251680 11231543296 1885311728 18.708 100 36 72 2 1901474512 5846016 10316768
23:11:10 23951 8192000000 10844195616 11239964672 1897524864 18.806 100 81 165 3 1927888208 6922752 23440592
23:11:40 2209 8192000000 10827678064 11244081152 1898423088 18.814 100 73 149 2 1930153792 11158480 20572224
23:11:50 2733 8192000000 10815476848 11240337408 1894435872 18.782 100 38 76 0 1914134208 9133184 10565152
23:11:59 7315 8192000000 10825969600 11242758144 1895424048 18.789 100 37 75 1 1911971568 6700512 9847008
23:12:14 4761 8192000000 10816294464 11240878080 1896521312 18.798 100 33 65 0 1912491056 6636272 9333472
23:12:26 3583 8192000000 10817007552 11241357312 1896535184 18.798 100 26 52 0 1910409808 6336800 7537824
23:12:36 5986 8192000000 10815032256 11243565056 1899566960 18.823 100 36 72 0 1921445104 11597552 10280592
23:12:48 7710 8192000000 10819877488 11246825472 1899103488 18.819 100 27 53 0 1913133600 6629280 7400832
23:13:02 5090 8192000000 10804103792 11244474368 1903007104 18.850 100 22 44 2 1916419728 6944720 6467904
23:13:14 5968 8192000000 10807874512 11247706112 1903429888 18.854 100 25 49 1 1916909488 5204976 8274624
23:13:26 9885 8192000000 10827974304 11250372608 1907056688 18.883 100 30 60 3 1921636032 5762432 8816912
23:13:43 48141 8192000000 10810137936 11249856512 1907074880 18.883 100 30 60 0 1921136048 5340592 8720576
23:14:40 6162 8192000000 10809786960 11249844224 1904991904 18.866 100 18 36 0 1916174336 5595664 5586768
23:14:52 8343 8192000000 10813812160 11255459840 1907680560 18.888 100 18 36 0 1918970096 6249424 5040112
23:15:08 7206 8192000000 10832233648 11256352768 1910143856 18.908 100 20 40 0 1921345104 5492608 5708640
23:15:21 7736 8192000000 10822117344 11258806272 1911709200 18.920 100 30 61 2 1925994896 5941856 8343840
23:15:35 6635 8192000000 10815865456 11249242112 1888472672 18.733 99 24 48 2 1900602048 5674480 6454896
23:15:51 10133 8192000000 10822904144 11258851328 1909208816 18.900 100 19 36 1 1919652864 5624832 4819216
23:16:08 5746 8192000000 10799960144 11239460864 1872452576 18.604 98 25 48 0 1884883024 5470688 6959760
23:16:20 6497 8192000000 10814007840 11251609600 1905281728 18.869 100 12 24 0 1914016144 5537040 3197376
23:16:35 7518 8192000000 10810215984 11232980992 1860312368 18.506 98 18 37 1 1870711168 5576080 4822720
23:16:50 11428 8192000000 10789534976 11223515136 1844570432 18.378 98 18 36 1 1855334768 5929072 4835264
23:17:09 9234 8192000000 10792539168 11219169280 1849145104 18.415 98 30 60 0 1864437568 6237328 9055136
23:17:24 13544 8192000000 10769713376 11194384384 1815415536 18.140 97 24 48 0 1828998816 6813424 6769856
23:17:47 14071 8192000000 10776654704 11202371584 1811525456 18.108 96 20 41 1 1822834592 5156784 6152352
23:18:09 53409 8192000000 10724473104 11150155776 1748256992 17.587 94 46 91 0 1766722560 5423904 13041664
23:19:13 12290 8192000000 10719635136 11133726720 1676630880 16.989 91 15 30 1 1685355648 4705856 4018912
23:19:31 5706 8192000000 10705079136 11123920896 1764118688 17.718 97 24 47 0 1776756240 5910416 6727136
23:19:43 7357 8192000000 10704704976 11122647040 1736279104 17.488 96 31 60 1 1750799360 6626048 7894208
23:19:57 3958 8192000000 10719528688 11135549440 1788767968 17.922 99 42 84 2 1809243024 7489552 12985504
23:20:12 6412 8192000000 10722885136 11146854400 1796404912 17.984 99 27 52 1 1810792352 6396016 7991424
23:20:24 7861 8192000000 10717938848 11140698112 1775764960 17.815 98 25 50 2 1790119664 6780608 7574096
23:20:41 8947 8192000000 10709410064 11124862976 1754657216 17.640 97 20 40 2 1766235216 5937216 5640784
23:20:56 9370 8192000000 10705764336 11127926784 1769884416 17.766 98 15 29 1 1779651232 5449968 4316848
23:21:12 8010 8192000000 10732062768 11149697024 1801509504 18.026 99 30 61 0 1816649872 6547664 8592704
23:21:26 12896 8192000000 10710106144 11129344000 1750840624 17.609 97 17 34 1 1760976464 5374992 4760848
23:21:47 9931 8192000000 10731404176 11151052800 1815757872 18.143 100 29 55 2 1830512080 6173072 8581136
23:22:07 8602 8192000000 10718667136 11143413760 1808977840 18.088 100 32 64 2 1825521232 7251200 9292192
23:22:23 8938 8192000000 10740247392 11164512256 1825717504 18.224 100 24 45 5 1838336816 4883312 7736000
23:22:39 11340 8192000000 10739275952 11161718784 1811520560 18.108 99 19 38 1 1822591104 5277744 5792800
23:22:57 63942 8192000000 10741566560 11176423424 1821078640 18.187 99 20 40 1 1831891264 4672288 6140336
23:24:07 12056 8192000000 10766537536 11183337472 1829836448 18.258 99 27 54 1 1843962064 5773008 8352608
23:24:29 7472 8192000000 10758996032 11186962432 1844611888 18.378 100 9 18 0 1851793376 4841920 2339568
23:24:42 6456 8192000000 10776696960 11199897600 1852532528 18.443 100 23 46 0 1865042976 6129088 6381360
23:24:56 5565 8192000000 10773080208 11202109440 1859220048 18.497 100 33 65 1 1876507296 8144624 9142624
23:25:07 9756 8192000000 10789162816 11208634368 1860183792 18.505 100 22 44 2 1872212496 5754576 6274128
23:25:25 6425 8192000000 10782962192 11207774208 1864935616 18.543 100 21 42 4 1877106960 5824912 6346432
23:25:41 9618 8192000000 10788279184 11214942208 1870510896 18.588 100 27 54 1 1884076672 5347392 8218384
23:26:00 10692 8192000000 10779973936 11217977344 1877586912 18.646 100 25 50 0 1891148784 5998224 7563648
23:26:17 6309 8192000000 10793550256 11227308032 1878280000 18.651 100 25 50 1 1891453104 5926816 7246288
23:26:30 9287 8192000000 10799723472 11227201536 1886779840 18.720 100 35 68 3 1902914160 5134432 10999888
23:26:47 7769 8192000000 10796901888 11231715328 1889759904 18.744 100 30 59 1 1904523488 6041856 8721728
23:27:01 8687 8192000000 10815424864 11243581440 1896508160 18.798 100 25 50 0 1908982496 5009376 7464960
23:27:16 7046 8192000000 10829572656 11250843648 1904519616 18.863 100 26 53 0 1917317168 4628848 8168704
23:27:36 5649 8192000000 10846863792 11261992960 1916635280 18.960 100 48 96 1 1936211120 5566256 14009584
23:27:56 38120 8192000000 10853364192 11276705792 1923755984 19.017 100 45 90 0 1943782464 7488864 12537616
23:28:42 18576 8192000000 10863105376 11287707648 1937819312 19.129 100 38 75 1 1956739440 8502080 10418048
23:29:11 84643 8192000000 10881719568 11309846528 1948525568 19.215 100 53 105 0 1973277248 9001632 15750048
23:30:45 85510 8192000000 10882296240 11323985920 1956863136 19.281 100 31 62 1 1975414720 9608832 8942752
23:32:17 15349 8192000000 10891231456 11321933824 1961703168 19.320 100 53 107 1 1987042128 9621488 15717472
23:32:51 20980 8192000000 10882219264 11324719104 1944709520 19.184 99 41 82 0 1967485312 10550480 12225312
23:33:22 14370 8192000000 10899396448 11337699328 1968052112 19.370 100 48 96 2 1996777488 14066288 14659088
23:33:45 2938 8192000000 10915142880 11339866112 1973698800 19.415 100 47 94 1 1997029584 10285584 13045200
23:33:56 2539 8192000000 10913290032 11338559488 1974360256 19.420 100 57 113 2 2003118448 11542464 17215728
23:34:05 2918 8192000000 10938145712 11351908352 1982913920 19.488 100 76 152 1 2017652000 13536960 21201120
23:34:15 3457 8192000000 10932268000 11353063424 1984703728 19.502 100 63 124 2 2015236928 12798016 17735184
23:34:27 10686 8192000000 10927197840 11361259520 1991043056 19.552 100 67 131 1 2022753520 13413408 18297056
23:34:48 11254 8192000000 10926345264 11362562048 1989876272 19.543 100 51 100 1 2016559888 12675344 14008272
23:35:06 5535 8192000000 10925380192 11355242496 1972348880 19.404 99 59 117 2 2002263872 13140880 16774112
23:35:19 28548 8192000000 10918275664 11356712960 1988127968 19.529 100 49 98 1 2013971360 12488144 13355248
23:35:59 6745 8192000000 10911939424 11333709824 1957151616 19.283 98 57 116 0 1989189312 15640672 16397024
23:36:16 14144 8192000000 10932256768 11361144832 1988095744 19.529 100 57 114 1 2020246992 16190368 15960880
23:36:39 4127 8192000000 10941871072 11369697280 1995333968 19.586 100 66 131 1 2031900896 17975840 18591088
23:36:50 4977 8192000000 10941548400 11366821888 1990818736 19.550 100 64 128 0 2028557200 19558032 18180432
23:37:03 10676 8192000000 10937313936 11371114496 1993090544 19.568 100 55 110 2 2028844464 20085344 15668576
23:37:21 10644 8192000000 10937396704 11378024448 2000637952 19.628 100 54 109 3 2038325168 22051488 15635728
23:37:38 1360 8192000000 10947331424 11383173120 2007732960 19.684 100 60 118 1 2045845584 20870640 17241984
23:37:51 6938 8192000000 10944455120 11381968896 1985749120 19.510 99 51 100 1 2022603200 22081424 14772656
23:38:08 2997 8192000000 10943514352 11380580352 1999305728 19.617 100 58 116 1 2038925040 22233888 17385424
23:38:21 5170 8192000000 10939695104 11372314624 1990024528 19.544 100 56 111 2 2031016320 24378384 16613408
23:38:34 6252 8192000000 10942762176 11369660416 1985925760 19.512 100 64 128 0 2028198864 23220672 19052432
23:38:48 3744 8192000000 10935705792 11362017280 1980374400 19.468 100 59 116 1 2019839376 22732800 16732176
23:38:59 2785 8192000000 10944317728 11368583168 1988234368 19.530 100 66 132 1 2029099984 21383488 19482128
23:39:10 13797 8192000000 10919539328 11347783680 1946814128 19.201 98 71 140 0 1991626592 22992608 21819856
23:39:35 4048 8192000000 10889112848 11307663360 1904525392 18.863 97 68 136 1 1949698592 25011696 20161504
23:39:46 3863 8192000000 10907708032 11319353344 1932360016 19.086 99 78 151 2 1981259184 26528576 22370592
23:39:57 9718 8192000000 10910835568 11331166208 1951895744 19.242 100 72 144 0 2000015664 27320992 20798928
23:40:15 3688 8192000000 10904042288 11330752512 1921115424 18.996 98 68 136 0 1966889328 26132608 19641296
23:40:28 6981 8192000000 10916686416 11338010624 1957062240 19.283 100 65 130 1 2003942128 27858992 19020896
23:40:42 7860 8192000000 10923256720 11347181568 1965181216 19.347 100 69 138 1 2014554144 29008752 20364176
23:41:00 3167 8192000000 10919016304 11334733824 1954204064 19.260 100 72 144 2 2003856768 28449152 21203552
23:41:11 6304 8192000000 10909530496 11326689280 1929568976 19.063 99 71 142 2 1979722624 29172208 20981440
23:41:24 4989 8192000000 10914510848 11330654208 1949465008 19.222 100 77 154 1 2001120144 29447392 22207744
23:41:41 4546 8192000000 10900871920 11320164352 1930971552 19.075 99 80 161 0 1984464720 28993392 24499776
23:41:52 2619 8192000000 10918106288 11333984256 1939423184 19.142 99 83 165 3 1996220528 31845296 24952048
23:42:02 1632 8192000000 10925770064 11339784192 1955176368 19.268 100 81 159 4 2011931008 33289408 23465232
23:42:12 3409 8192000000 10928618688 11346137088 1959872784 19.305 100 72 142 0 2015017792 33958384 21186624
23:42:25 4427 8192000000 10948057776 11360821248 1971187120 19.395 100 76 152 1 2029404256 34964912 23252224
23:42:42 3487 8192000000 10948676064 11370717184 1981997360 19.481 100 71 142 0 2039407744 35913424 21496960
23:42:53 1729 8192000000 10949803280 11365281792 1966274656 19.356 99 80 155 2 2025975008 35116448 24583904
23:43:03 2871 8192000000 10942403872 11363713024 1959396032 19.301 99 72 145 1 2017588624 36142000 22050592
23:43:14 8360 8192000000 10928785360 11350695936 1944619104 19.184 99 68 134 3 2001509904 36545056 20345744
23:43:32 5825 8192000000 10912507056 11331100672 1938952192 19.138 99 55 108 0 1995120752 39360928 16807632
23:43:46 3309 8192000000 10942374128 11360505856 1964100768 19.339 100 60 120 2 2023654064 40337872 19215424
23:44:00 3431 8192000000 10949587200 11367706624 1972767648 19.407 100 82 166 0 2038964416 40179856 26016912
23:44:16 3772 8192000000 10933234944 11339780096 1945767264 19.193 99 76 151 3 2010564064 40703920 24092880
23:44:27 3841 8192000000 10918746048 11324538880 1915966256 18.955 99 81 158 2 1983218720 42898448 24354016
23:44:39 4894 8192000000 10930102320 11341701120 1947374608 19.206 100 76 152 1 2016207664 45121408 23711648
23:44:53 7954 8192000000 10946309840 11367407616 1964771632 19.344 100 71 139 0 2033726576 46991792 21963152
23:45:10 8144 8192000000 10935602656 11353079808 1948910960 19.218 99 55 108 1 2013271456 46765248 17595248
23:45:25 3498 8192000000 10949355136 11366277120 1972018592 19.401 100 69 137 1 2034187744 39910624 22258528
23:45:40 8017 8192000000 10940286528 11360550912 1933686832 19.096 98 70 138 2 1998205744 41636928 22881984
23:45:57 1539 8192000000 10961179680 11366215680 1972406128 19.405 100 79 155 1 2035915008 40070704 23438176
23:46:06 1896 8192000000 10975467616 11378630656 1982108416 19.481 100 93 186 0 2053307328 42199344 28999568
23:46:17 1665 8192000000 10958506480 11368300544 1977364944 19.444 100 84 168 3 2045447584 41616112 26466528
23:46:27 14355 8192000000 10937739008 11356454912 1954817888 19.265 99 60 120 0 2016361760 42235152 19308720
23:46:49 6066 8192000000 10954827952 11369431040 1969695024 19.383 100 79 158 0 2037733872 42931216 25107632
23:47:01 9777 8192000000 10942563632 11374051328 1971340224 19.396 100 57 114 1 2033230944 43509488 18381232
23:47:32 11660 8192000000 10933108208 11367243776 1970669648 19.391 100 44 88 2 2026015472 40638240 14707584
23:48:04 4590 8192000000 10943942496 11376619520 1974782784 19.423 100 43 86 4 2033104864 44316640 14005440
23:48:18 7234 8192000000 10951360896 11376861184 1983666448 19.494 100 56 112 3 2042667408 41409152 17591808
23:48:33 3896 8192000000 10959634784 11385905152 1986807024 19.519 100 53 106 1 2046695728 42837088 17051616
23:48:49 11027 8192000000 10955467152 11391852544 1984923904 19.504 100 43 86 0 2043817696 44110256 14783536
23:49:08 18449 8192000000 10945420000 11383123968 1949365936 19.221 98 42 84 0 2010515216 46284336 14864944
23:49:33 6150 8192000000 10950773872 11382980608 1977673392 19.446 100 46 91 0 2036625168 43926688 15025088
23:49:47 18229 8192000000 10958736848 11391119360 1978036864 19.449 100 42 84 0 2038761616 46457408 14267344
23:50:14 10523 8192000000 10964785200 11399757824 1980386416 19.468 100 37 74 2 2046177760 52821792 12969552
23:50:43 15906 8192000000 10957217456 11405594624 1982045632 19.481 100 31 62 1 2047036000 53498000 11492368
23:51:08 18883 8192000000 10950248080 11405832192 1974375136 19.420 100 32 63 1 2037975152 52533664 11066352
23:51:43 21143 8192000000 10914693600 11349151744 1917085264 18.963 98 29 58 3 1977086736 50342416 9659056
23:52:24 14216 8192000000 10922041408 11360571392 1936824800 19.121 100 46 89 2 2006630352 54447232 15358320
23:52:57 26486 8192000000 10915097904 11371352064 1934561664 19.103 100 28 56 2 2002228192 57102528 10564000
23:53:38 28081 8192000000 10871099184 11321458688 1854595136 18.459 96 23 46 1 1915651472 52307088 8749248
23:54:14 52534 8192000000 10858444960 11328278528 1906847360 18.881 100 14 28 1 1944410032 32576736 4985936
23:55:16 46322 8192000000 10839423200 11300724736 1876732576 18.639 98 8 16 2 1895391216 16229968 2428672
23:56:56 51089 8192000000 10904877856 11340742656 1947926976 19.210 100 24 49 2 1962169984 7582704 6660304
23:58:00 34574 8192000000 10891270880 11314266112 1903424432 18.854 97 47 94 1 1925071504 8376864 13270208
23:58:45 101954 8192000000 10893856832 11341135872 1954988512 19.266 100 28 56 0 1974900576 11785008 8127056
00:00:44 54342 8192000000 10901794208 11353894912 1964095936 19.339 100 36 73 2 1989997504 16099584 9801984
00:01:45 64752 8192000000 10891546672 11357749248 1947723888 19.208 99 13 26 2 1969863344 18738432 3401024
00:02:59 11648 8192000000 10900225584 11368058880 1967216736 19.363 100 15 30 1 1990992768 19611200 4164832
00:03:17 12229 8192000000 10905085376 11376898048 1976170320 19.434 100 9 18 1 1998809712 19875648 2763744
00:03:36 21682 8192000000 10919430608 11370524672 1981713632 19.478 100 22 44 1 2012243040 24541552 5987856
00:04:05 49062 8192000000 10921208992 11369037824 1966172384 19.355 99 34 68 4 1989933792 13321920 10439488
00:05:00 37548 8192000000 10917193168 11382878208 1986422464 19.516 100 35 70 1 2017612448 20337936 10852048
00:05:47 36116 8192000000 10906026768 11375099904 1980620800 19.470 100 18 36 0 1998491088 11545104 6325184
00:06:44 123486 8192000000 10906646256 11371659264 1918433504 18.974 96 14 28 0 1935478256 12589264 4455488
00:08:53 43328 8192000000 10893947952 11373723648 1953227008 19.252 99 19 38 0 1980615312 20506016 6882288
00:09:54 72640 8192000000 10911647936 11372134400 1955250544 19.268 99 19 38 0 1977713424 16299520 6163360
00:11:47 42457 8192000000 10890447824 11361976320 1973308992 19.412 100 29 57 1 1993568736 12048496 8211248
00:12:37 64073 8192000000 10898859488 11380002816 1958470928 19.294 99 15 30 3 1977052720 14054368 4527424
00:14:13 25196 8192000000 10893702992 11361300480 1959805600 19.304 99 34 68 0 1979534624 9284592 10444432
00:14:49 27918 8192000000 10898602640 11365707776 1958841136 19.297 99 30 60 2 1975331760 8399936 8090688
00:15:35 48080 8192000000 10903070128 11365138432 1941221008 19.156 98 26 52 0 1960071328 11778640 7071680
00:16:30 45602 8192000000 10919015376 11388080128 1976865712 19.440 100 15 30 1 1998577632 17647248 4064672
00:17:48 52537 8192000000 10898629920 11377541120 1972551472 19.406 100 9 18 0 1988893200 13695888 2645840
00:18:55 105460 8192000000 10906882432 11380264960 1923821872 19.017 97 24 48 1 1950366192 19685744 6858576
00:21:22 39037 8192000000 10889011584 11354521600 1929319552 19.061 98 29 58 0 1949137600 11462928 8355120
00:22:08 136501 8192000000 10903274336 11353759744 1858807920 18.494 95 12 24 2 1876878368 15094560 2975888
00:24:31 85954 8192000000 10878426016 11347558400 1916026032 18.955 98 14 28 0 1935620880 14890768 4704080
00:26:03 100048 8192000000 10869575184 11341287424 1915220800 18.949 98 16 32 2 1930149248 9923024 5005424
00:28:12 69909 8192000000 10877671088 11342135296 1931801712 19.081 99 31 63 0 1955795792 15702000 8292080
00:29:38 23159 8192000000 10873435200 11325542400 1894160400 18.779 97 33 66 1 1916504608 13077312 9266896
00:30:22 75292 8192000000 10844869728 11322564608 1915606816 18.952 99 17 34 0 1940298480 19932832 4758832
00:31:54 72377 8192000000 10857389104 11311562752 1855322848 18.465 96 18 34 1 1875444896 15153920 4968128
00:33:23 46301 8192000000 10810017808 11273744384 1840289040 18.343 96 19 37 1 1854202832 8376800 5536992
00:34:20 69042 8192000000 10841167248 11317059584 1859512672 18.499 97 15 30 1 1877161136 13355808 4292656
00:35:37 25174 8192000000 10841703472 11306655744 1912127632 18.924 100 29 58 4 1935626464 15876224 7622608
00:37:39 37439 8192000000 10849065584 11307085824 1900741072 18.832 99 36 71 1 1920623760 8968256 10914432
00:38:28 48396 8192000000 10834906576 11303677952 1878167824 18.650 98 20 40 0 1892987712 9178688 5641200
00:39:22 33051 8192000000 10851104432 11312975872 1905248608 18.868 99 21 42 3 1920477312 9674736 5553968
00:40:37 51626 8192000000 10835545584 11280134144 1808400064 18.083 94 34 68 1 1832231584 14275264 9556256
00:41:39 25057 8192000000 10830654416 11276197888 1844432416 18.377 97 41 82 4 1871346704 15449088 11465200
00:42:33 118303 8192000000 10851740704 11304620032 1890739520 18.752 99 15 30 0 1918556176 22788608 5028048
00:44:39 88547 8192000000 10836619424 11313721344 1848471296 18.410 96 16 32 0 1865643248 12856224 4315728
00:46:14 44417 8192000000 10859115872 11312513024 1880098304 18.666 97 31 60 1 1897144624 7850816 9195504
00:47:08 52230 8192000000 10887795968 11326107648 1916565712 18.959 99 25 50 0 1931990032 8415664 7008656
00:48:07 30361 8192000000 10866422464 11314368512 1906921616 18.882 98 62 125 0 1934802624 10726720 17154288
00:48:44 95084 8192000000 10866316688 11328659456 1933928912 19.098 100 24 48 0 1948471296 7735216 6807168
00:50:28 47942 8192000000 10855623824 11309862912 1902913168 18.850 98 18 37 4 1913400032 4800080 5686784
00:51:22 33966 8192000000 10888658800 11342999552 1925220080 19.029 99 38 74 1 1947297408 11699040 10378288
00:52:02 59813 8192000000 10871622672 11348598784 1943641248 19.176 100 21 42 0 1970045680 20013760 6390672
00:54:18 52460 8192000000 10880880176 11363557376 1947472128 19.206 100 15 30 1 1968550352 16257008 4821216
00:55:21 70569 8192000000 10891893968 11358031872 1958596384 19.295 100 20 38 2 1978469856 14166016 5707456
00:57:45 82005 8192000000 10891325456 11370651648 1947569472 19.207 99 12 24 0 1966582688 15283760 3729456
00:59:20 47681 8192000000 10886926640 11357736960 1936461888 19.119 98 11 22 0 1949054256 9868944 2723424
01:00:14 38922 8192000000 10909590416 11374276608 1963455504 19.333 99 17 34 0 1977725808 9693920 4576384
01:00:59 77171 8192000000 10901404016 11373735936 1941916640 19.162 98 14 28 0 1955425216 10110528 3398048
01:02:24 46350 8192000000 10892822528 11362201600 1936798944 19.121 98 26 52 0 1952561328 9011248 6751136
01:03:17 39622 8192000000 10898500128 11358236672 1940059440 19.147 98 38 76 1 1961678160 11115264 10503456
01:04:08 42862 8192000000 10912169392 11363913728 1916604928 18.960 97 40 80 1 1940394576 12193328 11596320
01:04:59 89184 8192000000 10926049424 11375583232 1959123744 19.299 99 43 86 1 1982283536 11313024 11846768
01:06:39 23611 8192000000 10945554784 11387801600 1984210816 19.498 100 34 68 0 2004752768 11321840 9220112
01:07:09 41320 8192000000 10903432336 11384475648 1942946592 19.170 98 24 47 0 1965520720 16197936 6376192
01:07:57 48684 8192000000 10930136528 11389386752 1949981776 19.226 98 25 50 1 1967028080 10265504 6780800
01:09:04 61573 8192000000 10918291072 11401105408 1984459248 19.500 100 21 42 0 2005656656 15021184 6176224
01:10:13 67112 8192000000 10895305024 11351908352 1808490368 18.084 91 20 40 1 1823590912 9607472 5493072
01:11:27 24316 8192000000 10898455264 11357585408 1925166928 19.028 98 30 60 0 1942621280 9000752 8453600
01:12:02 128260 8192000000 10888970208 11349299200 1905762304 18.873 97 12 24 2 1920237888 11067504 3408080
01:14:17 97890 8192000000 10886310448 11340918784 1854212128 18.456 94 34 67 4 1872565200 9117776 9235296
01:16:01 2317 8192000000 10909297312 11365158912 1968242432 19.372 100 53 106 1 1998464512 15822416 14399664
01:16:10 27935 8192000000 10872394112 11344625664 1919534816 18.983 98 26 52 0 1941339776 14553056 7251904
01:17:00 59320 8192000000 10866389568 11357626368 1935415808 19.110 99 9 18 0 1948595568 10669680 2510080
01:18:52 59463 8192000000 10860216080 11335393280 1932372592 19.086 99 17 35 0 1945428448 8598992 4456864
01:19:59 60631 8192000000 10863074848 11347582976 1907098848 18.883 97 24 48 1 1928442496 14057200 7286448
01:22:45 49207 8192000000 10849307568 11322613760 1861057072 18.512 95 20 40 1 1874682064 8145696 5479296
01:23:46 42308 8192000000 10872123392 11328729088 1881520480 18.677 97 29 58 2 1900870096 10941744 8407872
01:24:40 40316 8192000000 10880334320 11343921152 1942468592 19.166 100 26 52 1 1964172064 13466656 8236816
01:25:26 84679 8192000000 10864489904 11344646144 1886392016 18.717 97 16 32 1 1908149008 16844688 4912304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-03-2021 01:29:13 to 14-03-2021 01:29:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-03-2021 01:29:45 to 14-03-2021 01:29:47.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          243105
MON$OLDEST_ACTIVE               247137
MON$OLDEST_SNAPSHOT             247137
MON$NEXT_TRANSACTION            247137
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2020544
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:41: 
:42: mscs-test-161.budzdorov.ru    Sun Mar 14 01:27:35 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

14.03.21 01:29:48. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-14 01:29:50 No severe PSQL-related problems occured
14.03.21 01:29:52. End of report.