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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-29 01:27:24
DTS_END                         2021-03-29 01:27:24.4010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41984
TRN_ID                          247437
ATT_ID                          694
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: 9440.38 16617 1132846
customer order: creation 185.37 349 22244
customer order: refuse 15.83 347 1900
order to supplier: creation 49.30 1305 5916
order to supplier: removal 3.70 78368 444
invoice (draft): creation 49.93 3215 5992
invoice (draft): removal 51.14 744 6137
invoice accept: apply 45.66 16604 5479
invoice accept: cancel 46.71 784 5605
customer reserve: creation 4132.77 168 495933
customer reserve: removal 4547.84 50 545741
realization accept: apply 88.35 178 10602
realization accept: cancel 84.72 97 10166
payment from customer: creation 63.00 121 7560
payment from customer: removal 6.32 93 758
payment to supplier: creation 53.32 162 6398
payment to supplier: removal 3.35 100 402
service: total inventory turnovers 4.96 978 595
service: total monetary turnovers 7.13 25 856
service: aggregate perf. data 0.95 19126 114
service: refresh index statistics 0.03 209534 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3774
TEST_TIME 2 4812
TEST_TIME 3 4559
TEST_TIME 4 5119
TEST_TIME 5 5014
TEST_TIME 6 5025
TEST_TIME 7 5003
TEST_TIME 8 5173
TEST_TIME 9 5251
TEST_TIME 10 5747
TEST_TIME 11 5824
TEST_TIME 12 6317
TEST_TIME 13 7423
TEST_TIME 14 7444
TEST_TIME 15 7513
TEST_TIME 16 8198
TEST_TIME 17 8022
TEST_TIME 18 8557
TEST_TIME 19 8646
TEST_TIME 20 9476
TEST_TIME 21 9559
TEST_TIME 22 9862
TEST_TIME 23 9953
TEST_TIME 24 10058
TEST_TIME 25 10031
TEST_TIME 26 10020
TEST_TIME 27 10087
TEST_TIME 28 10263
TEST_TIME 29 10241
TEST_TIME 30 10824
TEST_TIME 31 10587
TEST_TIME 32 10550
TEST_TIME 33 10525
TEST_TIME 34 10470
TEST_TIME 35 10431
TEST_TIME 36 10300
TEST_TIME 37 10396
TEST_TIME 38 10417
TEST_TIME 39 10466
TEST_TIME 40 10462
TEST_TIME 41 10407
TEST_TIME 42 10569
TEST_TIME 43 10352
TEST_TIME 44 10232
TEST_TIME 45 10131
TEST_TIME 46 10111
TEST_TIME 47 9979
TEST_TIME 48 10001
TEST_TIME 49 9938
TEST_TIME 50 9806
TEST_TIME 51 9995
TEST_TIME 52 9928
TEST_TIME 53 9826
TEST_TIME 54 9733
TEST_TIME 55 9633
TEST_TIME 56 9720
TEST_TIME 57 9729
TEST_TIME 58 9685
TEST_TIME 59 9662
TEST_TIME 60 9668
TEST_TIME 61 9687
TEST_TIME 62 9630
TEST_TIME 63 9679
TEST_TIME 64 9741
TEST_TIME 65 9729
TEST_TIME 66 9715
TEST_TIME 67 9839
TEST_TIME 68 9814
TEST_TIME 69 9849
TEST_TIME 70 9814
TEST_TIME 71 9819
TEST_TIME 72 9853
TEST_TIME 73 9814
TEST_TIME 74 9846
TEST_TIME 75 9736
TEST_TIME 76 9724
TEST_TIME 77 9709
TEST_TIME 78 9649
TEST_TIME 79 9665
TEST_TIME 80 9604
TEST_TIME 81 9568
TEST_TIME 82 9546
TEST_TIME 83 9497
TEST_TIME 84 9435
TEST_TIME 85 9378
TEST_TIME 86 9395
TEST_TIME 87 9373
TEST_TIME 88 9422
TEST_TIME 89 9398
TEST_TIME 90 9426
TEST_TIME 91 9467
TEST_TIME 92 9455
TEST_TIME 93 9540
TEST_TIME 94 9511
TEST_TIME 95 9499
TEST_TIME 96 9534
TEST_TIME 97 9515
TEST_TIME 98 9594
TEST_TIME 99 9615
TEST_TIME 100 9573
TEST_TIME 101 9656
TEST_TIME 102 9575
TEST_TIME 103 9505
TEST_TIME 104 9498
TEST_TIME 105 9483
TEST_TIME 106 9437
TEST_TIME 107 9420
TEST_TIME 108 9375
TEST_TIME 109 9389
TEST_TIME 110 9387
TEST_TIME 111 9369
TEST_TIME 112 9355
TEST_TIME 113 9389
TEST_TIME 114 9365
TEST_TIME 115 9469
TEST_TIME 116 9454
TEST_TIME 117 9451
TEST_TIME 118 9470
TEST_TIME 119 9491
TEST_TIME 120 9445

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-03-2021 01:28:11 to 29-03-2021 01:28:14.

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 1591808 1591808 0 0.00 0 33123 6 0 0
doc_list_biud 1591804 1591804 0 0.00 0 27941 23 0 0
sp_add_invoice_to_stock 5638 5479 159 2.82 29 158351 16605 0 159
sp_cancel_adding_invoice 5605 5605 0 0.00 3 68709 785 0 0
sp_cancel_client_order 1900 1900 0 0.00 4 17671 348 0 0
sp_cancel_customer_reserve 545741 545741 0 0.00 1 27943 50 0 0
sp_cancel_pay_from_customer 758 758 0 0.00 3 7338 94 0 0
sp_cancel_pay_to_supplier 402 402 0 0.00 3 5611 101 0 0
sp_cancel_supplier_invoice 6145 6137 8 0.13 1 11935 744 0 8
sp_cancel_supplier_order 444 444 0 0.00 9 848473 78369 0 0
sp_cancel_write_off 10166 10166 0 0.00 1 11761 98 0 0
sp_client_order 22244 22244 0 0.00 3 37362 350 0 0
sp_customer_reserve 495933 495933 0 0.00 0 93843 169 0 0
sp_fill_shopping_cart 34146 34146 0 0.00 1 10065 38 0 0
sp_fill_shopping_cart_clo_res 495924 495924 0 0.00 0 12528 11 0 0
sp_get_clo_for_invoice 5469 5469 0 0.00 0 18158 260 0 0
sp_kill_cost_storno 16931 16931 0 0.00 0 11662 51 0 0
sp_kill_qstorno_ret_qs2qd 1108229 1108229 0 0.00 0 27928 28 0 0
sp_kill_qty_storno 586061 586061 0 0.00 0 27940 60 0 0
sp_lock_selected_doc 22225 22225 0 0.00 0 9821 5 0 0
sp_make_cost_storno 30029 30029 0 0.00 0 20126 59 0 0
sp_multiply_rows_for_pdistr 30026 30026 0 0.00 0 14909 34 0 0
sp_multiply_rows_for_qdistr 22244 22244 0 0.00 0 8748 147 0 0
sp_pay_from_customer 7560 7560 0 0.00 4 23969 121 0 0
sp_pay_to_supplier 6398 6398 0 0.00 5 33128 162 0 0
sp_payment_common 13958 13958 0 0.00 1 21715 34 0 0
sp_qd_handle_on_cancel_clo 1900 1900 0 0.00 0 17659 320 0 0
sp_qd_handle_on_invoice_upd_sts 11072 11072 0 0.00 0 16029 295 0 0
sp_qd_handle_on_reserve_upd_sts 10601 10601 0 0.00 0 27432 55 0 0
sp_reserve_write_off 10602 10602 0 0.00 6 31246 178 0 0
sp_supplier_invoice 5992 5992 0 0.00 7 101054 3216 0 0
sp_supplier_order 5916 5916 0 0.00 5 59011 1305 0 0
srv_aggregate_perf_data 114 114 0 0.00 2633 219636 19127 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1045 160728 32970 0 0
srv_find_qd_qs_mism 1081380 1081380 0 0.00 0 11657 5 0 0
srv_make_invnt_saldo 595 595 0 0.00 28 33044 979 0 0
srv_make_money_saldo 856 856 0 0.00 0 1370 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 137218 249765 209534 0 0
t$perf-abend:sp_add_invoice_to_stock 159 159 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5479 5479 0 0.00 0 17653 150 0 0
t$perf-norm:sp_cancel_adding_invoice 488 488 0 0.00 1 4437 74 0 0
t$perf-norm:sp_cancel_client_order 1900 1900 0 0.00 0 4036 16 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 5985 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 758 758 0 0.00 0 1024 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 402 402 0 0.00 0 445 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 996 10 0 0
t$perf-norm:sp_cancel_supplier_order 444 444 0 0.00 0 24977 1452 0 0
t$perf-norm:sp_cancel_write_off 1045 1045 0 0.00 0 1085 7 0 0
t$perf-norm:sp_client_order 22244 22244 0 0.00 0 13733 17 0 0
t$perf-norm:sp_customer_reserve 1056 1056 0 0.00 0 1535 5 0 0
t$perf-norm:sp_pay_from_customer 7560 7560 0 0.00 0 5006 8 0 0
t$perf-norm:sp_pay_to_supplier 6398 6398 0 0.00 0 4880 8 0 0
t$perf-norm:sp_reserve_write_off 10602 10602 0 0.00 0 5765 11 0 0
t$perf-norm:sp_supplier_invoice 5992 5992 0 0.00 0 4332 15 0 0
t$perf-norm:sp_supplier_order 5916 5916 0 0.00 0 5508 14 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 198 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 244 3 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 1209 21 0 0
t$perf-norm:srv_make_money_saldo 856 856 0 0.00 0 1575 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 15 6 0 0
v_add_invoice_to_stock 11246 10928 318 2.82 0 18327 20 0 318
v_all_customers 40512 40512 0 0.00 0 21 1 0 0
v_all_suppliers 33003 33003 0 0.00 0 18 1 0 0
v_all_wares 44488 44488 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 976 976 0 0.00 0 5948 25 0 0
v_cancel_client_order 3800 3800 0 0.00 0 3715 7 0 0
v_cancel_customer_prepayment 1516 1516 0 0.00 0 4640 11 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 1552 4 0 0
v_cancel_payment_to_supplier 804 804 0 0.00 0 3412 13 0 0
v_cancel_supplier_invoice 830 814 16 1.92 0 1524 17 0 16
v_cancel_supplier_order 888 888 0 0.00 0 2519 7 0 0
v_cancel_write_off 2090 2090 0 0.00 0 2667 14 0 0
v_max_id_clo_ord 5914 5914 0 0.00 0 1854 2 0 0
v_max_id_clo_res 1056 1056 0 0.00 0 5411 20 0 0
v_max_id_ord_sup 5987 5987 0 0.00 0 3725 3 0 0
v_max_non_paid_invoice 1797 1797 0 0.00 0 412 3 0 0
v_max_non_paid_realizn 3956 3956 0 0.00 0 12960 7 0 0
v_min_id_clo_ord 5914 5914 0 0.00 0 6717 7 0 0
v_min_id_clo_res 1056 1056 0 0.00 0 2593 7 0 0
v_min_id_ord_sup 5987 5987 0 0.00 0 6839 11 0 0
v_min_non_paid_invoice 6398 6398 0 0.00 0 12757 26 0 0
v_min_non_paid_realizn 7560 7560 0 0.00 0 13464 20 0 0
v_our_firm 11184 11184 0 0.00 0 13 1 0 0
v_reserve_write_off 21202 21202 0 0.00 0 4868 6 0 0
x_lock_depdocs_on_canc_invoice 11335 11335 0 0.00 0 14018 96 0 0
x_lock_depdocs_on_canc_sup_ord 444 444 0 0.00 0 3593 293 0 0
x_make_qstorno_1000_1200 5916 5916 0 0.00 1 59006 1228 0 0
x_make_qstorno_1200_2000 5992 5992 0 0.00 3 101014 3073 0 0
x_make_qstorno_2100_3300 495933 495933 0 0.00 0 93839 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2021 01:28:15 to 29-03-2021 01:28:19.

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:28 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:34 10366 8192000000 10193876400 10495438848 852345856 9.424 70 47 99 0 870584080 2335488 15902736
22:57:52 29631 8192000000 10342674128 10656505856 1373276560 14.356 100 90 180 0 1406327936 4256688 28794688
22:58:31 36335 8192000000 10392818000 10717589504 1435490592 14.910 100 87 174 0 1470760000 6661664 28607744
22:59:19 30191 8192000000 10419453408 10747334656 1469767584 15.212 100 93 186 1 1508054832 8138432 30148816
22:59:58 28001 8192000000 10452151728 10784825344 1499131216 15.469 100 88 176 0 1535512784 8932256 27449312
23:00:33 17382 8192000000 10478300960 10817400832 1526804832 15.709 100 86 172 1 1563629376 9833328 26991216
23:01:08 12154 8192000000 10492918560 10832621568 1546917104 15.883 100 86 172 2 1583960320 10619792 26423424
23:01:30 15811 8192000000 10503928272 10851586048 1564671264 16.036 100 84 168 1 1601891408 11206992 26013152
23:01:54 10278 8192000000 10522036800 10872852480 1580286640 16.171 100 84 168 2 1617463008 11605184 25571184
23:02:14 15125 8192000000 10546211024 10900119552 1599086512 16.332 100 74 148 1 1632462960 11519312 21857136
23:02:37 15050 8192000000 10552860384 10910195712 1614605760 16.464 100 83 166 1 1651396352 12028928 24761664
23:03:00 10265 8192000000 10577537216 10935377920 1633846352 16.628 100 84 168 0 1670797520 12091072 24860096
23:03:20 14197 8192000000 10595553216 10955022336 1644960912 16.722 100 81 162 2 1682267776 13261360 24045504
23:03:41 11737 8192000000 10606676656 10970632192 1666249744 16.902 100 87 174 3 1705739552 14034224 25455584
23:04:04 8829 8192000000 10623583280 10989928448 1683056768 17.043 100 79 158 1 1719558400 13570992 22930640
23:04:21 8571 8192000000 10640434032 11011080192 1697164272 17.161 100 77 154 2 1732888368 13589696 22134400
23:04:38 6386 8192000000 10645657024 11018678272 1708187344 17.254 100 80 161 2 1745726880 14220784 23318752
23:04:51 4736 8192000000 10655758848 11032121344 1723475008 17.381 100 74 148 2 1757201504 12474368 21252128
23:05:04 11109 8192000000 10686276864 11062132736 1738190192 17.504 100 75 148 1 1771638672 12282352 21166128
23:05:24 6308 8192000000 10690859408 11068399616 1755280064 17.645 100 77 152 0 1789126592 12345088 21501440
23:05:38 6177 8192000000 10703678384 11081875456 1763772912 17.716 100 74 148 0 1796742128 12399920 20569296
23:05:51 6089 8192000000 10712745008 11093250048 1776265632 17.819 100 75 150 2 1810119856 12663664 21190560
23:06:04 7186 8192000000 10702967696 11090345984 1777046304 17.825 100 64 127 1 1807122048 12218464 17857280
23:06:19 3889 8192000000 10731217152 11113816064 1794767408 17.971 100 80 161 2 1830740128 12940608 23032112
23:06:29 3688 8192000000 10741965984 11126812672 1805263904 18.057 100 82 164 3 1841075600 12353760 23457936
23:06:40 2734 8192000000 10750898976 11132264448 1806713344 18.069 100 82 160 2 1842581632 13090784 22777504
23:06:50 3331 8192000000 10748156416 11135045632 1809519792 18.092 100 79 159 2 1845246560 12961328 22765440
23:07:00 3268 8192000000 10757880752 11141189632 1820386656 18.181 100 92 185 1 1857991504 12407344 25197504
23:07:10 3390 8192000000 10765753952 11148730368 1825377280 18.222 100 84 168 3 1862297728 13977936 22942512
23:07:20 2430 8192000000 10775472496 11162423296 1835671984 18.306 100 91 180 0 1875734336 14577232 25485120
23:07:29 2463 8192000000 10785273104 11170672640 1838714240 18.330 100 91 181 1 1878632592 13736096 26182256
23:07:38 1685 8192000000 10781294912 11169783808 1843956352 18.373 100 92 184 0 1883273872 13431040 25886480
23:07:46 1859 8192000000 10797358032 11184349184 1852500112 18.442 100 91 182 0 1890762256 13099824 25162320
23:07:55 2054 8192000000 10789886288 11177136128 1850452960 18.426 100 92 183 1 1889700480 13437056 25810464
23:08:04 2470 8192000000 10787360464 11178708992 1852554432 18.443 100 88 174 1 1889968416 13007312 24406672
23:08:15 1847 8192000000 10803561552 11189485568 1856258640 18.473 100 88 174 0 1895520560 14169600 25092320
23:08:23 1829 8192000000 10803486928 11190673408 1858170800 18.488 100 91 182 1 1897039632 13326096 25542736
23:08:32 2290 8192000000 10804441232 11193577472 1861397648 18.515 100 88 176 1 1899496800 12330416 25768736
23:08:41 1657 8192000000 10815166224 11202830336 1870122640 18.585 100 92 182 2 1909379296 12421392 26835264
23:08:49 1936 8192000000 10823336096 11211829248 1874224816 18.618 100 81 162 2 1910039360 12449056 23365488
23:08:57 29338 8192000000 10798258208 11206262784 1874617504 18.622 100 56 112 4 1899411456 8922608 15871344
23:09:34 7259 8192000000 10810971360 11214692352 1880312608 18.668 100 70 139 2 1907914160 7887808 19713744
23:09:48 11417 8192000000 10808974384 11220201472 1880998240 18.673 100 48 94 2 1902545648 8639024 12908384
23:10:05 12053 8192000000 10800546080 11219689472 1881821088 18.680 100 48 96 1 1905413488 10439664 13152736
23:10:27 4152 8192000000 10813967520 11220889600 1885826288 18.712 100 59 117 6 1913961280 10342608 17792384
23:10:37 6924 8192000000 10797996960 11217346560 1881719168 18.679 100 27 54 0 1897134112 7455536 7959408
23:10:52 3631 8192000000 10800668992 11220439040 1883294176 18.692 100 36 71 3 1901225568 7535616 10395776
23:11:03 14235 8192000000 10795816176 11220447232 1884126064 18.698 100 17 33 1 1895039488 5507968 5405456
23:11:25 10834 8192000000 10798576128 11226243072 1885582336 18.710 100 18 36 2 1900425488 9725216 5117936
23:11:42 7199 8192000000 10793941952 11223248896 1886504720 18.718 100 21 40 2 1898745888 6598144 5643024
23:11:59 7156 8192000000 10789227120 11223945216 1887535968 18.726 100 23 46 1 1900807680 7009296 6262416
23:12:12 6477 8192000000 10804538416 11228336128 1890436432 18.749 100 31 62 2 1905406304 5951696 9018176
23:12:28 8028 8192000000 10804104720 11232935936 1895432576 18.790 100 27 54 0 1909247984 6240496 7574912
23:12:44 10880 8192000000 10808459232 11237011456 1894820416 18.785 100 21 42 0 1906787376 6135440 5831520
23:13:01 11103 8192000000 10809127456 11243540480 1902338272 18.845 100 18 36 0 1913830000 6251648 5240080
23:13:19 12382 8192000000 10806439600 11245948928 1905276672 18.869 100 19 38 2 1917122864 6248288 5597904
23:13:38 16838 8192000000 10818195104 11247550464 1909555216 18.903 100 29 58 3 1924542576 6204736 8782624
23:14:05 71916 8192000000 10825174464 11256098816 1911131648 18.916 100 34 67 1 1926613408 4734048 10747712
23:15:23 5589 8192000000 10832063392 11266109440 1919869856 18.986 100 45 90 1 1942235952 9726672 12639424
23:15:42 5354 8192000000 10838882880 11266355200 1914895360 18.946 100 24 48 0 1927193424 5532304 6765760
23:15:58 9593 8192000000 10835300416 11268886528 1914701712 18.944 100 23 46 2 1930734624 10222768 5810144
23:16:14 10251 8192000000 10838727408 11266965504 1917898416 18.970 100 29 58 0 1932558368 6471632 8188320
23:16:32 8894 8192000000 10826595344 11263094784 1916556464 18.959 100 23 46 0 1928459472 5638928 6264080
23:16:48 3699 8192000000 10826370768 11259793408 1902499632 18.846 99 26 52 3 1915896128 5968112 7428384
23:17:00 6555 8192000000 10830883952 11266125824 1916454880 18.958 100 21 42 1 1927750608 5717712 5578016
23:17:13 7294 8192000000 10826131360 11255685120 1889015344 18.738 99 26 52 3 1903645680 6098912 8531424
23:17:29 5820 8192000000 10787369936 11209969664 1841445920 18.353 98 35 71 3 1858665184 7359872 9859392
23:17:41 10450 8192000000 10771937952 11206529024 1839576624 18.337 98 25 50 3 1852378144 5518336 7283184
23:18:02 5423 8192000000 10785087168 11216785408 1850641872 18.427 98 24 48 2 1863833968 5592864 7599232
23:18:14 9286 8192000000 10775491232 11210235904 1869432016 18.580 100 16 32 3 1880277488 6126768 4718704
23:18:29 11018 8192000000 10770724512 11182153728 1770865424 17.774 94 15 28 0 1779982160 5101376 4015360
23:18:47 10698 8192000000 10763130928 11180630016 1820937280 18.185 98 18 36 1 1832340304 6132784 5270240
23:19:04 60954 8192000000 10757895408 11163848704 1781041232 17.858 96 27 54 1 1793131840 4493216 7597392
23:20:11 10261 8192000000 10718971520 11135541248 1732316496 17.455 94 19 38 1 1742827168 5132864 5377808
23:20:34 6627 8192000000 10704321200 11120500736 1752321440 17.621 97 24 48 0 1768667600 9446688 6899472
23:20:47 4758 8192000000 10697088096 11107446784 1716580992 17.324 95 29 59 1 1730357744 5228992 8547760
23:21:00 5571 8192000000 10727135168 11148759040 1799297424 18.008 99 33 66 1 1815674976 7222160 9155392
23:21:14 7024 8192000000 10719847536 11135160320 1774534544 17.804 98 29 58 0 1789619136 6846176 8238416
23:21:29 5815 8192000000 10717955008 11133890560 1799493056 18.010 100 23 46 0 1810850848 5260496 6097296
23:21:43 6436 8192000000 10708934240 11124531200 1766057248 17.734 98 26 52 2 1779545392 5990192 7497952
23:21:56 7577 8192000000 10719511904 11137298432 1779814624 17.848 98 27 54 1 1798170096 10337600 8017872
23:22:10 8343 8192000000 10708010976 11128328192 1795080480 17.974 100 23 44 2 1807410784 5312160 7018144
23:22:26 5878 8192000000 10726632928 11142742016 1791457408 17.944 99 31 59 0 1805973248 5913344 8602496
23:22:39 10324 8192000000 10732861264 11154341888 1815695888 18.142 100 25 48 4 1832602816 9995744 6911184
23:22:59 16583 8192000000 10737146000 11150028800 1739084000 17.511 95 26 52 0 1756295872 9670512 7541360
23:23:22 9651 8192000000 10731716176 11153059840 1803124064 18.040 99 26 52 3 1817010752 5506560 8380128
23:23:40 17866 8192000000 10749600096 11169665024 1816817328 18.152 99 24 47 3 1829776304 5913808 7045168
23:24:04 62249 8192000000 10769963744 11187421184 1838134208 18.326 100 29 59 0 1852121328 4961536 9025584
23:25:14 10224 8192000000 10765556016 11194052608 1849599776 18.419 100 29 56 1 1863296112 5251200 8445136
23:25:36 9250 8192000000 10781902048 11206475776 1859539440 18.500 100 34 68 2 1876093200 6275488 10278272
23:25:52 7087 8192000000 10774930000 11204280320 1863981488 18.536 100 41 82 3 1881565856 5960912 11623456
23:26:08 9452 8192000000 10780620352 11208671232 1862640848 18.525 100 23 46 1 1875324400 5562240 7121312
23:26:25 7838 8192000000 10785941840 11211325440 1864924048 18.543 100 23 46 1 1877797088 6345104 6527936
23:26:39 6725 8192000000 10773689024 11207188480 1864990624 18.544 100 24 48 3 1878019984 6018512 7010848
23:26:54 12452 8192000000 10785117648 11217092608 1868093136 18.569 100 25 51 1 1880647952 4946624 7608192
23:27:17 7430 8192000000 10799926720 11227738112 1883513424 18.693 100 14 28 0 1892104272 4951536 3639312
23:27:32 35494 8192000000 10825702064 11243962368 1893216864 18.772 100 33 64 2 1908369744 6250816 8902064
23:28:16 14498 8192000000 10845399072 11263803392 1910130256 18.908 100 47 94 0 1932266272 9357568 12778448
23:28:38 18328 8192000000 10853494832 11273465856 1916234288 18.957 100 53 106 2 1942028640 11007296 14787056
23:29:05 16696 8192000000 10861379584 11282182144 1922717616 19.009 100 47 93 0 1948045664 12153136 13174912
23:29:29 16877 8192000000 10856832272 11284692992 1928053040 19.051 100 40 80 1 1950879584 11141696 11684848
23:30:01 39458 8192000000 10863115696 11296784384 1936695232 19.120 100 37 72 2 1958287632 10867712 10724688
23:30:51 76238 8192000000 10858329488 11311808512 1938088832 19.132 100 22 44 1 1956607904 12184720 6334352
23:32:15 26872 8192000000 10889783040 11330584576 1948308336 19.213 100 35 70 1 1970523936 12432768 9782832
23:32:48 4608 8192000000 10911849952 11335053312 1965447536 19.349 100 58 112 2 1993021152 12329840 15243776
23:33:26 20903 8192000000 10908619168 11345006592 1973755504 19.415 100 40 80 1 1998677520 13351552 11570464
23:33:56 4022 8192000000 10919498512 11352743936 1979499360 19.461 100 50 100 2 2007287840 13378912 14409568
23:34:08 4092 8192000000 10924758400 11354492928 1987170432 19.521 100 61 123 3 2019093952 14309520 17614000
23:34:26 4361 8192000000 10945841760 11375386624 1988878304 19.535 100 66 132 2 2023016432 15536960 18601168
23:34:43 12113 8192000000 10945906544 11371450368 1992553232 19.564 100 66 132 1 2033652832 21543936 19555664
23:35:03 3179 8192000000 10937148656 11367952384 1994648640 19.581 100 64 128 1 2033820800 19920304 19251856
23:35:14 6152 8192000000 10947184448 11376316416 1994409648 19.579 100 57 112 4 2029476256 18439280 16627328
23:35:28 2588 8192000000 10955841104 11383357440 2000493776 19.627 100 71 142 4 2040619664 19627600 20498288
23:35:49 6273 8192000000 10944521472 11372544000 1989741328 19.542 100 60 118 0 2028905136 21304128 17859680
23:36:05 9842 8192000000 10947606064 11377905664 1979863664 19.464 99 61 122 0 2022330944 24409424 18057856
23:36:30 6801 8192000000 10956672304 11379195904 1983955248 19.496 99 72 144 2 2032093120 26265504 21872368
23:36:50 4406 8192000000 10959747120 11391102976 2000523408 19.627 100 67 134 0 2050236080 29323248 20389424
23:37:07 11578 8192000000 10961210240 11390955520 2001510464 19.635 100 62 124 0 2047324912 27216528 18597920
23:37:29 2777 8192000000 10965997888 11398414336 2010541216 19.706 100 61 122 1 2055081232 26465680 18074336
23:37:39 3297 8192000000 10971677984 11401166848 2010811440 19.708 100 71 141 0 2058275840 25803568 21660832
23:37:50 1970 8192000000 10975543408 11395661824 1995856080 19.590 99 82 164 1 2048340640 27205424 25279136
23:38:02 8973 8192000000 10978061248 11403149312 2008567632 19.690 100 77 154 3 2060877280 29295328 23014320
23:38:19 5274 8192000000 10974696144 11402317824 2007959792 19.685 100 73 145 3 2057118464 28311040 20847632
23:38:33 15496 8192000000 10976269472 11408420864 2009547936 19.698 100 73 146 0 2065982528 34026112 22408480
23:39:00 6587 8192000000 10970946384 11410993152 2012356000 19.720 100 63 126 0 2062900992 30703424 19841568
23:39:16 4420 8192000000 10988994672 11418292224 2013211120 19.727 100 63 127 1 2068362912 34930208 20221584
23:39:26 2182 8192000000 10985720672 11418439680 2019507056 19.776 100 76 149 3 2072363104 30347216 22508832
23:39:36 1351 8192000000 10987966080 11422130176 2022084464 19.797 100 70 140 1 2076425712 32682192 21659056
23:39:46 2894 8192000000 10983162096 11416039424 2001720048 19.636 99 66 132 3 2055220128 33461408 20038672
23:39:57 2445 8192000000 10989368960 11412959232 2005952400 19.670 100 81 158 1 2064446752 34421456 24072896
23:40:06 2560 8192000000 10993014544 11419516928 2015456544 19.744 100 80 157 2 2075414176 35804336 24153296
23:40:16 1983 8192000000 10998327856 11424731136 2000530848 19.627 99 84 166 3 2064299024 37922608 25845568
23:40:25 1264 8192000000 10991874304 11416625152 2012818752 19.724 100 85 170 1 2077588128 38505904 26263472
23:40:38 4055 8192000000 10987065248 11415924736 2021007024 19.788 100 76 150 1 2072598064 29452784 22138256
23:40:49 5844 8192000000 10982971824 11414036480 2014471472 19.737 100 73 146 2 2063726448 27826032 21428944
23:41:03 15862 8192000000 10958326576 11404406784 1979215200 19.458 98 55 110 3 2026617280 30939696 16462384
23:41:27 3098 8192000000 10974660512 11404111872 2006595024 19.675 100 64 126 2 2053175360 27137344 19442992
23:41:37 3750 8192000000 10991798304 11420327936 2014171840 19.734 100 65 131 2 2064725072 31331040 19222192
23:41:47 7542 8192000000 10965522432 11398766592 1999700608 19.620 99 64 125 2 2046300672 28344944 18255120
23:42:08 5680 8192000000 10976982816 11408842752 1997290416 19.601 99 60 119 2 2043217888 28396000 17531472
23:42:22 4846 8192000000 10964676400 11403427840 2000458112 19.626 100 48 96 1 2045891568 31438304 13995152
23:42:36 8195 8192000000 10948291344 11388874752 1987496352 19.524 100 50 100 1 2034783168 31993360 15293456
23:42:56 6408 8192000000 10972907360 11412901888 2002112560 19.639 100 52 103 0 2056199152 37798976 16287616
23:43:10 2797 8192000000 10989791344 11417780224 2011142240 19.711 100 75 149 0 2067151520 33122496 22886784
23:43:19 7453 8192000000 10962311744 11404267520 1998122736 19.608 100 55 111 1 2050263056 35278384 16861936
23:43:35 16898 8192000000 10960445136 11416530944 2008568896 19.690 100 36 72 1 2055175728 34724848 11881984
23:44:02 15394 8192000000 10948098592 11406184448 2000832320 19.629 100 29 58 3 2040539488 30394208 9312960
23:44:25 6330 8192000000 10965917808 11412750336 2004572768 19.659 100 48 95 1 2052188736 32074928 15541040
23:44:39 16536 8192000000 10963466128 11410374656 1998053232 19.607 100 40 81 2 2045602704 34427680 13121792
23:45:02 1892 8192000000 10964171520 11386990592 1975247584 19.427 99 65 130 0 2033558592 36148224 22162784
23:45:10 13315 8192000000 10919052400 11378106368 1907320240 18.885 96 31 62 0 1954230832 36247856 10662736
23:45:38 10798 8192000000 10910422640 11362078720 1952862832 19.249 99 38 74 2 1998847808 33320016 12664960
23:45:56 12467 8192000000 10932214416 11376500736 1970644720 19.391 100 39 78 1 2017131376 34124560 12362096
23:46:15 15650 8192000000 10930566240 11385167872 1979973392 19.464 100 42 84 2 2030630560 36876272 13780896
23:46:39 8347 8192000000 10921778528 11368464384 1943594832 19.175 99 32 64 0 1994771264 40637984 10538448
23:46:54 9266 8192000000 10900270560 11340763136 1920715008 18.993 99 38 74 2 1972918736 39098272 13105456
23:47:10 1698 8192000000 10931167552 11352182784 1932741360 19.089 99 79 156 2 1999115856 41485904 24888592
23:47:19 6382 8192000000 10945017120 11361796096 1949607584 19.223 100 83 166 0 2019976912 44285072 26084256
23:47:34 1942 8192000000 10936736112 11348750336 1942626448 19.168 99 87 171 1 2010045648 42373344 25045856
23:47:42 2093 8192000000 10953846448 11367157760 1943733392 19.177 99 85 167 2 2015640528 46198496 25708640
23:47:51 8374 8192000000 10906198912 11354435584 1931217808 19.077 99 45 90 1 1983492560 38412352 13862400
23:48:08 11718 8192000000 10860748240 11310616576 1865525616 18.548 96 32 65 1 1904889520 29205200 10158704
23:48:41 9129 8192000000 10867804112 11292225536 1887644736 18.727 98 36 72 0 1927286800 28530368 11111696
23:48:59 9519 8192000000 10902969168 11340603392 1935238224 19.109 100 30 59 1 1976396592 31258400 9899968
23:49:16 10530 8192000000 10903144800 11343388672 1928469936 19.055 99 29 56 2 1969652000 31977520 9204544
23:49:33 14406 8192000000 10886074160 11334254592 1933432144 19.094 100 33 66 4 1977453024 33755152 10265728
23:49:56 12139 8192000000 10909267968 11351592960 1943272800 19.173 100 37 72 0 1993537968 38393376 11871792
23:50:28 10754 8192000000 10881978688 11320643584 1880257088 18.667 97 35 71 1 1923582288 32243472 11081728
23:50:53 1150 8192000000 10911934224 11327205376 1931727248 19.081 100 87 175 8 1993025792 34744160 26554384
23:51:02 15961 8192000000 10883916256 11325718528 1922763824 19.009 100 31 62 1 1965050080 32649408 9636848
23:51:37 34335 8192000000 10867461840 11294638080 1897579696 18.807 98 55 110 0 1940864112 25300144 17984272
23:52:24 43579 8192000000 10869514000 11311341568 1887416912 18.725 98 30 60 2 1927328272 30094624 9816736
23:53:15 16175 8192000000 10863460560 11309637632 1912135584 18.924 100 26 53 0 1952737088 32017472 8584032
23:53:44 7922 8192000000 10853431664 11301052416 1904165056 18.860 100 22 44 1 1943784720 32223936 7395728
23:54:30 22473 8192000000 10853292912 11312537600 1906397504 18.878 100 22 44 0 1947693696 33805184 7491008
23:55:29 42605 8192000000 10852146352 11314454528 1888221392 18.731 99 9 18 0 1927528304 35765376 3541536
23:56:29 37514 8192000000 10837244176 11307450368 1892920976 18.769 100 14 29 1 1933601296 35755440 4924880
23:57:13 51390 8192000000 10840691040 11282415616 1880699296 18.671 98 12 24 0 1900189344 16907632 2582416
23:58:17 54401 8192000000 10877671072 11308310528 1912649360 18.928 99 19 38 0 1926131040 8540336 4941344
23:59:54 76819 8192000000 10864371712 11319853056 1911131744 18.916 99 19 38 2 1926999504 10771152 5096608
00:01:24 67422 8192000000 10877260560 11322499072 1912555088 18.927 99 11 22 2 1932936128 17252256 3128784
00:02:38 65129 8192000000 10893409808 11326615552 1923920400 19.018 99 27 54 4 1943932528 12422720 7589408
00:03:58 102273 8192000000 10889252080 11362119680 1930009888 19.067 99 14 28 1 1953905664 19690384 4205392
00:05:51 160727 8192000000 10905417024 11359449088 1924183984 19.020 98 6 12 0 1939292832 13645488 1463360
00:08:41 40573 8192000000 10913729760 11371364352 1970752016 19.391 100 12 24 1 1983328176 8922256 3653904
00:09:32 121312 8192000000 10912810736 11378831360 1974099968 19.418 100 17 34 2 1994034912 14871312 5063632
00:11:41 67685 8192000000 10902396800 11363844096 1937987584 19.131 98 31 62 0 1955984784 9102464 8894736
00:13:00 110053 8192000000 10919636368 11371769856 1940432976 19.150 98 26 52 1 1954901616 7035776 7432864
00:14:57 2632 8192000000 10932740384 11379585024 1983244224 19.490 100 47 94 0 2008552304 12017680 13290400
00:15:06 10100 8192000000 10926044976 11384287232 1991921136 19.559 100 43 86 0 2015824912 11859344 12044432
00:15:31 29343 8192000000 10922900416 11389198336 1978374224 19.452 99 33 64 2 2001103424 13535984 9193216
00:16:10 103191 8192000000 10949526800 11409309696 1962259488 19.324 98 39 74 2 1991566720 17914432 11392800
00:18:04 52790 8192000000 10933706032 11422277632 1985953840 19.512 100 11 22 1 2017574864 28918720 2702304
00:19:03 3614 8192000000 10918599520 11423215616 1981977344 19.480 100 6 12 0 2014104640 30714160 1413136
00:19:13 2260 8192000000 10919375840 11424067584 1983962320 19.496 100 10 21 0 2013423072 26614032 2846720
00:19:22 12096 8192000000 10924406736 11413184512 1986384432 19.515 100 12 24 0 2018170336 28687344 3098560
00:19:46 17752 8192000000 10909243696 11394723840 1967573872 19.366 99 9 18 2 1989282464 19777536 1931056
00:20:10 44249 8192000000 10897748704 11369050112 1959169952 19.299 99 15 30 0 1972808544 9583424 4055168
00:21:00 38995 8192000000 10917120016 11391344640 1974730400 19.423 99 15 31 0 1992567312 13714864 4122048
00:22:12 86506 8192000000 10900944880 11378565120 1957429248 19.286 99 28 52 0 1980574480 15937200 7208032
00:23:46 57158 8192000000 10900434768 11384979456 1966871824 19.361 99 30 60 0 1991952016 16225872 8854320
00:24:59 57937 8192000000 10889752448 11378671616 1957008608 19.282 99 10 20 0 1973193456 13621856 2562992
00:26:09 36888 8192000000 10891042896 11369517056 1951181248 19.236 99 11 22 3 1963041232 9087840 2772144
00:26:59 68737 8192000000 10909809280 11381547008 1943340944 19.173 98 22 44 0 1959055856 9959344 5755568
00:28:14 102187 8192000000 10906906656 11378192384 1843990720 18.373 93 12 24 0 1855720640 8773744 2956176
00:30:10 38249 8192000000 10912865456 11385790464 1946506880 19.199 98 19 38 1 1960991296 9449456 5034960
00:30:55 55964 8192000000 10883138160 11366207488 1881894816 18.680 95 20 40 2 1898778720 11196096 5687808
00:31:58 53993 8192000000 10874796240 11331198976 1833232528 18.286 93 26 52 1 1849688816 9043584 7412704
00:32:58 63739 8192000000 10882889936 11352006656 1893520720 18.774 97 14 28 1 1909214480 11226256 4467504
00:34:09 64138 8192000000 10892441376 11365040128 1915977232 18.955 98 16 32 0 1938972528 18495424 4499872
00:35:19 21507 8192000000 10899990816 11356979200 1952842096 19.249 100 28 56 0 1969869104 9516608 7510400
00:35:49 34856 8192000000 10876643712 11338903552 1894238672 18.780 97 33 66 1 1916620064 13064864 9316528
00:37:01 91013 8192000000 10883364528 11330109440 1833105632 18.285 94 17 34 1 1846586224 8687888 4792704
00:38:39 78725 8192000000 10869337488 11343200256 1910720480 18.912 99 20 40 3 1927705552 11498992 5486080
00:40:16 51352 8192000000 10880340336 11342204928 1921530912 18.999 99 24 48 1 1940422400 11867664 7023824
00:41:18 79959 8192000000 10882360624 11345641472 1924477744 19.023 99 15 30 0 1938128928 9534528 4116656
00:43:07 73737 8192000000 10856749744 11317243904 1852350720 18.441 95 15 30 0 1867951360 11016800 4583840
00:44:27 67186 8192000000 10859561968 11339653120 1919972272 18.987 99 24 48 2 1938572608 11055792 7544544
00:46:06 45139 8192000000 10835315968 11305938944 1858590320 18.492 96 12 24 0 1868286304 6215648 3480336
00:46:59 82646 8192000000 10846628624 11314692096 1842292832 18.359 95 15 30 0 1854710816 8316960 4101024
00:48:29 52429 8192000000 10841277520 11314065408 1871419024 18.596 97 22 44 1 1884860928 6792944 6648960
00:49:36 41661 8192000000 10856506496 11330744320 1930593520 19.072 100 21 43 0 1946561056 10191232 5776304
00:51:38 97067 8192000000 10869719856 11338653696 1922331136 19.006 99 15 30 1 1937516048 11119872 4065040
00:53:27 12091 8192000000 10883537424 11348017152 1945667440 19.192 100 32 62 4 1968680720 14265008 8748272
00:53:45 37681 8192000000 10840036720 11302563840 1864976000 18.544 96 23 46 1 1883840640 12012640 6852000
00:54:48 70818 8192000000 10850029984 11332730880 1891537808 18.758 98 16 32 1 1907010688 10732144 4740736
00:56:08 28132 8192000000 10887552720 11355639808 1947909760 19.210 100 39 78 2 1967408768 8376064 11122944
00:56:46 54396 8192000000 10884626544 11360165888 1921782944 19.001 98 23 46 1 1939199072 10757984 6658144
00:57:50 56313 8192000000 10900239296 11367890944 1925936912 19.034 98 27 54 0 1942648000 8663280 8047808
00:58:58 108799 8192000000 10898815232 11383771136 1967774576 19.368 100 14 28 0 1988707712 16135536 4797600
01:01:04 22926 8192000000 10899019472 11363885056 1950018544 19.227 99 26 52 1 1966131152 7695312 8417296
01:01:38 34912 8192000000 10927380192 11385266176 1981831200 19.479 100 45 90 0 2007407312 12789200 12786912
01:02:24 78157 8192000000 10907534000 11389243392 1938663712 19.136 98 19 38 0 1956510240 12537776 5308752
01:03:54 50079 8192000000 10947010496 11394748416 1968664880 19.375 99 38 76 0 1993212336 13822800 10724656
01:04:52 89296 8192000000 10892663984 11374424064 1884724704 18.703 95 23 46 0 1905120528 14548208 5847616
01:06:42 23064 8192000000 10895958208 11359084544 1933375712 19.094 98 17 35 0 1945027056 7332304 4319040
01:07:11 18620 8192000000 10922364720 11381182464 1970318176 19.388 100 41 80 2 1988172864 7886400 9968288
01:07:35 32237 8192000000 10932322928 11388370944 1964546048 19.342 99 54 108 3 1992900064 13323232 15030784
01:09:50 75462 8192000000 10878333056 11343007744 1927927984 19.050 98 25 50 2 1941211824 6002720 7281120
01:11:20 1044 8192000000 10896921488 11355807744 1961845440 19.321 100 60 116 1 1987237600 8921792 16470368
01:11:28 19188 8192000000 10891454128 11357847552 1960128496 19.307 100 24 48 0 1976635472 10111120 6395856
01:12:15 88733 8192000000 10853585792 11335098368 1863166768 18.529 95 13 26 0 1872982960 6384528 3431664
01:13:50 46704 8192000000 10854208208 11330818048 1903114848 18.851 98 8 16 0 1915026704 9938720 1973136
01:14:46 41763 8192000000 10841850080 11328212992 1879508032 18.661 97 11 22 1 1892839856 10484352 2847472
01:15:34 31592 8192000000 10858229952 11335012352 1906965760 18.882 99 20 40 1 1924333552 11282864 6084928
01:16:12 74101 8192000000 10846561088 11345088512 1879071408 18.658 97 11 22 0 1898143472 16097216 2974848
01:17:43 35659 8192000000 10873862128 11348127744 1931286800 19.077 99 23 46 1 1946658592 9356256 6015536
01:18:26 63364 8192000000 10861629600 11330260992 1867215216 18.562 96 26 52 0 1886245936 11609728 7420992
01:19:38 46275 8192000000 10892295200 11350171648 1941775536 19.161 100 19 38 2 1964548416 17029968 5742912
01:20:37 71278 8192000000 10893367440 11364188160 1919552032 18.983 98 17 34 0 1936725680 12367968 4805680
01:22:03 78878 8192000000 10852947008 11330043904 1880084592 18.666 96 24 47 3 1902425856 15080720 7260544
01:23:28 49196 8192000000 10881337872 11339030528 1918231392 18.973 99 25 50 1 1936647872 11281904 7134576
01:24:24 59577 8192000000 10872840640 11346210816 1902709712 18.848 98 26 52 2 1925628304 15378368 7540224
01:25:34 33489 8192000000 10862027680 11317489664 1837208480 18.318 95 35 70 3 1858661040 11763008 9689552
01:26:15 64617 8192000000 10865561360 11328475136 1891218464 18.756 98 32 63 0 1910645248 11033440 8393344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 29-03-2021 01:28:21 to 29-03-2021 01:28:52.

Exceptions occured during test was in run

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

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

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          246276
MON$OLDEST_ACTIVE               247607
MON$OLDEST_SNAPSHOT             247607
MON$NEXT_TRANSACTION            247607
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                       2028896
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:125: 
:126: mscs-test-161.budzdorov.ru    Mon Mar 29 01:27:33 2021
:127:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:128: 
:129: 
:130: mscs-test-161.budzdorov.ru    Mon Mar 29 01:27:33 2021
:131:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:132: 
--- end of diff output ---

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

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