Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.04.2021 22:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17062320 kB
MemAvailable 31402660 kB
Buffers 0 kB
Cached 14575832 kB
SwapCached 120 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-04-07 22:27:28
DTS_END                         2021-04-07 22:27:28.7090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55216
TRN_ID                          232417
ATT_ID                          662
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: 9293.48 24700 1115217
customer order: creation 163.49 371 19619
customer order: refuse 14.09 340 1691
order to supplier: creation 44.55 1293 5346
order to supplier: removal 3.48 111945 417
invoice (draft): creation 44.63 3308 5356
invoice (draft): removal 57.30 751 6876
invoice accept: apply 39.23 16776 4707
invoice accept: cancel 51.73 774 6208
customer reserve: creation 3594.95 167 431394
customer reserve: removal 4988.73 61 598647
realization accept: apply 79.73 176 9568
realization accept: cancel 88.13 112 10576
payment from customer: creation 56.60 116 6792
payment from customer: removal 5.68 93 682
payment to supplier: creation 46.38 129 5566
payment to supplier: removal 3.09 82 371
service: total inventory turnovers 4.74 1117 569
service: total monetary turnovers 6.18 25 741
service: aggregate perf. data 0.73 24712 87
service: refresh index statistics 0.03 331652 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 07-04-2021 22:28:43 to 07-04-2021 22:28:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3092
TEST_TIME 2 3150
TEST_TIME 3 4418
TEST_TIME 4 4850
TEST_TIME 5 4214
TEST_TIME 6 4110
TEST_TIME 7 4469
TEST_TIME 8 4722
TEST_TIME 9 4794
TEST_TIME 10 4934
TEST_TIME 11 5409
TEST_TIME 12 5417
TEST_TIME 13 5601
TEST_TIME 14 5834
TEST_TIME 15 6087
TEST_TIME 16 6211
TEST_TIME 17 6593
TEST_TIME 18 6721
TEST_TIME 19 7021
TEST_TIME 20 7558
TEST_TIME 21 8042
TEST_TIME 22 7925
TEST_TIME 23 8151
TEST_TIME 24 8566
TEST_TIME 25 8900
TEST_TIME 26 9153
TEST_TIME 27 10030
TEST_TIME 28 10648
TEST_TIME 29 10539
TEST_TIME 30 10673
TEST_TIME 31 10602
TEST_TIME 32 10453
TEST_TIME 33 10246
TEST_TIME 34 10174
TEST_TIME 35 10049
TEST_TIME 36 10123
TEST_TIME 37 10068
TEST_TIME 38 10058
TEST_TIME 39 9895
TEST_TIME 40 9927
TEST_TIME 41 9904
TEST_TIME 42 9853
TEST_TIME 43 9977
TEST_TIME 44 9885
TEST_TIME 45 9865
TEST_TIME 46 9983
TEST_TIME 47 9910
TEST_TIME 48 9969
TEST_TIME 49 9811
TEST_TIME 50 9688
TEST_TIME 51 9694
TEST_TIME 52 9692
TEST_TIME 53 9594
TEST_TIME 54 9530
TEST_TIME 55 9545
TEST_TIME 56 9510
TEST_TIME 57 9490
TEST_TIME 58 9546
TEST_TIME 59 9565
TEST_TIME 60 9547
TEST_TIME 61 9562
TEST_TIME 62 9521
TEST_TIME 63 9512
TEST_TIME 64 9473
TEST_TIME 65 9584
TEST_TIME 66 9610
TEST_TIME 67 9617
TEST_TIME 68 9638
TEST_TIME 69 9616
TEST_TIME 70 9637
TEST_TIME 71 9643
TEST_TIME 72 9662
TEST_TIME 73 9641
TEST_TIME 74 9667
TEST_TIME 75 9597
TEST_TIME 76 9643
TEST_TIME 77 9639
TEST_TIME 78 9670
TEST_TIME 79 9564
TEST_TIME 80 9586
TEST_TIME 81 9607
TEST_TIME 82 9564
TEST_TIME 83 9496
TEST_TIME 84 9461
TEST_TIME 85 9490
TEST_TIME 86 9503
TEST_TIME 87 9463
TEST_TIME 88 9449
TEST_TIME 89 9385
TEST_TIME 90 9368
TEST_TIME 91 9368
TEST_TIME 92 9338
TEST_TIME 93 9275
TEST_TIME 94 9287
TEST_TIME 95 9314
TEST_TIME 96 9278
TEST_TIME 97 9324
TEST_TIME 98 9371
TEST_TIME 99 9397
TEST_TIME 100 9416
TEST_TIME 101 9402
TEST_TIME 102 9445
TEST_TIME 103 9452
TEST_TIME 104 9461
TEST_TIME 105 9501
TEST_TIME 106 9545
TEST_TIME 107 9551
TEST_TIME 108 9496
TEST_TIME 109 9425
TEST_TIME 110 9468
TEST_TIME 111 9415
TEST_TIME 112 9410
TEST_TIME 113 9391
TEST_TIME 114 9355
TEST_TIME 115 9308
TEST_TIME 116 9317
TEST_TIME 117 9303
TEST_TIME 118 9263
TEST_TIME 119 9331
TEST_TIME 120 9300

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-04-2021 22:28:47 to 07-04-2021 22:28:51.

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 1516008 1516008 0 0.00 0 20431 6 0 0
doc_list_biud 1516007 1516007 0 0.00 0 49225 30 0 0
sp_add_invoice_to_stock 4842 4707 135 2.78 28 176502 16776 0 135
sp_cancel_adding_invoice 6208 6208 0 0.00 5 68989 775 0 0
sp_cancel_client_order 1691 1691 0 0.00 4 6136 340 0 0
sp_cancel_customer_reserve 598647 598647 0 0.00 1 49229 62 0 0
sp_cancel_pay_from_customer 682 682 0 0.00 3 5255 93 0 0
sp_cancel_pay_to_supplier 371 371 0 0.00 3 2266 82 0 0
sp_cancel_supplier_invoice 6886 6876 10 0.14 2 14727 751 0 10
sp_cancel_supplier_order 417 417 0 0.00 6 1171157 111945 0 0
sp_cancel_write_off 10576 10576 0 0.00 1 13134 112 0 0
sp_client_order 19619 19619 0 0.00 3 44114 372 0 0
sp_customer_reserve 431394 431394 0 0.00 0 92236 168 0 0
sp_fill_shopping_cart 30303 30303 0 0.00 1 19184 36 0 0
sp_fill_shopping_cart_clo_res 431381 431381 0 0.00 0 11213 11 0 0
sp_get_clo_for_invoice 4694 4694 0 0.00 0 15094 252 0 0
sp_kill_cost_storno 17837 17837 0 0.00 0 7419 55 0 0
sp_kill_qstorno_ret_qs2qd 1215163 1215163 0 0.00 0 49221 33 0 0
sp_kill_qty_storno 638677 638677 0 0.00 0 49225 71 0 0
sp_lock_selected_doc 19844 19844 0 0.00 0 5490 3 0 0
sp_make_cost_storno 26620 26620 0 0.00 0 15437 53 0 0
sp_multiply_rows_for_pdistr 26620 26620 0 0.00 0 7789 29 0 0
sp_multiply_rows_for_qdistr 19619 19619 0 0.00 0 13406 153 0 0
sp_pay_from_customer 6792 6792 0 0.00 4 16013 116 0 0
sp_pay_to_supplier 5566 5566 0 0.00 4 15447 129 0 0
sp_payment_common 12358 12358 0 0.00 1 13140 30 0 0
sp_qd_handle_on_cancel_clo 1691 1691 0 0.00 0 5331 304 0 0
sp_qd_handle_on_invoice_upd_sts 10902 10902 0 0.00 0 36143 341 0 0
sp_qd_handle_on_reserve_upd_sts 9568 9568 0 0.00 0 8709 62 0 0
sp_reserve_write_off 9568 9568 0 0.00 6 9446 176 0 0
sp_supplier_invoice 5356 5356 0 0.00 6 91280 3308 0 0
sp_supplier_order 5346 5346 0 0.00 6 31101 1293 0 0
srv_aggregate_perf_data 87 87 0 0.00 3086 424309 24713 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1217 152573 34927 0 0
srv_find_qd_qs_mism 1070651 1070651 0 0.00 0 20430 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 33 26856 1118 0 0
srv_make_money_saldo 741 741 0 0.00 1 1189 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 156634 449903 331652 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4707 4707 0 0.00 0 9004 174 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 6764 107 0 0
t$perf-norm:sp_cancel_client_order 1691 1691 0 0.00 0 6254 16 0 0
t$perf-norm:sp_cancel_customer_reserve 644 644 0 0.00 0 845 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 682 682 0 0.00 0 4026 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 371 371 0 0.00 0 2638 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 366 9 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 23774 1819 0 0
t$perf-norm:sp_cancel_write_off 986 986 0 0.00 0 5608 15 0 0
t$perf-norm:sp_client_order 19619 19619 0 0.00 0 14391 19 0 0
t$perf-norm:sp_customer_reserve 959 959 0 0.00 0 1802 11 0 0
t$perf-norm:sp_pay_from_customer 6792 6792 0 0.00 0 13629 16 0 0
t$perf-norm:sp_pay_to_supplier 5566 5566 0 0.00 0 7179 13 0 0
t$perf-norm:sp_reserve_write_off 9568 9568 0 0.00 0 13838 12 0 0
t$perf-norm:sp_supplier_invoice 5356 5356 0 0.00 0 5453 17 0 0
t$perf-norm:sp_supplier_order 5346 5346 0 0.00 0 7598 18 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 203 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 919 9 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 616 14 0 0
t$perf-norm:srv_make_money_saldo 741 741 0 0.00 0 2270 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9658 9388 270 2.79 0 3862 20 0 270
v_all_customers 35820 35820 0 0.00 0 13 1 0 0
v_all_suppliers 29454 29454 0 0.00 0 22 1 0 0
v_all_wares 39230 39230 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 1529 9 0 0
v_cancel_client_order 3382 3382 0 0.00 0 5960 9 0 0
v_cancel_customer_prepayment 1364 1364 0 0.00 0 5235 19 0 0
v_cancel_customer_reserve 1288 1288 0 0.00 0 3364 7 0 0
v_cancel_payment_to_supplier 742 742 0 0.00 0 2249 12 0 0
v_cancel_supplier_invoice 788 768 20 2.53 0 2676 18 0 20
v_cancel_supplier_order 834 834 0 0.00 0 2389 11 0 0
v_cancel_write_off 1972 1972 0 0.00 0 1772 13 0 0
v_max_id_clo_ord 5341 5341 0 0.00 0 1493 2 0 0
v_max_id_clo_res 959 959 0 0.00 0 3006 22 0 0
v_max_id_ord_sup 5346 5346 0 0.00 0 4491 4 0 0
v_max_non_paid_invoice 1526 1526 0 0.00 0 514 2 0 0
v_max_non_paid_realizn 3596 3596 0 0.00 0 3533 5 0 0
v_min_id_clo_ord 5341 5341 0 0.00 0 4599 9 0 0
v_min_id_clo_res 959 959 0 0.00 0 3046 10 0 0
v_min_id_ord_sup 5346 5346 0 0.00 0 7724 5 0 0
v_min_non_paid_invoice 5566 5566 0 0.00 0 6259 14 0 0
v_min_non_paid_realizn 6792 6792 0 0.00 0 9503 25 0 0
v_our_firm 9802 9802 0 0.00 0 22 1 0 0
v_reserve_write_off 19136 19136 0 0.00 0 7056 8 0 0
x_lock_depdocs_on_canc_invoice 12700 12700 0 0.00 0 16483 120 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 9091 379 0 0
x_make_qstorno_1000_1200 5346 5346 0 0.00 1 31088 1212 0 0
x_make_qstorno_1200_2000 5356 5356 0 0.00 3 91262 3190 0 0
x_make_qstorno_2100_3300 431394 431394 0 0.00 0 92234 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-04-2021 22:28:52 to 07-04-2021 22:28:56.

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:32 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:38 8022 8192000000 10158813440 10453942272 806341840 8.961 66 50 104 1 826181248 2288128 17551280
19:57:54 26759 8192000000 10331098224 10647736320 1360518976 14.242 100 77 154 0 1390212704 4268544 25425184
19:58:38 32032 8192000000 10391398272 10713341952 1440238288 14.952 100 89 178 2 1475478832 6853024 28387520
19:59:19 26727 8192000000 10416270736 10747035648 1471247520 15.225 100 86 172 0 1506560080 7799696 27512864
19:59:53 20033 8192000000 10438678176 10772054016 1495480208 15.437 100 84 167 0 1530268288 8300160 26487920
20:00:32 19442 8192000000 10475583424 10809978880 1524901792 15.693 100 93 186 0 1563190768 9286656 29002320
20:01:03 18973 8192000000 10480197408 10822303744 1537008816 15.798 100 89 178 0 1575196592 10335424 27852352
20:01:29 13284 8192000000 10507768256 10847903744 1551507072 15.923 100 86 172 1 1588466608 10374064 26585472
20:01:53 19751 8192000000 10517558624 10864250880 1575408336 16.129 100 86 172 0 1613019440 11188576 26422528
20:02:24 14111 8192000000 10534515200 10893877248 1594493424 16.292 100 76 152 1 1628025168 10882672 22649072
20:02:48 11949 8192000000 10566793472 10921193472 1622128112 16.528 100 76 152 1 1656108592 10595200 23385280
20:03:09 9403 8192000000 10577689568 10936774656 1637810928 16.661 100 74 146 3 1670023840 10146880 22066032
20:03:30 13468 8192000000 10584842176 10954686464 1656685520 16.821 100 80 160 4 1691456480 10847728 23923232
20:03:56 12802 8192000000 10634382688 11002642432 1688513808 17.089 100 79 159 0 1722533152 10388624 23630720
20:04:17 10872 8192000000 10652929632 11027972096 1710443648 17.272 100 72 142 1 1741936720 10775280 20717792
20:04:36 6170 8192000000 10670299456 11046547456 1730474096 17.439 100 71 142 1 1761834272 11079840 20280336
20:04:50 8629 8192000000 10680953344 11059400704 1749476080 17.597 100 79 158 1 1783521728 11679744 22365904
20:05:06 6210 8192000000 10690878464 11070849024 1758622272 17.673 100 74 147 2 1790944016 11802864 20518880
20:05:20 5478 8192000000 10704069728 11086893056 1769838608 17.766 100 74 148 1 1802508848 12366336 20303904
20:05:33 4478 8192000000 10714743184 11096297472 1773557312 17.796 100 79 158 1 1809115904 13593360 21965232
20:05:44 3866 8192000000 10729460416 11108003840 1784285744 17.885 100 81 159 0 1819615280 13208992 22120544
20:05:54 5086 8192000000 10726399472 11111550976 1791468640 17.944 100 88 176 1 1829985584 13703472 24813472
20:06:08 9536 8192000000 10726632688 11113926656 1792744368 17.954 100 71 140 1 1825049264 12819072 19485824
20:06:25 3552 8192000000 10763480512 11142287360 1812243344 18.114 100 78 154 1 1846186176 12571200 21371632
20:06:35 2702 8192000000 10760346768 11145928704 1818272912 18.164 100 71 142 1 1851028576 12543264 20212400
20:06:46 2401 8192000000 10764679808 11152592896 1829952736 18.259 100 90 179 0 1868264432 12969424 25342272
20:06:55 4103 8192000000 10773621328 11162394624 1832783376 18.282 100 84 168 2 1870757904 13757488 24217040
20:07:07 2908 8192000000 10772747296 11161776128 1836650144 18.314 100 84 168 0 1873784880 13190480 23944256
20:07:16 2347 8192000000 10783221888 11172139008 1840510368 18.345 100 86 172 1 1878455040 13835712 24108960
20:07:25 2771 8192000000 10794653504 11179208704 1846136944 18.391 100 89 178 1 1885121408 14112688 24871776
20:07:34 1974 8192000000 10792002144 11179864064 1848304224 18.408 100 90 179 1 1888363632 14348944 25710464
20:07:43 1820 8192000000 10796930544 11182477312 1856376400 18.474 100 89 177 2 1893580624 12383696 24820528
20:07:51 2690 8192000000 10804132176 11195092992 1859145552 18.496 100 87 173 2 1897016640 13566560 24304528
20:08:00 1321 8192000000 10805574704 11194867712 1863818864 18.534 100 90 179 0 1902118352 13782576 24516912
20:08:09 1443 8192000000 10813990320 11202334720 1870099088 18.585 100 95 188 1 1911348688 14664016 26585584
20:08:17 2065 8192000000 10807853056 11201232896 1871312624 18.595 100 91 182 3 1909300416 12963040 25024752
20:08:25 2716 8192000000 10816758384 11207958528 1871531696 18.597 100 92 184 1 1910987696 13022208 26433792
20:08:35 2498 8192000000 10818328192 11209981952 1878832784 18.656 100 94 187 1 1918278288 12485632 26959872
20:08:44 8000 8192000000 10826846640 11219648512 1881248672 18.675 100 84 166 0 1917482656 13306880 22927104
20:08:58 1499 8192000000 10825509616 11222663168 1882814496 18.688 100 88 176 1 1922666272 15233472 24618304
20:09:06 2985 8192000000 10807029632 11216400384 1879610288 18.662 100 59 117 1 1908932736 12669456 16652992
20:09:18 5723 8192000000 10801536368 11213651968 1881773664 18.679 100 73 146 0 1914268480 11202064 21292752
20:09:31 30674 8192000000 10812717440 11218542592 1879522288 18.661 100 51 102 0 1903145984 9522496 14101200
20:10:08 24577 8192000000 10787734176 11213975552 1879984160 18.665 100 39 77 0 1898773280 7804512 10984608
20:10:48 20454 8192000000 10781812640 11216883712 1878964976 18.657 100 31 62 0 1895118896 6813024 9340896
20:11:15 6237 8192000000 10791966720 11219259392 1882576368 18.686 100 34 68 3 1902927120 10091360 10259392
20:11:28 6765 8192000000 10786792928 11219881984 1885800736 18.712 100 33 66 0 1902009632 7049648 9159248
20:11:41 6567 8192000000 10789626784 11227447296 1887052784 18.722 100 28 56 4 1903294096 7236688 9004624
20:11:55 11048 8192000000 10790926368 11225985024 1889040704 18.738 100 25 50 1 1902661472 6293632 7327136
20:12:15 7558 8192000000 10793586160 11231539200 1895229488 18.788 100 14 28 1 1903943648 5218656 3495504
20:12:31 9478 8192000000 10802526272 11239153664 1896925072 18.802 100 20 42 1 1908835888 6161440 5749376
20:12:47 5018 8192000000 10815909744 11241984000 1901120864 18.835 100 25 48 4 1914381136 5912608 7347664
20:12:59 8105 8192000000 10806076592 11241578496 1900228576 18.828 100 19 38 0 1911873856 5950496 5694784
20:13:13 11047 8192000000 10809178160 11242045440 1900180752 18.828 100 15 30 1 1910344096 6229584 3933760
20:13:34 13552 8192000000 10816506672 11246882816 1904480496 18.862 100 18 36 1 1915020848 5462912 5077440
20:13:57 9712 8192000000 10805394288 11247382528 1903186064 18.852 100 10 19 1 1911523056 5532208 2804784
20:14:16 13634 8192000000 10818478704 11255275520 1904624448 18.863 100 17 34 2 1919199312 10084592 4490272
20:14:36 6064 8192000000 10822864096 11253854208 1911171024 18.916 100 28 55 5 1925562656 7064944 7326688
20:14:54 19348 8192000000 10824681568 11260162048 1914465584 18.942 100 19 38 3 1925245136 5553872 5225680
20:15:32 44551 8192000000 10866663536 11279159296 1924812128 19.025 100 67 135 2 1951102208 6113040 20177040
20:16:23 5209 8192000000 10833300320 11271098368 1921240016 18.997 100 31 62 0 1937659440 7882736 8536688
20:16:36 6252 8192000000 10832285568 11268341760 1901251712 18.836 99 25 50 0 1913367680 5606784 6509184
20:16:52 6785 8192000000 10847919904 11275968512 1921920176 19.002 100 36 73 0 1938535040 6442000 10172864
20:17:07 7722 8192000000 10828993840 11265236992 1919113152 18.980 100 28 56 0 1937777552 11125456 7538944
20:17:21 3488 8192000000 10831301040 11262267392 1897090800 18.803 99 33 64 1 1914426768 7500768 9835200
20:17:32 9367 8192000000 10822805360 11259375616 1894152224 18.779 99 14 27 2 1904184288 5897680 4134384
20:17:47 8006 8192000000 10820288560 11240935424 1841687136 18.355 97 16 31 1 1856513040 8923440 5902464
20:18:03 9980 8192000000 10801345360 11231428608 1884971280 18.705 100 20 41 1 1895959904 5045712 5942912
20:18:21 4199 8192000000 10797902512 11225829376 1871940736 18.600 99 22 45 1 1883028416 5053744 6033936
20:18:32 9950 8192000000 10758523328 11196379136 1789128096 17.925 95 20 40 1 1800532000 5709536 5694368
20:18:53 12220 8192000000 10765866800 11195121664 1777832896 17.832 95 8 16 1 1785300832 5449616 2018320
20:19:12 15334 8192000000 10708987584 11127095296 1723180064 17.379 93 12 24 1 1731324672 4377744 3766864
20:19:33 7718 8192000000 10699739408 11117289472 1760849344 17.691 98 16 32 1 1771328944 5237216 5242384
20:19:48 5955 8192000000 10688384240 11102494720 1725076048 17.395 96 31 62 2 1739628352 5371488 9180816
20:20:02 11946 8192000000 10698444448 11101958144 1720106800 17.353 96 22 44 1 1732020464 5354144 6559520
20:20:21 73500 8192000000 10696590704 11127283712 1679300512 17.011 93 25 50 1 1691112464 4672672 7139280
20:21:40 9735 8192000000 10665487168 11077480448 1687293872 17.079 94 28 57 2 1704783408 10338368 7151168
20:21:56 5476 8192000000 10708003680 11122417664 1764181280 17.719 98 28 56 2 1779142624 6945344 8016000
20:22:08 9326 8192000000 10690373664 11107631104 1727038288 17.411 97 25 50 0 1739298576 5658032 6602256
20:22:24 4019 8192000000 10710998448 11123675136 1778173568 17.834 99 42 81 1 1800281584 10619616 11488400
20:22:38 8410 8192000000 10720945472 11143905280 1778013536 17.833 98 22 44 1 1790409248 5428416 6967296
20:22:53 9871 8192000000 10736688880 11164663808 1827664128 18.240 100 20 40 1 1843524256 10432432 5427696
20:23:09 13224 8192000000 10757039248 11172724736 1822470352 18.198 99 26 53 2 1835646416 5689008 7487056
20:23:30 10316 8192000000 10756116768 11181506560 1841926176 18.356 100 26 52 1 1855666960 5901680 7839104
20:23:47 7021 8192000000 10762209936 11189407744 1847581968 18.402 100 21 42 0 1859710480 5591872 6536640
20:24:01 5686 8192000000 10762807520 11194908672 1854272000 18.457 100 36 72 2 1871389920 6462912 10655008
20:24:13 5966 8192000000 10773609712 11198742528 1857737536 18.485 100 27 54 2 1871038640 5373488 7927616
20:24:31 12737 8192000000 10772308688 11200221184 1853392112 18.450 100 25 50 0 1866759280 5955952 7411216
20:24:52 10066 8192000000 10780332544 11205144576 1866464672 18.556 100 27 54 0 1878802576 4511328 7826576
20:25:08 68567 8192000000 10784937792 11213651968 1869815280 18.583 100 22 44 0 1882141456 5622672 6703504
20:26:26 6250 8192000000 10791914784 11222847488 1874925216 18.624 100 20 38 2 1887631040 6775760 5930064
20:26:40 8993 8192000000 10803404448 11222683648 1882142768 18.682 100 39 78 0 1899831120 6230592 11457760
20:26:56 3581 8192000000 10797910064 11226091520 1878681968 18.654 100 34 65 1 1894639744 6955264 9002512
20:27:06 4848 8192000000 10813401024 11237384192 1892508592 18.766 100 40 80 3 1910070704 6289440 11272672
20:27:17 5927 8192000000 10816814352 11244146688 1897345136 18.805 100 31 62 2 1912660544 5789264 9526144
20:27:29 50460 8192000000 10841675728 11258220544 1909676096 18.904 100 43 86 1 1928040416 5665744 12698576
20:28:36 19752 8192000000 10850928720 11275264000 1920345696 18.990 100 50 99 2 1942358480 7941616 14071168
20:29:03 20630 8192000000 10857023280 11282763776 1926575088 19.039 100 42 84 0 1947341040 9108688 11657264
20:29:31 3942 8192000000 10876053824 11292622848 1937305760 19.125 100 55 109 0 1962073232 9292384 15475088
20:29:42 33482 8192000000 10881658096 11307282432 1941953584 19.162 100 54 108 2 1968784864 11564400 15266880
20:30:37 18373 8192000000 10883779568 11318628352 1951334432 19.237 100 38 74 0 1977490768 15234160 10922176
20:31:05 46680 8192000000 10885073248 11322187776 1954439936 19.262 100 27 53 2 1982239952 19178848 8621168
20:32:02 7680 8192000000 10893478624 11324973056 1963974336 19.338 100 37 73 0 1988906160 13225984 11705840
20:32:24 50571 8192000000 10903994560 11338752000 1969703792 19.383 100 37 74 1 1997549088 16441168 11404128
20:33:26 4191 8192000000 10908401264 11341582336 1973438800 19.413 100 54 106 1 2004581168 15265040 15877328
20:33:38 28899 8192000000 10926057472 11356409856 1983209792 19.490 100 51 102 2 2016080032 17349360 15520880
20:34:13 5681 8192000000 10937737808 11366215680 1988164352 19.529 100 63 125 2 2027320336 21668496 17487488
20:34:26 12176 8192000000 10921682976 11357474816 1982729072 19.486 100 56 113 1 2019089440 18899440 17460928
20:34:48 10477 8192000000 10925214736 11367911424 1989199744 19.537 100 43 85 0 2023449888 21586688 12663456
20:35:06 13143 8192000000 10946085168 11372068864 1994502048 19.579 100 50 100 0 2031696064 21755392 15438624
20:35:45 10542 8192000000 10953400544 11388022784 2005091520 19.663 100 51 100 0 2041442384 21587680 14763184
20:36:02 6131 8192000000 10961498640 11393634304 2008465504 19.689 100 50 99 1 2047538576 24595024 14478048
20:36:18 5560 8192000000 10962253808 11391725568 2005980368 19.670 100 57 114 1 2049024112 24983840 18059904
20:36:36 4702 8192000000 10959315680 11386044416 2000134192 19.624 100 63 126 1 2044465808 24810432 19521184
20:36:49 9053 8192000000 10965954960 11395579904 2006466624 19.674 100 68 136 2 2051284576 25146512 19671440
20:37:09 1770 8192000000 10986317328 11409182720 2017266960 19.759 100 73 147 1 2071610528 31630720 22712848
20:37:18 6017 8192000000 10997989808 11421306880 2016363504 19.752 100 75 150 0 2076653792 37722192 22568096
20:37:35 2397 8192000000 10991234096 11406860288 2003312384 19.649 99 79 155 1 2060201536 33311888 23577264
20:37:45 4299 8192000000 10976207760 11409383424 2014745648 19.739 100 60 120 1 2067390496 34143712 18501136
20:37:59 10187 8192000000 10983714784 11415171072 2020619616 19.785 100 62 123 1 2074686272 34990416 19076240
20:38:18 12558 8192000000 10982677456 11419660288 2022226128 19.798 100 54 108 0 2072115584 33314896 16574560
20:38:37 12233 8192000000 10980480224 11421872128 2025575232 19.824 100 53 106 1 2073754928 31493264 16686432
20:38:56 4588 8192000000 10997201856 11428769792 2033126096 19.883 100 63 124 3 2084935424 32469600 19339728
20:39:08 14004 8192000000 10992857984 11427950592 2014701456 19.739 99 57 114 2 2066604720 33650800 18252464
20:39:31 8930 8192000000 10969484976 11405746176 2008934592 19.693 99 47 94 0 2061210448 37156784 15119072
20:39:50 3384 8192000000 11000555696 11434000384 2032852816 19.881 100 64 128 1 2091871632 38376736 20642080
20:40:01 2353 8192000000 11021041248 11445194752 2040995712 19.945 100 80 160 0 2106036144 38777904 26262528
20:40:12 5443 8192000000 11011851728 11436924928 2021502864 19.792 99 83 166 2 2086555472 39906192 25146416
20:40:26 6244 8192000000 10992709296 11417993216 2016693376 19.754 99 78 154 1 2082424272 41200288 24530608
20:40:43 11913 8192000000 10990339696 11421282304 1987126144 19.521 98 59 118 1 2049182752 42289424 19767184
20:41:02 5201 8192000000 10999045440 11428556800 2020418048 19.783 100 54 108 0 2079541904 41923200 17200656
20:41:14 4262 8192000000 10965083984 11388551168 1969804672 19.384 97 65 130 1 2031085472 40519120 20761680
20:41:26 7807 8192000000 10977075408 11397169152 1967819120 19.368 98 78 153 2 2035005232 42479088 24707024
20:41:41 3781 8192000000 10980115680 11402973184 1995922032 19.591 100 68 134 0 2058687056 41649280 21115744
20:41:51 2737 8192000000 11010543664 11426521088 2022524544 19.800 100 90 181 0 2093989088 43897456 27567088
20:42:04 2574 8192000000 11015432400 11431559168 2023006368 19.804 100 80 160 0 2092589760 45163872 24419520
20:42:15 3435 8192000000 11023375712 11442159616 2031097728 19.867 100 85 170 1 2104118288 46558912 26461648
20:42:36 4393 8192000000 11020768128 11456094208 2038015120 19.921 100 73 145 2 2110717248 50159728 22542400
20:42:48 4745 8192000000 11018920816 11450552320 2036843392 19.912 100 74 148 2 2107487120 47503872 23139856
20:43:02 6101 8192000000 11020501184 11446218752 2037067360 19.914 100 67 132 1 2104895120 46958912 20868848
20:43:15 3423 8192000000 11030970384 11458179072 2042695440 19.958 100 78 156 1 2115593728 48568176 24330112
20:43:30 3239 8192000000 11023891520 11453964288 2038359376 19.924 100 78 154 0 2113910544 50900720 24650448
20:43:42 3133 8192000000 11012636576 11437412352 2005378128 19.665 99 85 169 2 2081501648 50091312 26032208
20:43:55 1528 8192000000 11021009232 11442798592 2021257280 19.790 100 84 168 0 2099204208 51559648 26387280
20:44:03 2168 8192000000 10999858864 11425849344 2005897584 19.669 99 80 160 3 2083581424 52117664 25566176
20:44:11 2538 8192000000 10987256624 11407712256 1957617968 19.287 97 77 154 2 2036507872 55251728 23638176
20:44:22 4255 8192000000 10962103904 11374587904 1956878112 19.281 99 83 166 2 2036135024 52666752 26590160
20:44:34 4983 8192000000 10973245792 11383951360 1968600320 19.374 99 81 160 2 2046729024 52737664 25391040
20:44:46 2678 8192000000 10990293648 11398205440 1973978688 19.417 99 87 172 0 2054856640 52894240 27983712
20:44:58 5071 8192000000 10981691696 11399004160 1981718192 19.478 100 77 155 2 2060104208 53966128 24419888
20:45:14 5270 8192000000 10989082672 11405815808 1971461024 19.397 99 80 158 2 2053250240 56508064 25281152
20:45:27 3900 8192000000 10971483504 11388116992 1970260512 19.388 99 76 151 0 2051474512 57323568 23890432
20:45:39 1216 8192000000 10979223936 11389849600 1971469696 19.397 99 83 164 4 2055568432 58301856 25796880
20:45:49 2695 8192000000 10995943776 11407556608 1986867264 19.519 100 80 159 4 2068353408 56213472 25272672
20:45:59 3789 8192000000 10996408832 11416305664 1993537600 19.572 100 84 166 0 2076680384 56128672 27014112
20:46:15 6863 8192000000 10986804496 11415248896 1987850064 19.527 100 63 124 0 2067485344 59321552 20313728
20:46:29 3486 8192000000 11005012688 11422969856 1994714320 19.581 100 94 188 0 2088553648 63720112 30119216
20:46:39 5358 8192000000 11001908528 11425763328 1993402144 19.571 100 76 152 2 2083926480 65872800 24651536
20:46:51 1969 8192000000 11021821712 11435094016 2000572752 19.627 100 89 178 1 2091424176 62306848 28544576
20:47:00 3529 8192000000 11006302064 11428474880 1997274640 19.601 100 87 175 2 2087610208 62806288 27529280
20:47:11 3104 8192000000 11009738672 11425165312 1983157312 19.490 99 84 168 1 2074115968 64138192 26820464
20:47:24 5545 8192000000 10956003456 11391881216 1963553568 19.334 99 55 110 0 2042199520 60552896 18093056
20:47:49 2381 8192000000 10952105968 11384135680 1958837952 19.297 99 48 96 0 2030978672 56083648 16057072
20:48:03 12483 8192000000 10959837536 11397246976 1959698464 19.304 99 45 90 0 2028151104 53879824 14572816
20:48:31 9251 8192000000 10933787968 11373547520 1943004144 19.171 99 40 80 0 2008388144 51173616 14210384
20:48:46 10111 8192000000 10943719936 11392745472 1968843904 19.376 100 38 76 0 2033503504 52425632 12233968
20:49:02 10008 8192000000 10950325248 11392389120 1971376176 19.396 100 33 65 4 2031898976 49086080 11436720
20:49:25 13435 8192000000 10952187936 11401277440 1972795552 19.408 100 36 70 1 2036178240 51322320 12060368
20:49:45 21789 8192000000 10962396720 11409629184 1977488480 19.445 100 31 62 0 2044127824 55857376 10781968
20:50:18 7938 8192000000 10971426464 11409731584 1974282480 19.419 100 51 102 2 2047472288 56326736 16863072
20:50:57 7248 8192000000 10968489424 11408732160 1970739024 19.391 100 45 89 1 2044045440 58874144 14432272
20:51:32 15868 8192000000 10940399440 11392786432 1959720384 19.304 100 30 60 1 2021399968 51674160 10005424
20:52:12 26707 8192000000 10909166160 11367948288 1929565552 19.063 99 21 42 0 1988314960 51126448 7622960
20:52:47 28521 8192000000 10909957168 11356450816 1902414096 18.846 98 27 54 0 1962722416 50137520 10170800
20:53:22 20303 8192000000 10902735792 11358162944 1928085824 19.052 100 32 64 2 1990115536 50417984 11611728
20:53:49 20643 8192000000 10915718896 11369779200 1909160576 18.900 99 25 50 1 1976976192 58714944 9100672
20:54:16 41332 8192000000 10905283984 11380391936 1937825920 19.129 100 26 52 0 2007471392 60300592 9344880
20:55:03 53298 8192000000 10859147824 11317055488 1844626000 18.378 95 10 20 0 1863885200 16138352 3120848
20:56:05 13931 8192000000 10888192624 11321827328 1929590464 19.064 100 53 104 5 1958598320 13880208 15127648
20:56:36 8491 8192000000 10885242880 11329863680 1929806848 19.065 100 42 84 0 1959296224 17090656 12398720
20:56:52 12172 8192000000 10880817616 11341414400 1933298352 19.093 100 21 40 1 1963191072 23393440 6499280
20:58:38 45875 8192000000 10857655552 11328077824 1918924880 18.978 99 10 20 0 1932063328 10317024 2821424
20:59:30 86987 8192000000 10864959744 11323064320 1889131008 18.739 97 12 26 0 1900789792 8871328 2787456
21:01:12 85790 8192000000 10892881744 11359662080 1957097168 19.283 100 21 41 2 1974294208 12264240 4932800
21:02:44 125859 8192000000 10884489296 11347083264 1904264576 18.861 97 4 8 1 1921258912 16251664 742672
21:05:03 100003 8192000000 10895026368 11359674368 1882768304 18.687 96 15 30 0 1902420944 15117824 4534816
21:06:56 59477 8192000000 10882386784 11351404544 1921100272 18.996 98 18 36 0 1941855488 15194000 5561216
21:08:03 63874 8192000000 10887427552 11360964608 1938872176 19.138 99 10 20 1 1957550928 15877600 2801152
21:09:17 103287 8192000000 10885202624 11362537472 1936388752 19.118 99 12 24 0 1959798496 20300480 3109264
21:11:14 48971 8192000000 10904284704 11363745792 1946150848 19.196 99 16 33 0 1959749664 8503200 5095616
21:12:10 77395 8192000000 10884193264 11362435072 1907072096 18.883 97 17 34 1 1929176992 17137984 4966912
21:13:34 66778 8192000000 10903335552 11347058688 1947910832 19.210 99 38 74 2 1966064112 8122480 10030800
21:14:50 47519 8192000000 10902098096 11374927872 1968498384 19.374 100 13 23 2 1981638336 9630736 3509216
21:15:48 152561 8192000000 10919086080 11365969920 1917305536 18.965 97 39 74 1 1938850688 11510480 10034672
21:18:33 65699 8192000000 10878456400 11345989632 1945124544 19.188 99 30 59 0 1963893312 11193280 7575488
21:19:46 36452 8192000000 10870358112 11342266368 1925993104 19.035 98 39 78 1 1944552752 7592848 10966800
21:20:45 42975 8192000000 10889858448 11361603584 1966443472 19.357 100 17 34 0 1980908272 9547968 4916832
21:21:34 2119 8192000000 10899200736 11359678464 1953010512 19.250 99 37 73 4 1974939552 11469504 10459536
21:21:43 28072 8192000000 10886432784 11356581888 1946568096 19.199 99 31 62 1 1969151808 13622064 8961648
21:22:17 62410 8192000000 10909841648 11374948352 1965493216 19.350 100 31 62 0 1990593168 15302544 9797408
21:23:39 20095 8192000000 10915376000 11365732352 1953992672 19.258 99 31 60 2 1977741968 14970800 8778496
21:24:05 18557 8192000000 10925038224 11372584960 1957884176 19.289 99 47 94 1 1988189216 15792896 14512144
21:24:45 70268 8192000000 10908990768 11398209536 1969253920 19.380 100 25 50 0 2007582240 30656000 7672320
21:26:09 93511 8192000000 10899023536 11372949504 1906933616 18.882 97 12 24 2 1936852624 26304528 3614480
21:27:59 64536 8192000000 10865678864 11345944576 1904610048 18.863 97 11 22 0 1926426016 18744736 3071232
21:29:56 59648 8192000000 10874742864 11350593536 1917739200 18.969 98 12 23 1 1930105088 9453184 2912704
21:31:05 74742 8192000000 10884233504 11359485952 1886188752 18.715 96 11 22 1 1905714016 16465584 3059680
21:32:26 64496 8192000000 10890997824 11352477696 1903574112 18.855 97 27 54 0 1923013552 11388512 8050928
21:33:44 70408 8192000000 10893998992 11359244288 1898709728 18.816 97 14 28 0 1915732192 13186640 3835824
21:35:02 32495 8192000000 10898438576 11357708288 1926365952 19.038 98 39 78 4 1950819296 13050720 11402624
21:35:51 33633 8192000000 10838828912 11296395264 1803269776 18.041 93 20 40 0 1816373696 7579712 5524208
21:36:31 66518 8192000000 10858793664 11321081856 1867451536 18.564 97 19 38 1 1886056864 13107968 5497360
21:38:05 72513 8192000000 10877470480 11342512128 1906039968 18.875 98 19 38 0 1921341424 10039136 5262320
21:39:26 83359 8192000000 10875701808 11329835008 1838865600 18.332 94 21 42 0 1854315536 9567024 5882912
21:40:56 60640 8192000000 10874863760 11349872640 1944393536 19.182 100 20 40 0 1959242096 9246544 5602016
21:42:09 130547 8192000000 10846246928 11316711424 1797434560 17.993 92 18 36 0 1811377392 9421088 4521744
21:44:31 41590 8192000000 10877837264 11342966784 1934995984 19.107 100 25 50 4 1955605056 13841200 6767872
21:45:19 102464 8192000000 10875039376 11342188544 1903339280 18.853 98 15 30 0 1923189488 15701616 4148592
21:47:15 106178 8192000000 10856153600 11330387968 1877888032 18.648 97 30 60 1 1900911136 14867712 8155392
21:49:11 32375 8192000000 10852412528 11316137984 1874341072 18.619 97 36 71 2 1894353024 9451664 10560288
21:49:51 44105 8192000000 10879396000 11329982464 1936460672 19.119 100 44 88 2 1960897056 11785584 12650800
21:50:44 37243 8192000000 10884379552 11336855552 1937105040 19.124 100 44 88 0 1962435328 12991456 12338832
21:51:45 81691 8192000000 10865267680 11349315584 1922017424 19.003 99 31 63 3 1951205536 19660864 9527248
21:53:15 68984 8192000000 10873819952 11360636928 1920873024 18.994 99 13 26 0 1945505984 20808096 3824864
21:54:30 90758 8192000000 10871004160 11348434944 1922995104 19.011 99 14 28 0 1940899216 14134432 3769680
21:56:16 67529 8192000000 10874766080 11360292864 1955150544 19.267 100 22 44 0 1972969712 11528496 6290672
21:57:31 86201 8192000000 10875930592 11359457280 1926214160 19.037 98 17 34 0 1947768192 16755648 4798384
21:59:04 58663 8192000000 10864348976 11356852224 1945078512 19.187 100 5 10 0 1960528640 14776544 673584
22:00:08 27559 8192000000 10867838656 11347652608 1948702192 19.216 100 7 13 0 1960997808 11011376 1284240
22:00:49 61723 8192000000 10887697040 11373441024 1947711152 19.208 99 17 34 0 1959508816 7671856 4125808
22:02:26 64403 8192000000 10907258672 11382927360 1977501216 19.445 100 10 20 0 1990396416 10475824 2419376
22:03:50 66835 8192000000 10916868000 11395981312 1967497776 19.366 99 19 36 2 1987390080 14976928 4915376
22:05:25 43209 8192000000 10941142592 11393568768 1989400336 19.539 100 24 48 0 2006927840 10543600 6983904
22:06:16 29518 8192000000 10926559760 11403984896 1991023184 19.552 100 30 60 0 2012371472 12601824 8746464
22:06:55 79149 8192000000 10928330384 11397742592 1952791440 19.249 98 12 24 1 1967473904 11543776 3138688
22:08:20 57380 8192000000 10901539920 11378388992 1933127168 19.092 97 34 68 1 1952970032 10488352 9354512
22:09:25 78667 8192000000 10911384384 11379724288 1939973104 19.147 98 21 42 1 1957518720 11763488 5782128
22:10:54 84293 8192000000 10910428592 11388219392 1925397328 19.030 97 15 30 3 1941380880 11952608 4030944
22:12:30 91288 8192000000 10890894160 11378708480 1926765392 19.041 98 7 16 1 1944791312 15570896 2455024
22:14:07 69076 8192000000 10923249376 11372158976 1897981856 18.810 96 12 24 0 1911566352 9757840 3826656
22:15:26 79993 8192000000 10893458752 11365175296 1946896128 19.202 99 15 30 0 1961471536 10473008 4102400
22:17:00 84692 8192000000 10883926880 11367690240 1930197248 19.068 98 21 42 1 1946776192 10613760 5965184
22:18:37 4438 8192000000 10882222592 11367059456 1960328208 19.309 100 10 20 1 1975648928 12552560 2768160
22:18:47 30904 8192000000 10885147552 11360514048 1945539632 19.191 99 15 30 2 1960489536 10368672 4581232
22:20:16 67784 8192000000 10887339680 11372040192 1927677792 19.048 98 11 21 0 1939215136 8884224 2653120
22:21:30 89859 8192000000 10876114672 11352936448 1897643664 18.807 96 18 36 0 1915183280 12019424 5520192
22:23:08 77105 8192000000 10878047632 11361329152 1916763296 18.961 98 16 32 0 1931791680 10341648 4686736
22:24:40 77497 8192000000 10863621008 11342835712 1877926144 18.648 96 12 24 0 1893705008 12546784 3232080
22:26:04 57333 8192000000 10863574896 11332272128 1885448720 18.709 97 19 38 1 1907642528 16344592 5849216
22:27:08 25787 8192000000 9751204416 10102054912 889667408 9.796 46 8 15 1 896106528 4426880 2012240

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 07-04-2021 22:28:58 to 07-04-2021 22:29:28.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          232642
MON$OLDEST_ACTIVE               232643
MON$OLDEST_SNAPSHOT             232643
MON$NEXT_TRANSACTION            232643
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                       2052768
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.33442 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33442 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33442 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33442 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 ---
:48: 
:49: mscs-test-161.budzdorov.ru    Wed Apr  7 22:27:36 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Wed Apr  7 22:27:36 2021
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
--- end of diff output ---

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

07.04.21 22:29:32. 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-04-07 22:29:35 No severe PSQL-related problems occured
07.04.21 22:29:36. End of report.