Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.01.2021 22: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 17255456 kB
MemAvailable 31373832 kB
Buffers 0 kB
Cached 14475704 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-16 22:27:12
DTS_END                         2021-01-16 22:27:12.9380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55810
TRN_ID                          245859
ATT_ID                          658
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: 9289.23 17105 1114707
customer order: creation 183.53 325 22023
customer order: refuse 15.55 357 1866
order to supplier: creation 48.61 1287 5833
order to supplier: removal 3.55 82698 426
invoice (draft): creation 48.71 3361 5845
invoice (draft): removal 50.32 682 6038
invoice accept: apply 43.29 17900 5195
invoice accept: cancel 45.33 766 5440
customer reserve: creation 4006.73 178 480807
customer reserve: removal 4546.29 50 545555
realization accept: apply 87.67 167 10520
realization accept: cancel 74.42 106 8930
payment from customer: creation 61.84 101 7421
payment from customer: removal 5.81 59 697
payment to supplier: creation 50.78 112 6093
payment to supplier: removal 3.77 81 452
service: total inventory turnovers 4.87 1087 584
service: total monetary turnovers 7.30 33 876
service: aggregate perf. data 0.85 20972 102
service: refresh index statistics 0.03 211780 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-01-2021 22:29:15 to 16-01-2021 22:29:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6533
TEST_TIME 2 5305
TEST_TIME 3 6063
TEST_TIME 4 7496
TEST_TIME 5 6603
TEST_TIME 6 6275
TEST_TIME 7 6361
TEST_TIME 8 6358
TEST_TIME 9 6890
TEST_TIME 10 6913
TEST_TIME 11 6832
TEST_TIME 12 6858
TEST_TIME 13 6925
TEST_TIME 14 6902
TEST_TIME 15 7508
TEST_TIME 16 7680
TEST_TIME 17 7614
TEST_TIME 18 7628
TEST_TIME 19 7902
TEST_TIME 20 8221
TEST_TIME 21 8272
TEST_TIME 22 8258
TEST_TIME 23 8467
TEST_TIME 24 8643
TEST_TIME 25 8675
TEST_TIME 26 8663
TEST_TIME 27 8731
TEST_TIME 28 9034
TEST_TIME 29 9574
TEST_TIME 30 10073
TEST_TIME 31 10075
TEST_TIME 32 10057
TEST_TIME 33 10047
TEST_TIME 34 10018
TEST_TIME 35 9874
TEST_TIME 36 9953
TEST_TIME 37 9994
TEST_TIME 38 9959
TEST_TIME 39 10137
TEST_TIME 40 10136
TEST_TIME 41 9902
TEST_TIME 42 9729
TEST_TIME 43 9829
TEST_TIME 44 9695
TEST_TIME 45 9645
TEST_TIME 46 9555
TEST_TIME 47 9652
TEST_TIME 48 9582
TEST_TIME 49 9609
TEST_TIME 50 9600
TEST_TIME 51 9556
TEST_TIME 52 9429
TEST_TIME 53 9379
TEST_TIME 54 9318
TEST_TIME 55 9402
TEST_TIME 56 9376
TEST_TIME 57 9318
TEST_TIME 58 9475
TEST_TIME 59 9491
TEST_TIME 60 9465
TEST_TIME 61 9457
TEST_TIME 62 9560
TEST_TIME 63 9507
TEST_TIME 64 9528
TEST_TIME 65 9685
TEST_TIME 66 9679
TEST_TIME 67 9679
TEST_TIME 68 9669
TEST_TIME 69 9771
TEST_TIME 70 9797
TEST_TIME 71 9667
TEST_TIME 72 9583
TEST_TIME 73 9506
TEST_TIME 74 9508
TEST_TIME 75 9496
TEST_TIME 76 9462
TEST_TIME 77 9416
TEST_TIME 78 9374
TEST_TIME 79 9330
TEST_TIME 80 9315
TEST_TIME 81 9284
TEST_TIME 82 9338
TEST_TIME 83 9343
TEST_TIME 84 9392
TEST_TIME 85 9388
TEST_TIME 86 9422
TEST_TIME 87 9423
TEST_TIME 88 9413
TEST_TIME 89 9417
TEST_TIME 90 9423
TEST_TIME 91 9459
TEST_TIME 92 9488
TEST_TIME 93 9549
TEST_TIME 94 9494
TEST_TIME 95 9414
TEST_TIME 96 9399
TEST_TIME 97 9423
TEST_TIME 98 9417
TEST_TIME 99 9381
TEST_TIME 100 9329
TEST_TIME 101 9272
TEST_TIME 102 9219
TEST_TIME 103 9239
TEST_TIME 104 9260
TEST_TIME 105 9236
TEST_TIME 106 9310
TEST_TIME 107 9319
TEST_TIME 108 9343
TEST_TIME 109 9333
TEST_TIME 110 9330
TEST_TIME 111 9319
TEST_TIME 112 9308
TEST_TIME 113 9406
TEST_TIME 114 9410
TEST_TIME 115 9466
TEST_TIME 116 9434
TEST_TIME 117 9456
TEST_TIME 118 9389
TEST_TIME 119 9360
TEST_TIME 120 9292

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-01-2021 22:29:19 to 16-01-2021 22:29: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 1559892 1559892 0 0.00 0 15408 6 0 0
doc_list_biud 1559891 1559891 0 0.00 0 25533 23 0 0
sp_add_invoice_to_stock 5290 5195 95 1.79 38 220962 17901 0 95
sp_cancel_adding_invoice 5440 5440 0 0.00 6 62296 767 0 0
sp_cancel_client_order 1866 1866 0 0.00 4 14564 357 0 0
sp_cancel_customer_reserve 545555 545555 0 0.00 1 25567 51 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 2 2855 60 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 2 6009 82 0 0
sp_cancel_supplier_invoice 6047 6038 9 0.14 2 17811 682 0 9
sp_cancel_supplier_order 426 426 0 0.00 7 836203 82699 0 0
sp_cancel_write_off 8930 8930 0 0.00 1 18012 107 0 0
sp_client_order 22023 22023 0 0.00 3 88342 325 0 0
sp_customer_reserve 480807 480807 0 0.00 0 82315 179 0 0
sp_fill_shopping_cart 33700 33700 0 0.00 1 10324 38 0 0
sp_fill_shopping_cart_clo_res 480803 480803 0 0.00 0 14607 12 0 0
sp_get_clo_for_invoice 5190 5190 0 0.00 0 33465 281 0 0
sp_kill_cost_storno 15519 15519 0 0.00 0 6075 49 0 0
sp_kill_qstorno_ret_qs2qd 1106504 1106504 0 0.00 0 25506 28 0 0
sp_kill_qty_storno 583965 583965 0 0.00 0 25532 61 0 0
sp_lock_selected_doc 21757 21757 0 0.00 0 6658 3 0 0
sp_make_cost_storno 29224 29224 0 0.00 0 12767 46 0 0
sp_multiply_rows_for_pdistr 29224 29224 0 0.00 0 12599 29 0 0
sp_multiply_rows_for_qdistr 22023 22023 0 0.00 0 88330 141 0 0
sp_pay_from_customer 7421 7421 0 0.00 4 12608 101 0 0
sp_pay_to_supplier 6093 6093 0 0.00 4 9681 113 0 0
sp_payment_common 13514 13514 0 0.00 1 7888 22 0 0
sp_qd_handle_on_cancel_clo 1866 1866 0 0.00 0 14557 333 0 0
sp_qd_handle_on_invoice_upd_sts 10630 10630 0 0.00 0 23884 302 0 0
sp_qd_handle_on_reserve_upd_sts 10520 10520 0 0.00 0 19311 61 0 0
sp_reserve_write_off 10520 10520 0 0.00 6 19327 168 0 0
sp_supplier_invoice 5845 5845 0 0.00 6 68009 3362 0 0
sp_supplier_order 5833 5833 0 0.00 5 28347 1287 0 0
srv_aggregate_perf_data 102 102 0 0.00 3338 205044 20973 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1066 170701 30934 0 0
srv_find_qd_qs_mism 1064599 1064599 0 0.00 0 10642 6 0 0
srv_make_invnt_saldo 584 584 0 0.00 23 78076 1088 0 0
srv_make_money_saldo 876 876 0 0.00 1 6309 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 179906 242057 211780 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5195 5195 0 0.00 0 19201 169 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 1 4107 90 0 0
t$perf-norm:sp_cancel_client_order 1866 1866 0 0.00 0 2902 13 0 0
t$perf-norm:sp_cancel_customer_reserve 719 719 0 0.00 0 623 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 2998 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 3182 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 871 9 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 27530 1524 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 2909 15 0 0
t$perf-norm:sp_client_order 22023 22023 0 0.00 0 21921 20 0 0
t$perf-norm:sp_customer_reserve 962 962 0 0.00 0 10259 26 0 0
t$perf-norm:sp_pay_from_customer 7421 7421 0 0.00 0 5888 9 0 0
t$perf-norm:sp_pay_to_supplier 6093 6093 0 0.00 0 5845 13 0 0
t$perf-norm:sp_reserve_write_off 10520 10520 0 0.00 0 9259 11 0 0
t$perf-norm:sp_supplier_invoice 5845 5845 0 0.00 0 4240 21 0 0
t$perf-norm:sp_supplier_order 5833 5833 0 0.00 0 4416 18 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 676 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 367 8 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 6641 33 0 0
t$perf-norm:srv_make_money_saldo 876 876 0 0.00 0 4063 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10570 10380 190 1.79 0 7478 18 0 190
v_all_customers 39682 39682 0 0.00 0 19 1 0 0
v_all_suppliers 32108 32108 0 0.00 0 22 1 0 0
v_all_wares 44046 44046 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 586 7 0 0
v_cancel_client_order 3732 3732 0 0.00 0 1631 6 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 1742 7 0 0
v_cancel_customer_reserve 1438 1438 0 0.00 0 3603 9 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 3024 11 0 0
v_cancel_supplier_invoice 876 858 18 2.05 0 3015 21 0 18
v_cancel_supplier_order 852 852 0 0.00 0 1582 6 0 0
v_cancel_write_off 2044 2044 0 0.00 0 4242 16 0 0
v_max_id_clo_ord 5832 5832 0 0.00 0 584 1 0 0
v_max_id_clo_res 962 962 0 0.00 0 4342 24 0 0
v_max_id_ord_sup 5845 5845 0 0.00 0 2554 4 0 0
v_max_non_paid_invoice 1716 1716 0 0.00 0 428 2 0 0
v_max_non_paid_realizn 4077 4077 0 0.00 0 6609 8 0 0
v_min_id_clo_ord 5832 5832 0 0.00 0 2381 7 0 0
v_min_id_clo_res 962 962 0 0.00 0 5150 13 0 0
v_min_id_ord_sup 5845 5845 0 0.00 0 4711 8 0 0
v_min_non_paid_invoice 6093 6093 0 0.00 0 5967 14 0 0
v_min_non_paid_realizn 7421 7421 0 0.00 0 4916 12 0 0
v_our_firm 11052 11052 0 0.00 0 20 1 0 0
v_reserve_write_off 21040 21040 0 0.00 0 4928 6 0 0
x_lock_depdocs_on_canc_invoice 11049 11049 0 0.00 0 18340 125 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 3055 260 0 0
x_make_qstorno_1000_1200 5833 5833 0 0.00 2 28329 1201 0 0
x_make_qstorno_1200_2000 5845 5845 0 0.00 3 63674 3224 0 0
x_make_qstorno_2100_3300 480807 480807 0 0.00 0 82313 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-01-2021 22:29:23 to 16-01-2021 22:29: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
19:57:16 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 13387 8192000000 10186380304 10484269056 815106784 9.049 66 52 104 0 835215440 2429008 17679648
19:57:45 19326 8192000000 10313356592 10625069056 1350771184 14.154 100 84 167 2 1382847920 4238704 27838032
19:58:14 9115 8192000000 10341042432 10655367168 1399750496 14.593 100 90 180 0 1434709792 5688304 29270992
19:58:39 29404 8192000000 10371281248 10694397952 1416495952 14.742 100 81 162 0 1450020128 6582496 26941680
19:59:19 16800 8192000000 10404355312 10728439808 1455020192 15.082 100 94 188 0 1493207520 7495776 30691552
19:59:44 24322 8192000000 10418004336 10745200640 1468343360 15.199 100 87 174 0 1504556864 8092592 28120912
20:00:25 15582 8192000000 10433738880 10763849728 1487351728 15.366 100 92 183 1 1525475440 8898480 29225232
20:00:57 7099 8192000000 10443325504 10776350720 1500517552 15.481 100 92 184 0 1539003248 9296560 29189136
20:01:19 15092 8192000000 10464677776 10804056064 1520490000 15.654 100 80 160 0 1554383328 9356640 24536688
20:01:50 17372 8192000000 10496004928 10844872704 1548939376 15.901 100 73 146 0 1580698160 9806544 21952240
20:02:17 10067 8192000000 10515816832 10866921472 1579033488 16.160 100 77 154 2 1612777392 10341744 23402160
20:02:44 12516 8192000000 10550274720 10902196224 1606930704 16.399 100 86 174 0 1644169280 11224912 26013664
20:03:08 13267 8192000000 10577635312 10934968320 1624379648 16.547 100 83 166 1 1661268240 12219200 24669392
20:03:30 11145 8192000000 10597253840 10957242368 1650322096 16.767 100 80 160 0 1685837808 12258960 23256752
20:03:51 8670 8192000000 10618922976 10983702528 1670347856 16.936 100 82 163 0 1706593008 12472432 23772720
20:04:08 10882 8192000000 10642105232 11012513792 1701893904 17.201 100 76 152 3 1736126160 12282880 21949376
20:04:27 8336 8192000000 10667771328 11036495872 1720464608 17.356 100 81 162 0 1756412000 12422912 23524480
20:04:45 6816 8192000000 10666525072 11042021376 1736320336 17.488 100 83 166 1 1772354576 13061952 22972288
20:04:59 6044 8192000000 10681883728 11058360320 1743636272 17.549 100 75 150 2 1777359104 12711264 21011568
20:05:15 4704 8192000000 10695643936 11071488000 1751909664 17.617 100 78 153 1 1786196016 13127792 21158560
20:05:28 3659 8192000000 10707781616 11085443072 1762515456 17.705 100 81 159 2 1798151568 13192384 22443728
20:05:39 4279 8192000000 10719309168 11099684864 1776226480 17.818 100 74 148 1 1810908384 13090064 21591840
20:05:51 5430 8192000000 10733833440 11108933632 1784644256 17.888 100 87 172 0 1822899472 14273136 23982080
20:06:03 4102 8192000000 10733372432 11113426944 1794172192 17.966 100 82 164 1 1830825328 13698464 22954672
20:06:14 2109 8192000000 10745247472 11124371456 1801795280 18.029 100 91 178 1 1841544224 15164384 24584560
20:06:22 3522 8192000000 10750767792 11129774080 1804390672 18.050 100 86 172 4 1842718496 14379328 23948496
20:06:32 4082 8192000000 10741057696 11125932032 1803837280 18.045 100 78 155 3 1839673392 14155744 21680368
20:06:43 5221 8192000000 10758087680 11145347072 1813745104 18.127 100 87 171 4 1850668496 13323072 23600320
20:06:55 1684 8192000000 10771907360 11153776640 1831948880 18.275 100 87 174 0 1869722880 12372880 25401120
20:07:04 2785 8192000000 10774317424 11158163456 1833523456 18.288 100 86 172 1 1869961392 13028960 23408976
20:07:13 2711 8192000000 10774776880 11165241344 1836750080 18.314 100 84 168 0 1874861952 13754432 24357440
20:07:22 2167 8192000000 10788159824 11177287680 1844386608 18.376 100 86 173 0 1882684400 13934272 24363520
20:07:31 1279 8192000000 10792007040 11177803776 1848194208 18.407 100 90 180 1 1888074384 14338784 25541392
20:07:39 1291 8192000000 10798459632 11184013312 1853757632 18.453 100 92 182 1 1892989328 13701520 25530176
20:07:46 1734 8192000000 10806013280 11192999936 1859291248 18.498 100 93 186 1 1897961360 12791680 25878432
20:07:55 2243 8192000000 10801267920 11189334016 1858697184 18.493 100 90 179 4 1898121248 12796224 26627840
20:08:03 2434 8192000000 10807945184 11196698624 1865869248 18.551 100 93 188 1 1905271008 13394768 26006992
20:08:12 2728 8192000000 10811147808 11198627840 1866517232 18.556 100 93 188 0 1907113120 14635888 25960000
20:08:22 1528 8192000000 10814827632 11201056768 1866079360 18.553 100 91 175 0 1904745792 12547840 26118592
20:08:29 1834 8192000000 10812664320 11201503232 1868562368 18.573 100 95 191 2 1907776384 12464688 26749328
20:08:37 18702 8192000000 10792074400 11195240448 1862774304 18.526 100 60 116 3 1888505312 8136064 17594944
20:09:03 1313 8192000000 10802578640 11209232384 1876638064 18.638 100 70 139 0 1910503360 14497456 19367840
20:09:13 5491 8192000000 10791996432 11204747264 1869542768 18.581 100 50 100 0 1893238544 10194704 13501072
20:09:25 6387 8192000000 10792400176 11213807616 1871566752 18.597 100 42 84 0 1896705120 13753424 11384944
20:09:40 5237 8192000000 10779219904 11207081984 1877057216 18.641 100 52 105 0 1899734336 7918672 14758448
20:09:53 3877 8192000000 10793822800 11213475840 1876303776 18.635 100 40 77 1 1894598176 7740752 10553648
20:10:07 11755 8192000000 10772398960 11205976064 1874655840 18.622 100 32 64 3 1891667840 7937664 9074336
20:10:27 3955 8192000000 10789921952 11214114816 1876077136 18.633 100 38 76 1 1898659824 11332240 11250448
20:10:42 16954 8192000000 10806479344 11220848640 1877917472 18.648 100 24 49 0 1891097648 6382976 6797200
20:11:05 64380 8192000000 10814539056 11237761024 1889884192 18.745 100 58 115 1 1912856528 6438560 16533776
20:12:17 5331 8192000000 10813919296 11241582592 1894804800 18.784 100 58 116 1 1921026752 9533072 16688880
20:12:29 9866 8192000000 10797302496 11233931264 1887911792 18.729 100 20 40 2 1899055904 5545552 5598560
20:12:45 2558 8192000000 10817808432 11244654592 1894087392 18.779 100 43 86 3 1913073104 6458400 12527312
20:12:54 8413 8192000000 10810017520 11242827776 1897595792 18.807 100 30 60 1 1912763200 6676928 8490480
20:13:10 7266 8192000000 10805296896 11239976960 1894910432 18.785 100 25 50 1 1909061680 6508464 7642784
20:13:29 4582 8192000000 10813915280 11246469120 1895832736 18.793 100 25 50 0 1908780960 6160016 6788208
20:13:41 5807 8192000000 10815806672 11247030272 1896595872 18.799 100 22 43 2 1908183120 5738832 5848416
20:13:54 6040 8192000000 10812034000 11244339200 1896818656 18.801 100 22 44 3 1908789584 5475056 6495872
20:14:08 8215 8192000000 10803328976 11243216896 1897459056 18.806 100 18 36 2 1909024016 6116288 5448672
20:14:25 10698 8192000000 10809105408 11248590848 1901782416 18.841 100 19 37 0 1913227424 6012096 5432912
20:14:45 9323 8192000000 10825549168 11256909824 1903732256 18.856 100 20 40 0 1914522992 5297024 5493712
20:15:06 7220 8192000000 10817633152 11253616640 1903220800 18.852 100 20 40 1 1914786048 5608848 5956400
20:15:21 66167 8192000000 10831504160 11259977728 1886232416 18.715 99 35 68 4 1906679296 10026144 10420736
20:16:40 11912 8192000000 10808339600 11252920320 1902400080 18.846 100 11 22 0 1911104816 5698800 3005936
20:16:58 9041 8192000000 10800953344 11242967040 1878536720 18.653 99 15 30 1 1888674480 6020736 4117024
20:17:14 7555 8192000000 10792967392 11225759744 1856784208 18.477 98 28 56 2 1871637936 6615536 8238192
20:17:30 5719 8192000000 10761403056 11185537024 1803338848 18.041 96 32 65 1 1818650448 6387280 8924320
20:17:43 11590 8192000000 10780804320 11211079680 1850001776 18.422 99 32 62 3 1865295680 6634272 8659632
20:18:07 14071 8192000000 10788097328 11221983232 1822613504 18.199 97 10 20 1 1830536112 5060720 2861888
20:18:30 10690 8192000000 10785432432 11218395136 1870610352 18.589 100 23 45 2 1882407280 5693280 6103648
20:18:51 8676 8192000000 10756548864 11183046656 1784067488 17.883 96 26 52 2 1797282880 5729536 7485856
20:19:07 8496 8192000000 10756065664 11179708416 1807731280 18.077 98 20 41 1 1818692528 5667456 5293792
20:19:21 8816 8192000000 10727674640 11148185600 1770363088 17.770 96 26 52 2 1782540912 5388384 6789440
20:19:41 10219 8192000000 10703388288 11128193024 1701870560 17.201 94 12 22 1 1709221664 4791264 2559840
20:19:57 62847 8192000000 10681921664 11102269440 1684578816 17.056 93 37 74 2 1700363088 5468384 10315888
20:21:12 8756 8192000000 10724704608 11147350016 1807664128 18.077 100 32 62 4 1826262960 10591264 8007568
20:21:28 4669 8192000000 10722119616 11135119360 1791106896 17.941 99 46 90 4 1811030512 6492688 13430928
20:21:39 4137 8192000000 10731375984 11143651328 1790422224 17.935 99 40 80 0 1813016352 11285168 11308960
20:21:50 7868 8192000000 10709713520 11114516480 1742738384 17.541 96 32 63 3 1758124736 5590800 9795552
20:22:04 6107 8192000000 10701252192 11121201152 1733253456 17.463 96 29 58 0 1751659168 10328480 8077232
20:22:18 5215 8192000000 10712387568 11129602048 1781185712 17.859 99 25 48 3 1793099072 5262384 6650976
20:22:30 4757 8192000000 10733012096 11144998912 1809076704 18.088 100 42 83 0 1828567600 7802416 11688480
20:22:42 6765 8192000000 10733328400 11153727488 1812440752 18.116 100 24 46 5 1825790000 6044224 7305024
20:22:56 8345 8192000000 10713940256 11144536064 1788228944 17.917 98 26 52 0 1802298512 5981728 8087840
20:23:11 10050 8192000000 10737828016 11161563136 1811857168 18.111 99 31 62 1 1827408864 5628560 9923136
20:23:28 6304 8192000000 10742838656 11171299328 1833948992 18.292 100 21 42 2 1845151712 5089504 6113216
20:23:40 11350 8192000000 10759357296 11182075904 1842421440 18.361 100 28 55 2 1857233664 5634224 9178000
20:23:58 10525 8192000000 10763458128 11188006912 1845685552 18.387 100 20 40 1 1857459952 4859200 6915200
20:24:17 16533 8192000000 10757551600 11190378496 1851768240 18.436 100 16 32 0 1862038096 5559040 4710816
20:24:42 69519 8192000000 10770881600 11202908160 1856743408 18.477 100 26 50 3 1868968784 5149232 7076144
20:26:06 9285 8192000000 10780575264 11206864896 1865271392 18.546 100 34 68 0 1881687024 6711280 9704352
20:26:25 8531 8192000000 10790961440 11215941632 1871121392 18.593 100 30 60 3 1886503040 6919392 8462256
20:26:39 11012 8192000000 10801235616 11220541440 1869782896 18.583 100 31 62 1 1885345152 7045376 8516880
20:27:00 5240 8192000000 10787371440 11218923520 1876310272 18.635 100 25 50 1 1888950656 5693248 6947136
20:27:12 5075 8192000000 10818450144 11237916672 1890651488 18.751 100 31 58 2 1903342752 4988064 7703200
20:27:26 34265 8192000000 10827687904 11248697344 1901041280 18.835 100 38 76 2 1922448912 11248144 10159488
20:28:08 5862 8192000000 10839627024 11258236928 1909344352 18.901 100 45 89 1 1928850976 7270864 12235760
20:28:48 55359 8192000000 10849217408 11281006592 1919023008 18.979 100 42 82 0 1939281472 9019888 11238576
20:29:51 8832 8192000000 10855561888 11280240640 1926921488 19.042 100 37 74 0 1949039184 11891104 10226592
20:30:09 15885 8192000000 10859823888 11289792512 1931546784 19.079 100 41 82 3 1955072912 11722032 11804096
20:30:35 12593 8192000000 10879769888 11303993344 1940272816 19.149 100 47 94 0 1968923296 15696720 12953760
20:30:56 1282 8192000000 10902780528 11309080576 1949995248 19.226 100 84 166 3 1987031856 12873152 24163456
20:31:04 8159 8192000000 10887491136 11311022080 1948626432 19.216 100 57 115 1 1979568272 13946720 16995120
20:31:20 37875 8192000000 10875540064 11313774592 1949956080 19.226 100 43 86 2 1972745280 10806064 11983136
20:32:08 16580 8192000000 10906632416 11329396736 1960325616 19.309 100 62 122 1 1989507472 11777904 17403952
20:32:39 6151 8192000000 10911134208 11333427200 1965857136 19.353 100 61 121 1 1996928368 13903488 17167744
20:32:52 24171 8192000000 10910983072 11334889472 1969282752 19.380 100 63 126 1 2001772176 14658272 17831152
20:33:26 10565 8192000000 10904237168 11334275072 1967379216 19.365 100 48 94 1 1996333824 15164880 13789728
20:33:47 11382 8192000000 10896054480 11326275584 1958940576 19.298 100 53 106 1 1988307744 13866528 15500640
20:34:09 12185 8192000000 10896788128 11330015232 1962100160 19.323 100 43 86 2 1988923344 14378416 12444768
20:34:30 31533 8192000000 10887153968 11323916288 1927329344 19.046 98 33 66 3 1951956624 14701680 9925600
20:35:10 4301 8192000000 10909226752 11333861376 1962306464 19.324 100 51 102 2 1993153120 15794880 15051776
20:35:22 4020 8192000000 10910227056 11340025856 1970031120 19.386 100 56 112 1 2003053408 17136432 15885856
20:35:32 2101 8192000000 10930648848 11353808896 1976761424 19.439 100 68 135 2 2014872576 17655136 20456016
20:35:42 1531 8192000000 10938180688 11357745152 1981807328 19.479 100 75 149 3 2022690704 19195664 21687712
20:35:55 7216 8192000000 10943188432 11367673856 1984293824 19.499 100 65 129 0 2023563104 20732816 18536464
20:36:10 3523 8192000000 10943285680 11363610624 1989133808 19.537 100 80 160 2 2027813312 15948096 22731408
20:36:23 22446 8192000000 10922098736 11359924224 1981535296 19.477 100 57 114 1 2013556544 15747872 16273376
20:37:09 19108 8192000000 10905621600 11350614016 1958529072 19.294 99 35 70 1 1980593888 11682800 10382016
20:37:45 9963 8192000000 10896188224 11338604544 1967024880 19.362 100 43 84 4 1990036048 10923200 12087968
20:38:08 11976 8192000000 10906870096 11342503936 1968513872 19.374 100 54 106 0 1999984208 14963088 16507248
20:38:27 6944 8192000000 10900263792 11332136960 1943569968 19.175 99 49 98 0 1974493056 16435216 14487872
20:38:44 5152 8192000000 10905017072 11336658944 1962991568 19.330 100 49 98 0 1990986784 13444592 14550624
20:38:58 6568 8192000000 10894887792 11325927424 1930760544 19.073 98 55 110 1 1961901776 14981216 16160016
20:39:12 4662 8192000000 10906371120 11335077888 1963803856 19.336 100 58 115 2 1997347936 16774912 16769168
20:39:25 24793 8192000000 10921642096 11353890816 1974246912 19.419 100 55 108 2 2005429088 15417856 15764320
20:39:56 4701 8192000000 10916663792 11352821760 1981106352 19.473 100 54 104 1 2013802608 16326912 16369344
20:40:09 3854 8192000000 10925278432 11358801920 1976888912 19.440 100 57 112 3 2014549488 20349504 17311072
20:40:25 6661 8192000000 10923581600 11356336128 1976412208 19.436 100 53 105 2 2006694080 14035120 16246752
20:40:46 6877 8192000000 10910002864 11335430144 1953173536 19.252 99 53 107 1 1985785920 15786544 16825840
20:41:03 5119 8192000000 10939192272 11361230848 1983127808 19.489 100 67 127 1 2020154544 16852256 20174480
20:41:15 4291 8192000000 10922428368 11345145856 1967128592 19.363 99 67 132 0 2006583536 19456672 19998272
20:41:26 2640 8192000000 10927806608 11347902464 1972220128 19.403 100 77 151 0 2015559312 21107264 22231920
20:41:37 1098 8192000000 10933649152 11340800000 1960414144 19.309 99 92 182 3 2009429264 22651792 26363328
20:41:44 3229 8192000000 10936912672 11353518080 1972714080 19.407 100 82 163 1 2021499792 24011216 24774496
20:41:55 3461 8192000000 10940458224 11362914304 1979420656 19.460 100 71 142 1 2025762784 25033520 21308608
20:42:06 7138 8192000000 10906281424 11321188352 1934973456 19.107 98 61 121 0 1978221424 24801856 18446112
20:42:26 3655 8192000000 10927410576 11347197952 1951169040 19.236 99 79 155 2 1997455248 23576944 22709264
20:42:38 4425 8192000000 10932792112 11345358848 1967984960 19.369 100 67 134 1 2014180688 25146784 21048944
20:42:52 2751 8192000000 10937833888 11362672640 1980327936 19.467 100 82 164 2 2034564480 28701728 25534816
20:43:01 1064 8192000000 10928631168 11349704704 1971186496 19.395 100 75 146 2 2012356896 18392320 22778080
20:43:12 1976 8192000000 10928209456 11347550208 1968478432 19.373 100 76 151 3 2011179536 19332944 23368160
20:43:28 1555 8192000000 10932883200 11354517504 1975553648 19.429 100 72 142 2 2018142048 19746352 22842048
20:43:38 1587 8192000000 10920393840 11343286272 1962738416 19.328 99 68 135 2 2008599440 24246352 21614672
20:43:48 11759 8192000000 10915367104 11354914816 1966152560 19.355 100 52 101 1 2009955280 27726736 16075984
20:44:18 14084 8192000000 10914886784 11342663680 1961889200 19.321 99 54 106 1 2002052992 23511936 16651856
20:44:39 3253 8192000000 10905529408 11328786432 1950997984 19.234 100 64 127 1 1996382064 25159776 20224304
20:44:53 13711 8192000000 10892610464 11326078976 1944014000 19.179 100 46 93 0 1984487696 25851072 14622624
20:45:14 2603 8192000000 10907049312 11330420736 1947870304 19.210 100 61 123 1 1994219568 27101600 19247664
20:45:37 3414 8192000000 10927186832 11334926336 1953630432 19.255 100 73 143 1 2002986688 27617920 21738336
20:45:49 4013 8192000000 10936464736 11352043520 1963711472 19.336 100 59 117 2 2011057168 28917536 18428160
20:46:00 2088 8192000000 10933156304 11343286272 1957741680 19.288 100 76 150 1 2011236432 30189536 23305216
20:46:09 1947 8192000000 10916645792 11336249344 1947592048 19.207 100 76 146 2 2002425328 30840016 23993264
20:46:23 5302 8192000000 10888553648 11300950016 1905595424 18.871 98 72 143 3 1954018160 26133744 22288992
20:46:35 5299 8192000000 10886899184 11322183680 1941063264 19.155 100 56 112 0 1985430672 27214832 17152576
20:46:50 3551 8192000000 10906522976 11331260416 1951615312 19.239 100 58 116 3 1996700560 27054640 18030608
20:47:04 4462 8192000000 10882286080 11307253760 1899705728 18.824 98 64 127 3 1948387568 29260368 19421472
20:47:16 3859 8192000000 10898690912 11310223360 1924201104 19.020 100 62 122 1 1971420368 28690192 18529072
20:47:27 2553 8192000000 10916742000 11320418304 1941266752 19.157 100 87 173 2 1994993136 28059136 25667248
20:47:38 4453 8192000000 10901916224 11315453952 1936132544 19.116 100 71 141 0 1983745952 27161408 20452000
20:47:53 5142 8192000000 10893222256 11311648768 1926664256 19.040 100 63 126 1 1975277952 29790384 18823312
20:48:08 6843 8192000000 10882921584 11320598528 1933387296 19.094 100 35 70 1 1972877600 28945648 10544656
20:48:21 14285 8192000000 10862209808 11298508800 1878264384 18.651 97 24 47 2 1912203232 25925872 8012976
20:48:43 9353 8192000000 10905830848 11322368000 1933335440 19.094 100 43 86 2 1972681024 26269264 13076320
20:48:59 7679 8192000000 10900676736 11326222336 1940860688 19.154 100 66 132 1 1995045280 33381856 20802736
20:49:15 2159 8192000000 10921521904 11336785920 1946181328 19.196 100 72 144 1 2002430144 34634336 21614480
20:49:27 8985 8192000000 10926375888 11350839296 1950870048 19.233 100 49 98 1 2006009808 39360816 15778944
20:49:49 6840 8192000000 10921025728 11355951104 1956581712 19.279 100 44 88 1 2011658960 40581792 14495456
20:50:10 6244 8192000000 10932432576 11361816576 1964567200 19.342 100 37 74 0 2016053184 38837440 12648544
20:50:24 1845 8192000000 10931455552 11352838144 1952929296 19.250 99 66 129 3 2012022192 38068528 21024368
20:50:37 4627 8192000000 10930109280 11359731712 1960571504 19.311 100 60 120 0 2018144272 38104240 19468528
20:50:49 2231 8192000000 10928959568 11345215488 1952446992 19.246 100 72 144 0 2013396864 37916768 23033104
20:51:04 8431 8192000000 10915393824 11353341952 1952896624 19.250 100 50 99 1 2006672096 37673792 16101680
20:51:19 10570 8192000000 10896114432 11336298496 1910473856 18.910 98 35 69 0 1957151392 35414224 11263312
20:51:38 17653 8192000000 10890033168 11331039232 1922427328 19.006 99 32 64 1 1968316352 35675696 10213328
20:52:06 6669 8192000000 10901380880 11328761856 1920210496 18.989 99 52 101 1 1972702864 37032672 15459696
20:52:26 6762 8192000000 10911686448 11330465792 1940370816 19.150 100 63 126 1 1992081744 31673024 20037904
20:52:41 6830 8192000000 10916431536 11329638400 1944309216 19.181 100 79 159 1 2001678864 33645984 23723664
20:52:55 50918 8192000000 10890509920 11329003520 1933939792 19.098 100 35 69 1 1981375216 35938480 11496944
20:54:04 15592 8192000000 10876066832 11315879936 1907870544 18.890 99 30 60 2 1951789296 33975040 9943712
20:54:32 16292 8192000000 10882503792 11323162624 1918651888 18.976 100 27 54 0 1964576160 36929376 8994896
20:54:55 12875 8192000000 10879843936 11325480960 1915087328 18.947 100 26 52 2 1968333296 44406704 8839264
20:55:15 11276 8192000000 10872245920 11325624320 1907250128 18.885 100 19 38 1 1958120448 43243872 7626448
20:56:11 25473 8192000000 10848893392 11311104000 1899344976 18.821 100 16 30 1 1939915600 35496512 5074112
20:56:44 26375 8192000000 10860827104 11317694464 1905686032 18.872 100 12 24 0 1941658560 31634272 4338256
20:57:18 12732 8192000000 10864044512 11318046720 1924352400 19.022 100 16 33 1 1949509680 20862320 4294960
20:57:36 19608 8192000000 10835044320 11296968704 1888539712 18.734 98 12 24 1 1913639296 21229104 3870480
20:58:03 63743 8192000000 10859659936 11312672768 1871978544 18.600 97 13 26 0 1890268176 14995184 3294448
20:59:13 88578 8192000000 10878644448 11331661824 1898830416 18.817 98 12 24 1 1925626112 23789296 3006400
21:00:48 70118 8192000000 10918342464 11339374592 1944420752 19.182 100 18 36 1 1962328896 13163888 4744256
21:02:06 36409 8192000000 10890357728 11337170944 1941404112 19.158 99 49 95 0 1965860912 11813056 12643744
21:03:00 61198 8192000000 10886438096 11340894208 1933871168 19.098 99 18 36 1 1952227888 13175744 5180976
21:04:16 73879 8192000000 10904823824 11363311616 1938652080 19.136 99 19 38 1 1957133008 13450768 5030160
21:05:37 33341 8192000000 10893511088 11352645632 1965719824 19.351 100 16 31 0 1982352752 11699104 4933824
21:06:17 101123 8192000000 10907906672 11382882304 1948286384 19.213 99 6 12 1 1966771136 16845120 1639632
21:08:06 70648 8192000000 10921716896 11369164800 1973599488 19.414 100 16 32 0 1993851264 15729952 4521824
21:09:27 57073 8192000000 10914432960 11366936576 1961367104 19.317 99 35 70 0 1979429904 8538896 9523904
21:10:35 38868 8192000000 10905638800 11370819584 1982477008 19.484 100 30 60 1 1999328848 8417568 8434272
21:11:24 79622 8192000000 10927060400 11378728960 1978835024 19.455 99 33 65 2 2001742208 13765696 9141488
21:12:50 25092 8192000000 10925425632 11395387392 1995304240 19.586 100 22 45 1 2016055040 14653696 6097104
21:13:23 14553 8192000000 10929381232 11399327744 1998498864 19.611 100 17 34 1 2018213728 14825472 4889392
21:13:53 16379 8192000000 10951980704 11406540800 2009536736 19.698 100 68 137 2 2045589072 15542544 20509792
21:14:31 59559 8192000000 10936205312 11424096256 2003392528 19.649 100 20 40 1 2028924976 19866592 5665856
21:15:39 25655 8192000000 10936446608 11411423232 1998510368 19.611 100 17 32 0 2025046192 22581120 3954704
21:16:11 18545 8192000000 10919803632 11401461760 1976662528 19.438 99 16 32 1 1997576480 16236880 4677072
21:16:36 15378 8192000000 10919754752 11398885376 1968846096 19.376 99 17 34 0 1998908384 24971632 5090656
21:16:57 46426 8192000000 10884376912 11364691968 1948454960 19.214 98 7 14 0 1962266752 12069984 1741808
21:17:50 48800 8192000000 10848231792 11316989952 1903891824 18.858 96 14 28 0 1914933616 7193200 3848592
21:18:49 88479 8192000000 10909442752 11380281344 1980954656 19.472 100 13 26 1 1994101792 9405984 3741152
21:20:26 68859 8192000000 10919347952 11399843840 1989406432 19.539 100 14 28 1 2012441200 18900656 4134112
21:21:42 18315 8192000000 10915396912 11401150464 1989250864 19.538 100 8 16 0 2009857472 18086320 2520288
21:22:14 22954 8192000000 10887803760 11375382528 1944753040 19.185 98 5 10 1 1965615712 19372128 1490544
21:22:43 13940 8192000000 10894454192 11393994752 1971719472 19.399 100 1 2 0 1985545728 13764128 62128
21:23:19 43960 8192000000 10902958400 11381198848 1979409184 19.460 100 15 30 1 1995067440 11578704 4079552
21:24:14 26051 8192000000 10928762384 11383267328 1971360048 19.396 99 35 71 1 1993119888 10980688 10779152
21:24:47 45695 8192000000 10909876224 11398258688 1988876064 19.535 100 24 48 1 2008905392 13369264 6660064
21:25:46 35150 8192000000 10913314736 11385716736 1978843536 19.456 99 18 36 0 1991002976 7301504 4857936
21:26:37 51704 8192000000 10905045248 11367378944 1910147520 18.908 96 24 49 1 1925455504 8797072 6510912
21:27:42 30789 8192000000 10906562928 11355840512 1938334432 19.133 98 37 74 0 1957845136 9256304 10254400
21:28:23 22750 8192000000 10893220560 11348852736 1923314160 19.013 98 30 60 0 1942580368 10921072 8345136
21:28:57 57486 8192000000 10862129328 11334410240 1857752896 18.485 95 15 30 0 1875042656 13029424 4260336
21:30:00 75631 8192000000 10827248720 11291729920 1753702496 17.632 90 21 42 0 1771306496 11826560 5777440
21:31:22 33197 8192000000 10858476592 11302473728 1867551568 18.564 97 38 76 0 1890537824 11798576 11187680
21:32:04 70477 8192000000 10848052288 11328806912 1884582848 18.702 98 10 20 1 1902641904 15163520 2895536
21:33:22 69214 8192000000 10876117952 11333255168 1920863776 18.994 99 13 25 0 1937467664 13190016 3413872
21:34:44 20329 8192000000 10865919088 11314954240 1905521008 18.871 98 36 72 1 1924661616 9043584 10097024
21:35:10 12216 8192000000 10887399216 11317567488 1933176064 19.092 100 64 126 1 1960760528 9549184 18035280
21:35:34 30583 8192000000 10880831472 11341582336 1932232336 19.085 100 42 84 1 1956843360 12854032 11756992
21:36:14 101542 8192000000 10848187184 11319934976 1836379600 18.311 95 17 34 0 1865358432 24196320 4782512
21:38:02 69879 8192000000 10827500176 11297288192 1877188720 18.642 98 13 26 0 1895718752 14970688 3559344
21:39:18 47362 8192000000 10833031424 11285712896 1822427248 18.198 95 27 53 0 1837136672 7337168 7372256
21:40:16 60111 8192000000 10837465152 11307294720 1916756752 18.961 100 37 74 2 1937740160 10489760 10493648
21:41:25 44374 8192000000 10835451888 11313217536 1918069328 18.971 100 11 20 1 1928592032 7507408 3015296
21:44:03 63206 8192000000 10835632752 11302469632 1897624912 18.807 99 12 24 1 1908039664 7275952 3138800
21:45:22 64408 8192000000 10839836848 11309441024 1905846992 18.873 99 18 36 1 1922236448 10973056 5416400
21:46:49 55556 8192000000 10846302928 11324846080 1913902832 18.938 99 14 28 0 1928769664 10587648 4279184
21:47:57 34108 8192000000 10856156464 11317067776 1893908016 18.777 98 17 34 1 1909404384 10934384 4561984
21:48:37 50146 8192000000 10843052672 11300794368 1905828864 18.873 99 21 41 4 1924183584 11969520 6385200
21:49:33 50351 8192000000 10856572688 11323027456 1897096208 18.803 98 34 68 0 1915884304 9259664 9528432
21:50:34 48607 8192000000 10853086832 11327062016 1910202704 18.908 99 18 36 2 1930461712 14825456 5433552
21:51:49 61766 8192000000 10866244928 11328303104 1912784624 18.929 99 20 40 0 1932586368 14066976 5734768
21:52:57 73062 8192000000 10857249472 11327897600 1876336656 18.636 97 25 50 1 1897436832 14294432 6805744
21:54:17 49875 8192000000 10868793472 11317301248 1896736768 18.800 98 31 62 0 1913531632 6914320 9880544
21:55:15 39672 8192000000 10880364784 11340509184 1938549216 19.135 100 30 60 0 1957157088 9809568 8798304
21:56:07 23809 8192000000 10889789328 11346219008 1949372544 19.221 100 26 52 0 1967132560 10975984 6784032
21:56:40 114287 8192000000 10887007632 11364462592 1926715024 19.041 98 16 32 0 1943317760 12558960 4043776
21:58:41 68119 8192000000 10911139232 11366547456 1940778240 19.153 98 30 60 2 1958067632 9529328 7760064
21:59:58 82029 8192000000 10897592528 11368931328 1916209584 18.956 97 11 22 1 1931601120 12466640 2924896
22:01:28 110151 8192000000 10879950032 11335081984 1910763904 18.913 97 25 49 2 1925312576 8033968 6514704
22:03:29 79609 8192000000 10883870080 11364216832 1944460512 19.182 99 23 46 3 1965416384 14505440 6450432
22:05:02 64025 8192000000 10873682656 11352498176 1944588752 19.183 99 13 26 1 1958384128 10120288 3675088
22:06:14 51445 8192000000 10887155104 11369234432 1970039152 19.386 100 10 20 2 1980363120 7480000 2843968
22:07:21 55569 8192000000 10906660272 11374096384 1975523632 19.429 100 16 32 0 1991360592 11272800 4564160
22:08:23 74307 8192000000 10887968016 11366387712 1936497632 19.119 98 8 16 0 1955335456 16794160 2043664
22:09:46 46595 8192000000 10897985152 11373768704 1962065136 19.322 100 10 20 1 1981960800 16513792 3381872
22:10:44 50910 8192000000 10878512720 11362025472 1911481888 18.919 97 9 18 1 1934694768 20635664 2577216
22:11:49 58576 8192000000 10904516208 11369074688 1965576640 19.350 100 14 28 0 1983581424 13753600 4251184
22:12:56 53771 8192000000 10889143728 11371454464 1951252304 19.236 99 18 36 0 1972934736 16165040 5517392
22:14:00 96389 8192000000 10828053056 11295281152 1741487712 17.531 88 20 40 1 1760157824 12925024 5745088
22:15:43 42828 8192000000 10873264896 11327287296 1896889616 18.801 98 35 70 1 1915587136 8193312 10504208
22:16:34 59496 8192000000 10866704112 11339784192 1889904688 18.745 97 29 58 3 1909192800 11197248 8090864
22:17:40 27431 8192000000 10887212448 11342405632 1910844064 18.913 98 27 54 0 1926715440 8657536 7213840
22:18:27 48347 8192000000 10883170016 11346530304 1901839856 18.841 97 33 66 0 1923907888 12717488 9350544
22:19:22 87615 8192000000 10890941024 11378688000 1947239744 19.204 100 19 38 2 1968379504 15590688 5549072
22:20:56 128955 8192000000 10866639456 11348656128 1882626784 18.686 96 6 12 0 1900773712 16896992 1249936
22:23:11 170700 8192000000 10890966448 11384926208 1945048704 19.187 99 17 34 1 1967200576 17484944 4666928
22:26:16 50804 8192000000 10878287024 11356225536 1938688864 19.136 99 13 26 1 1953155280 11187792 3278624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-01-2021 22:29:29 to 16-01-2021 22:30:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 95 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-01-2021 22:30:02 to 16-01-2021 22:30:04.

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          244462
MON$OLDEST_ACTIVE               245994
MON$OLDEST_SNAPSHOT             245994
MON$NEXT_TRANSACTION            245994
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                       2033632
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 ---
:984: 
:985: mscs-test-161.budzdorov.ru    Sat Jan 16 22:27:25 2021
:986:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:987: 
--- end of diff output ---

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

16.01.21 22:30:05. 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-16 22:30:08 No severe PSQL-related problems occured
16.01.21 22:30:09. End of report.