Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.01.2021 19: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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17470472 kB
MemAvailable 31396348 kB
Buffers 0 kB
Cached 14213392 kB
SwapCached 4864 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-01-04 19:27:09
DTS_END                         2021-01-04 19:27:09.3040
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41506
TRN_ID                          243956
ATT_ID                          688
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: 9327.23 20986 1119267
customer order: creation 176.14 359 21137
customer order: refuse 15.08 357 1809
order to supplier: creation 46.98 1215 5637
order to supplier: removal 3.19 102406 383
invoice (draft): creation 46.43 3199 5571
invoice (draft): removal 51.18 702 6141
invoice accept: apply 42.43 18052 5092
invoice accept: cancel 46.72 731 5606
customer reserve: creation 3946.12 179 473534
customer reserve: removal 4651.17 55 558140
realization accept: apply 86.24 209 10349
realization accept: cancel 83.56 120 10027
payment from customer: creation 61.03 127 7324
payment from customer: removal 5.65 111 678
payment to supplier: creation 49.00 142 5880
payment to supplier: removal 3.48 90 418
service: total inventory turnovers 5.01 907 601
service: total monetary turnovers 6.80 69 816
service: aggregate perf. data 1.00 15954 120
service: refresh index statistics 0.03 274736 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-01-2021 19:28:42 to 04-01-2021 19:28:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4713
TEST_TIME 2 4319
TEST_TIME 3 4527
TEST_TIME 4 4931
TEST_TIME 5 5362
TEST_TIME 6 5028
TEST_TIME 7 4893
TEST_TIME 8 4833
TEST_TIME 9 5227
TEST_TIME 10 5183
TEST_TIME 11 5248
TEST_TIME 12 5624
TEST_TIME 13 5823
TEST_TIME 14 6309
TEST_TIME 15 6865
TEST_TIME 16 7325
TEST_TIME 17 8213
TEST_TIME 18 8235
TEST_TIME 19 8834
TEST_TIME 20 8875
TEST_TIME 21 9567
TEST_TIME 22 9469
TEST_TIME 23 10087
TEST_TIME 24 10709
TEST_TIME 25 10550
TEST_TIME 26 10620
TEST_TIME 27 10609
TEST_TIME 28 10583
TEST_TIME 29 10274
TEST_TIME 30 9975
TEST_TIME 31 9907
TEST_TIME 32 9798
TEST_TIME 33 10004
TEST_TIME 34 9888
TEST_TIME 35 9764
TEST_TIME 36 9815
TEST_TIME 37 9656
TEST_TIME 38 9497
TEST_TIME 39 9528
TEST_TIME 40 9392
TEST_TIME 41 9250
TEST_TIME 42 9347
TEST_TIME 43 9288
TEST_TIME 44 9311
TEST_TIME 45 9445
TEST_TIME 46 9389
TEST_TIME 47 9431
TEST_TIME 48 9493
TEST_TIME 49 9593
TEST_TIME 50 9578
TEST_TIME 51 9617
TEST_TIME 52 9599
TEST_TIME 53 9634
TEST_TIME 54 9762
TEST_TIME 55 9674
TEST_TIME 56 9560
TEST_TIME 57 9483
TEST_TIME 58 9520
TEST_TIME 59 9421
TEST_TIME 60 9299
TEST_TIME 61 9300
TEST_TIME 62 9385
TEST_TIME 63 9530
TEST_TIME 64 9514
TEST_TIME 65 9481
TEST_TIME 66 9567
TEST_TIME 67 9539
TEST_TIME 68 9586
TEST_TIME 69 9612
TEST_TIME 70 9682
TEST_TIME 71 9738
TEST_TIME 72 9745
TEST_TIME 73 9721
TEST_TIME 74 9807
TEST_TIME 75 9783
TEST_TIME 76 9683
TEST_TIME 77 9609
TEST_TIME 78 9557
TEST_TIME 79 9591
TEST_TIME 80 9537
TEST_TIME 81 9526
TEST_TIME 82 9520
TEST_TIME 83 9451
TEST_TIME 84 9449
TEST_TIME 85 9396
TEST_TIME 86 9370
TEST_TIME 87 9380
TEST_TIME 88 9359
TEST_TIME 89 9324
TEST_TIME 90 9308
TEST_TIME 91 9300
TEST_TIME 92 9424
TEST_TIME 93 9495
TEST_TIME 94 9483
TEST_TIME 95 9500
TEST_TIME 96 9543
TEST_TIME 97 9536
TEST_TIME 98 9582
TEST_TIME 99 9560
TEST_TIME 100 9544
TEST_TIME 101 9465
TEST_TIME 102 9432
TEST_TIME 103 9420
TEST_TIME 104 9376
TEST_TIME 105 9315
TEST_TIME 106 9295
TEST_TIME 107 9289
TEST_TIME 108 9348
TEST_TIME 109 9364
TEST_TIME 110 9363
TEST_TIME 111 9359
TEST_TIME 112 9352
TEST_TIME 113 9347
TEST_TIME 114 9332
TEST_TIME 115 9342
TEST_TIME 116 9454
TEST_TIME 117 9440
TEST_TIME 118 9460
TEST_TIME 119 9408
TEST_TIME 120 9330

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-01-2021 19:28:45 to 04-01-2021 19:28:49.

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 1557097 1557097 0 0.00 0 17698 7 0 0
doc_list_biud 1557077 1557077 0 0.00 0 46427 25 0 0
sp_add_invoice_to_stock 5195 5092 103 1.98 25 223803 18053 0 103
sp_cancel_adding_invoice 5606 5606 0 0.00 5 57440 731 0 0
sp_cancel_client_order 1809 1809 0 0.00 4 12123 357 0 0
sp_cancel_customer_reserve 558140 558140 0 0.00 1 38397 56 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 3 9126 111 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 4279 90 0 0
sp_cancel_supplier_invoice 6149 6141 8 0.13 2 14559 703 0 8
sp_cancel_supplier_order 383 383 0 0.00 15 1044951 102407 0 0
sp_cancel_write_off 10027 10027 0 0.00 1 18402 120 0 0
sp_client_order 21137 21137 0 0.00 3 29673 360 0 0
sp_customer_reserve 473534 473534 0 0.00 0 67358 179 0 0
sp_fill_shopping_cart 32345 32345 0 0.00 1 14424 35 0 0
sp_fill_shopping_cart_clo_res 473533 473533 0 0.00 0 16310 15 0 0
sp_get_clo_for_invoice 5088 5088 0 0.00 0 21550 283 0 0
sp_kill_cost_storno 16729 16729 0 0.00 0 6593 56 0 0
sp_kill_qstorno_ret_qs2qd 1132831 1132831 0 0.00 0 35274 30 0 0
sp_kill_qty_storno 597525 597525 0 0.00 0 46426 65 0 0
sp_lock_selected_doc 21174 21174 0 0.00 0 7880 9 0 0
sp_make_cost_storno 28641 28641 0 0.00 0 16935 59 0 0
sp_multiply_rows_for_pdistr 28634 28634 0 0.00 0 14219 30 0 0
sp_multiply_rows_for_qdistr 21137 21137 0 0.00 0 9729 166 0 0
sp_pay_from_customer 7324 7324 0 0.00 4 17264 127 0 0
sp_pay_to_supplier 5880 5880 0 0.00 4 12834 143 0 0
sp_payment_common 13203 13203 0 0.00 1 17243 36 0 0
sp_qd_handle_on_cancel_clo 1809 1809 0 0.00 0 12115 318 0 0
sp_qd_handle_on_invoice_upd_sts 10688 10688 0 0.00 0 46424 309 0 0
sp_qd_handle_on_reserve_upd_sts 10337 10337 0 0.00 0 20089 66 0 0
sp_reserve_write_off 10349 10349 0 0.00 6 20230 209 0 0
sp_supplier_invoice 5571 5571 0 0.00 7 106470 3200 0 0
sp_supplier_order 5637 5637 0 0.00 6 35777 1216 0 0
srv_aggregate_perf_data 120 120 0 0.00 2933 247553 15954 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 1159 135132 35365 0 0
srv_find_qd_qs_mism 1070152 1070152 0 0.00 0 17697 6 0 0
srv_make_invnt_saldo 601 601 0 0.00 36 37111 908 0 0
srv_make_money_saldo 816 816 0 0.00 1 36226 70 0 0
srv_recalc_idx_stat 4 4 0 0.00 201473 335126 274736 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5092 5092 0 0.00 0 13991 162 0 0
t$perf-norm:sp_cancel_adding_invoice 380 380 0 0.00 1 1974 61 0 0
t$perf-norm:sp_cancel_client_order 1809 1809 0 0.00 0 6886 13 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 6193 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 678 678 0 0.00 0 18720 30 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 401 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 2761 30 0 0
t$perf-norm:sp_cancel_supplier_order 383 383 0 0.00 0 46868 1689 0 0
t$perf-norm:sp_cancel_write_off 1027 1027 0 0.00 0 7232 14 0 0
t$perf-norm:sp_client_order 21137 21137 0 0.00 0 22598 18 0 0
t$perf-norm:sp_customer_reserve 1033 1033 0 0.00 0 1554 5 0 0
t$perf-norm:sp_pay_from_customer 7324 7324 0 0.00 0 7016 9 0 0
t$perf-norm:sp_pay_to_supplier 5880 5880 0 0.00 0 7723 11 0 0
t$perf-norm:sp_reserve_write_off 10349 10349 0 0.00 0 5488 8 0 0
t$perf-norm:sp_supplier_invoice 5571 5571 0 0.00 0 5214 15 0 0
t$perf-norm:sp_supplier_order 5637 5637 0 0.00 0 5787 17 0 0
t$perf-norm:srv_aggregate_perf_data 120 120 0 0.00 0 145 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 1250 16 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 888 15 0 0
t$perf-norm:srv_make_money_saldo 816 816 0 0.00 0 1705 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10368 10162 206 1.98 0 15167 23 0 206
v_all_customers 38148 38148 0 0.00 0 17 1 0 0
v_all_suppliers 30772 30772 0 0.00 0 29 1 0 0
v_all_wares 42274 42274 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 760 760 0 0.00 0 724 6 0 0
v_cancel_client_order 3618 3618 0 0.00 0 9724 9 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 2749 9 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 2536 6 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 3217 8 0 0
v_cancel_supplier_invoice 760 744 16 2.10 0 5869 31 0 16
v_cancel_supplier_order 766 766 0 0.00 0 571 4 0 0
v_cancel_write_off 2054 2054 0 0.00 0 13913 24 0 0
v_max_id_clo_ord 5637 5637 0 0.00 0 2564 2 0 0
v_max_id_clo_res 1033 1033 0 0.00 0 4807 23 0 0
v_max_id_ord_sup 5571 5571 0 0.00 0 7036 7 0 0
v_max_non_paid_invoice 1702 1702 0 0.00 0 1460 4 0 0
v_max_non_paid_realizn 4012 4012 0 0.00 0 6351 5 0 0
v_min_id_clo_ord 5637 5637 0 0.00 0 4327 6 0 0
v_min_id_clo_res 1033 1033 0 0.00 0 2508 9 0 0
v_min_id_ord_sup 5571 5571 0 0.00 0 6980 9 0 0
v_min_non_paid_invoice 5880 5880 0 0.00 0 9030 22 0 0
v_min_non_paid_realizn 7323 7323 0 0.00 0 6910 23 0 0
v_our_firm 10748 10748 0 0.00 0 13 1 0 0
v_reserve_write_off 20674 20674 0 0.00 0 20088 9 0 0
x_lock_depdocs_on_canc_invoice 11375 11375 0 0.00 0 11156 97 0 0
x_lock_depdocs_on_canc_sup_ord 383 383 0 0.00 0 9786 351 0 0
x_make_qstorno_1000_1200 5637 5637 0 0.00 2 35759 1139 0 0
x_make_qstorno_1200_2000 5571 5571 0 0.00 3 106462 3071 0 0
x_make_qstorno_2100_3300 473534 473534 0 0.00 0 67357 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-01-2021 19:28:50 to 04-01-2021 19:28:54.

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
16:57:12 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:19 25353 8192000000 10263901936 10573561856 756791840 8.456 61 46 94 0 775059152 2094256 16173056
16:57:53 40575 8192000000 10340739232 10656149504 1388357232 14.491 100 86 171 1 1421757984 5308864 28091888
16:58:45 11489 8192000000 10365403280 10683695104 1419725312 14.770 100 88 176 0 1455625056 6600928 29298816
16:59:04 14739 8192000000 10376288352 10697412608 1429529344 14.857 100 93 186 2 1468269872 7255360 31485168
16:59:27 19226 8192000000 10397915184 10726670336 1457048176 15.100 100 84 168 1 1492662544 7652976 27961392
16:59:57 17953 8192000000 10433044256 10761125888 1475850720 15.265 100 88 176 1 1512985824 8363360 28771744
17:00:24 16058 8192000000 10432925200 10763386880 1486777728 15.361 100 88 176 0 1524387200 8936384 28673088
17:00:49 24385 8192000000 10459013104 10795556864 1507605568 15.542 100 87 174 0 1545449152 9599680 28243904
17:01:27 13132 8192000000 10473814096 10815348736 1531834592 15.753 100 87 174 1 1570002912 10425376 27742944
17:01:52 14689 8192000000 10492823136 10843205632 1549493648 15.906 100 75 150 0 1583534048 10556192 23484208
17:02:15 13759 8192000000 10528377456 10881269760 1583042192 16.194 100 81 162 1 1618656096 10627840 24986064
17:02:36 12599 8192000000 10539188944 10891931648 1599453792 16.335 100 84 168 0 1635976528 11186384 25336352
17:02:58 15595 8192000000 10557327840 10914959360 1618361744 16.496 100 79 157 1 1653626464 11529920 23734800
17:03:21 13904 8192000000 10578772304 10943823872 1635146304 16.639 100 79 160 0 1670427424 11422592 23858528
17:03:43 12400 8192000000 10610577920 10976735232 1671137856 16.943 100 78 157 2 1706261536 12070528 23053152
17:04:02 9979 8192000000 10627879520 10998947840 1687123200 17.077 100 82 165 0 1724235584 12977536 24134848
17:04:20 10691 8192000000 10641523776 11015045120 1700169776 17.187 100 72 144 0 1733671952 12557360 20944816
17:04:38 5596 8192000000 10657565216 11029692416 1716288000 17.321 100 74 148 0 1751108656 13829104 20991552
17:04:52 8853 8192000000 10673901104 11050856448 1733572112 17.465 100 85 170 0 1772803712 13940704 25290896
17:05:08 6152 8192000000 10678574096 11056017408 1742531440 17.540 100 84 167 0 1779062240 13198208 23332592
17:05:21 5056 8192000000 10691921152 11068715008 1752920016 17.626 100 85 170 2 1791413008 14363312 24129680
17:05:35 3110 8192000000 10696347296 11072921600 1760924096 17.692 100 81 162 1 1797879232 13852368 23102768
17:05:45 4984 8192000000 10710280592 11086446592 1769238416 17.761 100 82 164 1 1806612832 14894464 22479952
17:05:58 9283 8192000000 10710643632 11096035328 1774845408 17.807 100 68 136 0 1807799952 14168768 18785776
17:06:15 5351 8192000000 10733133104 11116486656 1791009568 17.940 100 81 161 1 1827399808 13608624 22781616
17:06:27 2579 8192000000 10758398064 11141316608 1812211104 18.114 100 83 165 0 1849746544 13865904 23669536
17:06:37 3713 8192000000 10768052304 11153997824 1823728608 18.208 100 89 179 1 1863230816 14466784 25035424
17:06:48 1726 8192000000 10777498848 11159638016 1830127248 18.260 100 91 182 1 1869998880 14778016 25093616
17:06:56 2851 8192000000 10782470416 11167920128 1836860816 18.315 100 88 174 0 1875029584 13445072 24723696
17:07:06 2100 8192000000 10783703808 11170373632 1844871632 18.380 100 94 188 3 1885912464 13683472 27357360
17:07:15 1594 8192000000 10790182496 11177578496 1845597968 18.386 100 86 170 0 1884487392 14759488 24129936
17:07:23 2064 8192000000 10801258976 11191848960 1860054544 18.504 100 95 191 3 1900136336 13364800 26716992
17:07:31 2761 8192000000 10803048992 11193643008 1866565584 18.556 100 93 186 0 1905545248 12815008 26164656
17:07:40 1649 8192000000 10803900176 11198803968 1866663440 18.557 100 96 188 4 1906228784 13085376 26479968
17:07:48 1805 8192000000 10803652864 11194884096 1866964768 18.560 100 88 175 0 1904424336 13276560 24183008
17:07:56 2268 8192000000 10812140768 11201712128 1870107376 18.585 100 93 185 4 1908939248 12765824 26066048
17:08:05 2175 8192000000 10814208912 11204788224 1870498064 18.588 100 92 180 0 1908365872 12857488 25010320
17:08:14 1545 8192000000 10816681408 11206922240 1874668048 18.622 100 93 186 0 1915964848 15619968 25676832
17:08:21 1712 8192000000 10817944304 11209306112 1877190064 18.642 100 95 190 0 1916790976 12624864 26976048
17:08:29 5342 8192000000 10774720304 11200225280 1866457728 18.556 100 44 88 1 1888971984 10482032 12032224
17:08:41 24020 8192000000 10818386944 11209990144 1874821056 18.623 100 66 134 0 1902428800 8414976 19192768
17:09:11 6761 8192000000 10798725472 11203321856 1882250624 18.683 100 64 126 4 1908930624 9879888 16800112
17:09:24 4019 8192000000 10805185280 11214643200 1878006304 18.649 100 47 94 0 1901113952 9743312 13364336
17:09:35 7179 8192000000 10795706000 11214114816 1876518944 18.637 100 37 74 0 1895638512 8670480 10449088
17:09:48 8256 8192000000 10790380608 11208441856 1873622432 18.614 100 22 44 0 1885949168 5797120 6529616
17:10:04 9496 8192000000 10788749424 11215183872 1878687488 18.655 100 24 48 1 1891741248 6783344 6270416
17:10:20 6092 8192000000 10793035840 11218219008 1879499792 18.661 100 26 52 3 1893385904 6831120 7054992
17:10:33 6171 8192000000 10801392640 11226497024 1886926832 18.721 100 36 72 0 1904893776 8028720 9938224
17:10:50 9985 8192000000 10794960304 11225387008 1885079344 18.706 100 19 39 2 1896094368 5405024 5610000
17:11:06 8605 8192000000 10797058240 11226861568 1888117888 18.731 100 13 26 0 1897523664 5869408 3536368
17:11:25 15383 8192000000 10792598704 11230896128 1891181616 18.755 100 23 46 3 1903900816 6025440 6693760
17:11:50 11349 8192000000 10799236064 11233501184 1893388784 18.773 100 16 32 0 1903781616 5622880 4769952
17:12:09 14518 8192000000 10800115952 11234959360 1895857440 18.793 100 13 26 1 1909380720 10045216 3478064
17:12:31 10577 8192000000 10826902944 11238096896 1897204448 18.804 100 19 38 1 1909186016 6046816 5934752
17:12:51 63619 8192000000 10820548672 11253477376 1897775856 18.808 100 23 47 1 1909507872 5171216 6560800
17:14:01 10759 8192000000 10819357856 11254251520 1902338448 18.845 100 31 62 1 1918333664 6981968 9013248
17:14:18 5095 8192000000 10829228208 11256979456 1903969856 18.858 100 33 66 1 1921010512 7911744 9128912
17:14:32 6586 8192000000 10822649296 11258695680 1908420512 18.894 100 37 74 0 1926221616 7103824 10697280
17:14:45 6147 8192000000 10814729696 11256295424 1908764288 18.897 100 31 62 2 1924663072 6559680 9339104
17:14:57 4420 8192000000 10816450720 11242799104 1890099424 18.747 99 36 73 2 1907130640 6620800 10410416
17:15:08 5807 8192000000 10818231936 11259408384 1908763280 18.897 100 28 56 0 1923597568 6753888 8080400
17:15:21 4520 8192000000 10833149296 11264233472 1912422864 18.926 100 39 78 3 1930483776 6411328 11649584
17:15:32 9256 8192000000 10814601824 11258564608 1909344672 18.901 100 22 42 1 1920972768 4975840 6652256
17:15:48 4658 8192000000 10826995600 11263041536 1911620240 18.920 100 25 50 0 1925230688 6521792 7088656
17:16:00 7351 8192000000 10828102320 11264733184 1913601872 18.936 100 30 60 2 1928023072 6016064 8405136
17:16:15 7181 8192000000 10822565136 11264237568 1912271136 18.925 100 23 46 2 1924112464 5244400 6596928
17:16:29 11706 8192000000 10815188256 11252277248 1886323696 18.716 99 18 37 1 1896659712 5417712 4918304
17:16:48 14814 8192000000 10806020160 11245318144 1895628832 18.791 100 13 26 1 1904830336 5464496 3737008
17:17:12 7820 8192000000 10805407248 11235966976 1853492352 18.450 98 16 32 3 1867863984 9991568 4380064
17:17:28 13020 8192000000 10775307104 11198009344 1774776768 17.806 94 28 57 1 1788050320 5321232 7952320
17:17:51 66522 8192000000 10753206480 11174051840 1759683552 17.682 95 26 52 0 1772015200 4737392 7594256
17:19:04 11841 8192000000 10702802304 11125764096 1708084912 17.253 93 23 46 0 1720803344 6264576 6453856
17:19:22 3252 8192000000 10720530464 11135025152 1759227568 17.678 97 28 55 2 1773419920 5678144 8514208
17:19:35 5409 8192000000 10714908496 11126784000 1776075616 17.817 98 30 60 2 1795748336 10357936 9314784
17:19:47 6333 8192000000 10671675456 11085451264 1684614352 17.056 93 20 39 0 1696771840 6194128 5963360
17:20:03 4103 8192000000 10706647952 11111706624 1753780960 17.633 98 39 76 2 1775620864 10232944 11606960
17:20:14 10463 8192000000 10692594448 11111395328 1706494384 17.239 95 24 48 1 1719799536 6437568 6867584
17:20:32 4776 8192000000 10701786560 11118927872 1770931296 17.775 99 23 46 1 1783712544 6085776 6695472
17:20:47 8453 8192000000 10711732944 11126243328 1786477616 17.903 99 40 80 0 1803665936 5494688 11693632
17:21:03 9646 8192000000 10730210368 11146182656 1793233392 17.958 99 19 38 0 1804527376 6205584 5088400
17:21:19 8608 8192000000 10728654480 11144065024 1806299088 18.066 100 33 66 1 1822364976 6456624 9609264
17:21:34 10105 8192000000 10717817008 11138539520 1779747392 17.847 98 27 54 1 1793620224 5708448 8164384
17:21:53 9086 8192000000 10730805632 11148042240 1798453024 18.001 99 30 58 1 1812666288 6065328 8147936
17:22:11 49312 8192000000 10732417584 11158388736 1818700720 18.167 100 27 54 1 1831476384 5486896 7288768
17:23:07 25793 8192000000 10729045920 11148648448 1796913232 17.989 98 38 76 0 1813622720 5960128 10749360
17:23:43 11977 8192000000 10743114848 11162775552 1797339984 17.992 98 26 52 1 1810833376 5896864 7596528
17:24:02 6947 8192000000 10762195792 11182948352 1835291984 18.302 100 23 47 1 1851541536 9691152 6558400
17:24:15 9822 8192000000 10776256192 11195219968 1846288016 18.392 100 35 68 0 1866437440 10118144 10031280
17:24:31 6527 8192000000 10770672832 11192291328 1852639200 18.444 100 35 71 2 1868735344 5896720 10199424
17:24:44 3633 8192000000 10777048048 11198078976 1853894432 18.454 100 27 52 0 1867289264 6020592 7374240
17:24:54 6226 8192000000 10769713600 11195949056 1854218304 18.456 100 31 61 1 1869332880 6878352 8236224
17:25:08 5962 8192000000 10760435104 11197063168 1856962912 18.479 100 24 48 0 1869907392 5542448 7402032
17:25:22 11239 8192000000 10773885968 11201138688 1857496016 18.483 100 23 45 1 1869226912 5121488 6609408
17:25:39 11789 8192000000 10776474000 11205005312 1860807712 18.510 100 15 30 0 1870385280 4805392 4772176
17:25:58 6382 8192000000 10775178352 11206565888 1864133200 18.537 100 23 46 1 1876202304 6230688 5838416
17:26:10 12167 8192000000 10784473456 11209994240 1867703472 18.566 100 22 45 3 1879514208 5262896 6547840
17:26:29 6845 8192000000 10780030448 11210842112 1867075696 18.561 100 26 52 2 1880642864 5635168 7932000
17:26:42 12897 8192000000 10780990480 11212914688 1864614080 18.541 100 14 28 2 1873920384 5060480 4245824
17:27:01 14894 8192000000 10812443936 11229253632 1882583696 18.686 100 33 66 1 1897264832 5237952 9443184
17:27:26 97542 8192000000 10842267984 11263799296 1905234000 18.868 100 44 88 1 1925319008 7672960 12412048
17:29:10 23784 8192000000 10844188096 11271897088 1917358368 18.966 100 46 91 2 1938873536 8789920 12725248
17:29:45 24405 8192000000 10858541296 11287986176 1928614400 19.056 100 48 95 2 1953185728 10971632 13599696
17:30:16 8318 8192000000 10873563248 11296215040 1936526864 19.119 100 56 112 1 1964058128 11442320 16088944
17:30:32 20117 8192000000 10883493136 11306868736 1940650656 19.152 100 55 109 1 1972439440 16397088 15391696
17:30:58 40377 8192000000 10875559120 11307577344 1943199520 19.172 100 58 116 0 1974344560 14833072 16311968
17:31:53 23439 8192000000 10876298560 11317870592 1941769664 19.161 100 36 72 3 1967045984 13971408 11304912
17:32:38 25179 8192000000 10897627968 11326025728 1961091056 19.315 100 49 96 3 1992298656 16981328 14226272
17:33:10 20184 8192000000 10909187232 11338469376 1973933376 19.417 100 44 87 1 2001949936 14063152 13953408
17:33:43 32056 8192000000 10921448304 11356352512 1976972784 19.441 100 43 86 3 2004414176 14141056 13300336
17:34:22 18228 8192000000 10929636720 11364151296 1987022720 19.520 100 44 87 2 2018437632 17774720 13640192
17:34:51 12834 8192000000 10939647056 11375247360 1995013632 19.583 100 42 84 3 2028033504 20222160 12797712
17:35:12 17521 8192000000 10949879856 11381428224 1998622576 19.612 100 45 88 2 2034602608 22365280 13614752
17:35:52 22307 8192000000 10953514256 11390029824 2004136384 19.655 100 51 102 0 2044902256 24568032 16197840
17:36:27 11196 8192000000 10956181168 11394932736 2009840512 19.700 100 52 101 2 2049536240 23777616 15918112
17:36:46 5970 8192000000 10958090848 11393363968 2013086480 19.726 100 59 119 0 2054416240 23204336 18125424
17:37:03 5469 8192000000 10965434656 11393671168 1998871888 19.614 99 68 135 1 2043287072 24335200 20079984
17:37:32 12000 8192000000 10964812640 11397373952 1997689040 19.605 99 59 117 2 2044612832 29006912 17916880
17:37:56 7419 8192000000 10966961328 11390337024 1983833632 19.495 99 55 109 0 2032606560 32456320 16316608
17:38:19 3433 8192000000 10967761632 11388948480 1997268656 19.601 100 70 140 2 2048948880 29939280 21740944
17:38:32 7370 8192000000 10961949360 11389587456 2000678912 19.628 100 64 127 0 2050415712 30407456 19329344
17:38:49 3944 8192000000 10980840112 11402997760 2013012448 19.725 100 74 148 0 2069301408 33478112 22810848
17:38:59 2897 8192000000 10996886544 11414925312 2022030160 19.796 100 80 157 1 2079233040 32610064 24592816
17:39:11 2137 8192000000 11005610128 11420880896 2026419824 19.831 100 89 175 1 2085981568 32875056 26686688
17:39:21 1748 8192000000 10979932544 11398623232 2012684448 19.723 100 85 170 2 2070855872 32236768 25934656
17:39:29 3113 8192000000 10991201728 11410530304 2014630528 19.738 100 77 151 1 2070762832 32346624 23785680
17:39:39 2682 8192000000 10970240064 11379638272 1980689680 19.470 98 83 165 2 2038442544 32500160 25252704
17:39:49 5753 8192000000 10975134032 11395235840 2000773584 19.629 100 73 145 1 2056032000 33219792 22038624
17:40:03 2560 8192000000 10977099408 11391909888 1997450512 19.603 100 76 150 1 2054088464 34170720 22467232
17:40:14 1897 8192000000 10992478240 11400183808 2001605664 19.635 100 97 192 0 2068010176 36350304 30054208
17:40:24 1173 8192000000 10972627360 11382382592 1986833840 19.519 99 91 182 1 2051426640 36686032 27906768
17:40:33 3237 8192000000 10990711440 11404001280 2008711760 19.691 100 90 181 2 2073695232 37143104 27840368
17:40:45 2604 8192000000 10993123440 11409215488 2009007840 19.694 100 83 166 0 2074667232 39067712 26591680
17:40:54 4484 8192000000 10983244976 11404947456 1989888160 19.543 99 81 159 1 2055715360 40571424 25255776
17:41:07 1971 8192000000 10986266832 11401498624 1990662000 19.549 99 89 178 1 2059697216 41622416 27412800
17:41:15 3297 8192000000 10975174192 11394084864 1959437328 19.302 98 72 144 1 2019748112 38176864 22133920
17:41:25 4111 8192000000 10968000752 11383181312 1957889248 19.289 98 86 172 2 2024700832 39058720 27752864
17:41:36 2995 8192000000 10959788416 11377491968 1967014960 19.362 99 79 158 1 2033513552 41766544 24732048
17:41:46 4296 8192000000 10950197840 11372171264 1946293568 19.197 98 74 148 1 2012439072 42220688 23924816
17:41:58 10390 8192000000 10935602640 11361947648 1938629920 19.136 99 60 120 0 2002447328 45270512 18546896
17:42:18 1948 8192000000 10940656208 11361579008 1940060848 19.147 99 66 129 0 2008703152 48381456 20260848
17:42:29 8061 8192000000 10926652784 11337904128 1926433264 19.038 99 77 154 2 1995104432 44381984 24289184
17:42:45 4034 8192000000 10935127888 11350716416 1947896144 19.210 100 68 136 0 2015660656 45649968 22114544
17:42:58 5451 8192000000 10916431552 11336515584 1922754688 19.009 98 65 124 3 1985920736 43194576 19971472
17:43:11 7475 8192000000 10936352624 11361779712 1960166528 19.307 100 62 124 1 2022092832 41603776 20322528
17:43:28 7890 8192000000 10936894752 11357069312 1943350720 19.173 99 57 112 2 2005120608 42681792 19088096
17:43:45 4126 8192000000 10952989136 11364638720 1958084400 19.291 100 71 140 1 2024708736 44301648 22322688
17:43:55 1624 8192000000 10951801280 11356078080 1932138784 19.084 98 82 163 0 2004031216 44934432 26958000
17:44:04 2908 8192000000 10947653344 11351691264 1940305664 19.149 99 83 167 0 2014140448 46534976 27299808
17:44:14 1158 8192000000 10956392912 11361927168 1943797904 19.177 99 88 178 2 2019642624 47705760 28138960
17:44:22 4405 8192000000 10936772608 11360116736 1956071776 19.275 100 70 141 1 2025921184 47105648 22743760
17:44:40 4191 8192000000 10934307856 11361001472 1944495904 19.183 99 80 157 2 2013526928 43995344 25035680
17:44:52 9736 8192000000 10919782944 11346825216 1915561744 18.951 98 54 104 1 1973718176 41600496 16555936
17:45:10 9508 8192000000 10934023216 11364597760 1960768240 19.312 100 46 92 1 2018720864 42857616 15095008
17:45:28 5482 8192000000 10931903616 11360468992 1939836896 19.145 99 49 98 0 2001147120 45668080 15642144
17:45:40 3373 8192000000 10931336288 11342000128 1930620080 19.072 99 80 158 3 1998348144 41803088 25924976
17:45:50 4922 8192000000 10928458384 11351715840 1947395120 19.206 100 65 130 0 2011321296 43565872 20360304
17:46:05 7385 8192000000 10920464112 11352068096 1934865696 19.106 99 50 99 2 1992910704 41718544 16326464
17:46:24 10197 8192000000 10927486896 11369041920 1951917344 19.242 100 40 80 0 2009936272 44675248 13343680
17:46:48 13732 8192000000 10917558192 11354820608 1949569968 19.223 100 35 70 4 1997108192 35979280 11558944
17:47:09 24137 8192000000 10902316256 11345440768 1911299856 18.917 98 38 75 0 1962642128 39231760 12110512
17:47:44 15210 8192000000 10905263024 11344277504 1922319664 19.005 99 35 70 0 1976754704 42425488 12009552
17:48:30 22177 8192000000 10881291328 11340128256 1934319152 19.101 100 24 48 2 1976697568 34448432 7929984
17:48:58 23364 8192000000 10867324240 11314733056 1906848816 18.881 99 22 44 0 1946896016 32233696 7813504
17:49:30 14202 8192000000 10875528112 11319853056 1903395744 18.854 99 29 58 2 1949433696 35380208 10657744
17:49:59 23910 8192000000 10870876640 11322302464 1903937824 18.858 99 19 38 1 1948136064 37475936 6722304
17:51:11 33393 8192000000 10825889056 11275370496 1851518592 18.434 98 9 18 0 1873886912 19489840 2878480
17:51:50 39276 8192000000 10858886480 11285659648 1903666464 18.856 100 23 43 3 1920293296 9844160 6782672
17:52:39 36520 8192000000 10886415696 11306565632 1919763936 18.985 99 52 104 4 1947145520 12916720 14464864
17:53:30 67651 8192000000 10867209952 11329437696 1916144560 18.956 99 25 50 2 1937311824 14415504 6751760
17:54:45 62521 8192000000 10873358736 11331903488 1906469840 18.878 98 33 66 1 1930707648 13921392 10316416
17:55:56 135130 8192000000 10888705024 11334213632 1930116528 19.068 99 28 55 2 1949547296 10245040 9185728
17:58:20 27422 8192000000 10898102240 11351941120 1957023744 19.282 100 24 46 0 1973431504 10323184 6084576
17:58:54 49598 8192000000 10885207840 11343450112 1950902288 19.234 99 20 40 1 1968787904 11739040 6146576
18:01:46 41060 8192000000 10863508000 11324133376 1912535488 18.927 98 8 15 1 1925014880 9468016 3011376
18:03:23 44584 8192000000 10899729008 11340795904 1948684672 19.216 100 22 44 1 1961320000 6330064 6305264
18:04:16 71942 8192000000 10855745056 11319418880 1922196160 19.004 98 21 42 0 1937248816 9628224 5424432
18:05:38 31203 8192000000 10884932272 11344842752 1953501776 19.254 100 20 40 1 1971114688 12052176 5560736
18:06:17 36343 8192000000 10876545808 11353067520 1957328016 19.285 100 12 24 0 1973718208 12816128 3574064
18:07:09 69141 8192000000 10876602768 11355254784 1960808880 19.312 100 5 10 0 1970003264 7669984 1524400
18:08:26 29026 8192000000 10899559344 11362447360 1968846624 19.376 100 8 15 0 1980323024 9339744 2136656
18:09:08 51099 8192000000 10883985152 11363594240 1960399104 19.309 99 11 22 2 1976051248 12635568 3016576
18:10:09 31672 8192000000 10912325664 11375861760 1966932480 19.361 99 23 46 1 1985335312 11794400 6608432
18:10:49 27570 8192000000 10923187664 11387101184 1989508368 19.540 100 16 32 1 2008710976 13974032 5228576
18:11:24 51433 8192000000 10927153408 11381702656 1975155648 19.426 99 25 50 0 1992912416 10736336 7020432
18:12:29 29021 8192000000 10901132736 11369713664 1967747280 19.368 99 25 48 1 1983507856 8680704 7079872
18:13:05 23446 8192000000 10930599360 11387240448 1991510256 19.556 100 33 66 1 2010291968 9538880 9242832
18:13:35 31052 8192000000 10937499312 11389501440 1989064400 19.536 100 30 60 1 2010335088 13034784 8235904
18:14:13 44466 8192000000 10933182800 11408572416 2004210448 19.656 100 35 70 1 2032879968 18758992 9910528
18:15:22 53011 8192000000 10927306976 11414368256 1995667088 19.589 100 15 30 0 2022311952 22344864 4300000
18:16:23 26315 8192000000 10933702816 11392319488 1987946288 19.528 99 28 54 1 2005699696 10276160 7477248
18:16:57 30952 8192000000 10934071776 11386793984 1950337728 19.229 97 44 88 1 1974682928 11842192 12503008
18:17:35 59216 8192000000 10924737088 11383087104 1967829872 19.368 99 34 68 2 1994018480 16399648 9788960
18:18:44 93723 8192000000 10933246032 11386761216 1917040912 18.963 96 28 56 0 1938707264 14074416 7591936
18:20:31 51741 8192000000 10903379648 11374706688 1902428624 18.846 96 30 60 2 1926354736 15561696 8364416
18:22:22 105016 8192000000 10900005744 11369426944 1965900288 19.353 99 29 58 1 1983684592 9694352 8089952
18:24:51 16719 8192000000 10899594976 11365060608 1952509248 19.246 98 40 80 2 1977239648 12786928 11943472
18:25:16 58428 8192000000 10890584976 11368706048 1936097648 19.116 98 30 60 2 1962380704 17296816 8986240
18:26:31 71735 8192000000 10897434224 11364757504 1935340976 19.110 98 13 26 0 1954313472 15279424 3693072
18:27:53 98210 8192000000 10902662832 11396775936 1978932944 19.456 100 12 24 2 2000119728 17228224 3958560
18:29:37 57214 8192000000 10844647152 11318652928 1800440448 18.018 91 13 26 0 1821141984 17068736 3632800
18:30:42 38894 8192000000 10867368944 11342635008 1924249840 19.021 99 14 27 1 1936467632 8065056 4152736
18:31:27 38710 8192000000 10870464448 11331219456 1872405984 18.604 95 20 40 2 1884807456 7121616 5279856
18:32:18 55384 8192000000 10832280832 11298869248 1773516592 17.796 91 15 30 2 1788664336 10154592 4993152
18:33:26 61405 8192000000 10852399456 11320590336 1871048848 18.593 97 22 44 1 1888828416 11473296 6306272
18:34:56 35589 8192000000 10852127184 11300896768 1882849312 18.688 98 36 70 0 1906370368 13708496 9812560
18:35:47 61343 8192000000 10876829968 11328602112 1898637856 18.815 98 39 78 1 1928858032 19206560 11013616
18:37:33 65127 8192000000 10860191616 11324497920 1897873904 18.809 98 3 6 0 1918401888 19823456 704528
18:38:45 48610 8192000000 10860196576 11318411264 1898418880 18.814 98 27 52 2 1916029408 10496528 7114000
18:39:42 40679 8192000000 10883207376 11332005888 1904812624 18.865 98 20 40 0 1918264864 7690400 5761840
18:40:29 50082 8192000000 10875341200 11326763008 1911217312 18.916 98 36 72 2 1935284272 14020032 10046928
18:41:25 114066 8192000000 10867613488 11324166144 1846217472 18.391 95 23 46 0 1866426304 14091856 6116976
18:44:03 65180 8192000000 10863268448 11311484928 1902067888 18.843 98 36 72 0 1920268848 7662288 10538672
18:45:21 43771 8192000000 10874613392 11323498496 1932024272 19.083 100 38 76 0 1951928464 8690496 11213696
18:46:14 53343 8192000000 10857739344 11332481024 1937695856 19.128 100 21 43 1 1954386624 10304400 6386368
18:47:26 54299 8192000000 10843830576 11325304832 1918651904 18.976 99 7 14 1 1932174576 11185584 2337088
18:48:27 37479 8192000000 10844762256 11318878208 1893491280 18.774 98 11 22 0 1909853120 13439696 2922144
18:49:56 51114 8192000000 10859884320 11323355136 1924752304 19.025 99 16 32 1 1937598096 8318096 4527696
18:50:55 76528 8192000000 10859135920 11332730880 1921442896 18.998 99 13 26 0 1934095008 9119552 3532560
18:52:57 82961 8192000000 10856699120 11344482304 1926513440 19.039 99 11 22 1 1942225728 12559152 3153136
18:54:26 70964 8192000000 10858170096 11328561152 1917414160 18.966 99 11 22 0 1930258080 10143888 2700032
18:57:00 72212 8192000000 10875955504 11342147584 1924443216 19.022 98 25 50 1 1948751328 16986768 7321344
18:58:25 101642 8192000000 10879558352 11366760448 1932790624 19.089 99 9 17 1 1958633232 22925408 2917200
19:00:48 44790 8192000000 10902169024 11360833536 1964700176 19.343 100 25 50 1 1981099360 9531904 6867280
19:01:40 40768 8192000000 10904429664 11369705472 1949489760 19.222 99 35 70 0 1973297408 13910144 9897504
19:02:34 71429 8192000000 10915064672 11393105920 1972131008 19.402 100 27 54 1 1999450768 19674688 7645072
19:03:51 123856 8192000000 10922619248 11403288576 1964003520 19.338 99 9 18 1 1983932752 17577360 2351872
19:06:09 32752 8192000000 10928583696 11390705664 1968046256 19.370 99 17 35 0 1982683200 10083840 4553104
19:06:51 14140 8192000000 10937027920 11393277952 1982892144 19.488 99 50 100 1 2005062928 8181952 13988832
19:07:17 14504 8192000000 10933475424 11384438784 1973605072 19.414 99 54 108 1 1999441936 10801168 15035696
19:07:43 66881 8192000000 10912112960 11371491328 1965155136 19.347 99 41 82 1 1987644448 11178288 11311024
19:09:28 41142 8192000000 10881735168 11341344768 1897865216 18.809 96 32 64 0 1916250528 9562304 8823008
19:10:15 16649 8192000000 10850713456 11326341120 1922978928 19.011 99 17 33 0 1935300608 7260960 5060720
19:11:28 55808 8192000000 10848175984 11326406656 1891482640 18.758 97 6 12 0 1902951920 9525152 1944128
19:12:38 34807 8192000000 10874569504 11346681856 1928065008 19.051 99 17 33 0 1943266256 10680832 4520416
19:13:20 48255 8192000000 10873310800 11351666688 1915243712 18.949 98 10 20 2 1930286256 12114880 2927664
19:14:16 35547 8192000000 10887249744 11348541440 1913852640 18.938 97 20 40 0 1930888128 11411424 5624064
19:15:10 72068 8192000000 10876654352 11359715328 1887397904 18.725 96 10 20 2 1900095216 9740368 2956944
19:16:31 91350 8192000000 10897992816 11362578432 1928622592 19.056 98 13 26 0 1942120864 9569552 3928720
19:18:08 30454 8192000000 10906695216 11367182336 1955904336 19.273 99 45 90 1 1976428176 7703776 12820064
19:18:48 70814 8192000000 10869044176 11338104832 1864288160 18.538 95 20 40 1 1880711472 10074864 6348448
19:20:16 86825 8192000000 10862669648 11334647808 1859305296 18.498 95 24 48 3 1882176880 16160592 6710992
19:22:07 100492 8192000000 10845510224 11319205888 1796504096 17.985 93 10 20 0 1814319936 14967552 2848288
19:24:07 133897 8192000000 10854063472 11318349824 1835539296 18.304 95 21 42 1 1853013664 12087392 5386976
19:26:27 69769 8192000000 9070454544 9270558720 241428416 2.862 13 3 6 0 243124800 1031904 664480

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 04-01-2021 19:28:55 to 04-01-2021 19:29:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-01-2021 19:29:26 to 04-01-2021 19:29:28.

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          244255
MON$OLDEST_ACTIVE               244256
MON$OLDEST_SNAPSHOT             244256
MON$NEXT_TRANSACTION            244256
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                       2013568
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:403: 
:404: mscs-test-161.budzdorov.ru    Mon Jan  4 19:27:39 2021
:405:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:406: 
--- end of diff output ---

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

04.01.21 19:29:29. 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-01-04 19:29:32 No severe PSQL-related problems occured
04.01.21 19:29:33. End of report.