Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.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 17588704 kB
MemAvailable 31533100 kB
Buffers 0 kB
Cached 14060884 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-15 22:27:22
DTS_END                         2021-03-15 22:27:22.4300
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/37230
TRN_ID                          235313
ATT_ID                          710
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: 9276.60 22259 1113192
customer order: creation 163.20 369 19584
customer order: refuse 13.87 350 1664
order to supplier: creation 44.35 1291 5322
order to supplier: removal 3.54 98731 425
invoice (draft): creation 44.03 3276 5284
invoice (draft): removal 53.92 757 6470
invoice accept: apply 40.51 18652 4861
invoice accept: cancel 48.50 726 5820
customer reserve: creation 3804.53 183 456544
customer reserve: removal 4765.19 58 571823
realization accept: apply 80.59 192 9671
realization accept: cancel 89.93 107 10791
payment from customer: creation 56.83 152 6819
payment from customer: removal 5.48 85 657
payment to supplier: creation 47.55 139 5706
payment to supplier: removal 3.31 75 397
service: total inventory turnovers 4.23 1304 508
service: total monetary turnovers 6.08 26 729
service: aggregate perf. data 0.94 17768 113
service: refresh index statistics 0.03 300937 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-03-2021 22:28:03 to 15-03-2021 22:28:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4115
TEST_TIME 2 4829
TEST_TIME 3 3355
TEST_TIME 4 3368
TEST_TIME 5 3479
TEST_TIME 6 3970
TEST_TIME 7 5097
TEST_TIME 8 4920
TEST_TIME 9 5342
TEST_TIME 10 5314
TEST_TIME 11 5924
TEST_TIME 12 6052
TEST_TIME 13 6463
TEST_TIME 14 6613
TEST_TIME 15 7273
TEST_TIME 16 7425
TEST_TIME 17 7629
TEST_TIME 18 7847
TEST_TIME 19 7796
TEST_TIME 20 8185
TEST_TIME 21 8317
TEST_TIME 22 8736
TEST_TIME 23 8841
TEST_TIME 24 9438
TEST_TIME 25 9921
TEST_TIME 26 11205
TEST_TIME 27 10911
TEST_TIME 28 10661
TEST_TIME 29 10492
TEST_TIME 30 10470
TEST_TIME 31 10302
TEST_TIME 32 10189
TEST_TIME 33 10094
TEST_TIME 34 10098
TEST_TIME 35 9980
TEST_TIME 36 9755
TEST_TIME 37 9600
TEST_TIME 38 9609
TEST_TIME 39 9610
TEST_TIME 40 9587
TEST_TIME 41 9623
TEST_TIME 42 9626
TEST_TIME 43 9513
TEST_TIME 44 9430
TEST_TIME 45 9534
TEST_TIME 46 9591
TEST_TIME 47 9765
TEST_TIME 48 9887
TEST_TIME 49 9949
TEST_TIME 50 9842
TEST_TIME 51 9908
TEST_TIME 52 9890
TEST_TIME 53 9744
TEST_TIME 54 9651
TEST_TIME 55 9645
TEST_TIME 56 9527
TEST_TIME 57 9498
TEST_TIME 58 9532
TEST_TIME 59 9456
TEST_TIME 60 9446
TEST_TIME 61 9480
TEST_TIME 62 9439
TEST_TIME 63 9436
TEST_TIME 64 9511
TEST_TIME 65 9550
TEST_TIME 66 9538
TEST_TIME 67 9562
TEST_TIME 68 9604
TEST_TIME 69 9635
TEST_TIME 70 9521
TEST_TIME 71 9683
TEST_TIME 72 9720
TEST_TIME 73 9679
TEST_TIME 74 9712
TEST_TIME 75 9721
TEST_TIME 76 9673
TEST_TIME 77 9597
TEST_TIME 78 9556
TEST_TIME 79 9563
TEST_TIME 80 9502
TEST_TIME 81 9518
TEST_TIME 82 9497
TEST_TIME 83 9452
TEST_TIME 84 9413
TEST_TIME 85 9381
TEST_TIME 86 9348
TEST_TIME 87 9359
TEST_TIME 88 9357
TEST_TIME 89 9407
TEST_TIME 90 9378
TEST_TIME 91 9396
TEST_TIME 92 9366
TEST_TIME 93 9412
TEST_TIME 94 9464
TEST_TIME 95 9480
TEST_TIME 96 9503
TEST_TIME 97 9563
TEST_TIME 98 9524
TEST_TIME 99 9525
TEST_TIME 100 9510
TEST_TIME 101 9554
TEST_TIME 102 9477
TEST_TIME 103 9448
TEST_TIME 104 9402
TEST_TIME 105 9404
TEST_TIME 106 9348
TEST_TIME 107 9294
TEST_TIME 108 9283
TEST_TIME 109 9302
TEST_TIME 110 9273
TEST_TIME 111 9265
TEST_TIME 112 9250
TEST_TIME 113 9282
TEST_TIME 114 9250
TEST_TIME 115 9293
TEST_TIME 116 9357
TEST_TIME 117 9351
TEST_TIME 118 9332
TEST_TIME 119 9328
TEST_TIME 120 9280

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-03-2021 22:28:07 to 15-03-2021 22:28:10.

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 1534922 1534922 0 0.00 0 29351 7 0 0
doc_list_biud 1534922 1534922 0 0.00 0 32640 27 0 0
sp_add_invoice_to_stock 5013 4861 152 3.03 23 206953 18652 0 152
sp_cancel_adding_invoice 5820 5820 0 0.00 5 61710 727 0 0
sp_cancel_client_order 1664 1664 0 0.00 4 11424 350 0 0
sp_cancel_customer_reserve 571823 571823 0 0.00 1 32645 59 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 7307 86 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 5204 76 0 0
sp_cancel_supplier_invoice 6483 6470 13 0.20 1 15997 757 0 13
sp_cancel_supplier_order 425 425 0 0.00 6 1036616 98731 0 0
sp_cancel_write_off 10791 10791 0 0.00 1 23563 108 0 0
sp_client_order 19584 19584 0 0.00 3 29101 370 0 0
sp_customer_reserve 456544 456544 0 0.00 0 140910 183 0 0
sp_fill_shopping_cart 30182 30182 0 0.00 1 19123 41 0 0
sp_fill_shopping_cart_clo_res 456530 456530 0 0.00 0 18507 15 0 0
sp_get_clo_for_invoice 4847 4847 0 0.00 0 27582 316 0 0
sp_kill_cost_storno 17665 17665 0 0.00 0 23558 56 0 0
sp_kill_qstorno_ret_qs2qd 1161332 1161332 0 0.00 0 32637 32 0 0
sp_kill_qty_storno 611511 611511 0 0.00 0 32638 68 0 0
sp_lock_selected_doc 20025 20025 0 0.00 0 8790 6 0 0
sp_make_cost_storno 27043 27043 0 0.00 0 29345 60 0 0
sp_multiply_rows_for_pdistr 27043 27043 0 0.00 0 25686 38 0 0
sp_multiply_rows_for_qdistr 19584 19584 0 0.00 0 16482 168 0 0
sp_pay_from_customer 6819 6819 0 0.00 4 29521 153 0 0
sp_pay_to_supplier 5706 5706 0 0.00 5 29362 139 0 0
sp_payment_common 12525 12525 0 0.00 1 29502 39 0 0
sp_qd_handle_on_cancel_clo 1664 1664 0 0.00 0 11412 318 0 0
sp_qd_handle_on_invoice_upd_sts 10667 10667 0 0.00 0 29272 296 0 0
sp_qd_handle_on_reserve_upd_sts 9671 9671 0 0.00 0 11125 53 0 0
sp_reserve_write_off 9671 9671 0 0.00 6 19369 193 0 0
sp_supplier_invoice 5284 5284 0 0.00 6 118741 3277 0 0
sp_supplier_order 5322 5322 0 0.00 5 33441 1292 0 0
srv_aggregate_perf_data 113 113 0 0.00 2316 331695 17769 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 1112 136456 35525 0 0
srv_find_qd_qs_mism 1066432 1066432 0 0.00 0 26707 6 0 0
srv_make_invnt_saldo 508 508 0 0.00 50 77918 1304 0 0
srv_make_money_saldo 729 729 0 0.00 0 4234 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 186456 445056 300937 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4861 4861 0 0.00 0 23731 166 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 3700 80 0 0
t$perf-norm:sp_cancel_client_order 1664 1664 0 0.00 0 1226 9 0 0
t$perf-norm:sp_cancel_customer_reserve 644 644 0 0.00 0 2770 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 5968 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 17282 49 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 1004 17 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 35948 1599 0 0
t$perf-norm:sp_cancel_write_off 916 916 0 0.00 0 4343 11 0 0
t$perf-norm:sp_client_order 19584 19584 0 0.00 0 15117 18 0 0
t$perf-norm:sp_customer_reserve 942 942 0 0.00 0 849 6 0 0
t$perf-norm:sp_pay_from_customer 6819 6819 0 0.00 0 6103 9 0 0
t$perf-norm:sp_pay_to_supplier 5706 5706 0 0.00 0 3431 7 0 0
t$perf-norm:sp_reserve_write_off 9671 9671 0 0.00 0 17653 18 0 0
t$perf-norm:sp_supplier_invoice 5284 5284 0 0.00 0 8672 14 0 0
t$perf-norm:sp_supplier_order 5322 5322 0 0.00 0 5588 16 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 134 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 20 1 0 0
t$perf-norm:srv_make_invnt_saldo 508 508 0 0.00 0 1276 19 0 0
t$perf-norm:srv_make_money_saldo 729 729 0 0.00 0 4399 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 18 7 0 0
v_add_invoice_to_stock 9994 9690 304 3.04 0 7319 18 0 304
v_all_customers 36004 36004 0 0.00 0 54 1 0 0
v_all_suppliers 29792 29792 0 0.00 0 183 1 0 0
v_all_wares 39168 39168 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 1199 7 0 0
v_cancel_client_order 3328 3328 0 0.00 0 1315 3 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 2386 5 0 0
v_cancel_customer_reserve 1288 1288 0 0.00 0 1365 8 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 2111 5 0 0
v_cancel_supplier_invoice 834 808 26 3.11 0 2205 19 0 26
v_cancel_supplier_order 850 850 0 0.00 0 252 3 0 0
v_cancel_write_off 1832 1832 0 0.00 0 2444 14 0 0
v_max_id_clo_ord 5320 5320 0 0.00 0 4891 2 0 0
v_max_id_clo_res 942 942 0 0.00 0 4803 21 0 0
v_max_id_ord_sup 5278 5278 0 0.00 0 3080 3 0 0
v_max_non_paid_invoice 1408 1408 0 0.00 0 280 2 0 0
v_max_non_paid_realizn 3415 3415 0 0.00 0 4287 5 0 0
v_min_id_clo_ord 5320 5320 0 0.00 0 3506 8 0 0
v_min_id_clo_res 942 942 0 0.00 0 6509 16 0 0
v_min_id_ord_sup 5278 5278 0 0.00 0 6632 11 0 0
v_min_non_paid_invoice 5706 5706 0 0.00 0 5587 21 0 0
v_min_non_paid_realizn 6819 6819 0 0.00 0 19401 29 0 0
v_our_firm 9972 9972 0 0.00 0 13 1 0 0
v_reserve_write_off 19342 19342 0 0.00 0 6576 5 0 0
x_lock_depdocs_on_canc_invoice 11886 11886 0 0.00 0 25869 106 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 13001 335 0 0
x_make_qstorno_1000_1200 5322 5322 0 0.00 2 33430 1211 0 0
x_make_qstorno_1200_2000 5284 5284 0 0.00 3 118726 3127 0 0
x_make_qstorno_2100_3300 456544 456544 0 0.00 0 140904 166 0 0

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

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 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:32 20375 8192000000 10263399648 10567819264 792693088 8.822 64 42 86 1 809052992 2253056 14106848
19:58:01 32404 8192000000 10360197584 10675331072 1382861280 14.442 100 80 160 1 1413488656 4532032 26095344
19:58:47 23881 8192000000 10392349968 10716401664 1451852992 15.054 100 91 182 0 1487916880 6480080 29583808
19:59:19 22759 8192000000 10420473024 10744696832 1468440224 15.200 100 90 181 1 1508909104 11368960 29099920
19:59:54 18477 8192000000 10421871616 10752225280 1483778928 15.334 100 89 178 1 1520332992 7610336 28943728
20:00:26 28497 8192000000 10459570768 10793340928 1506214672 15.530 100 86 172 0 1541690256 7809376 27666208
20:01:09 13619 8192000000 10482873248 10824044544 1541341200 15.835 100 84 169 0 1575683808 8676816 25665792
20:01:34 19759 8192000000 10507411472 10853834752 1559758240 15.994 100 78 156 2 1593203520 9075472 24369808
20:02:03 13863 8192000000 10539348288 10894442496 1596839856 16.312 100 71 142 0 1627217440 9141472 21236112
20:02:26 9799 8192000000 10559983648 10916397056 1621942352 16.526 100 80 160 0 1655257808 9637616 23677840
20:02:45 11341 8192000000 10581953024 10941034496 1637891680 16.662 100 76 151 1 1670221840 10328000 22002160
20:03:07 17474 8192000000 10610584000 10972078080 1664946832 16.891 100 88 177 3 1701991280 11422432 25622016
20:03:33 9408 8192000000 10611913792 10976751616 1678431376 17.004 100 76 152 1 1711803504 11787072 21585056
20:03:49 11852 8192000000 10627211760 10997985280 1693935472 17.134 100 76 152 1 1727748688 12080544 21732672
20:04:09 7713 8192000000 10639394736 11010400256 1702862064 17.209 100 77 154 1 1737344272 12188512 22293696
20:04:25 6503 8192000000 10663515312 11032297472 1715136544 17.312 100 83 166 1 1751480688 12291664 24052480
20:04:40 9358 8192000000 10664234704 11039195136 1725909968 17.401 100 75 148 3 1760130272 12814400 21405904
20:04:57 6351 8192000000 10670469024 11047088128 1732721440 17.458 100 83 164 0 1769561040 13217040 23622560
20:05:11 8180 8192000000 10676580480 11055812608 1743247216 17.546 100 83 165 2 1780904896 13868544 23789136
20:05:26 5116 8192000000 10698405136 11073142784 1760030800 17.685 100 81 162 1 1796303264 13442608 22829856
20:05:40 5090 8192000000 10715379072 11090546688 1768649232 17.756 100 79 158 3 1804964720 14060544 22254944
20:05:52 4458 8192000000 10713006320 11097497600 1780996192 17.858 100 74 145 2 1814028544 13101760 19930592
20:06:03 3986 8192000000 10722113680 11106131968 1786283184 17.901 100 73 146 1 1819343280 12696784 20363312
20:06:14 4510 8192000000 10737189264 11116179456 1797879360 17.997 100 86 174 0 1835121584 12611424 24630800
20:06:27 4322 8192000000 10730364320 11118329856 1798568032 18.002 100 76 153 2 1833200464 12653600 21978832
20:06:39 4177 8192000000 10748032176 11134148608 1804030128 18.047 100 78 156 1 1838199632 12494928 21674576
20:06:50 2750 8192000000 10757312704 11145654272 1819318128 18.172 100 87 174 0 1858566880 14549216 24699536
20:06:59 2693 8192000000 10764117424 11151765504 1822659360 18.199 100 83 167 1 1860530992 14860672 23010960
20:07:09 3583 8192000000 10774262992 11158515712 1828007744 18.243 100 85 168 1 1866766800 14182400 24576656
20:07:19 3106 8192000000 10779033536 11166380032 1835439136 18.304 100 89 178 3 1873608384 13473792 24695456
20:07:29 2272 8192000000 10780959040 11168030720 1841537888 18.353 100 89 178 0 1880653744 13973792 25142064
20:07:38 1946 8192000000 10785746688 11171368960 1841106720 18.350 100 91 183 0 1879873136 13538864 25227552
20:07:46 2312 8192000000 10791209408 11174928384 1841665936 18.354 100 91 182 1 1881135744 13588144 25881664
20:07:55 1684 8192000000 10791218112 11179106304 1851662512 18.436 100 92 181 2 1889084800 11881712 25540576
20:08:03 1823 8192000000 10784662336 11177390080 1849187456 18.416 100 77 155 2 1881682384 10680000 21814928
20:08:11 2174 8192000000 10807880800 11191730176 1857990640 18.487 100 92 184 0 1896683024 12505184 26187200
20:08:19 2263 8192000000 10807556608 11192217600 1860706768 18.509 100 94 189 0 1900895600 12516944 27671888
20:08:28 2241 8192000000 10803357248 11190263808 1863703088 18.533 100 96 193 0 1903107568 11761936 27642544
20:08:37 1714 8192000000 10808356272 11197140992 1863808432 18.534 100 92 185 2 1902053232 11882928 26361872
20:08:44 38930 8192000000 10802985376 11200303104 1863130688 18.529 100 66 132 0 1894986416 12982832 18872896
20:09:30 11242 8192000000 10783419040 11203518464 1873844656 18.615 100 66 130 3 1902765824 10674064 18247104
20:09:48 4187 8192000000 10785766704 11203887104 1870755040 18.590 100 49 99 1 1892092848 6536656 14801152
20:09:59 3149 8192000000 10789948048 11206856704 1872372608 18.603 100 51 102 1 1895179280 7939200 14867472
20:10:10 3469 8192000000 10794838192 11207974912 1871480544 18.596 100 34 66 1 1888468352 7854240 9133568
20:10:23 6195 8192000000 10787548576 11210063872 1874395792 18.620 100 29 56 2 1889014672 6797984 7820896
20:10:37 4263 8192000000 10788641920 11213303808 1877739408 18.647 100 29 58 1 1892976112 7192256 8044448
20:10:48 9139 8192000000 10786545360 11214696448 1881728288 18.679 100 22 44 0 1894248320 6793168 5726864
20:11:07 6987 8192000000 10782356256 11216498688 1880178112 18.667 100 18 36 1 1891333472 6242800 4912560
20:11:21 12605 8192000000 10785638944 11217924096 1881132544 18.674 100 19 38 2 1892660912 6565136 4963232
20:11:43 7813 8192000000 10787470512 11220291584 1883726608 18.695 100 25 51 2 1897163760 5875488 7561664
20:11:58 6991 8192000000 10792916144 11222552576 1883593664 18.694 100 23 46 1 1896667424 7063856 6009904
20:12:11 17337 8192000000 10797834288 11225395200 1883422592 18.693 100 15 31 0 1893446272 6002416 4021264
20:12:35 8699 8192000000 10792101952 11229569024 1887711904 18.727 100 16 32 1 1898452560 6015584 4725072
20:12:50 8441 8192000000 10810134272 11233443840 1890665792 18.751 100 18 36 5 1900828304 5185664 4976848
20:13:07 8195 8192000000 10804015344 11236098048 1893910352 18.777 100 36 69 0 1910631776 6591360 10130064
20:13:22 78527 8192000000 10803270080 11241484288 1897025392 18.802 100 30 60 1 1911207056 5688176 8493488
20:14:47 12982 8192000000 10813291936 11245260800 1897512240 18.806 100 24 48 1 1910892128 6936304 6443584
20:15:08 4797 8192000000 10817720112 11246841856 1897891808 18.809 100 27 53 1 1911602960 6899104 6812048
20:15:20 5015 8192000000 10826503600 11250368512 1901514704 18.838 100 38 75 2 1919718224 7878416 10325104
20:15:32 6276 8192000000 10816414096 11250819072 1904629872 18.864 100 37 74 1 1921922704 6783184 10509648
20:15:48 4878 8192000000 10826885344 11253440512 1903409632 18.854 100 33 67 2 1920085888 7360464 9315792
20:16:00 5499 8192000000 10813856720 11251195904 1900999040 18.834 100 21 42 1 1913338608 6526320 5813248
20:16:13 16321 8192000000 10805225280 11237490688 1864626640 18.541 98 14 28 1 1874517840 5072048 4819152
20:16:38 5225 8192000000 10794393120 11223080960 1852593296 18.443 98 35 70 0 1868956912 6733504 9630112
20:16:50 7006 8192000000 10784727936 11208876032 1865412064 18.547 99 21 40 2 1877016832 5502528 6102240
20:17:05 4896 8192000000 10784024928 11208806400 1828590976 18.248 97 28 55 0 1841454864 4882672 7981216
20:17:19 9156 8192000000 10778768224 11206103040 1858517792 18.491 99 26 51 1 1872070320 5739744 7812784
20:17:34 11781 8192000000 10765703088 11194589184 1766759312 17.740 94 15 30 2 1775792304 4806848 4226144
20:17:56 9884 8192000000 10770069264 11198631936 1841797136 18.355 99 25 51 0 1854570800 5778112 6995552
20:18:14 23903 8192000000 10710563632 11137732608 1726743824 17.408 93 21 42 2 1738329248 5517616 6067808
20:19:15 21028 8192000000 10730711872 11152330752 1731782016 17.450 94 19 38 0 1741997488 4631568 5583904
20:19:46 13424 8192000000 10727170432 11139858432 1711282160 17.279 93 28 57 0 1725333872 6113600 7938112
20:20:08 4819 8192000000 10736894224 11148685312 1796989296 17.989 99 28 56 1 1810846672 6298032 7559344
20:20:21 6371 8192000000 10696910192 11106066432 1712449520 17.289 95 26 52 1 1725651408 5725440 7476448
20:20:34 5205 8192000000 10673546816 11088408576 1707209600 17.245 95 27 54 1 1720157840 5300720 7647520
20:20:51 6873 8192000000 10698224304 11113451520 1749878720 17.601 98 34 68 1 1770636208 11491600 9265888
20:21:05 8308 8192000000 10670197616 11082809344 1737055328 17.494 97 23 44 3 1748481008 4561584 6864096
20:21:20 9104 8192000000 10687881136 11103002624 1733232528 17.462 97 28 56 1 1746889296 5245360 8411408
20:21:36 7505 8192000000 10674455488 11092836352 1736768384 17.492 98 27 54 1 1749910288 5040320 8101584
20:21:50 7525 8192000000 10696414544 11119235072 1755558592 17.648 98 21 42 0 1770627344 9425744 5643008
20:22:04 5045 8192000000 10717500496 11133030400 1786415584 17.902 99 35 68 2 1803522000 7019488 10086928
20:22:16 9486 8192000000 10726580272 11139993600 1785418064 17.894 99 36 71 1 1801525136 5409984 10697088
20:22:35 10755 8192000000 10728317376 11149713408 1794527584 17.969 99 20 40 2 1805755504 5503712 5724208
20:22:56 55997 8192000000 10758162832 11167236096 1817876800 18.160 100 33 68 3 1832348112 5178896 9292416
20:24:01 31256 8192000000 10745762512 11180322816 1837655840 18.322 100 17 34 3 1847671040 5307360 4707840
20:24:38 7893 8192000000 10763615504 11186597888 1846663376 18.395 100 26 51 1 1859223360 5371872 7188112
20:24:52 7797 8192000000 10769695744 11198222336 1855507264 18.467 100 26 52 1 1870020896 6927456 7586176
20:25:06 10467 8192000000 10781164672 11205414912 1859639728 18.500 100 40 81 3 1877809968 6728128 11442112
20:25:24 8943 8192000000 10776953600 11204009984 1859981440 18.503 100 22 44 2 1872403680 5767040 6655200
20:25:42 12755 8192000000 10786893600 11212193792 1865038512 18.544 100 18 36 1 1875581952 5603072 4940368
20:26:02 5772 8192000000 10790054032 11214794752 1868838640 18.575 100 27 54 0 1882846432 5257344 8750448
20:26:19 7321 8192000000 10785529920 11216052224 1875345008 18.627 100 33 67 2 1890669344 5332320 9992016
20:26:36 10049 8192000000 10785029760 11221422080 1874539040 18.621 100 18 37 4 1885364848 5666880 5158928
20:26:52 8484 8192000000 10786240112 11227271168 1883554848 18.694 100 33 66 1 1899500896 6459664 9486384
20:27:08 13185 8192000000 10820614272 11244417024 1894054480 18.778 100 16 29 2 1903571920 4962208 4555232
20:27:33 15390 8192000000 10833127712 11255939072 1909240912 18.901 100 39 75 1 1926781824 6043152 11497760
20:28:01 14672 8192000000 10854693744 11271790592 1918687440 18.976 100 44 88 0 1940146160 9110208 12348512
20:28:27 42876 8192000000 10867057808 11293237248 1930326768 19.069 100 41 83 2 1954106736 11652192 12127776
20:29:20 30610 8192000000 10877914192 11308941312 1943895952 19.178 100 38 75 1 1966761216 11990864 10874400
20:30:19 119343 8192000000 10896476288 11337170944 1957464896 19.286 100 22 44 0 1981141264 17120256 6556112
20:32:30 30371 8192000000 10908914176 11347304448 1975051136 19.425 100 35 70 0 2001933280 16764384 10117760
20:33:09 9762 8192000000 10933660240 11363311616 1985665120 19.510 100 54 108 3 2020765728 19447760 15652848
20:33:30 9682 8192000000 10929206272 11367153664 1992306416 19.562 100 50 99 1 2026035120 19189056 14539648
20:33:52 22097 8192000000 10938794208 11377348608 1990130672 19.545 100 39 78 0 2025022768 22799760 12092336
20:34:23 13513 8192000000 10936513824 11383476224 1996317408 19.594 100 42 84 0 2033826096 24455680 13053008
20:34:44 5219 8192000000 10948226672 11380572160 2000110464 19.624 100 56 112 1 2037523040 19811376 17601200
20:34:58 11424 8192000000 10942109984 11379539968 2003128400 19.647 100 56 111 2 2038970960 19766720 16075840
20:35:21 2459 8192000000 10963525552 11389419520 2005264592 19.664 100 74 148 0 2052321696 24560144 22496960
20:35:32 4585 8192000000 10950181696 11379007488 1985273296 19.506 99 68 133 0 2030425488 25574080 19578112
20:35:44 12280 8192000000 10967249664 11391094784 2004130192 19.655 100 70 140 2 2058065040 33480640 20454208
20:36:04 10854 8192000000 10957064352 11381526528 1989007200 19.536 99 58 116 2 2035832400 29676864 17148336
20:36:26 13359 8192000000 10966464752 11399725056 2004330160 19.657 100 66 130 1 2055656544 31407680 19918704
20:36:47 17916 8192000000 10962421344 11400204288 2004573472 19.659 100 56 112 1 2051057296 29126720 17357104
20:37:18 12258 8192000000 10973291216 11411472384 2014470352 19.737 100 47 94 2 2062391248 33090944 14829952
20:37:38 8845 8192000000 10985288944 11413745664 2014794000 19.739 100 52 103 6 2063685248 33140608 15750640
20:37:58 9449 8192000000 10974249776 11410960384 2004356656 19.657 99 57 114 1 2055095264 33317728 17420880
20:38:15 10670 8192000000 10981606240 11417530368 2014509520 19.737 100 47 94 3 2064119072 34698224 14911328
20:38:33 3446 8192000000 10985559024 11421609984 2026562688 19.832 100 61 118 2 2076464528 31594240 18307600
20:38:48 4152 8192000000 10988048608 11418152960 2021143440 19.789 100 65 130 1 2074092656 32391488 20557728
20:39:02 6133 8192000000 11004086496 11431706624 2030961712 19.866 100 83 164 1 2090586608 34282848 25342048
20:39:19 4360 8192000000 10991907168 11419860992 2021596304 19.793 100 71 142 1 2076187920 32865856 21725760
20:39:31 1439 8192000000 11001071856 11421904896 2022013264 19.796 100 93 187 0 2085705072 35294640 28397168
20:39:40 1109 8192000000 11000544848 11416285184 2017331600 19.759 100 89 176 3 2079238848 36111312 25795936
20:39:50 14395 8192000000 11000031296 11420864512 2019474416 19.776 100 80 160 0 2082291344 39040192 23776736
20:40:11 1503 8192000000 11016075920 11432611840 2027803008 19.841 100 89 180 2 2095761440 40483792 27474640
20:40:21 8722 8192000000 11006618752 11433562112 2028841120 19.850 100 84 168 1 2094086048 40502928 24742000
20:40:43 9197 8192000000 10994912672 11427921920 2022196288 19.797 100 68 136 1 2083035968 40175824 20663856
20:41:01 4489 8192000000 10991274064 11417612288 2008776832 19.692 99 69 136 1 2068125056 38055568 21292656
20:41:14 1955 8192000000 11012424416 11431809024 2025726304 19.825 100 83 167 0 2092066144 39761344 26578496
20:41:24 4064 8192000000 11001587120 11427147776 2020535744 19.784 100 80 161 1 2087192896 42113680 24543472
20:41:36 2626 8192000000 11007357504 11436658688 2022344208 19.799 100 73 146 1 2088189008 43268688 22576112
20:41:48 2777 8192000000 11007066288 11443343360 2027732624 19.841 100 61 123 1 2091630016 44990192 18907200
20:42:11 8822 8192000000 11008993952 11449073664 2020283808 19.782 99 58 113 0 2077258672 39132480 17842384
20:42:27 4925 8192000000 10997072560 11433316352 2009957696 19.701 99 55 110 0 2065712960 38133440 17621824
20:42:40 2491 8192000000 10998468464 11430830080 2022226192 19.798 100 67 134 2 2081242112 38739120 20276800
20:42:51 3645 8192000000 10995019728 11428265984 2018680624 19.770 100 63 124 1 2078836512 40816048 19339840
20:43:05 5831 8192000000 10972544016 11410849792 1981724976 19.478 98 55 109 0 2034523232 35140896 17657360
20:43:20 2478 8192000000 11003956800 11429249024 2017863408 19.763 100 75 147 4 2076196976 35535520 22798048
20:43:28 2164 8192000000 10999553968 11429785600 2025055008 19.820 100 76 153 2 2085671088 37032848 23583232
20:43:37 3502 8192000000 10979962256 11407609856 2002387408 19.642 100 76 151 2 2063668944 37472368 23809168
20:43:48 2046 8192000000 10974158480 11389317120 1992100896 19.560 99 85 170 2 2054208832 37320288 24787648
20:43:59 5236 8192000000 10963861120 11384893440 1962216400 19.324 98 78 154 1 2026813376 41071536 23525440
20:44:12 2180 8192000000 10977554640 11393146880 1993130656 19.569 100 88 177 1 2061983504 41815872 27036976
20:44:21 4547 8192000000 10956739824 11391492096 1986801744 19.519 100 62 124 0 2046154256 40187216 19165296
20:44:37 15068 8192000000 10939275760 11384176640 1953423024 19.254 98 36 72 1 2008025616 42664800 11937792
20:45:02 1142 8192000000 10959654544 11371659264 1972356784 19.404 99 67 128 0 2027618352 35854464 19407104
20:45:13 2880 8192000000 10966003392 11390291968 1978254128 19.451 99 64 128 0 2037109600 38262368 20593104
20:45:23 4523 8192000000 10984944752 11419475968 2012008704 19.717 100 58 116 0 2072654480 42709008 17936768
20:45:41 12463 8192000000 10965923664 11416850432 1988402672 19.531 99 37 74 0 2045111984 43949008 12760304
20:46:07 5683 8192000000 10991117696 11428204544 2013138848 19.726 100 43 86 0 2068605568 41197984 14268736
20:46:20 10069 8192000000 10991780912 11430342656 2012755648 19.723 100 47 94 1 2073001280 44367328 15878304
20:46:37 16961 8192000000 10976975184 11416776704 1993943376 19.575 99 38 76 0 2055209680 48409840 12856464
20:47:05 15477 8192000000 10974696864 11427393536 1999490192 19.619 100 39 78 3 2060333440 47885984 12957264
20:47:27 12291 8192000000 10970013136 11422904320 1995263696 19.585 100 34 68 1 2058454640 51850672 11340272
20:47:52 8942 8192000000 10967770944 11413573632 1987134544 19.521 100 36 70 0 2047691392 48519296 12037552
20:48:08 4443 8192000000 10941069536 11383664640 1950636432 19.232 98 52 104 1 2017492192 49824800 17030960
20:48:24 1281 8192000000 10985474096 11398131712 1967642160 19.367 99 80 159 1 2040871936 48806752 24423024
20:48:32 3716 8192000000 10975986912 11406020608 1987223264 19.522 100 70 140 0 2062297152 52217104 22856784
20:48:43 8659 8192000000 10961619728 11400482816 1978399984 19.452 100 49 98 0 2049325392 54596496 16328912
20:49:02 19565 8192000000 10956491104 11404423168 1965685120 19.351 99 35 70 1 2033195968 55389216 12121632
20:49:30 15176 8192000000 10944290896 11385544704 1952770176 19.249 99 30 60 0 2020590304 56804240 11015888
20:50:21 15831 8192000000 10944634080 11389825024 1953461760 19.254 99 40 78 4 2019906896 53157648 13287488
20:50:46 30297 8192000000 10921726224 11368886272 1924591696 19.024 99 32 64 3 1994889200 58577344 11720160
20:51:34 18934 8192000000 10922490672 11383021568 1942619584 19.168 100 24 48 0 2004244640 52638176 8986880
20:52:28 42439 8192000000 10878456384 11327053824 1846809968 18.396 96 17 34 1 1899953440 46845360 6298112
20:53:23 31788 8192000000 10876715952 11308085248 1922153136 19.004 100 16 32 3 1947246736 20587744 4505856
20:54:03 9755 8192000000 10880843664 11313672192 1929119712 19.060 100 59 118 1 1954041728 8872240 16049776
20:54:20 103397 8192000000 10856921728 11313184768 1911703488 18.920 99 38 74 1 1932225952 9543968 10978496
20:56:23 61838 8192000000 10885212112 11331452928 1905223408 18.868 98 43 84 0 1927730992 10349552 12158032
20:57:31 136455 8192000000 10864700144 11327930368 1854305008 18.457 95 14 28 0 1877370496 19663568 3401920
21:00:43 95900 8192000000 10838691472 11296464896 1858820992 18.494 96 9 18 1 1876926320 15597824 2507504
21:02:54 76359 8192000000 10833044976 11298234368 1915983216 18.955 100 17 34 0 1928991424 8383072 4625136
21:04:26 68818 8192000000 10831562048 11309092864 1903479760 18.854 99 16 32 0 1917699232 9340848 4878624
21:05:51 56431 8192000000 10847832192 11325521920 1932575408 19.087 100 13 26 1 1945026720 8684880 3766432
21:06:53 42584 8192000000 10874147824 11329789952 1944973600 19.186 100 27 54 2 1961275856 8264048 8038208
21:07:46 50084 8192000000 10856492032 11330039808 1909097584 18.899 98 15 30 2 1923440720 10003456 4339680
21:08:57 31500 8192000000 10883336464 11341017088 1942859168 19.170 99 29 58 0 1959186448 8290192 8037088
21:09:35 49831 8192000000 10898398464 11355906048 1942620048 19.168 99 30 60 2 1967345152 15898656 8826448
21:10:48 26830 8192000000 10893345488 11353071616 1960662848 19.311 100 22 40 0 1978382896 12404176 5315872
21:11:23 39361 8192000000 10896940672 11360673792 1965547424 19.350 100 22 45 0 1987370864 15047296 6776144
21:12:12 48627 8192000000 10905735760 11361382400 1947610608 19.207 99 24 48 2 1970483088 15840336 7032144
21:13:08 74490 8192000000 10914265168 11369537536 1929761408 19.065 98 24 48 1 1949938976 13422064 6755504
21:14:29 63299 8192000000 10902589600 11388440576 1962662512 19.327 100 17 34 2 1991071136 23159856 5248768
21:15:42 93111 8192000000 10886592864 11371536384 1954746320 19.264 99 12 24 0 1976881872 18727248 3408304
21:17:29 34757 8192000000 10930175072 11381383168 1979798032 19.463 100 29 58 0 2002175824 15022080 7355712
21:18:47 57687 8192000000 10928381456 11379810304 1965164672 19.347 99 24 48 1 1984866256 13565792 6135792
21:19:51 116489 8192000000 10902353328 11360227328 1950914688 19.234 98 31 62 3 1968513536 8448176 9150672
21:22:00 75654 8192000000 10926208960 11397038080 1992806160 19.566 100 32 63 0 2017270656 15082528 9381968
21:23:51 51257 8192000000 10952945424 11400302592 1986166464 19.513 99 31 62 3 2007756144 12350768 9238912
21:24:52 120703 8192000000 10906696464 11382910976 1945348624 19.189 97 19 37 0 1963977344 12982000 5646720
21:26:59 75527 8192000000 10899617600 11375886336 1972825472 19.408 99 11 20 1 1986939648 11578400 2535776
21:28:21 73043 8192000000 10907374144 11397132288 1957125712 19.283 98 14 28 1 1975553056 14737456 3689888
21:29:40 52414 8192000000 10917833984 11393957888 1976333552 19.436 99 16 32 0 1989444384 8548928 4561904
21:30:39 73548 8192000000 10878026304 11355938816 1864183840 18.537 94 7 14 0 1876627616 10891248 1552528
21:32:00 68388 8192000000 10874038464 11343228928 1890569120 18.750 96 11 22 0 1901493760 8188768 2735872
21:33:14 45550 8192000000 10879618464 11347484672 1906396064 18.878 97 19 38 3 1921037632 9799872 4841696
21:34:10 79427 8192000000 10898556544 11378540544 1970860208 19.392 100 17 35 0 1987745824 11893088 4992528
21:35:43 52781 8192000000 10900116480 11368013824 1922636736 19.008 97 28 56 1 1939070320 9372304 7061280
21:36:53 38479 8192000000 10907410560 11358142464 1919756224 18.985 97 33 66 1 1940291376 10602112 9933040
21:37:44 18509 8192000000 10901471712 11342303232 1909839680 18.905 97 51 102 0 1939167520 14310784 15017056
21:38:18 19550 8192000000 10883633600 11345993728 1927919584 19.050 99 45 90 2 1956071504 14342896 13809024
21:38:59 72315 8192000000 10861471216 11334352896 1847404800 18.401 96 9 18 1 1860027408 10174848 2447760
21:40:24 32141 8192000000 10902909520 11353260032 1958579504 19.295 100 28 56 2 1974763120 8252768 7930848
21:41:04 19084 8192000000 10890101472 11346391040 1925250608 19.029 98 43 86 1 1947877600 10864592 11762400
21:41:35 39502 8192000000 10887744384 11338330112 1890754784 18.752 97 37 74 0 1913769456 12980256 10034416
21:42:20 30500 8192000000 10877922720 11337961472 1906144032 18.876 98 40 80 0 1935370352 18177344 11048976
21:42:58 37923 8192000000 10867626608 11304214528 1861902592 18.519 96 37 73 2 1882364560 11026864 9435104
21:43:45 54661 8192000000 10836772064 11304853504 1903200400 18.852 99 27 53 2 1918936176 8355392 7380384
21:45:06 71289 8192000000 10845722208 11308617728 1813785584 18.127 94 21 42 0 1830716128 11487056 5443488
21:47:49 36386 8192000000 10833268800 11308158976 1886697424 18.719 98 18 36 2 1902488176 10571056 5219696
21:48:31 87620 8192000000 10843608688 11321757696 1890691088 18.751 98 16 32 2 1904658736 9486624 4481024
21:50:29 24163 8192000000 10859619232 11331817472 1937706832 19.128 100 16 32 0 1951130624 8759088 4664704
21:51:07 74548 8192000000 10848279648 11316080640 1866035424 18.552 96 7 14 0 1878706432 10926544 1744464
21:52:34 56939 8192000000 10829114480 11301146624 1874512672 18.621 97 16 32 1 1890645264 11688032 4444560
21:53:40 42485 8192000000 10834791504 11318460416 1904398512 18.862 99 5 10 1 1914379152 8225392 1755248
21:54:29 48631 8192000000 10851383968 11315978240 1894945984 18.786 98 19 38 3 1908122208 8141344 5034880
21:55:33 31898 8192000000 10866463824 11329761280 1920851456 18.994 99 28 56 0 1942099712 13544752 7703504
21:56:11 24903 8192000000 10846160496 11317280768 1897748432 18.808 98 23 46 0 1917507776 13196656 6562688
21:56:45 59789 8192000000 10881627392 11352014848 1919534960 18.983 99 21 42 2 1937159696 11831840 5792896
21:57:54 38676 8192000000 10891451056 11362934784 1968647456 19.375 100 22 42 1 1982253232 8115760 5490016
21:58:44 88205 8192000000 10902858832 11368534016 1920712256 18.993 97 17 32 1 1939454064 14229728 4512080
22:00:25 44723 8192000000 10895785632 11368378368 1950890224 19.234 99 22 43 1 1975945616 18487792 6567600
22:01:22 40716 8192000000 10911710624 11376283648 1967470624 19.365 99 36 72 1 1986732240 9458448 9803168
22:02:27 61661 8192000000 10929611056 11398717440 1966743984 19.360 99 24 48 0 1988583104 15450128 6388992
22:03:39 47167 8192000000 10911937424 11383615488 1962194944 19.323 99 22 44 1 1979810960 12099040 5516976
22:04:37 86989 8192000000 10927381520 11398184960 1965061504 19.346 99 18 36 1 1983426272 13420960 4943808
22:06:24 35641 8192000000 10937015568 11392909312 1992128416 19.561 100 48 96 0 2017657104 12657632 12871056
22:07:11 12475 8192000000 10941272528 11394342912 1993527248 19.572 100 39 78 0 2014812176 10775568 10509360
22:07:31 19950 8192000000 10931044720 11383361536 1938059760 19.131 97 47 95 0 1964607072 13621856 12925456
22:08:04 72925 8192000000 10896787424 11381202944 1941789552 19.161 98 33 66 0 1968960640 17589520 9581568
22:10:12 86967 8192000000 10878303280 11351908352 1931959216 19.083 98 21 42 0 1947060832 9475024 5626592
22:12:31 83261 8192000000 10881271344 11365584896 1946208496 19.196 99 11 22 0 1957605936 8381600 3015840
22:14:01 24538 8192000000 10891993472 11373875200 1968505744 19.374 100 8 16 1 1982143232 11244288 2393200
22:14:38 59464 8192000000 10883423040 11362209792 1954209296 19.260 99 11 22 0 1972760192 15076000 3474896
22:15:45 88427 8192000000 10885041152 11372490752 1916242928 18.957 97 10 20 0 1932853168 13425744 3184496
22:17:20 122249 8192000000 10901073952 11384479744 1942354976 19.166 98 11 22 0 1960548416 14832928 3360512
22:19:33 33104 8192000000 10889826848 11364990976 1938245488 19.133 98 25 50 1 1954936288 10125040 6565760
22:20:15 110425 8192000000 10904401648 11376594944 1925986560 19.035 97 17 33 2 1946797184 15345856 5464768
22:22:13 90906 8192000000 10900611104 11382013952 1921431712 18.998 97 20 39 1 1944883024 17338880 6112432
22:24:59 33545 8192000000 10899778960 11357011968 1934623104 19.104 98 44 88 0 1957086784 10594544 11869136
22:26:59 33799 8192000000 9399735248 9685819392 546252864 6.251 29 2 2 0 548525744 2039536 233344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 15-03-2021 22:28:17 to 15-03-2021 22:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 152 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-03-2021 22:28:48 to 15-03-2021 22:28:50.

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          235617
MON$OLDEST_ACTIVE               235618
MON$OLDEST_SNAPSHOT             235618
MON$NEXT_TRANSACTION            235618
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                       2010176
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:120: 
:121: mscs-test-161.budzdorov.ru    Mon Mar 15 22:27:34 2021
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:123: 
--- end of diff output ---

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

15.03.21 22:28:51. 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-15 22:28:53 No severe PSQL-related problems occured
15.03.21 22:28:55. End of report.