Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.06.2021 01:27
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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17002296 kB
MemAvailable 31347160 kB
Buffers 0 kB
Cached 14630720 kB
SwapCached 2408 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-06-20 01:27:38
DTS_END                         2021-06-20 01:27:38.3870
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_WRITE_OFF(41:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43908
TRN_ID                          245647
ATT_ID                          675
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: 9537.11 20990 1144453
customer order: creation 175.33 342 21040
customer order: refuse 14.90 366 1788
order to supplier: creation 46.04 1324 5525
order to supplier: removal 3.70 86929 444
invoice (draft): creation 46.68 3579 5601
invoice (draft): removal 54.50 706 6540
invoice accept: apply 42.27 18541 5072
invoice accept: cancel 49.43 801 5932
customer reserve: creation 3940.37 183 472844
customer reserve: removal 4860.43 52 583252
realization accept: apply 85.42 176 10250
realization accept: cancel 84.17 118 10100
payment from customer: creation 61.70 110 7404
payment from customer: removal 5.93 53 712
payment to supplier: creation 50.33 123 6040
payment to supplier: removal 3.47 115 416
service: total inventory turnovers 4.61 1125 553
service: total monetary turnovers 6.93 60 832
service: aggregate perf. data 0.87 17391 104
service: refresh index statistics 0.03 287711 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-06-2021 01:28:15 to 20-06-2021 01:28:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3465
TEST_TIME 2 2717
TEST_TIME 3 4476
TEST_TIME 4 6259
TEST_TIME 5 7018
TEST_TIME 6 6896
TEST_TIME 7 6800
TEST_TIME 8 6569
TEST_TIME 9 6655
TEST_TIME 10 6589
TEST_TIME 11 6444
TEST_TIME 12 6725
TEST_TIME 13 6881
TEST_TIME 14 6911
TEST_TIME 15 6906
TEST_TIME 16 7683
TEST_TIME 17 7692
TEST_TIME 18 7838
TEST_TIME 19 7737
TEST_TIME 20 8131
TEST_TIME 21 8335
TEST_TIME 22 8580
TEST_TIME 23 8943
TEST_TIME 24 9283
TEST_TIME 25 9321
TEST_TIME 26 9712
TEST_TIME 27 9512
TEST_TIME 28 9337
TEST_TIME 29 9690
TEST_TIME 30 9487
TEST_TIME 31 9655
TEST_TIME 32 10029
TEST_TIME 33 10248
TEST_TIME 34 10199
TEST_TIME 35 10125
TEST_TIME 36 10269
TEST_TIME 37 10118
TEST_TIME 38 10012
TEST_TIME 39 10033
TEST_TIME 40 10167
TEST_TIME 41 10101
TEST_TIME 42 9905
TEST_TIME 43 9917
TEST_TIME 44 9765
TEST_TIME 45 9671
TEST_TIME 46 9617
TEST_TIME 47 9694
TEST_TIME 48 9697
TEST_TIME 49 9661
TEST_TIME 50 9610
TEST_TIME 51 9516
TEST_TIME 52 9505
TEST_TIME 53 9508
TEST_TIME 54 9496
TEST_TIME 55 9543
TEST_TIME 56 9540
TEST_TIME 57 9552
TEST_TIME 58 9630
TEST_TIME 59 9604
TEST_TIME 60 9682
TEST_TIME 61 9674
TEST_TIME 62 9657
TEST_TIME 63 9629
TEST_TIME 64 9579
TEST_TIME 65 9685
TEST_TIME 66 9850
TEST_TIME 67 9848
TEST_TIME 68 9832
TEST_TIME 69 9797
TEST_TIME 70 9699
TEST_TIME 71 9658
TEST_TIME 72 9692
TEST_TIME 73 9616
TEST_TIME 74 9573
TEST_TIME 75 9602
TEST_TIME 76 9583
TEST_TIME 77 9521
TEST_TIME 78 9508
TEST_TIME 79 9461
TEST_TIME 80 9382
TEST_TIME 81 9437
TEST_TIME 82 9463
TEST_TIME 83 9461
TEST_TIME 84 9438
TEST_TIME 85 9441
TEST_TIME 86 9435
TEST_TIME 87 9441
TEST_TIME 88 9424
TEST_TIME 89 9519
TEST_TIME 90 9532
TEST_TIME 91 9588
TEST_TIME 92 9585
TEST_TIME 93 9626
TEST_TIME 94 9646
TEST_TIME 95 9626
TEST_TIME 96 9681
TEST_TIME 97 9729
TEST_TIME 98 9639
TEST_TIME 99 9607
TEST_TIME 100 9572
TEST_TIME 101 9533
TEST_TIME 102 9520
TEST_TIME 103 9512
TEST_TIME 104 9500
TEST_TIME 105 9450
TEST_TIME 106 9439
TEST_TIME 107 9372
TEST_TIME 108 9357
TEST_TIME 109 9384
TEST_TIME 110 9445
TEST_TIME 111 9433
TEST_TIME 112 9420
TEST_TIME 113 9459
TEST_TIME 114 9436
TEST_TIME 115 9511
TEST_TIME 116 9470
TEST_TIME 117 9461
TEST_TIME 118 9550
TEST_TIME 119 9565
TEST_TIME 120 9537

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-06-2021 01:28:19 to 20-06-2021 01:28:22.

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 1582407 1582407 0 0.00 0 14219 6 0 0
doc_list_biud 1582404 1582404 0 0.00 0 64045 25 0 0
sp_add_invoice_to_stock 5223 5072 151 2.89 42 186843 18542 0 151
sp_cancel_adding_invoice 5932 5932 0 0.00 5 96085 801 0 0
sp_cancel_client_order 1788 1788 0 0.00 4 10705 367 0 0
sp_cancel_customer_reserve 583252 583252 0 0.00 1 64048 52 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 2 1616 54 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 2 7266 116 0 0
sp_cancel_supplier_invoice 6544 6540 4 0.06 2 24385 707 0 4
sp_cancel_supplier_order 444 444 0 0.00 7 821240 86930 0 0
sp_cancel_write_off 10100 10100 0 0.00 1 13531 118 0 0
sp_client_order 21040 21040 0 0.00 4 20264 342 0 0
sp_customer_reserve 472844 472844 0 0.00 0 52739 184 0 0
sp_fill_shopping_cart 32146 32146 0 0.00 1 11864 35 0 0
sp_fill_shopping_cart_clo_res 472844 472844 0 0.00 0 21357 13 0 0
sp_get_clo_for_invoice 5072 5072 0 0.00 0 20360 256 0 0
sp_kill_cost_storno 17160 17160 0 0.00 0 9118 50 0 0
sp_kill_qstorno_ret_qs2qd 1183588 1183588 0 0.00 0 64041 28 0 0
sp_kill_qty_storno 623377 623377 0 0.00 0 64045 62 0 0
sp_lock_selected_doc 21295 21295 0 0.00 0 11468 6 0 0
sp_make_cost_storno 28766 28766 0 0.00 0 14218 48 0 0
sp_multiply_rows_for_pdistr 28765 28765 0 0.00 0 9791 26 0 0
sp_multiply_rows_for_qdistr 21040 21040 0 0.00 0 20099 147 0 0
sp_pay_from_customer 7404 7404 0 0.00 4 23511 110 0 0
sp_pay_to_supplier 6040 6040 0 0.00 4 25057 123 0 0
sp_payment_common 13443 13443 0 0.00 1 25016 36 0 0
sp_qd_handle_on_cancel_clo 1788 1788 0 0.00 0 6929 321 0 0
sp_qd_handle_on_invoice_upd_sts 11004 11004 0 0.00 0 18474 320 0 0
sp_qd_handle_on_reserve_upd_sts 10249 10249 0 0.00 0 19578 62 0 0
sp_reserve_write_off 10250 10250 0 0.00 6 19712 176 0 0
sp_supplier_invoice 5601 5601 0 0.00 7 93975 3580 0 0
sp_supplier_order 5525 5525 0 0.00 6 25522 1325 0 0
srv_aggregate_perf_data 104 104 0 0.00 2779 89462 17392 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1450 149418 32248 0 0
srv_find_qd_qs_mism 1095615 1095615 0 0.00 0 13477 6 0 0
srv_make_invnt_saldo 553 553 0 0.00 57 33305 1125 0 0
srv_make_money_saldo 832 832 0 0.00 1 29196 61 0 0
srv_recalc_idx_stat 4 4 0 0.00 158121 404226 287711 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5072 5072 0 0.00 0 14409 165 0 0
t$perf-norm:sp_cancel_adding_invoice 438 438 0 0.00 0 11774 125 0 0
t$perf-norm:sp_cancel_client_order 1788 1788 0 0.00 0 4921 12 0 0
t$perf-norm:sp_cancel_customer_reserve 741 741 0 0.00 0 6532 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 2058 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 6374 28 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 2807 26 0 0
t$perf-norm:sp_cancel_supplier_order 444 444 0 0.00 0 38140 1675 0 0
t$perf-norm:sp_cancel_write_off 1044 1044 0 0.00 0 5413 9 0 0
t$perf-norm:sp_client_order 21040 21040 0 0.00 0 6019 18 0 0
t$perf-norm:sp_customer_reserve 1004 1004 0 0.00 0 2442 6 0 0
t$perf-norm:sp_pay_from_customer 7404 7404 0 0.00 0 7673 12 0 0
t$perf-norm:sp_pay_to_supplier 6040 6040 0 0.00 0 12987 15 0 0
t$perf-norm:sp_reserve_write_off 10250 10250 0 0.00 0 15665 15 0 0
t$perf-norm:sp_supplier_invoice 5601 5601 0 0.00 0 9116 22 0 0
t$perf-norm:sp_supplier_order 5525 5525 0 0.00 0 5252 17 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 369 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 1966 15 0 0
t$perf-norm:srv_make_invnt_saldo 553 553 0 0.00 0 1415 25 0 0
t$perf-norm:srv_make_money_saldo 832 832 0 0.00 0 6532 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10446 10144 302 2.89 0 8515 20 0 302
v_all_customers 38284 38284 0 0.00 0 23 1 0 0
v_all_suppliers 31108 31108 0 0.00 0 19 1 0 0
v_all_wares 42080 42080 0 0.00 0 32 1 0 0
v_cancel_adding_invoice 876 876 0 0.00 0 904 7 0 0
v_cancel_client_order 3576 3576 0 0.00 0 7607 11 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 676 4 0 0
v_cancel_customer_reserve 1482 1482 0 0.00 0 3429 7 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 6985 20 0 0
v_cancel_supplier_invoice 790 782 8 1.01 0 321 12 0 8
v_cancel_supplier_order 888 888 0 0.00 0 5664 14 0 0
v_cancel_write_off 2088 2088 0 0.00 0 1576 14 0 0
v_max_id_clo_ord 5520 5520 0 0.00 0 556 1 0 0
v_max_id_clo_res 1004 1004 0 0.00 0 7380 17 0 0
v_max_id_ord_sup 5585 5585 0 0.00 0 7604 5 0 0
v_max_non_paid_invoice 1590 1590 0 0.00 0 132 2 0 0
v_max_non_paid_realizn 3969 3969 0 0.00 0 338 2 0 0
v_min_id_clo_ord 5520 5520 0 0.00 0 2765 6 0 0
v_min_id_clo_res 1004 1004 0 0.00 0 1195 5 0 0
v_min_id_ord_sup 5585 5585 0 0.00 0 5198 5 0 0
v_min_non_paid_invoice 6039 6039 0 0.00 0 25010 20 0 0
v_min_non_paid_realizn 7404 7404 0 0.00 0 23498 23 0 0
v_our_firm 10666 10666 0 0.00 0 13 1 0 0
v_reserve_write_off 20498 20498 0 0.00 0 12098 8 0 0
x_lock_depdocs_on_canc_invoice 12081 12081 0 0.00 0 19698 118 0 0
x_lock_depdocs_on_canc_sup_ord 444 444 0 0.00 0 12202 381 0 0
x_make_qstorno_1000_1200 5525 5525 0 0.00 2 25510 1249 0 0
x_make_qstorno_1200_2000 5601 5601 0 0.00 4 93933 3453 0 0
x_make_qstorno_2100_3300 472844 472844 0 0.00 0 51528 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-06-2021 01:28:23 to 20-06-2021 01:28:27.

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:42 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:48 17506 8192000000 10249099648 10554925056 844363168 9.344 67 44 89 1 861686032 2416896 14905968
22:58:14 30674 8192000000 10351279024 10669953024 1387988848 14.488 100 88 178 0 1420716432 4669968 28057616
22:58:55 24548 8192000000 10383137392 10705530880 1430316944 14.864 100 89 178 1 1465911312 6678176 28916192
22:59:31 22238 8192000000 10411495456 10737639424 1466405184 15.182 100 95 189 0 1504699936 7898336 30396416
23:00:04 32758 8192000000 10436495760 10768011264 1485853328 15.353 100 94 188 1 1524413152 8662688 29897136
23:00:56 10937 8192000000 10450924304 10787385344 1508973024 15.554 100 89 178 0 1546495216 9618576 27903616
23:01:26 24013 8192000000 10468668848 10811613184 1524114272 15.686 100 86 172 0 1561335936 9904960 27316704
23:02:00 18134 8192000000 10507958416 10851024896 1553308496 15.939 100 79 158 2 1588594672 10288736 24997440
23:02:29 14317 8192000000 10523403088 10872127488 1579810688 16.167 100 82 164 1 1616474624 11423712 25240224
23:02:54 12792 8192000000 10540986960 10891706368 1592545360 16.276 100 86 172 0 1630353104 11655984 26151760
23:03:16 10578 8192000000 10554349072 10911645696 1608408672 16.411 100 78 154 0 1643312640 11906320 22997648
23:03:35 12863 8192000000 10589812432 10947203072 1633499920 16.625 100 81 163 0 1669804784 12176688 24128176
23:03:55 10515 8192000000 10610882464 10970443776 1656667520 16.821 100 85 170 0 1694428832 12619760 25141552
23:04:14 6514 8192000000 10613556576 10976841728 1671095872 16.942 100 87 174 3 1709583616 13006416 25481328
23:04:28 9479 8192000000 10617497904 10984382464 1680241088 17.019 100 77 154 1 1715834576 13279728 22313760
23:04:46 9390 8192000000 10631258672 11001929728 1692642000 17.123 100 86 173 1 1732006304 14119536 25244768
23:05:02 7520 8192000000 10641736112 11011850240 1703877904 17.218 100 86 169 1 1741935488 14013264 24044320
23:05:16 4886 8192000000 10670164064 11039326208 1726443280 17.406 100 88 175 0 1764635728 13229328 24963120
23:05:28 5052 8192000000 10673184496 11047104512 1734551936 17.473 100 86 173 1 1772214592 13176576 24486080
23:05:40 4390 8192000000 10689539936 11060207616 1743245888 17.546 100 86 172 0 1780752192 12331472 25174832
23:05:51 4730 8192000000 10687430784 11068727296 1756987104 17.659 100 86 172 0 1795149840 12812944 25349792
23:06:02 4426 8192000000 10708319904 11084644352 1765768512 17.732 100 89 178 1 1803423152 12212928 25441712
23:06:14 4489 8192000000 10711509280 11088515072 1772365504 17.787 100 84 168 1 1808930208 12782640 23782064
23:06:26 3569 8192000000 10723385584 11102179328 1780760640 17.856 100 87 174 0 1818552720 13226720 24565360
23:06:36 2913 8192000000 10730840528 11113279488 1789924640 17.931 100 83 163 1 1825663536 13069040 22669856
23:06:45 2693 8192000000 10742932192 11123871744 1799642640 18.011 100 82 165 0 1835625328 12972112 23010576
23:06:55 3065 8192000000 10747641312 11128008704 1803769488 18.045 100 87 174 2 1841834144 14041152 24023504
23:07:04 1913 8192000000 10752816128 11136397312 1815218544 18.139 100 91 181 3 1854400192 12832640 26349008
23:07:12 8029 8192000000 10745870240 11134443520 1815670816 18.142 100 77 153 0 1849506752 12641664 21194272
23:07:27 2532 8192000000 10769056640 11156127744 1822245936 18.196 100 80 160 0 1856707568 12290608 22171024
23:07:36 1848 8192000000 10780430976 11164348416 1836736816 18.314 100 86 171 2 1874978864 14360880 23881168
23:07:44 2179 8192000000 10792287424 11177422848 1845460496 18.385 100 90 180 1 1885934512 13949184 26524832
23:07:53 2200 8192000000 10795796400 11180777472 1851138992 18.431 100 94 189 3 1890646064 13195696 26311376
23:08:02 1570 8192000000 10792924032 11182182400 1851930320 18.438 100 90 178 3 1890109376 13485408 24693648
23:08:09 1930 8192000000 10805292784 11188654080 1856703856 18.477 100 91 183 2 1896615824 12945360 26966608
23:08:17 1803 8192000000 10805982800 11189694464 1858518848 18.491 100 93 184 2 1897092384 12557104 26016432
23:08:25 1484 8192000000 10815909792 11202244608 1865766800 18.550 100 93 189 1 1904971904 12745440 26459664
23:08:33 2215 8192000000 10815524880 11200757760 1866545904 18.556 100 95 190 3 1906917568 13443456 26928208
23:08:42 1141 8192000000 10801013456 11196502016 1868003584 18.568 100 91 181 1 1908374320 14752528 25618208
23:08:50 15876 8192000000 10790642464 11197722624 1866449760 18.556 100 68 137 1 1896377760 11792160 18135840
23:09:12 989 8192000000 10821060864 11210625024 1876374080 18.636 100 90 178 2 1914254976 12586160 25294736
23:09:19 38602 8192000000 10792934432 11204640768 1867556960 18.565 100 35 70 1 1885502160 7852064 10093136
23:10:04 12766 8192000000 10781278800 11206369280 1871243376 18.594 100 37 76 3 1887708304 5585632 10879296
23:10:26 5238 8192000000 10796238208 11212505088 1875392944 18.628 100 47 94 0 1897160368 8656000 13111424
23:10:39 5091 8192000000 10792478176 11214819328 1875273616 18.627 100 38 74 4 1893864960 8534816 10056528
23:10:53 4232 8192000000 10792130576 11213864960 1876118208 18.634 100 34 67 0 1892281536 7219344 8943984
23:11:06 8217 8192000000 10777106832 11214753792 1878097504 18.650 100 21 42 0 1890416592 6449472 5869616
23:11:22 10562 8192000000 10793261376 11218550784 1881336864 18.676 100 18 37 1 1891799712 5574384 4888464
23:11:39 7627 8192000000 10796351680 11224670208 1885416352 18.709 100 16 32 0 1895695872 5788256 4491264
23:11:55 4933 8192000000 10805234608 11231821824 1892873424 18.769 100 29 58 1 1907437520 6421072 8143024
23:12:08 8924 8192000000 10796109232 11229114368 1889804192 18.744 100 24 48 1 1902871424 6197008 6870224
23:12:24 7074 8192000000 10802110560 11235905536 1891916128 18.761 100 14 28 0 1900852976 5272640 3664208
23:12:40 7879 8192000000 10791499456 11233665024 1896344480 18.797 100 22 43 1 1908579216 6687760 5546976
23:12:55 8074 8192000000 10806951856 11236503552 1897381216 18.805 100 17 34 0 1907778368 5900496 4496656
23:13:11 8414 8192000000 10808842752 11241603072 1898965536 18.818 100 17 34 1 1909751936 6030592 4755808
23:13:25 3669 8192000000 10817130176 11244945408 1902516352 18.847 100 30 60 1 1920940192 10375328 8048512
23:13:37 16196 8192000000 10807148528 11244146688 1901247984 18.836 100 15 30 1 1912192016 7076992 3867040
23:14:02 18593 8192000000 10811228592 11250692096 1905954992 18.874 100 24 48 0 1918272048 5464064 6852992
23:14:27 41828 8192000000 10827894208 11258478592 1908500960 18.895 100 20 38 1 1919275952 5799232 4975760
23:15:46 1294 8192000000 10883564784 11285774336 1928776048 19.057 100 94 184 2 1965202048 9980432 26445568
23:15:58 3341 8192000000 10840386272 11272069120 1919083744 18.980 100 45 90 2 1940314976 8804368 12426864
23:16:09 6231 8192000000 10832555664 11264098304 1915914640 18.954 100 27 54 1 1930015696 6676032 7425024
23:16:23 5823 8192000000 10834847776 11268657152 1917010304 18.963 100 24 48 0 1930813968 6286992 7516672
23:16:35 4071 8192000000 10833833504 11268046848 1916003024 18.955 100 31 62 3 1935461904 10833520 8625360
23:16:45 4543 8192000000 10809034816 11246116864 1894638576 18.783 99 25 50 0 1912919600 11241920 7039104
23:16:59 9286 8192000000 10789192080 11220463616 1774792224 17.807 93 22 44 2 1790430592 9487040 6151328
23:17:14 7057 8192000000 10793522400 11225473024 1865513312 18.548 99 15 30 0 1875235872 5461328 4261232
23:17:31 9079 8192000000 10756780800 11180773376 1795464064 17.977 96 14 28 2 1804654272 5222512 3967696
23:17:48 13888 8192000000 10782767968 11212718080 1843052208 18.366 99 14 28 0 1851868336 5221440 3594688
23:18:11 8274 8192000000 10797719408 11222798336 1871236096 18.594 100 19 35 0 1882511728 5764672 5510960
23:18:26 8548 8192000000 10769762320 11201687552 1805048384 18.055 96 25 50 2 1817597584 4608000 7941200
23:18:42 48862 8192000000 10781383296 11208613888 1836183104 18.310 98 43 86 0 1855407456 6923088 12301264
23:19:37 10404 8192000000 10757409664 11190915072 1850260608 18.424 99 20 39 1 1861306656 5025968 6020080
23:19:54 10588 8192000000 10767030432 11192201216 1820005184 18.178 98 27 55 2 1833454976 5692896 7756896
23:20:14 7625 8192000000 10716109936 11138498560 1745307664 17.563 95 37 73 1 1762455984 6105360 11042960
23:20:30 5190 8192000000 10734437632 11146752000 1802527920 18.035 99 36 70 2 1819140768 7356736 9256112
23:20:41 12321 8192000000 10673949008 11080495104 1652767264 16.788 92 21 42 2 1664222992 5354352 6101376
23:21:00 7776 8192000000 10682516672 11098034176 1746975120 17.577 98 33 66 4 1762775920 6228624 9572176
23:21:14 7723 8192000000 10696321600 11110330368 1742920752 17.543 97 38 75 5 1760057792 5437072 11699968
23:21:29 9172 8192000000 10698246048 11107942400 1710122240 17.270 96 14 28 0 1723233696 9204976 3906480
23:21:49 6558 8192000000 10703502848 11120586752 1765390928 17.729 98 17 34 1 1774777456 4806464 4580064
23:22:04 6894 8192000000 10716880912 11136671744 1804628048 18.052 100 24 48 1 1817699680 5711536 7360096
23:22:21 9118 8192000000 10720639088 11149021184 1813901088 18.128 100 18 36 1 1824564192 5482864 5180240
23:22:39 12841 8192000000 10727389664 11155996672 1810795856 18.102 99 18 34 1 1820867248 4801472 5269920
23:23:01 61655 8192000000 10748970128 11173089280 1803476416 18.042 98 45 88 2 1821123824 5384000 12263408
23:24:13 11017 8192000000 10746084800 11176370176 1828476736 18.247 100 12 21 1 1837029904 5528656 3024512
23:24:36 5114 8192000000 10753547408 11178246144 1840182432 18.342 100 36 72 4 1857125584 6865392 10077760
23:24:50 8034 8192000000 10753578560 11179896832 1845008576 18.382 100 33 66 0 1861606208 6755904 9841728
23:25:05 6320 8192000000 10766156144 11189231616 1849989040 18.422 100 38 78 5 1867195264 5740400 11465824
23:25:18 8421 8192000000 10769753632 11195510784 1852540320 18.443 100 27 54 1 1865868544 5719952 7608272
23:25:35 6719 8192000000 10767848304 11195912192 1856218400 18.473 100 25 50 1 1868808608 5720320 6869888
23:25:50 6961 8192000000 10768767024 11197902848 1857193552 18.481 100 18 36 3 1869024768 5702976 6128240
23:26:06 10146 8192000000 10772904080 11206365184 1862356464 18.522 100 23 45 2 1874843952 5806912 6680576
23:26:23 8367 8192000000 10786858304 11204878336 1866253328 18.554 100 31 60 2 1881294528 5093632 9947568
23:26:37 9908 8192000000 10783420448 11214401536 1866763072 18.558 100 23 46 5 1882625776 9338944 6523760
23:26:58 16357 8192000000 10802833552 11229257728 1876933248 18.640 100 17 34 0 1887039680 5137792 4968640
23:27:24 13275 8192000000 10802373952 11231481856 1889066064 18.738 100 16 32 1 1898093440 4375968 4651408
23:27:44 28501 8192000000 10836200400 11250319360 1904561984 18.863 100 58 116 0 1927406848 6076752 16768112
23:28:22 11062 8192000000 10846915920 11262857216 1916186560 18.956 100 53 104 4 1938959616 7847728 14925328
23:28:41 96162 8192000000 10840020512 11274080256 1918260624 18.973 100 32 64 0 1936041760 8502800 9278336
23:30:32 3660 8192000000 10878579280 11296600064 1938802576 19.137 100 83 169 3 1976624752 14503616 23318560
23:30:45 16934 8192000000 10876663104 11302707200 1937419088 19.126 100 60 120 2 1966832688 12338784 17074816
23:31:09 3339 8192000000 10883523472 11306160128 1944710304 19.184 100 63 126 1 1975906528 13296528 17899696
23:31:26 1450 8192000000 10909421296 11320549376 1957515072 19.286 100 90 178 0 1995030288 12690400 24824816
23:31:36 6739 8192000000 10898515296 11318444032 1954244896 19.260 100 68 135 0 1986338992 12995200 19098896
23:31:50 3287 8192000000 10896831952 11316404224 1955683456 19.272 100 81 162 1 1992396656 13087616 23625584
23:32:01 5259 8192000000 10910091552 11320430592 1958233568 19.292 100 75 148 1 1992334816 13140992 20960256
23:32:15 15190 8192000000 10896816912 11322699776 1957823408 19.289 100 59 117 1 1987454080 13221312 16409360
23:32:39 10841 8192000000 10890177200 11330281472 1958348752 19.293 100 38 76 0 1980025856 10414576 11262528
23:33:03 13321 8192000000 10886025616 11321913344 1960028224 19.306 100 42 84 0 1982344512 9573280 12743008
23:33:27 3926 8192000000 10909889184 11334721536 1965730576 19.352 100 56 111 1 1993230320 10945936 16553808
23:33:38 4203 8192000000 10906610976 11334541312 1968346640 19.372 100 60 117 2 1996818384 12075312 16396432
23:33:57 11639 8192000000 10912401296 11346436096 1972408720 19.405 100 50 100 0 2001915200 15466848 14039632
23:34:20 5486 8192000000 10911629136 11344936960 1976242080 19.435 100 54 110 1 2002316864 10356624 15718160
23:34:33 11935 8192000000 10902287040 11336908800 1965935888 19.353 99 48 96 2 1990604016 9800624 14867504
23:34:52 8925 8192000000 10905780272 11326967808 1965383104 19.349 99 59 114 1 1993269904 11668784 16218016
23:35:12 10576 8192000000 10924209920 11348873216 1974858256 19.424 100 55 110 0 2003130208 12418368 15853584
23:35:30 7746 8192000000 10918016000 11346472960 1966615216 19.359 99 68 134 3 2000696576 14362224 19719136
23:35:54 7206 8192000000 10933789296 11361681408 1990687600 19.549 100 66 127 1 2024725600 15432800 18605200
23:36:18 11528 8192000000 10940439952 11371499520 1995585792 19.588 100 61 122 2 2030479840 16600512 18293536
23:36:38 10917 8192000000 10919662512 11361280000 1986296432 19.515 100 46 93 2 2016684928 16454432 13934064
23:36:58 3044 8192000000 10917753904 11347865600 1973804528 19.416 100 59 117 0 2006859024 15428832 17625664
23:37:09 5840 8192000000 10924272608 11351793664 1981311024 19.475 100 65 129 1 2017237680 16615152 19311504
23:37:32 16921 8192000000 10910218528 11349438464 1976718912 19.439 100 55 110 1 2011435216 18226208 16490096
23:38:03 7713 8192000000 10917932752 11345424384 1973633056 19.414 100 61 122 2 2009320544 17738848 17948640
23:38:17 7421 8192000000 10896289920 11325743104 1948728832 19.216 99 59 118 2 1984795920 18872464 17194624
23:38:36 5790 8192000000 10928771312 11345436672 1975404576 19.428 100 66 131 0 2015617184 20002128 20210480
23:38:49 12911 8192000000 10924826784 11354165248 1978714432 19.455 100 57 114 0 2018222656 21118656 18389568
23:39:09 2435 8192000000 10928355168 11347214336 1970322144 19.388 100 72 139 1 2014349584 22299024 21728416
23:39:20 3560 8192000000 10946187808 11365056512 1982873856 19.487 100 70 140 2 2027414816 23005536 21535424
23:39:31 6093 8192000000 10956891088 11378921472 1996818896 19.598 100 69 138 0 2041454672 23910400 20725376
23:39:44 3747 8192000000 10963841792 11384262656 2003255248 19.648 100 74 148 2 2052188384 26691040 22242096
23:39:57 10355 8192000000 10960539904 11386949632 2008467312 19.689 100 75 149 1 2053924144 22991968 22464864
23:40:17 10287 8192000000 10949815600 11380486144 1998571392 19.611 100 60 120 2 2040503808 23686128 18246288
23:40:36 5579 8192000000 10952169184 11389546496 1999103792 19.616 100 53 106 0 2045394368 29669472 16621104
23:40:51 6564 8192000000 10960645456 11394588672 2005257408 19.664 100 57 114 0 2047592640 24521568 17813664
23:41:06 13273 8192000000 10966710304 11399151616 2011234704 19.711 100 55 110 1 2055081760 26166896 17680160
23:41:26 5467 8192000000 10926446064 11354828800 1948800032 19.217 97 56 108 1 1992423728 25889072 17734624
23:41:42 6517 8192000000 10929170992 11358785536 1969900896 19.385 100 66 133 0 2018646960 28364832 20381232
23:41:57 3327 8192000000 10937263008 11359830016 1972855728 19.408 100 72 145 1 2021923376 26950288 22117360
23:42:09 3332 8192000000 10914550080 11323518976 1938792608 19.137 98 84 165 5 1992825264 28351360 25681296
23:42:21 2359 8192000000 10928300752 11338334208 1953982464 19.258 100 77 151 1 2006003584 28992928 23028192
23:42:34 3689 8192000000 10943502832 11361304576 1972234544 19.403 100 79 158 1 2028828400 31262912 25330944
23:42:45 4631 8192000000 10928800160 11347841024 1946377088 19.198 99 82 160 0 2002666160 32367424 23921648
23:42:59 8757 8192000000 10925279152 11333763072 1946233248 19.196 99 79 154 2 2003166112 33561872 23370992
23:43:16 2912 8192000000 10937209936 11356332032 1971305904 19.396 100 77 151 1 2022754688 27810976 23637808
23:43:28 2924 8192000000 10933643024 11348271104 1962957296 19.330 100 78 152 0 2016329536 29905136 23467104
23:43:37 4443 8192000000 10922676656 11343560704 1957958688 19.290 100 76 148 2 2010048080 28980864 23108528
23:43:52 30357 8192000000 10889601472 11323559936 1940800720 19.153 99 57 114 0 1986154560 27596224 17757616
23:44:48 8317 8192000000 10885087120 11323211776 1918098160 18.972 99 42 84 1 1957791072 26370944 13321968
23:45:06 7132 8192000000 10846505440 11279732736 1884001520 18.697 97 53 106 3 1922344976 22921952 15421504
23:45:29 6904 8192000000 10881061120 11313360896 1914932896 18.946 99 41 82 1 1956043552 28508192 12602464
23:45:54 4394 8192000000 10885197296 11304386560 1904957056 18.866 98 60 120 0 1954230192 30212720 19060416
23:46:07 6369 8192000000 10899176720 11321008128 1923913680 19.018 99 68 135 0 1974142736 29737056 20492000
23:46:23 7227 8192000000 10899690656 11320037376 1931193440 19.076 100 58 114 2 1978217184 29463136 17560608
23:46:40 3496 8192000000 10919629232 11329011712 1930575584 19.071 99 79 156 1 1986043616 30882496 24585536
23:46:51 2333 8192000000 10925470000 11336318976 1949062032 19.219 100 80 160 0 2008517328 33309856 26145440
23:47:01 4773 8192000000 10890812096 11313594368 1910649888 18.912 98 60 120 1 1963038496 34059408 18329200
23:47:14 3532 8192000000 10911365904 11333451776 1942808304 19.169 100 60 118 1 1996235744 34371280 19056160
23:47:28 3570 8192000000 10892472624 11316359168 1919767408 18.985 99 63 127 1 1975278528 36054944 19456176
23:47:42 12391 8192000000 10885226112 11319009280 1911732416 18.921 99 37 74 1 1958947680 34755568 12459696
23:48:01 9865 8192000000 10895179472 11330322432 1934102720 19.100 100 37 74 1 1980326576 33748784 12475072
23:48:23 10906 8192000000 10874353232 11311116288 1898576672 18.815 98 31 62 4 1945405936 36341760 10487504
23:48:41 4586 8192000000 10896984832 11331403776 1933337824 19.094 100 41 82 0 1982853984 36440736 13075424
23:48:53 8117 8192000000 10895945376 11320201216 1927087808 19.044 100 40 80 0 1974083440 33500528 13495104
23:49:09 6653 8192000000 10897412384 11324182528 1929959328 19.067 100 53 106 2 1980047760 33309376 16779056
23:49:23 8409 8192000000 10890940160 11321278464 1924179312 19.020 100 50 99 2 1974339504 34397216 15762976
23:49:43 6854 8192000000 10882881248 11308716032 1903067984 18.851 99 42 84 2 1949831184 32393760 14369440
23:49:57 16804 8192000000 10865326880 11313995776 1920665488 18.992 100 35 71 1 1965111136 32931040 11514608
23:50:24 20475 8192000000 10872408704 11310104576 1910602000 18.911 99 25 50 2 1944929776 26408560 7919216
23:50:51 10077 8192000000 10871970464 11312373760 1907779280 18.889 99 37 74 2 1950130080 30283568 12067232
23:51:24 13610 8192000000 10878295424 11326803968 1936666928 19.120 100 34 68 2 1980242816 33319040 10256848
23:52:07 26423 8192000000 10850656352 11290517504 1879571632 18.662 98 21 42 0 1915240192 28775424 6893136
23:52:44 30519 8192000000 10860315632 11304095744 1911966400 18.922 100 13 26 1 1944220080 27597136 4656544
23:53:22 14246 8192000000 10864895168 11302674432 1904512400 18.863 99 37 74 1 1942036704 26467808 11056496
23:53:51 38241 8192000000 10859501600 11288485888 1878991168 18.657 98 28 55 0 1907246272 20633504 7621600
23:54:36 20669 8192000000 10855468800 11298275328 1914356704 18.942 100 22 44 0 1940482400 19777744 6347952
23:55:06 6102 8192000000 10877854448 11314774016 1931713744 19.081 100 44 88 2 1966292640 20988432 13590464
23:55:45 5424 8192000000 10888252544 11322003456 1930148288 19.068 100 48 96 2 1972010736 26858928 15003520
23:55:59 3961 8192000000 10894247584 11332702208 1939289248 19.141 100 40 81 0 1981395504 29596848 12509408
23:56:10 5838 8192000000 10884468720 11333734400 1934473664 19.103 100 28 56 1 1973653344 29447312 9732368
23:56:46 41482 8192000000 10885462448 11329757184 1932788272 19.089 100 18 36 0 1962134864 23788656 5557936
23:57:34 25024 8192000000 10898987616 11348627456 1949516944 19.223 100 19 38 0 1983685328 28159216 6009168
23:58:09 34316 8192000000 10888510544 11339845632 1933660224 19.096 99 19 38 1 1961872240 22065136 6146880
23:58:50 49860 8192000000 10903806368 11358466048 1944164784 19.180 100 28 56 0 1985278288 31953168 9160336
23:59:54 23165 8192000000 10866461248 11329347584 1931710720 19.081 99 17 34 0 1959333440 22885760 4736960
00:00:36 87083 8192000000 10884819808 11343622144 1933430288 19.094 99 6 12 0 1943429216 9090464 908464
00:02:09 64432 8192000000 10884779808 11349692416 1925316080 19.029 98 8 16 0 1938541152 11285568 1939504
00:03:24 59084 8192000000 10931726784 11367288832 1964337984 19.341 100 33 65 0 1981041584 7926080 8777520
00:04:30 65433 8192000000 10910855584 11368529920 1984643408 19.501 100 42 81 1 2007089888 10276704 12169776
00:05:43 18508 8192000000 10919179808 11376508928 1980913408 19.472 100 22 45 1 1999488624 11814096 6761120
00:06:13 39664 8192000000 10947106080 11382546432 1998783984 19.613 100 59 115 3 2026704256 10212752 17707520
00:07:08 77507 8192000000 10911860224 11392872448 1970690512 19.391 99 12 24 1 1991178512 15999968 4488032
00:08:31 128720 8192000000 10936275664 11397922816 1990812304 19.550 100 28 57 0 2014998416 15930048 8256064
00:11:02 41997 8192000000 10929579456 11388915712 1993844976 19.574 100 21 43 2 2006202384 6625680 5731728
00:12:30 11942 8192000000 10940528528 11394355200 1983055760 19.489 99 38 77 1 2007688624 13660176 10972688
00:12:50 18850 8192000000 10953561760 11400933376 1988254048 19.530 99 56 109 1 2017605824 13393632 15958144
00:13:16 17434 8192000000 10941878464 11408592896 2000391264 19.626 100 26 52 0 2020016064 12165968 7458832
00:13:47 21426 8192000000 10960703968 11406266368 1992291440 19.562 99 50 98 1 2021633056 15079744 14261872
00:14:17 55043 8192000000 10916116080 11394019328 1977115152 19.442 99 25 50 2 1998590768 14067360 7408256
00:15:27 8145 8192000000 10939597904 11389673472 1992060672 19.560 100 45 91 3 2017838544 11763632 14014240
00:15:46 50391 8192000000 10935794944 11405217792 1996378800 19.594 100 21 42 1 2018260352 16205584 5675968
00:16:42 83068 8192000000 10922900896 11405651968 1985417328 19.508 99 9 18 0 1999559520 11378688 2763504
00:18:36 55495 8192000000 10907201568 11379757056 1971958880 19.401 99 11 22 1 1989654880 14066256 3629744
00:19:51 59172 8192000000 10917295088 11404701696 1992504512 19.564 100 15 30 0 2014326048 17405856 4415680
00:21:09 8218 8192000000 10912418192 11403862016 1988065024 19.529 100 8 16 0 2003335952 13049776 2221152
00:21:24 73549 8192000000 10921061168 11400495104 1961074928 19.315 98 14 28 0 1979421472 14492816 3853728
00:22:43 54094 8192000000 10898756176 11378257920 1929524176 19.063 97 16 32 1 1948103536 13949808 4629552
00:23:47 76653 8192000000 10916220144 11370770432 1911429456 18.918 96 30 60 2 1933013440 13104976 8479008
00:25:12 61440 8192000000 10893764272 11365253120 1906746768 18.881 97 12 24 0 1922194032 12229376 3217888
00:26:20 42900 8192000000 10905930928 11367604224 1952157520 19.244 99 32 64 0 1971810448 10848496 8804432
00:27:09 71578 8192000000 10901040752 11366936576 1914344672 18.942 97 21 42 2 1928884048 9441936 5097440
00:28:29 90601 8192000000 10877752848 11350761472 1836448096 18.312 93 13 26 0 1848686656 9072304 3166256
00:30:06 63067 8192000000 10856201184 11315490816 1832290832 18.278 93 21 42 1 1853281280 15472000 5518448
00:31:16 71466 8192000000 10854294544 11323764736 1845256368 18.384 95 13 26 1 1873038128 23483024 4298736
00:32:33 66234 8192000000 10847404928 11325399040 1808590688 18.084 94 10 20 1 1844066528 32032512 3443328
00:33:54 94256 8192000000 10849566448 11298013184 1702282576 17.204 88 25 50 1 1719818656 10786624 6749456
00:35:41 60766 8192000000 10833904640 11295797248 1890727456 18.752 99 19 38 0 1907825024 11502192 5595376
00:37:51 139403 8192000000 10819634560 11295387648 1780969168 17.857 92 18 36 1 1798415280 13009088 4437024
00:40:18 48740 8192000000 10847382672 11316834304 1894612624 18.783 99 25 50 2 1915901168 14020160 7268384
00:41:22 74946 8192000000 10865432112 11336282112 1935258656 19.109 100 23 46 1 1955886128 13797152 6830320
00:42:43 54153 8192000000 10861100912 11337560064 1935310400 19.109 100 20 41 1 1951253776 10195696 5747680
00:43:44 65160 8192000000 10852533104 11329802240 1907786208 18.889 98 18 36 0 1920796400 7365984 5644208
00:44:55 41153 8192000000 10856754800 11334004736 1932901040 19.090 100 14 28 0 1945709408 8139840 4668528
00:45:58 28048 8192000000 10869157952 11355734016 1946362112 19.197 100 14 28 1 1958545760 8141264 4042384
00:46:57 73671 8192000000 10878791232 11347075072 1907258048 18.885 98 22 44 1 1934090848 20194160 6638640
00:48:30 60008 8192000000 10863322384 11348467712 1921510208 18.999 99 22 44 0 1950638064 22285888 6841968
00:49:50 75890 8192000000 10852441872 11331190784 1903188080 18.852 99 7 14 1 1919173808 14125008 1860720
00:51:15 40665 8192000000 10873694688 11342663680 1941191184 19.156 100 33 66 2 1959796176 9793328 8811664
00:52:05 69535 8192000000 10873938224 11352166400 1925773504 19.033 99 20 40 3 1940202208 8858672 5570032
00:53:20 13589 8192000000 10887946688 11349487616 1949907904 19.226 100 37 74 0 1967001536 6385104 10708528
00:53:44 25465 8192000000 10904264992 11373223936 1963925120 19.337 100 34 68 1 1984809696 11198496 9686080
00:54:20 54503 8192000000 10892968704 11379326976 1964735664 19.344 100 19 38 1 1985101872 14901712 5464496
00:55:27 75211 8192000000 10907263280 11378110464 1954225056 19.260 99 28 55 2 1979225904 17161488 7839360
00:58:11 71492 8192000000 10906874800 11395928064 1983618832 19.493 100 17 34 0 2003938688 15797376 4522480
00:59:34 149417 8192000000 10932045072 11401691136 1935015808 19.107 97 13 26 3 1949907248 11376096 3515344
01:02:09 31871 8192000000 10952801328 11415699456 2000474000 19.626 100 34 68 1 2021364624 11265984 9624640
01:02:48 55801 8192000000 10926064528 11412914176 1977245216 19.443 99 21 42 0 1999060512 15778288 6037008
01:03:52 83508 8192000000 10924942496 11407712256 1977578320 19.446 99 13 26 0 2000581360 19368160 3634880
01:05:54 103255 8192000000 10931651312 11401007104 1982648048 19.486 99 33 66 2 2000052336 8370896 9033392
01:07:45 29865 8192000000 10940064400 11402936320 1998013536 19.607 100 44 88 0 2019567216 9650176 11903504
01:08:29 32707 8192000000 10917335616 11392569344 1979560480 19.461 99 37 74 1 2000961968 10884848 10516640
01:09:11 41243 8192000000 10906675856 11387924480 1934426096 19.102 97 22 44 0 1949621088 8873552 6321440
01:09:59 80815 8192000000 10902110608 11390681088 1927497584 19.047 97 12 24 0 1951856432 20800768 3558080
01:11:26 53299 8192000000 10889647616 11381170176 1929887296 19.066 98 8 14 1 1946878288 14543984 2447008
01:12:35 53539 8192000000 10904121280 11379154944 1967116976 19.363 100 17 34 0 1986291488 14648592 4525920
01:13:35 57150 8192000000 10895949584 11378802688 1971018256 19.394 100 11 22 3 1986631344 12609680 3003408
01:14:38 80835 8192000000 10886336080 11370246144 1897899728 18.809 96 27 53 1 1920845328 15561200 7384400
01:16:05 74267 8192000000 10858682400 11322789888 1848428992 18.409 95 13 26 0 1870616176 18198896 3988288
01:17:31 49226 8192000000 10842743168 11304701952 1829405552 18.254 95 15 30 2 1843563584 10364208 3793824
01:18:37 29173 8192000000 10864561088 11318808576 1892436304 18.765 98 33 66 2 1911414416 9907856 9070256
01:19:14 46311 8192000000 10873058048 11335897088 1926861776 19.042 100 35 68 0 1950100112 13123648 10114688
01:20:07 51483 8192000000 10830848432 11300483072 1835133104 18.301 95 35 70 3 1860036544 15188752 9714688
01:21:04 35901 8192000000 10865569600 11328610304 1923094672 19.012 100 21 42 0 1941304832 12250464 5959696
01:22:14 57242 8192000000 10834218736 11308445696 1849083808 18.415 96 15 30 0 1866375792 13266256 4025728
01:23:24 26309 8192000000 10867693584 11323809792 1886212992 18.715 98 26 51 0 1904176704 10852528 7111184
01:23:56 15283 8192000000 10869467712 11318788096 1885416848 18.709 98 40 80 1 1915800672 19376704 11007120
01:24:23 46264 8192000000 10857123360 11324362752 1866602912 18.557 97 32 64 4 1895062656 19394960 9064784
01:25:19 59019 8192000000 10865385424 11347238912 1893714768 18.776 99 17 34 0 1927411248 29480016 4216464
01:26:24 80544 8192000000 9180391920 9422622720 335025760 3.928 18 2 4 0 342860736 7312720 522256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 20-06-2021 01:28:29 to 20-06-2021 01:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

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

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          245950
MON$OLDEST_ACTIVE               245951
MON$OLDEST_SNAPSHOT             245951
MON$NEXT_TRANSACTION            245951
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                       2051488
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
--- end of diff output ---

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

20.06.21 01:29:04. 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-06-20 01:29:07 No severe PSQL-related problems occured
20.06.21 01:29:08. End of report.