Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.03.2021 22: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 17482944 kB
MemAvailable 31503168 kB
Buffers 0 kB
Cached 14167304 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-23 22:27:23
DTS_END                         2021-03-23 22:27:23.4160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48766
TRN_ID                          247351
ATT_ID                          691
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: 9368.77 16861 1124252
customer order: creation 184.33 374 22119
customer order: refuse 14.67 349 1760
order to supplier: creation 46.73 1250 5607
order to supplier: removal 3.63 103196 435
invoice (draft): creation 47.89 3057 5747
invoice (draft): removal 52.72 766 6326
invoice accept: apply 43.48 16698 5217
invoice accept: cancel 47.23 786 5667
customer reserve: creation 3987.10 166 478452
customer reserve: removal 4629.12 65 555494
realization accept: apply 86.98 186 10438
realization accept: cancel 88.04 116 10565
payment from customer: creation 62.51 120 7501
payment from customer: removal 6.36 66 763
payment to supplier: creation 51.73 132 6207
payment to supplier: removal 3.63 63 435
service: total inventory turnovers 4.78 1141 574
service: total monetary turnovers 6.98 21 837
service: aggregate perf. data 0.87 17827 104
service: refresh index statistics 0.03 190838 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-03-2021 22:28:14 to 23-03-2021 22:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3041
TEST_TIME 2 3080
TEST_TIME 3 3609
TEST_TIME 4 3440
TEST_TIME 5 3881
TEST_TIME 6 4236
TEST_TIME 7 4162
TEST_TIME 8 4381
TEST_TIME 9 4400
TEST_TIME 10 4761
TEST_TIME 11 4967
TEST_TIME 12 5116
TEST_TIME 13 5169
TEST_TIME 14 5932
TEST_TIME 15 6139
TEST_TIME 16 6071
TEST_TIME 17 6647
TEST_TIME 18 7097
TEST_TIME 19 7160
TEST_TIME 20 7383
TEST_TIME 21 8022
TEST_TIME 22 8471
TEST_TIME 23 9009
TEST_TIME 24 9246
TEST_TIME 25 9741
TEST_TIME 26 10315
TEST_TIME 27 11125
TEST_TIME 28 10957
TEST_TIME 29 10692
TEST_TIME 30 10657
TEST_TIME 31 10671
TEST_TIME 32 10653
TEST_TIME 33 10499
TEST_TIME 34 10347
TEST_TIME 35 10263
TEST_TIME 36 10166
TEST_TIME 37 10073
TEST_TIME 38 10230
TEST_TIME 39 10114
TEST_TIME 40 10020
TEST_TIME 41 9950
TEST_TIME 42 9853
TEST_TIME 43 9698
TEST_TIME 44 9642
TEST_TIME 45 9548
TEST_TIME 46 9464
TEST_TIME 47 9481
TEST_TIME 48 9412
TEST_TIME 49 9409
TEST_TIME 50 9531
TEST_TIME 51 9531
TEST_TIME 52 9491
TEST_TIME 53 9545
TEST_TIME 54 9584
TEST_TIME 55 9658
TEST_TIME 56 9684
TEST_TIME 57 9741
TEST_TIME 58 9708
TEST_TIME 59 9749
TEST_TIME 60 9774
TEST_TIME 61 9669
TEST_TIME 62 9546
TEST_TIME 63 9532
TEST_TIME 64 9465
TEST_TIME 65 9401
TEST_TIME 66 9362
TEST_TIME 67 9414
TEST_TIME 68 9454
TEST_TIME 69 9404
TEST_TIME 70 9395
TEST_TIME 71 9539
TEST_TIME 72 9483
TEST_TIME 73 9519
TEST_TIME 74 9509
TEST_TIME 75 9523
TEST_TIME 76 9593
TEST_TIME 77 9690
TEST_TIME 78 9736
TEST_TIME 79 9729
TEST_TIME 80 9633
TEST_TIME 81 9608
TEST_TIME 82 9548
TEST_TIME 83 9488
TEST_TIME 84 9413
TEST_TIME 85 9378
TEST_TIME 86 9348
TEST_TIME 87 9482
TEST_TIME 88 9430
TEST_TIME 89 9432
TEST_TIME 90 9499
TEST_TIME 91 9522
TEST_TIME 92 9546
TEST_TIME 93 9523
TEST_TIME 94 9532
TEST_TIME 95 9603
TEST_TIME 96 9595
TEST_TIME 97 9586
TEST_TIME 98 9598
TEST_TIME 99 9560
TEST_TIME 100 9614
TEST_TIME 101 9567
TEST_TIME 102 9496
TEST_TIME 103 9519
TEST_TIME 104 9483
TEST_TIME 105 9513
TEST_TIME 106 9507
TEST_TIME 107 9474
TEST_TIME 108 9432
TEST_TIME 109 9408
TEST_TIME 110 9367
TEST_TIME 111 9391
TEST_TIME 112 9400
TEST_TIME 113 9396
TEST_TIME 114 9391
TEST_TIME 115 9377
TEST_TIME 116 9428
TEST_TIME 117 9417
TEST_TIME 118 9424
TEST_TIME 119 9414
TEST_TIME 120 9371

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-03-2021 22:28:17 to 23-03-2021 22:28:21.

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 1568201 1568201 0 0.00 0 20657 6 0 0
doc_list_biud 1568198 1568198 0 0.00 0 27672 29 0 0
sp_add_invoice_to_stock 5304 5217 87 1.64 32 151157 16698 0 87
sp_cancel_adding_invoice 5667 5667 0 0.00 5 65200 787 0 0
sp_cancel_client_order 1760 1760 0 0.00 4 9851 349 0 0
sp_cancel_customer_reserve 555494 555494 0 0.00 1 22766 65 0 0
sp_cancel_pay_from_customer 763 763 0 0.00 3 5195 67 0 0
sp_cancel_pay_to_supplier 435 435 0 0.00 3 5121 64 0 0
sp_cancel_supplier_invoice 6331 6326 5 0.07 1 18141 766 0 5
sp_cancel_supplier_order 435 435 0 0.00 5 1075015 103196 0 0
sp_cancel_write_off 10565 10565 0 0.00 1 12574 116 0 0
sp_client_order 22119 22119 0 0.00 3 50744 375 0 0
sp_customer_reserve 478452 478452 0 0.00 0 83050 167 0 0
sp_fill_shopping_cart 33466 33466 0 0.00 1 16965 37 0 0
sp_fill_shopping_cart_clo_res 478448 478448 0 0.00 0 14811 14 0 0
sp_get_clo_for_invoice 5213 5213 0 0.00 0 18769 280 0 0
sp_kill_cost_storno 17430 17430 0 0.00 0 11031 57 0 0
sp_kill_qstorno_ret_qs2qd 1128314 1128314 0 0.00 0 22754 35 0 0
sp_kill_qty_storno 595895 595895 0 0.00 0 27672 75 0 0
sp_lock_selected_doc 21659 21659 0 0.00 0 6488 4 0 0
sp_make_cost_storno 29359 29359 0 0.00 0 20579 59 0 0
sp_multiply_rows_for_pdistr 29357 29357 0 0.00 0 12394 26 0 0
sp_multiply_rows_for_qdistr 22119 22119 0 0.00 0 50723 185 0 0
sp_pay_from_customer 7501 7501 0 0.00 4 15784 120 0 0
sp_pay_to_supplier 6207 6207 0 0.00 5 15700 133 0 0
sp_payment_common 13708 13708 0 0.00 1 15740 39 0 0
sp_qd_handle_on_cancel_clo 1760 1760 0 0.00 0 9803 321 0 0
sp_qd_handle_on_invoice_upd_sts 10879 10879 0 0.00 0 27671 318 0 0
sp_qd_handle_on_reserve_upd_sts 10436 10436 0 0.00 0 12809 58 0 0
sp_reserve_write_off 10438 10438 0 0.00 6 20730 187 0 0
sp_supplier_invoice 5747 5747 0 0.00 5 75138 3057 0 0
sp_supplier_order 5607 5607 0 0.00 5 31794 1251 0 0
srv_aggregate_perf_data 104 104 0 0.00 2857 156480 17827 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 945 130647 32276 0 0
srv_find_qd_qs_mism 1074598 1074598 0 0.00 0 9572 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 31 122518 1142 0 0
srv_make_money_saldo 837 837 0 0.00 1 420 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 173298 217433 190838 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5217 5217 0 0.00 0 13415 181 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 6109 94 0 0
t$perf-norm:sp_cancel_client_order 1760 1760 0 0.00 0 4569 14 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 2214 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 763 763 0 0.00 0 5356 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 435 435 0 0.00 0 195 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 9233 45 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 28455 1520 0 0
t$perf-norm:sp_cancel_write_off 1047 1047 0 0.00 0 1474 6 0 0
t$perf-norm:sp_client_order 22119 22119 0 0.00 0 10731 18 0 0
t$perf-norm:sp_customer_reserve 1057 1057 0 0.00 0 3079 7 0 0
t$perf-norm:sp_pay_from_customer 7501 7501 0 0.00 0 8242 13 0 0
t$perf-norm:sp_pay_to_supplier 6207 6207 0 0.00 0 9382 17 0 0
t$perf-norm:sp_reserve_write_off 10438 10438 0 0.00 0 9878 12 0 0
t$perf-norm:sp_supplier_invoice 5747 5747 0 0.00 0 8348 24 0 0
t$perf-norm:sp_supplier_order 5607 5607 0 0.00 0 4247 14 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 266 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 85 2 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 961 16 0 0
t$perf-norm:srv_make_money_saldo 837 837 0 0.00 0 539 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 69 19 0 0
v_add_invoice_to_stock 10596 10422 174 1.64 0 5277 18 0 174
v_all_customers 39776 39776 0 0.00 0 20 1 0 0
v_all_suppliers 31928 31928 0 0.00 0 23 1 0 0
v_all_wares 44238 44238 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 4331 10 0 0
v_cancel_client_order 3520 3520 0 0.00 0 2003 5 0 0
v_cancel_customer_prepayment 1526 1526 0 0.00 0 518 3 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 2114 7 0 0
v_cancel_payment_to_supplier 870 870 0 0.00 0 234 2 0 0
v_cancel_supplier_invoice 830 820 10 1.20 0 1606 14 0 10
v_cancel_supplier_order 870 870 0 0.00 0 777 6 0 0
v_cancel_write_off 2094 2094 0 0.00 0 2198 14 0 0
v_max_id_clo_ord 5607 5607 0 0.00 0 576 1 0 0
v_max_id_clo_res 1057 1057 0 0.00 0 7311 24 0 0
v_max_id_ord_sup 5740 5740 0 0.00 0 11125 5 0 0
v_max_non_paid_invoice 1590 1590 0 0.00 0 339 2 0 0
v_max_non_paid_realizn 4133 4133 0 0.00 0 5035 5 0 0
v_min_id_clo_ord 5607 5607 0 0.00 0 4123 7 0 0
v_min_id_clo_res 1057 1057 0 0.00 0 2724 6 0 0
v_min_id_ord_sup 5740 5740 0 0.00 0 5591 4 0 0
v_min_non_paid_invoice 6207 6207 0 0.00 0 9764 26 0 0
v_min_non_paid_realizn 7501 7501 0 0.00 0 9723 29 0 0
v_our_firm 11198 11198 0 0.00 0 16 1 0 0
v_reserve_write_off 20872 20872 0 0.00 0 5992 7 0 0
x_lock_depdocs_on_canc_invoice 11583 11583 0 0.00 0 18838 110 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 8573 307 0 0
x_make_qstorno_1000_1200 5607 5607 0 0.00 1 31686 1174 0 0
x_make_qstorno_1200_2000 5747 5747 0 0.00 3 75130 2921 0 0
x_make_qstorno_2100_3300 478452 478452 0 0.00 0 83045 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-03-2021 22:28:22 to 23-03-2021 22:28:26.

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:26 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 15708 8192000000 10215624176 10520408064 909205840 9.989 73 46 94 1 927861296 2570592 16084864
19:58:04 22100 8192000000 10329722752 10642001920 1376632528 14.386 100 87 174 0 1410348496 4733584 28982384
19:58:39 20862 8192000000 10359076800 10678054912 1414018080 14.720 100 83 166 0 1446691328 5760416 26912832
19:59:09 14398 8192000000 10382828000 10706841600 1437651040 14.929 100 78 156 0 1469273920 6488416 25134464
19:59:40 16938 8192000000 10417932976 10741690368 1465842688 15.177 100 87 174 1 1501599376 7306688 28450000
20:00:09 13973 8192000000 10428103152 10759106560 1481018992 15.310 100 91 182 1 1519118176 8029792 30069392
20:00:35 21815 8192000000 10440106816 10772271104 1493957760 15.423 100 86 172 0 1530234288 8468736 27807792
20:01:06 15779 8192000000 10462882864 10797789184 1514268192 15.600 100 86 172 0 1550661008 8999248 27393568
20:01:29 12109 8192000000 10478876992 10815090688 1526664592 15.708 100 77 154 0 1559963600 9008128 24290880
20:01:50 21976 8192000000 10509272048 10856771584 1563586144 16.027 100 82 164 1 1598653696 9718384 25349168
20:02:21 16063 8192000000 10535503872 10884083712 1590327728 16.257 100 78 154 0 1624466832 9738656 24400448
20:02:48 17602 8192000000 10552667824 10906746880 1612121408 16.443 100 83 166 1 1648571776 11138176 25312192
20:03:16 14193 8192000000 10577195200 10935525376 1630266464 16.597 100 79 158 1 1665069760 11464656 23338640
20:03:40 8504 8192000000 10583018944 10947407872 1646147648 16.732 100 80 160 1 1682149904 11756544 24245712
20:03:57 13740 8192000000 10612733856 10974441472 1669097552 16.926 100 79 158 0 1703448704 11253024 23098128
20:04:21 7762 8192000000 10629450384 10996289536 1688545024 17.089 100 76 152 2 1722565488 11544976 22475488
20:04:37 7433 8192000000 10645796448 11019460608 1706252160 17.237 100 70 140 0 1737950592 11633824 20064608
20:04:54 4839 8192000000 10665379392 11038232576 1722784576 17.375 100 79 155 2 1757135088 12062272 22288240
20:05:06 6416 8192000000 10673644880 11046322176 1737037360 17.494 100 81 160 1 1771686192 12172976 22475856
20:05:20 4196 8192000000 10682951952 11062345728 1750559120 17.606 100 75 149 1 1783978752 11879952 21539680
20:05:31 5159 8192000000 10699437760 11076046848 1764249456 17.720 100 78 153 1 1796754768 11066240 21439072
20:05:43 4454 8192000000 10711804048 11094056960 1775787728 17.815 100 78 156 4 1809931584 12427584 21716272
20:05:55 3787 8192000000 10726768576 11105488896 1788056272 17.916 100 87 171 2 1825470416 13930816 23483328
20:06:06 4561 8192000000 10731879952 11111952384 1792690752 17.954 100 84 168 1 1830230640 14175728 23364160
20:06:17 4619 8192000000 10743440480 11123286016 1800987664 18.022 100 85 170 1 1838401888 13367856 24046368
20:06:28 2809 8192000000 10742291072 11125121024 1807150176 18.073 100 89 181 0 1846258944 14159376 24949392
20:06:38 1808 8192000000 10752545536 11130064896 1810458112 18.100 100 90 180 0 1849710672 14065248 25187312
20:06:46 1817 8192000000 10760407408 11139608576 1817981024 18.161 100 87 174 1 1856526608 13900608 24644976
20:06:55 8109 8192000000 10750354576 11137355776 1819282656 18.172 100 89 178 1 1858685168 13893504 25509008
20:07:10 4713 8192000000 10770344336 11154915328 1824726624 18.216 100 81 161 3 1860856336 13652112 22477600
20:07:21 1519 8192000000 10785924032 11170021376 1845064608 18.382 100 86 172 0 1880827872 12097984 23665280
20:07:29 2006 8192000000 10798008176 11179909120 1850437456 18.426 100 88 176 0 1889078416 13701072 24939888
20:07:37 1261 8192000000 10801074896 11186896896 1855464272 18.466 100 90 176 1 1894169600 13748736 24956592
20:07:44 1862 8192000000 10802051072 11189424128 1862929392 18.527 100 93 190 2 1901733264 11979232 26824640
20:07:53 1314 8192000000 10809198368 11193597952 1865636368 18.549 100 91 186 0 1902699152 10758064 26304720
20:08:01 1620 8192000000 10814674736 11200851968 1867938608 18.568 100 90 181 1 1905866208 12444416 25483184
20:08:09 1271 8192000000 10819003408 11207229440 1872243216 18.602 100 94 187 2 1910689936 12277360 26169360
20:08:17 1805 8192000000 10822311856 11207573504 1874864480 18.624 100 86 172 1 1911490464 11645072 24980912
20:08:25 11393 8192000000 10785758608 11206209536 1876234992 18.635 100 72 144 0 1908754096 12273776 20245328
20:08:58 19319 8192000000 10814435008 11216093184 1876712608 18.639 100 66 136 1 1907381392 10424880 20243904
20:09:24 13595 8192000000 10801496880 11212566528 1879729728 18.663 100 44 88 0 1900601632 8505152 12366752
20:09:50 7752 8192000000 10785444112 11214077952 1880776592 18.671 100 25 50 1 1894376096 6656128 6943376
20:10:09 3586 8192000000 10806376384 11223724032 1884133216 18.698 100 36 72 2 1902632896 7950976 10548704
20:10:22 7589 8192000000 10802613920 11224514560 1887166080 18.723 100 30 60 0 1903214832 7402320 8646432
20:10:36 9601 8192000000 10792857680 11221114880 1886218512 18.715 100 17 32 4 1896389760 5837504 4333744
20:10:58 8890 8192000000 10797883520 11229433856 1891214912 18.756 100 18 36 2 1902796064 5971760 5609392
20:11:13 9978 8192000000 10805123712 11232329728 1891776752 18.760 100 20 39 1 1902799664 5781904 5241008
20:11:34 6053 8192000000 10799645152 11230547968 1893275808 18.772 100 26 51 1 1907520208 6478048 7766352
20:11:48 8901 8192000000 10818520480 11236454400 1894573616 18.783 100 21 42 0 1906336560 6203200 5559744
20:12:04 7178 8192000000 10795435232 11235790848 1894392448 18.781 100 23 46 1 1907632336 6450192 6789696
20:12:17 10880 8192000000 10797882576 11235225600 1895332800 18.789 100 21 42 1 1907433824 5877088 6223936
20:12:39 10870 8192000000 10803329024 11236958208 1895528800 18.790 100 15 30 2 1905555920 5836992 4190128
20:12:57 5581 8192000000 10817625584 11250044928 1901592256 18.839 100 26 52 1 1923560976 15375360 6593360
20:13:09 9477 8192000000 10806426080 11239915520 1899768336 18.824 100 15 30 1 1909073840 5445264 3860240
20:13:25 17045 8192000000 10822406752 11243880448 1904147680 18.860 100 27 55 0 1916668464 5290080 7230704
20:13:51 56962 8192000000 10867117184 11266596864 1910154640 18.908 100 48 97 0 1930541824 6046112 14341072
20:14:54 5087 8192000000 10824550976 11256352768 1906918224 18.882 100 23 46 0 1920491152 7084880 6488048
20:15:08 6125 8192000000 10827467424 11261669376 1912074688 18.923 100 29 58 0 1926867024 6878800 7913536
20:15:23 7923 8192000000 10830634928 11262754816 1914615120 18.944 100 34 68 1 1931564608 7246304 9703184
20:15:41 4037 8192000000 10838565840 11266387968 1916371680 18.958 100 44 87 1 1936184192 7514976 12297536
20:15:55 6254 8192000000 10808907472 11242528768 1893514400 18.774 99 27 54 1 1912577744 11393472 7669872
20:16:07 9355 8192000000 10817792000 11252211712 1891109600 18.755 99 19 38 0 1901677968 4640672 5927696
20:16:22 9215 8192000000 10819156144 11241938944 1871174560 18.594 98 27 51 1 1884695344 5765968 7754816
20:16:38 6457 8192000000 10807149888 11237384192 1875760848 18.631 99 18 36 1 1886454480 5504976 5188656
20:16:52 8866 8192000000 10792299520 11219681280 1842791616 18.364 97 29 57 2 1857464032 5819728 8852688
20:17:09 8964 8192000000 10779661008 11204321280 1807369040 18.074 96 26 52 1 1820200608 5105952 7725616
20:17:26 4761 8192000000 10788577472 11207249920 1825974608 18.226 97 29 58 1 1841177840 6408192 8795040
20:17:37 6892 8192000000 10783140912 11214225408 1870175680 18.586 100 30 60 2 1885773600 6870192 8727728
20:17:53 54569 8192000000 10792287568 11208712192 1792204064 17.950 95 32 64 0 1806205744 5115152 8886528
20:18:55 22689 8192000000 10699287808 11117780992 1645348352 16.725 89 17 34 0 1655309600 5033840 4927408
20:19:29 5345 8192000000 10716035808 11125161984 1755701872 17.649 98 42 84 2 1778466256 10498624 12265760
20:19:41 6143 8192000000 10690916896 11105722368 1748506160 17.589 97 28 56 0 1763986304 7488128 7992016
20:19:54 6528 8192000000 10710961984 11134328832 1784580464 17.887 99 31 62 3 1800037040 6731760 8724816
20:20:07 7520 8192000000 10700854352 11112996864 1741376304 17.530 97 26 52 1 1755751424 6577712 7797408
20:20:21 5160 8192000000 10710039168 11108483072 1778701824 17.839 100 28 56 2 1793517008 6605392 8209792
20:20:33 9387 8192000000 10666100896 11077308416 1677784000 16.999 94 31 62 2 1692893616 5430384 9679232
20:20:53 9910 8192000000 10706922576 11128844288 1779969760 17.849 99 27 54 2 1793605008 5726848 7908400
20:21:11 6565 8192000000 10730990864 11143491584 1778877600 17.840 98 20 40 0 1790438112 5442320 6118192
20:21:28 7474 8192000000 10731559408 11151761408 1797845360 17.996 99 26 50 1 1814897232 10356736 6695136
20:21:41 8221 8192000000 10723658528 11145715712 1785303664 17.893 98 23 46 0 1797458048 5148144 7006240
20:21:57 7472 8192000000 10717675968 11144343552 1802051376 18.031 99 22 42 1 1813922528 5842592 6028560
20:22:16 3280 8192000000 10726481056 11137753088 1806826368 18.070 100 32 64 1 1822109280 5381712 9901200
20:22:25 6207 8192000000 10734251328 11145879552 1797811040 17.996 99 34 68 1 1813720384 5337488 10571856
20:22:39 17257 8192000000 10732043440 11155947520 1767605888 17.747 97 27 54 0 1785519696 10106544 7807264
20:23:09 68387 8192000000 10754442016 11174084608 1830594736 18.264 100 20 40 0 1841834800 5087600 6152464
20:24:28 15483 8192000000 10756131984 11182301184 1822157920 18.195 99 18 36 0 1832959264 5628176 5173168
20:24:51 5769 8192000000 10769020416 11193200640 1852072704 18.439 100 36 72 2 1868365872 5916768 10376400
20:25:05 6915 8192000000 10782898768 11200774144 1855375728 18.466 100 41 80 1 1873831472 7460288 10995456
20:25:18 7127 8192000000 10779010544 11200778240 1855354400 18.466 100 37 73 1 1872848416 6926624 10567392
20:25:33 5993 8192000000 10776158384 11204509696 1857198032 18.481 100 35 70 1 1874249408 7210624 9840752
20:25:45 9589 8192000000 10766355888 11201855488 1860023328 18.503 100 18 36 1 1870658256 5352928 5282000
20:26:03 10866 8192000000 10781498416 11210801152 1864437120 18.539 100 16 32 1 1874613200 5715472 4460608
20:26:22 11971 8192000000 10792837008 11216723968 1867326864 18.563 100 21 42 3 1882890160 10188832 5374464
20:26:42 11873 8192000000 10783140208 11215360000 1870565808 18.589 100 29 59 2 1884717120 5951168 8200144
20:27:00 9174 8192000000 10802284016 11230593024 1881208784 18.675 100 21 43 0 1891919008 4795200 5915024
20:27:17 22524 8192000000 10808164032 11238076416 1895163952 18.787 100 28 56 2 1907159184 4223696 7771536
20:27:53 38407 8192000000 10846738144 11267842048 1905748528 18.873 100 42 77 2 1922374352 5841232 10784592
20:28:41 20851 8192000000 10863406992 11280637952 1923701696 19.016 100 57 112 1 1950464416 10977744 15784976
20:29:14 106542 8192000000 10854703392 11301502976 1933386224 19.094 100 41 80 2 1957911968 12880144 11645600
20:31:21 45303 8192000000 10880995168 11317596160 1946241024 19.197 100 47 91 1 1974224752 14420560 13563168
20:32:18 38556 8192000000 10891952640 11334266880 1955544384 19.271 100 35 71 2 1982585552 16619696 10421472
20:33:04 50615 8192000000 10914142016 11348430848 1968082336 19.370 100 35 70 2 2001475904 22808704 10584864
20:34:04 8091 8192000000 10923516224 11353870336 1977275632 19.443 100 52 105 4 2015661024 22611232 15774160
20:34:20 27768 8192000000 10930539440 11369275392 1982090480 19.481 100 42 84 0 2019045520 23938816 13016224
20:34:56 14988 8192000000 10932457888 11373150208 1986448016 19.516 100 45 90 0 2027642400 27761536 13432848
20:35:19 12347 8192000000 10946386144 11377291264 1989384880 19.539 100 45 88 1 2029969632 26640000 13944752
20:35:40 21160 8192000000 10956679680 11393728512 2003198272 19.648 100 54 108 0 2049449232 30195200 16055760
20:36:15 7254 8192000000 10968380752 11401887744 2011902800 19.716 100 57 113 1 2061131584 31711856 17516928
20:36:35 3177 8192000000 10984835312 11409932288 2017126688 19.758 100 83 161 2 2074109936 32365568 24617680
20:36:47 4408 8192000000 10980186960 11412004864 2016984256 19.756 100 64 127 1 2069641904 33583776 19073872
20:36:59 11901 8192000000 10996335648 11415588864 2015116512 19.742 100 68 136 1 2070732432 35551248 20064672
20:37:19 4308 8192000000 10971638032 11410145280 2008761824 19.692 100 53 104 2 2064112256 38390720 16959712
20:37:30 5808 8192000000 10976406192 11412578304 2014404544 19.736 100 53 106 2 2069036368 38283680 16348144
20:37:43 6819 8192000000 10969424544 11403747328 1998715648 19.613 99 49 96 2 2053278480 38875648 15687184
20:38:00 6049 8192000000 10979469424 11417432064 2017522128 19.761 100 50 100 0 2070019440 37180832 15316480
20:38:13 2481 8192000000 10986757008 11420545024 2019486864 19.776 100 51 102 4 2070554784 35991296 15076624
20:38:23 3650 8192000000 10999813024 11426828288 2009519056 19.698 99 69 134 0 2071345952 41923088 19903808
20:38:35 3958 8192000000 10992821440 11419209728 2018491088 19.768 100 75 151 0 2080412608 38997856 22923664
20:38:46 2820 8192000000 11004569552 11418255360 2016005520 19.749 100 77 154 2 2079802544 40210544 23586480
20:39:00 2145 8192000000 10995639248 11417501696 2013896592 19.732 100 80 160 1 2078445440 40448160 24100688
20:39:08 2243 8192000000 10996079216 11418300416 2017999968 19.764 100 81 161 1 2082732160 40907424 23824768
20:39:18 3163 8192000000 10993861968 11406430208 1996617072 19.596 99 83 164 3 2062966160 41909424 24439664
20:39:28 4199 8192000000 10991977760 11413286912 2011650992 19.715 100 75 148 1 2077487728 42424176 23412560
20:39:40 4440 8192000000 10973688496 11394383872 1981527664 19.477 99 78 154 3 2048478736 43419376 23531696
20:39:52 12681 8192000000 10970533968 11401146368 1995117200 19.584 100 70 140 1 2061700240 44729712 21853328
20:40:12 5387 8192000000 10981603312 11409375232 2002505792 19.642 100 71 141 0 2069434720 44880384 22048544
20:40:26 5159 8192000000 10985792352 11408527360 1995653456 19.588 100 65 130 2 2063186688 46872320 20660912
20:40:38 2601 8192000000 10990060112 11402285056 1997029792 19.599 100 76 150 1 2068136320 47643536 23462992
20:40:52 2565 8192000000 10989701584 11409870848 2000367968 19.626 100 77 151 1 2072779904 48399040 24012896
20:41:03 1697 8192000000 10991607120 11410800640 1997098144 19.600 100 82 163 2 2071667280 48956160 25612976
20:41:13 7797 8192000000 10989813136 11417026560 2004340592 19.657 100 76 151 2 2076838464 48651136 23846736
20:41:29 3034 8192000000 11005519056 11425566720 2013107296 19.726 100 89 178 1 2088054512 47733792 27213424
20:41:42 2616 8192000000 10999704128 11421806592 2017505632 19.761 100 77 153 1 2089585200 48536672 23542896
20:41:53 2323 8192000000 11009638464 11423600640 2015355024 19.744 100 94 188 0 2089972368 45498800 29118544
20:42:02 2539 8192000000 10989381856 11405557760 1998324608 19.610 99 81 164 1 2068547952 45602736 24620608
20:42:12 3373 8192000000 11012074128 11429752832 2021020672 19.788 100 89 180 3 2093792384 45950368 26821344
20:42:23 2862 8192000000 11005380912 11427033088 2018099984 19.765 100 86 168 1 2091662992 46986048 26576960
20:42:35 5091 8192000000 10975050432 11403399168 1990343152 19.547 100 64 126 3 2057434096 47012816 20078128
20:42:49 3051 8192000000 10985156544 11407622144 1990606592 19.549 100 73 146 2 2064044480 50618544 22819344
20:42:59 945 8192000000 10993113248 11409727488 1994514560 19.579 100 88 179 0 2073425584 51579456 27331568
20:43:10 8290 8192000000 10994062272 11417784320 2001814272 19.637 100 83 167 1 2081600960 53575984 26210704
20:43:25 3493 8192000000 11008439872 11424555008 2005676720 19.667 100 81 160 2 2085368784 55065008 24627056
20:43:35 2131 8192000000 11000110864 11418677248 1988387200 19.531 99 81 162 0 2071377872 57205392 25785280
20:43:44 3928 8192000000 10974208464 11396820992 1973771632 19.415 99 72 144 2 2054716848 57919648 23025568
20:44:00 7258 8192000000 11003429680 11425165312 1998669504 19.612 100 77 153 1 2082911296 59033808 25207984
20:44:16 1646 8192000000 10994341776 11414900736 1990153408 19.545 100 85 170 0 2077540768 59271216 28116144
20:44:27 3616 8192000000 10974900384 11398766592 1971097824 19.394 99 70 138 1 2046540624 53412448 22030352
20:44:41 5355 8192000000 10949639440 11370590208 1956018080 19.274 99 66 132 3 2030896400 54336064 20542256
20:44:54 1350 8192000000 10963095056 11369951232 1954818512 19.265 99 82 164 1 2033853808 53361856 25673440
20:45:03 1444 8192000000 10984003088 11396644864 1961774848 19.320 99 84 167 3 2043762352 55386208 26601296
20:45:11 6209 8192000000 10956375648 11393126400 1977752864 19.447 100 68 136 1 2055445664 55362496 22330304
20:45:26 13413 8192000000 10953200368 11390726144 1964372640 19.341 99 40 80 1 2027691632 49392368 13926624
20:45:52 10081 8192000000 10962242576 11395481600 1966159072 19.355 99 51 100 2 2034904096 51974000 16771024
20:46:12 3742 8192000000 10962012912 11387351040 1970129392 19.386 100 63 127 1 2045568608 54940256 20498960
20:46:22 6498 8192000000 10971219504 11400888320 1980495952 19.469 100 52 104 2 2055200064 56257312 18446800
20:46:37 10830 8192000000 10974786480 11414851584 1989629952 19.541 100 54 108 0 2067936064 59654928 18651184
20:46:55 9839 8192000000 10970098784 11413819392 1969487472 19.381 99 47 94 1 2045737728 60066624 16183632
20:47:12 7811 8192000000 10963536384 11405987840 1964937392 19.345 99 39 78 0 2036331360 57929680 13464288
20:47:36 7321 8192000000 10975468528 11402485760 1955338096 19.269 99 62 123 0 2036469056 61104368 20026592
20:47:52 2857 8192000000 10974224240 11391782912 1959987600 19.306 99 72 144 0 2047495712 63779328 23728784
20:48:01 5711 8192000000 10970562368 11398324224 1960980432 19.314 99 65 130 1 2041945360 59500176 21464752
20:48:18 12341 8192000000 10968402416 11409108992 1977361056 19.444 100 49 98 1 2052367504 57840432 17166016
20:48:39 10760 8192000000 10973718272 11411836928 1972183184 19.403 99 44 88 1 2039367408 52005152 15179072
20:49:01 12296 8192000000 10964384720 11409063936 1974311264 19.420 99 39 78 2 2038549136 50609632 13628240
20:49:21 23533 8192000000 10951380176 11407015936 1971881776 19.400 99 37 74 0 2037014720 51846608 13286336
20:49:57 19794 8192000000 10942420832 11390025728 1953390320 19.253 99 35 70 1 2016376304 50746496 12239488
20:50:24 11254 8192000000 10940327328 11393024000 1967226912 19.363 100 36 70 3 2031649680 51523936 12898832
20:51:00 11696 8192000000 10935477184 11385257984 1963312880 19.332 100 31 62 3 2014429568 40484832 10631856
20:51:38 21824 8192000000 10923051472 11369619456 1944726592 19.184 99 25 50 0 1992039568 38080976 9232000
20:52:06 25947 8192000000 10921929984 11385860096 1950435024 19.230 100 26 50 3 2001729808 42513184 8781600
20:52:45 37563 8192000000 10886417616 11344105472 1845831072 18.388 95 17 34 0 1896161904 43915872 6414960
20:53:29 18319 8192000000 10873318752 11323572224 1884051408 18.698 98 14 28 0 1920513744 31302144 5160192
20:53:54 10269 8192000000 10872181504 11333779456 1921047616 18.995 100 17 34 0 1960721264 33631936 6041712
20:54:11 25939 8192000000 10855670720 11329957888 1901626272 18.839 99 12 24 1 1930397648 24367024 4404352
20:54:44 100239 8192000000 10863179584 11326836736 1894101216 18.779 98 22 44 1 1912954752 11797840 7055696
20:56:44 74483 8192000000 10876746736 11340562432 1919082224 18.979 99 22 42 3 1935259408 9751152 6426032
20:59:01 35366 8192000000 10873268192 11316432896 1889028560 18.738 97 24 48 0 1904234848 8894864 6311424
20:59:49 100463 8192000000 10876980176 11343847424 1908728016 18.896 97 22 44 0 1925562448 10850176 5984256
21:01:36 36300 8192000000 10884146128 11320688640 1889317760 18.740 96 57 112 2 1911853680 7046128 15489792
21:02:19 22035 8192000000 10882720928 11336916992 1948501840 19.215 100 24 46 3 1964993904 9442288 7049776
21:02:50 38809 8192000000 10892490368 11341254656 1952064480 19.243 100 30 60 2 1972320784 11349920 8906384
21:03:38 35373 8192000000 10893252912 11350396928 1957282480 19.284 100 35 69 3 1979805168 12029680 10493008
21:04:28 45890 8192000000 10899762592 11362050048 1942554784 19.167 99 32 64 1 1967377168 15500624 9321760
21:05:23 40049 8192000000 10887336256 11367796736 1962085024 19.323 100 7 14 0 1977460432 13504272 1871136
21:07:02 27380 8192000000 10889642496 11369476096 1977184976 19.442 100 9 18 1 1985770512 6275904 2309632
21:07:36 5728 8192000000 10894289680 11369820160 1977757424 19.447 100 6 12 2 1985351840 6316368 1278048
21:07:48 3986 8192000000 10892831744 11370930176 1978385232 19.452 100 7 14 2 1986668512 6157456 2125824
21:07:59 11411 8192000000 10906216192 11372204032 1979337232 19.459 100 7 13 0 1986972352 6003312 1631808
21:08:31 25426 8192000000 10899479696 11368706048 1975627728 19.430 100 17 34 1 1987909696 7625056 4656912
21:09:06 36942 8192000000 10885770736 11361701888 1954639552 19.263 99 11 22 0 1964824608 7016000 3169056
21:10:08 83426 8192000000 10878133216 11349819392 1935789856 19.113 98 23 46 1 1949110432 6098416 7222160
21:11:40 76626 8192000000 10885319760 11365658624 1950138416 19.228 99 13 26 0 1960797024 7705600 2953008
21:13:11 4911 8192000000 10897714656 11367559168 1978974448 19.457 100 24 48 0 1993305488 7132768 7198272
21:13:22 17314 8192000000 10907508368 11374919680 1982557376 19.485 100 31 62 2 1999498784 7943184 8998224
21:13:56 43114 8192000000 10896914544 11377246208 1967034848 19.362 99 24 48 1 1984313728 10252608 7026272
21:14:46 62588 8192000000 10888425792 11371421696 1944262656 19.181 98 9 18 0 1957198976 10022144 2914176
21:15:55 64024 8192000000 10899924688 11372236800 1946365472 19.198 98 15 30 0 1964883648 12781664 5736512
21:17:05 46625 8192000000 10887587520 11375644672 1969370352 19.380 100 16 32 2 1986812432 12598592 4843488
21:17:58 28623 8192000000 10898410032 11364376576 1957798128 19.289 99 21 42 2 1970981184 7005280 6177776
21:18:34 37947 8192000000 10917238160 11381473280 1966100448 19.355 99 26 50 2 1984892256 11231472 7560336
21:19:21 29102 8192000000 10929021920 11397464064 1994892464 19.582 100 37 74 0 2017972048 12658928 10420656
21:20:02 31044 8192000000 10904892480 11385499648 1953980816 19.258 98 23 46 0 1974737776 14154544 6602416
21:20:39 34560 8192000000 10917193072 11393019904 1985133664 19.505 100 18 35 1 2004852544 13913056 5805824
21:21:20 89115 8192000000 10907928128 11387412480 1870640032 18.589 94 9 19 0 1884337872 11306016 2391824
21:22:55 43652 8192000000 10902711152 11358629888 1934093600 19.100 98 15 30 1 1950679568 12248288 4337680
21:23:50 70783 8192000000 10869614880 11346935808 1843704720 18.371 94 21 40 2 1861128832 11496064 5928048
21:25:32 41040 8192000000 10867283072 11326685184 1892717088 18.768 97 27 55 1 1912387280 11562224 8107968
21:26:28 51642 8192000000 10884793264 11349241856 1931389856 19.078 99 23 46 2 1948568288 10736128 6442304
21:27:32 82675 8192000000 10868760656 11334328320 1882126704 18.682 96 14 25 1 1894235376 8516464 3592208
21:29:01 59168 8192000000 10850279056 11310649344 1886466464 18.717 97 22 44 0 1899414560 7173696 5774400
21:30:10 44279 8192000000 10841964096 11321970688 1918886736 18.978 99 18 36 0 1932725216 8692304 5146176
21:31:00 28242 8192000000 10842034128 11325648896 1917758544 18.969 99 3 6 0 1926548576 8022384 767648
21:31:34 6581 8192000000 10847460272 11328966656 1914611712 18.944 99 5 10 1 1923174352 7519840 1042800
21:31:47 22993 8192000000 10859099600 11335278592 1937139872 19.124 100 6 12 0 1948976672 10342640 1494160
21:32:23 44674 8192000000 10843139344 11307507712 1868960800 18.576 96 11 22 0 1884667888 11944416 3762672
21:33:14 74036 8192000000 10848098576 11317870592 1851133904 18.431 96 8 16 0 1867296480 13754272 2408304
21:34:34 58906 8192000000 10859771424 11320238080 1885324000 18.708 97 23 46 1 1900433648 8813120 6296528
21:35:56 35213 8192000000 10848336944 11316146176 1889541536 18.742 97 16 32 2 1905286512 9931936 5813040
21:36:37 45575 8192000000 10838149840 11289247744 1813714608 18.126 94 20 40 1 1830374912 10686144 5974160
21:37:46 74205 8192000000 10828204944 11307048960 1844686208 18.379 96 12 24 1 1862089616 14193712 3209696
21:39:13 50278 8192000000 10820859312 11268534272 1818547424 18.166 95 26 52 3 1834211648 8594240 7069984
21:40:13 64388 8192000000 10871491088 11329445888 1902690640 18.848 99 32 64 0 1925587152 13891904 9004608
21:41:27 52880 8192000000 10860398080 11328823296 1879265040 18.659 97 21 42 0 1898386384 12913440 6207904
21:42:45 50924 8192000000 10873227424 11338227712 1918568672 18.975 99 17 35 1 1936980640 13694224 4717744
21:43:48 56211 8192000000 10861336304 11327516672 1914576144 18.943 99 14 28 1 1935884448 17216976 4091328
21:44:56 68214 8192000000 10877186224 11359653888 1906511728 18.879 98 19 38 0 1932550848 20953296 5085824
21:46:10 92553 8192000000 10860329520 11324432384 1863650960 18.533 96 14 28 0 1880848640 12988544 4209136
21:48:41 70157 8192000000 10864986704 11336503296 1942254880 19.165 100 17 34 0 1956015168 9226144 4534144
21:49:57 92127 8192000000 10871341520 11342442496 1914910912 18.946 98 13 26 0 1933120832 14755216 3454704
21:51:46 72593 8192000000 10860819760 11335716864 1926926624 19.042 99 14 28 1 1948809280 17583424 4299232
21:53:53 71621 8192000000 10888531648 11392229376 1963133984 19.331 100 18 35 1 1990134672 21788976 5211712
21:55:32 93322 8192000000 10880561280 11357597696 1887415328 18.725 96 10 20 0 1905236112 14764256 3056528
21:57:12 58993 8192000000 10921903904 11372802048 1957065776 19.283 99 31 61 4 1975959136 10815136 8078224
21:58:18 33369 8192000000 10883629344 11350228992 1953598992 19.255 99 25 50 1 1970929488 10760880 6569616
21:58:58 91010 8192000000 10908483312 11385511936 1919276976 18.981 97 14 28 0 1935035920 12212768 3546176
22:00:35 57821 8192000000 10923984304 11390001152 1963441920 19.333 99 30 60 0 1989517728 17965296 8110512
22:01:49 52689 8192000000 10930242928 11400273920 1987675952 19.525 100 23 46 0 2004699328 10756352 6267024
22:02:51 68093 8192000000 10933399312 11411214336 1992217808 19.561 100 29 58 2 2017379264 16960864 8200592
22:04:15 23938 8192000000 10918363280 11387236352 1958225520 19.292 98 25 49 2 1977056864 11656496 7174848
22:04:49 16549 8192000000 10930396848 11389587456 1968525744 19.374 99 25 50 1 1985058400 9568800 6963856
22:05:11 71486 8192000000 10903472192 11367137280 1929964560 19.067 97 22 44 0 1947185760 11346176 5875024
22:06:29 23628 8192000000 10940957024 11386933248 1968659904 19.375 99 47 93 2 1992565008 10546256 13358848
22:07:02 16676 8192000000 10932739696 11395063808 1988489200 19.532 100 48 96 0 2013177968 10962224 13726544
22:08:25 130647 8192000000 10913206144 11373785088 1929119456 19.060 97 27 54 0 1952204032 15088928 7995648
22:10:45 84986 8192000000 10896277120 11376492544 1922832576 19.010 97 29 57 2 1943266368 12388304 8045488
22:12:25 55497 8192000000 10874924912 11367456768 1931194848 19.076 98 11 21 2 1949612208 15151680 3265680
22:13:49 47558 8192000000 10876200352 11367374848 1964381536 19.341 100 6 12 0 1973841904 8109920 1350448
22:14:43 25422 8192000000 10860706112 11330609152 1891907792 18.761 96 18 36 1 1903084944 5593760 5583392
22:15:15 57131 8192000000 10876963600 11352657920 1943898592 19.178 100 13 26 0 1954509520 6732048 3878880
22:16:25 80098 8192000000 10889486496 11367407616 1957391440 19.285 100 22 44 2 1976529728 12468800 6669488
22:17:51 65934 8192000000 10858087168 11330646016 1859985472 18.503 95 8 16 0 1875654320 13013360 2655488
22:19:23 88411 8192000000 10874902192 11353722880 1905086448 18.867 97 8 16 2 1916929328 9535520 2307360
22:21:03 34650 8192000000 10880931616 11351449600 1931183376 19.076 99 19 38 1 1942475808 6163088 5129344
22:21:53 48776 8192000000 10857182816 11334631424 1866314592 18.554 95 18 36 0 1883134976 11321680 5498704
22:22:56 66645 8192000000 10826243392 11297804288 1785387200 17.894 92 16 32 0 1801936752 11853440 4696112
22:24:15 70986 8192000000 10846613520 11298402304 1814854848 18.136 94 31 63 2 1834487792 10707168 8925776
22:25:32 42114 8192000000 10843934640 11300163584 1849872928 18.421 97 26 52 1 1867480896 10548944 7059024
22:26:22 29851 8192000000 10849003856 11301662720 1889106608 18.739 99 34 68 0 1910168240 11840224 9221408
22:26:58 28216 8192000000 9537857328 9855090688 669377136 7.553 35 20 38 1 679786848 5004816 5404896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-03-2021 22:28:28 to 23-03-2021 22:28:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 87 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

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

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          247600
MON$OLDEST_ACTIVE               247601
MON$OLDEST_SNAPSHOT             247601
MON$NEXT_TRANSACTION            247601
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                       2018752
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:184: 
:185: mscs-test-161.budzdorov.ru    Tue Mar 23 22:27:34 2021
:186:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:187: 
--- end of diff output ---

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

23.03.21 22:29:03. 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-23 22:29:06 No severe PSQL-related problems occured
23.03.21 22:29:07. End of report.