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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17608676 kB
MemAvailable 31667200 kB
Buffers 0 kB
Cached 14126420 kB
SwapCached 2176 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 2020-11-30 01:27:00
DTS_END                         2020-11-30 01:27:00.9400
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44114
TRN_ID                          236948
ATT_ID                          711
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: 9129.31 27045 1095517
customer order: creation 165.12 380 19814
customer order: refuse 14.48 340 1737
order to supplier: creation 42.95 1318 5154
order to supplier: removal 3.48 103097 417
invoice (draft): creation 45.45 3665 5454
invoice (draft): removal 54.37 780 6524
invoice accept: apply 40.14 18093 4817
invoice accept: cancel 48.33 773 5800
customer reserve: creation 3744.16 176 449299
customer reserve: removal 4679.43 59 561531
realization accept: apply 80.80 201 9696
realization accept: cancel 85.36 120 10243
payment from customer: creation 57.54 140 6905
payment from customer: removal 5.56 94 667
payment to supplier: creation 46.88 166 5626
payment to supplier: removal 3.33 92 400
service: total inventory turnovers 4.52 1497 542
service: total monetary turnovers 6.56 46 787
service: aggregate perf. data 0.83 21499 100
service: refresh index statistics 0.03 388357 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-11-2020 01:28:47 to 30-11-2020 01:28:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4117
TEST_TIME 2 4037
TEST_TIME 3 4021
TEST_TIME 4 4020
TEST_TIME 5 4728
TEST_TIME 6 5348
TEST_TIME 7 5282
TEST_TIME 8 5332
TEST_TIME 9 5951
TEST_TIME 10 6674
TEST_TIME 11 7091
TEST_TIME 12 7149
TEST_TIME 13 7198
TEST_TIME 14 7106
TEST_TIME 15 7147
TEST_TIME 16 7170
TEST_TIME 17 7282
TEST_TIME 18 7294
TEST_TIME 19 7457
TEST_TIME 20 7559
TEST_TIME 21 8029
TEST_TIME 22 8345
TEST_TIME 23 8408
TEST_TIME 24 9106
TEST_TIME 25 9239
TEST_TIME 26 9806
TEST_TIME 27 10954
TEST_TIME 28 10980
TEST_TIME 29 10835
TEST_TIME 30 10606
TEST_TIME 31 10519
TEST_TIME 32 10405
TEST_TIME 33 10655
TEST_TIME 34 10434
TEST_TIME 35 10553
TEST_TIME 36 10471
TEST_TIME 37 10374
TEST_TIME 38 10307
TEST_TIME 39 10225
TEST_TIME 40 10072
TEST_TIME 41 9956
TEST_TIME 42 9815
TEST_TIME 43 9697
TEST_TIME 44 9620
TEST_TIME 45 9584
TEST_TIME 46 9550
TEST_TIME 47 9606
TEST_TIME 48 9506
TEST_TIME 49 9420
TEST_TIME 50 9470
TEST_TIME 51 9480
TEST_TIME 52 9407
TEST_TIME 53 9335
TEST_TIME 54 9297
TEST_TIME 55 9298
TEST_TIME 56 9297
TEST_TIME 57 9327
TEST_TIME 58 9319
TEST_TIME 59 9403
TEST_TIME 60 9522
TEST_TIME 61 9482
TEST_TIME 62 9564
TEST_TIME 63 9560
TEST_TIME 64 9668
TEST_TIME 65 9681
TEST_TIME 66 9681
TEST_TIME 67 9734
TEST_TIME 68 9631
TEST_TIME 69 9521
TEST_TIME 70 9566
TEST_TIME 71 9497
TEST_TIME 72 9437
TEST_TIME 73 9408
TEST_TIME 74 9417
TEST_TIME 75 9360
TEST_TIME 76 9365
TEST_TIME 77 9321
TEST_TIME 78 9235
TEST_TIME 79 9267
TEST_TIME 80 9302
TEST_TIME 81 9270
TEST_TIME 82 9261
TEST_TIME 83 9281
TEST_TIME 84 9341
TEST_TIME 85 9312
TEST_TIME 86 9345
TEST_TIME 87 9328
TEST_TIME 88 9378
TEST_TIME 89 9450
TEST_TIME 90 9437
TEST_TIME 91 9461
TEST_TIME 92 9482
TEST_TIME 93 9575
TEST_TIME 94 9493
TEST_TIME 95 9462
TEST_TIME 96 9410
TEST_TIME 97 9388
TEST_TIME 98 9367
TEST_TIME 99 9336
TEST_TIME 100 9301
TEST_TIME 101 9262
TEST_TIME 102 9200
TEST_TIME 103 9177
TEST_TIME 104 9193
TEST_TIME 105 9222
TEST_TIME 106 9238
TEST_TIME 107 9232
TEST_TIME 108 9239
TEST_TIME 109 9222
TEST_TIME 110 9244
TEST_TIME 111 9251
TEST_TIME 112 9262
TEST_TIME 113 9289
TEST_TIME 114 9301
TEST_TIME 115 9265
TEST_TIME 116 9354
TEST_TIME 117 9307
TEST_TIME 118 9240
TEST_TIME 119 9207
TEST_TIME 120 9130

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-11-2020 01:28:51 to 30-11-2020 01:28:54.

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 1511971 1511971 0 0.00 0 21399 7 0 0
doc_list_biud 1511971 1511971 0 0.00 0 53804 28 0 0
sp_add_invoice_to_stock 4944 4817 127 2.56 32 145550 18093 0 127
sp_cancel_adding_invoice 5800 5800 0 0.00 5 51365 774 0 0
sp_cancel_client_order 1737 1737 0 0.00 4 10149 341 0 0
sp_cancel_customer_reserve 561531 561531 0 0.00 1 53821 59 0 0
sp_cancel_pay_from_customer 667 667 0 0.00 3 6863 95 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 9646 92 0 0
sp_cancel_supplier_invoice 6532 6524 8 0.12 2 14518 781 0 8
sp_cancel_supplier_order 417 417 0 0.00 7 1249987 103098 0 0
sp_cancel_write_off 10243 10243 0 0.00 1 10955 121 0 0
sp_client_order 19814 19814 0 0.00 3 34487 381 0 0
sp_customer_reserve 449299 449299 0 0.00 0 39340 176 0 0
sp_fill_shopping_cart 30410 30410 0 0.00 1 20610 41 0 0
sp_fill_shopping_cart_clo_res 449294 449294 0 0.00 0 14502 15 0 0
sp_get_clo_for_invoice 4812 4812 0 0.00 0 17668 324 0 0
sp_kill_cost_storno 17110 17110 0 0.00 0 16548 64 0 0
sp_kill_qstorno_ret_qs2qd 1140246 1140246 0 0.00 0 53792 32 0 0
sp_kill_qty_storno 600760 600760 0 0.00 0 53804 69 0 0
sp_lock_selected_doc 20190 20190 0 0.00 0 9615 9 0 0
sp_make_cost_storno 27039 27039 0 0.00 0 21396 66 0 0
sp_multiply_rows_for_pdistr 27039 27039 0 0.00 0 10489 36 0 0
sp_multiply_rows_for_qdistr 19814 19814 0 0.00 0 21110 159 0 0
sp_pay_from_customer 6905 6905 0 0.00 4 15798 140 0 0
sp_pay_to_supplier 5626 5626 0 0.00 5 21407 167 0 0
sp_payment_common 12531 12531 0 0.00 1 16770 47 0 0
sp_qd_handle_on_cancel_clo 1737 1737 0 0.00 0 10142 309 0 0
sp_qd_handle_on_invoice_upd_sts 10612 10612 0 0.00 0 19810 351 0 0
sp_qd_handle_on_reserve_upd_sts 9696 9696 0 0.00 0 11487 55 0 0
sp_reserve_write_off 9696 9696 0 0.00 6 17633 201 0 0
sp_supplier_invoice 5454 5454 0 0.00 7 101518 3666 0 0
sp_supplier_order 5154 5154 0 0.00 5 54195 1318 0 0
srv_aggregate_perf_data 100 100 0 0.00 2545 342057 21500 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1082 157972 33637 0 0
srv_find_qd_qs_mism 1049572 1049572 0 0.00 0 19105 5 0 0
srv_make_invnt_saldo 542 542 0 0.00 37 166006 1498 0 0
srv_make_money_saldo 787 787 0 0.00 1 11182 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 241405 585283 388358 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4817 4817 0 0.00 0 8914 172 0 0
t$perf-norm:sp_cancel_adding_invoice 383 383 0 0.00 0 2645 89 0 0
t$perf-norm:sp_cancel_client_order 1737 1737 0 0.00 0 6311 13 0 0
t$perf-norm:sp_cancel_customer_reserve 664 664 0 0.00 0 1319 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 667 667 0 0.00 0 3006 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 373 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 538 14 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 19676 1616 0 0
t$perf-norm:sp_cancel_write_off 1012 1012 0 0.00 0 5880 16 0 0
t$perf-norm:sp_client_order 19814 19814 0 0.00 0 8643 23 0 0
t$perf-norm:sp_customer_reserve 940 940 0 0.00 0 3084 7 0 0
t$perf-norm:sp_pay_from_customer 6905 6905 0 0.00 0 5903 8 0 0
t$perf-norm:sp_pay_to_supplier 5626 5626 0 0.00 0 2963 11 0 0
t$perf-norm:sp_reserve_write_off 9696 9696 0 0.00 0 8672 13 0 0
t$perf-norm:sp_supplier_invoice 5454 5454 0 0.00 0 5800 24 0 0
t$perf-norm:sp_supplier_order 5154 5154 0 0.00 0 8410 19 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 132 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 308 4 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 1092 22 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 1272 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 4 0 0
v_add_invoice_to_stock 9876 9622 254 2.57 0 11225 22 0 254
v_all_customers 36161 36161 0 0.00 0 62 1 0 0
v_all_suppliers 29280 29280 0 0.00 0 45 1 0 0
v_all_wares 39628 39628 0 0.00 0 163 1 0 0
v_cancel_adding_invoice 766 766 0 0.00 0 3524 17 0 0
v_cancel_client_order 3474 3474 0 0.00 0 2734 5 0 0
v_cancel_customer_prepayment 1334 1334 0 0.00 0 1721 6 0 0
v_cancel_customer_reserve 1328 1328 0 0.00 0 3310 7 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 425 4 0 0
v_cancel_supplier_invoice 822 806 16 1.94 0 4900 23 0 16
v_cancel_supplier_order 834 834 0 0.00 0 8134 19 0 0
v_cancel_write_off 2024 2024 0 0.00 0 4933 21 0 0
v_max_id_clo_ord 5154 5154 0 0.00 0 477 1 0 0
v_max_id_clo_res 940 940 0 0.00 0 1756 16 0 0
v_max_id_ord_sup 5442 5442 0 0.00 0 5255 4 0 0
v_max_non_paid_invoice 1582 1582 0 0.00 0 1536 4 0 0
v_max_non_paid_realizn 3653 3653 0 0.00 0 5118 6 0 0
v_min_id_clo_ord 5154 5154 0 0.00 0 7911 7 0 0
v_min_id_clo_res 940 940 0 0.00 0 590 2 0 0
v_min_id_ord_sup 5442 5442 0 0.00 0 2953 5 0 0
v_min_non_paid_invoice 5626 5626 0 0.00 0 11167 32 0 0
v_min_non_paid_realizn 6905 6905 0 0.00 0 13976 30 0 0
v_our_firm 9970 9970 0 0.00 0 28 1 0 0
v_reserve_write_off 19391 19391 0 0.00 0 5178 7 0 0
x_lock_depdocs_on_canc_invoice 11921 11921 0 0.00 0 12087 116 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 11890 377 0 0
x_make_qstorno_1000_1200 5154 5154 0 0.00 1 54186 1232 0 0
x_make_qstorno_1200_2000 5454 5454 0 0.00 4 101460 3519 0 0
x_make_qstorno_2100_3300 449299 449299 0 0.00 0 39095 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-11-2020 01:28:55 to 30-11-2020 01:28:59.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:10 11114 8192000000 10177022848 10476036096 782885280 8.723 64 52 101 1 803028560 2168880 17974400
22:57:30 18442 8192000000 10280551744 10586996736 1335299456 14.015 100 84 169 0 1367321968 4148880 27873632
22:57:57 36646 8192000000 10340475024 10660937728 1383878096 14.451 100 84 168 1 1417669936 5772240 28019600
22:58:46 16630 8192000000 10384043456 10707988480 1433089760 14.889 100 85 170 0 1467645232 6825616 27729856
22:59:10 16892 8192000000 10402952560 10732920832 1464094752 15.162 100 89 178 0 1500776752 7684112 28997888
22:59:41 8622 8192000000 10437057296 10766741504 1489576368 15.385 100 86 172 1 1524985184 8155664 27253152
23:00:02 16975 8192000000 10451996960 10786390016 1505630016 15.525 100 90 180 0 1543502368 9025760 28846592
23:00:29 23219 8192000000 10479502592 10821005312 1530880256 15.745 100 85 170 0 1567245456 9858880 26506320
23:01:02 8859 8192000000 10492852128 10834436096 1545855712 15.874 100 86 172 0 1582896864 9912544 27128608
23:01:21 16587 8192000000 10506469200 10855763968 1568716880 16.071 100 81 162 1 1604294320 10540272 25037168
23:01:51 17238 8192000000 10558978480 10914807808 1616583760 16.481 100 79 157 0 1650502464 10507792 23410912
23:02:20 11640 8192000000 10583133616 10942750720 1638828928 16.670 100 83 164 1 1674599360 11425152 24345280
23:02:43 17491 8192000000 10599473584 10958860288 1655271856 16.809 100 91 182 0 1694614256 12668512 26673888
23:03:11 11147 8192000000 10613107248 10973949952 1671084528 16.942 100 82 164 0 1707452736 12465776 23902432
23:03:30 11385 8192000000 10623588416 10987528192 1684046160 17.051 100 80 160 1 1719994304 12298416 23649728
23:03:48 8807 8192000000 10642780208 11008520192 1696235904 17.154 100 84 168 3 1733454240 12905456 24312880
23:04:06 7379 8192000000 10649674704 11024347136 1711001040 17.277 100 70 140 0 1744018496 13199520 19817936
23:04:20 3902 8192000000 10674506224 11046641664 1731740208 17.450 100 76 150 3 1765532368 12729280 21062880
23:04:31 7033 8192000000 10683198272 11057070080 1745098864 17.561 100 84 168 0 1782287200 13157920 24030416
23:04:45 3590 8192000000 10684496848 11062448128 1750239840 17.604 100 72 143 3 1782512176 11689184 20583152
23:04:56 4746 8192000000 10697598944 11075809280 1759969648 17.684 100 78 156 3 1794435920 12549056 21917216
23:05:08 5701 8192000000 10714338720 11090731008 1768925520 17.758 100 79 157 1 1803751712 12236688 22589504
23:05:20 4086 8192000000 10722188848 11101274112 1778808016 17.840 100 89 177 4 1816939216 13692000 24439200
23:05:31 4723 8192000000 10733371360 11113283584 1790933104 17.939 100 87 174 1 1829713264 13547792 25232368
23:05:42 4120 8192000000 10741731712 11124903936 1796484656 17.985 100 82 163 1 1833665040 13447152 23733232
23:05:53 3533 8192000000 10741287824 11125022720 1802804960 18.037 100 88 173 1 1841811536 15126848 23879728
23:06:04 2738 8192000000 10754075680 11136618496 1807460464 18.075 100 93 185 0 1848463616 15547584 25455568
23:06:12 8694 8192000000 10755360464 11138015232 1812054896 18.113 100 90 178 0 1851472928 15614240 23803792
23:06:28 3756 8192000000 10760494112 11139932160 1813295616 18.123 100 89 179 2 1852072176 13506528 25270032
23:06:38 2539 8192000000 10768748352 11151265792 1827218832 18.237 100 89 178 3 1866600480 13895168 25486480
23:06:48 2105 8192000000 10772671712 11155517440 1831713040 18.273 100 86 173 2 1868655728 12178976 24763712
23:06:56 2923 8192000000 10784164880 11170197504 1837892144 18.324 100 85 169 4 1874118096 12734256 23491696
23:07:05 1837 8192000000 10789610736 11173826560 1849268736 18.416 100 96 194 2 1889376752 12387984 27720032
23:07:13 2326 8192000000 10794159904 11180302336 1849039888 18.414 100 95 188 1 1889610032 13808832 26761312
23:07:22 1233 8192000000 10795927760 11183345664 1855035472 18.463 100 90 182 1 1893722848 12900368 25787008
23:07:30 1536 8192000000 10809777520 11196612608 1861764976 18.518 100 89 175 0 1898750912 12728688 24257248
23:07:38 1636 8192000000 10810993488 11197505536 1863953440 18.535 100 88 175 0 1901266112 12775504 24537168
23:07:46 1779 8192000000 10806073456 11197698048 1866080368 18.553 100 92 183 1 1904813552 12652992 26080192
23:07:54 1304 8192000000 10820466800 11208003584 1869528768 18.580 100 92 184 0 1908176368 13166944 25480656
23:08:02 2194 8192000000 10816834640 11206950912 1872773120 18.607 100 92 185 1 1912604192 13957008 25874064
23:08:11 5778 8192000000 10807031040 11201392640 1869849424 18.583 100 84 167 1 1906723840 13181632 23692784
23:08:23 1496 8192000000 10816093760 11207680000 1873994080 18.617 100 83 166 1 1910079104 12044048 24040976
23:08:31 2189 8192000000 10800853552 11207315456 1873189984 18.610 100 65 130 0 1902396432 11510432 17696016
23:08:41 4549 8192000000 10793298736 11211169792 1873799312 18.615 100 51 101 2 1898104768 10199488 14105968
23:08:54 4374 8192000000 10809423136 11221786624 1881022432 18.673 100 53 107 1 1909836624 14536064 14278128
23:09:04 53205 8192000000 10817940368 11222167552 1881132000 18.674 100 38 76 2 1898107296 5401056 11574240
23:10:05 1059 8192000000 10842575984 11237851136 1897017984 18.802 100 96 192 2 1935227872 10697920 27511968
23:10:12 18871 8192000000 10790881072 11225686016 1886149264 18.715 100 36 72 1 1905367280 9108480 10109536
23:10:38 5351 8192000000 10795973872 11221856256 1884679744 18.703 100 29 59 0 1898881424 6142000 8059680
23:10:49 6645 8192000000 10806171328 11231514624 1886209696 18.715 100 39 77 2 1907298592 10604416 10484480
23:11:02 6586 8192000000 10799730720 11228684288 1893149120 18.771 100 24 48 0 1906253488 6675312 6429056
23:11:18 7985 8192000000 10802864096 11232817152 1894246304 18.780 100 26 52 2 1908771968 7424192 7101472
23:11:35 7619 8192000000 10800533792 11236487168 1894169280 18.779 100 26 52 1 1908210128 7206672 6834176
23:11:53 6465 8192000000 10807081952 11239141376 1895676464 18.792 100 13 26 1 1904570400 5286480 3607456
23:12:09 6027 8192000000 10807356864 11241816064 1901378464 18.837 100 17 35 0 1911625824 5544944 4702416
23:12:25 6408 8192000000 10811722128 11244937216 1902355872 18.845 100 26 51 0 1915129792 5318928 7454992
23:12:39 8306 8192000000 10817462880 11252903936 1902817776 18.849 100 27 55 2 1920995984 10584592 7593616
23:12:54 8737 8192000000 10816684688 11250388992 1909420336 18.902 100 22 43 0 1922289328 6178480 6690512
23:13:11 13128 8192000000 10823840064 11256864768 1907368496 18.886 100 14 28 1 1917111744 5626368 4116880
23:13:31 6253 8192000000 10816148496 11257905152 1911450176 18.918 100 22 44 0 1928636752 10905760 6280816
23:13:44 15132 8192000000 10839668096 11260035072 1914411856 18.942 100 34 68 2 1930127152 5303856 10411440
23:14:07 59537 8192000000 10841269008 11263709184 1917733840 18.969 100 50 101 0 1938369088 5695424 14939824
23:15:13 6669 8192000000 10826346320 11268976640 1915670576 18.952 100 36 72 0 1934082320 8370864 10040880
23:15:27 7771 8192000000 10831702704 11266650112 1916100128 18.956 100 33 66 2 1931690672 6425216 9165328
23:15:42 5129 8192000000 10824266048 11261145088 1911521792 18.919 100 31 61 1 1930718336 10564592 8631952
23:15:54 5518 8192000000 10829570832 11256111104 1894991024 18.786 99 34 68 0 1911581552 6245200 10345328
23:16:07 6637 8192000000 10834631680 11270713344 1917507968 18.967 100 39 78 1 1939645904 11275136 10862800
23:16:22 7482 8192000000 10813051568 11236126720 1862606448 18.524 97 25 50 1 1875518896 6095024 6817424
23:16:36 11576 8192000000 10783873296 11213496320 1849232416 18.416 97 23 45 0 1861822752 6003344 6586992
23:16:57 12199 8192000000 10788638976 11225743360 1868207664 18.570 99 21 41 4 1880213232 5880944 6124624
23:17:17 7586 8192000000 10770461616 11203145728 1823612608 18.207 97 14 28 1 1833283200 5835056 3835536
23:17:32 8851 8192000000 10775364544 11206483968 1796445056 17.985 96 14 28 0 1805655664 5560944 3649664
23:17:49 12968 8192000000 10717745456 11135524864 1687242960 17.078 91 21 44 0 1697947808 4756512 5948336
23:18:10 50178 8192000000 10739422480 11161403392 1793488256 17.960 98 39 78 1 1810241520 5100048 11653216
23:19:07 11110 8192000000 10719170576 11140784128 1750808832 17.608 96 18 36 3 1761335360 4886416 5640112
23:19:25 6616 8192000000 10719143120 11119763456 1721977776 17.369 95 46 90 3 1740418992 5913200 12528016
23:19:38 9259 8192000000 10701074736 11111780352 1741311088 17.530 97 20 40 2 1752331824 5553504 5467232
23:19:53 6850 8192000000 10715141808 11131633664 1799907520 18.013 100 33 66 2 1815383920 6053984 9422416
23:20:08 6927 8192000000 10694955184 11103612928 1705971328 17.235 95 24 48 2 1718451936 4970784 7509824
23:20:24 6759 8192000000 10685145888 11103346688 1749281664 17.596 98 31 61 3 1764137760 5657936 9198160
23:20:38 5668 8192000000 10717282496 11133841408 1760184016 17.686 97 30 60 1 1774833344 6056032 8593296
23:20:51 8358 8192000000 10687850432 11100307456 1691666800 17.115 94 16 32 0 1701558672 5021872 4870000
23:21:05 10163 8192000000 10716493712 11133718528 1797355520 17.992 100 24 48 1 1809706384 5521440 6829424
23:21:23 6234 8192000000 10737506928 11143557120 1809933120 18.095 100 47 95 1 1830510848 5849632 14728096
23:21:37 11520 8192000000 10710066560 11126431744 1756492368 17.655 97 25 50 0 1773700768 9845552 7362848
23:21:55 10072 8192000000 10699393824 11119042560 1763489040 17.713 98 16 32 0 1773697968 5702608 4506320
23:22:11 5340 8192000000 10706121376 11113406464 1768642080 17.756 98 31 62 0 1784200256 6532576 9025600
23:22:26 10848 8192000000 10724235232 11149012992 1813565328 18.125 100 13 26 3 1822264304 5013584 3685392
23:22:43 19226 8192000000 10771801616 11173621760 1830230864 18.261 100 19 36 2 1841250816 5031664 5988288
23:23:09 66843 8192000000 10754402528 11180498944 1838137136 18.326 100 27 53 1 1850609920 4661584 7811200
23:24:22 12323 8192000000 10767925520 11195146240 1849459712 18.418 100 26 52 0 1867525680 10774768 7291200
23:24:43 7536 8192000000 10774132112 11193806848 1852200224 18.440 100 29 58 0 1866120896 6012272 7908400
23:24:58 7045 8192000000 10784732032 11210080256 1862661392 18.525 100 29 57 0 1875910160 5283376 7965392
23:25:12 7393 8192000000 10785436960 11209641984 1866025520 18.552 100 30 58 3 1880130960 5827984 8277456
23:25:27 7950 8192000000 10791559232 11213668352 1871902128 18.600 100 34 69 0 1887731808 5132528 10697152
23:25:43 10407 8192000000 10775796928 11212529664 1871685696 18.598 100 24 48 1 1885160160 6213488 7260976
23:26:02 8637 8192000000 10793199920 11222761472 1873357872 18.611 100 19 38 1 1884105648 5845664 4902112
23:26:17 10227 8192000000 10786407488 11216797696 1873786128 18.615 100 17 35 1 1884629632 5520928 5322576
23:26:33 7663 8192000000 10802209152 11223486464 1879234816 18.659 100 37 75 1 1896374688 5191184 11948688
23:26:54 9046 8192000000 10791791552 11223261184 1878093168 18.650 100 16 32 0 1887532160 4692336 4746656
23:27:17 30474 8192000000 10819289920 11250311168 1900484576 18.830 100 32 66 1 1915724768 5322192 9918000
23:27:56 68633 8192000000 10848973872 11277012992 1918839296 18.978 100 37 72 1 1935833232 6975360 10018576
23:29:14 35670 8192000000 10860919824 11292401664 1933089504 19.092 100 33 64 2 1949911504 7518960 9303040
23:29:58 114592 8192000000 10890738576 11322613760 1946054096 19.195 100 34 68 1 1967961744 11570848 10336800
23:32:00 63359 8192000000 10901889520 11338747904 1960195600 19.308 100 35 69 1 1984002288 13727120 10079568
23:33:32 20773 8192000000 10908509360 11346841600 1967016736 19.362 100 47 94 0 1996403584 15725632 13661216
23:34:05 5392 8192000000 10924213680 11352391680 1980659872 19.470 100 64 126 2 2016728432 18063520 18005040
23:34:16 8665 8192000000 10926545264 11359023104 1983916752 19.496 100 60 120 1 2018615232 17565824 17132656
23:34:33 8872 8192000000 10927568416 11362246656 1985188144 19.506 100 54 105 0 2018058336 17792112 15078080
23:34:50 14684 8192000000 10933377952 11369680896 1991205808 19.553 100 58 116 0 2026547184 18593488 16747888
23:35:20 2900 8192000000 10950500352 11374772224 1993224720 19.569 100 76 149 0 2035562512 19343504 22994288
23:35:29 12069 8192000000 10941829712 11373961216 1995538176 19.588 100 69 138 1 2036155680 19949952 20667552
23:35:51 3576 8192000000 10929405088 11357396992 1967939760 19.369 99 74 148 2 2011823440 21935232 21948448
23:36:04 10019 8192000000 10927095264 11360206848 1963125408 19.331 99 61 122 1 2003863904 22534928 18203568
23:36:22 1366 8192000000 10925512592 11354099712 1974234256 19.419 100 66 132 1 2015955504 22253712 19467536
23:36:31 5399 8192000000 10931618160 11355967488 1974245360 19.419 100 70 137 0 2015135248 20274512 20615376
23:36:44 9806 8192000000 10928150944 11355140096 1962254176 19.324 99 68 135 0 2004268640 22055696 19958768
23:37:09 14947 8192000000 10936098720 11370897408 1981278128 19.475 100 59 116 0 2022192432 23813872 17100432
23:37:36 11246 8192000000 10938238080 11373633536 1992153120 19.561 100 56 112 0 2033214704 24599776 16461808
23:38:02 4251 8192000000 10939576864 11375587328 1980566784 19.469 99 63 126 2 2023829056 24140432 19121840
23:38:14 10616 8192000000 10944090848 11370151936 1985910544 19.511 100 74 147 0 2032180128 23977616 22291968
23:38:31 2492 8192000000 10951138080 11376754688 1991976896 19.559 100 64 128 0 2034276896 23491712 18808288
23:38:41 2857 8192000000 10920709088 11348787200 1951082288 19.235 98 69 136 2 1995912560 24879936 19950336
23:38:51 2981 8192000000 10946280608 11371085824 1987768704 19.526 100 71 142 1 2034763392 25418544 21576144
23:39:01 4675 8192000000 10959557024 11376459776 1994412944 19.579 100 76 152 1 2043254336 26475488 22365904
23:39:15 5400 8192000000 10968182144 11378872320 1988628912 19.533 100 84 167 2 2041098928 26069600 26400416
23:39:28 2247 8192000000 10978684832 11392466944 2003606736 19.651 100 90 178 0 2056862176 26429472 26825968
23:39:39 10071 8192000000 10967856432 11391311872 2003257712 19.648 100 70 138 0 2050736224 27573520 19904992
23:39:56 3900 8192000000 10971677712 11400065024 2008208784 19.687 100 71 139 1 2059165488 30459200 20497504
23:40:08 4943 8192000000 10965157280 11387371520 1993346560 19.570 99 64 126 3 2041640464 29373520 18920384
23:40:21 6344 8192000000 10965139936 11401216000 2008432640 19.689 100 62 124 1 2056550256 29695104 18422512
23:40:35 8321 8192000000 10978594496 11409707008 2015616192 19.746 100 59 118 0 2063626256 29630400 18379664
23:40:52 3881 8192000000 10984977120 11414315008 2020762304 19.786 100 66 131 0 2071275376 29577072 20936000
23:41:04 3618 8192000000 10997557904 11422695424 2029454032 19.854 100 73 146 0 2082721520 30880560 22386928
23:41:16 5046 8192000000 10989331792 11421974528 2026776688 19.833 100 70 140 0 2079629680 31820256 21032736
23:41:31 3972 8192000000 10984204256 11410604032 2000673056 19.628 99 72 143 0 2055191232 33146224 21371952
23:41:42 6068 8192000000 10975590080 11399483392 2001318688 19.633 100 77 154 1 2057857136 33485440 23053008
23:41:56 2514 8192000000 10979183552 11395444736 1988342448 19.531 99 81 163 2 2046048880 33717168 23989264
23:42:05 3278 8192000000 10971130912 11393380352 1999120640 19.616 100 80 156 2 2057313888 34531536 23661712
23:42:16 1488 8192000000 10983679024 11403948032 2010861136 19.708 100 89 175 1 2071704640 34633296 26210208
23:42:26 3147 8192000000 10996094432 11412090880 2012809600 19.724 100 84 168 1 2074227904 35665840 25752464
23:42:36 4301 8192000000 10977445568 11397910528 2003969616 19.654 100 76 152 0 2064523392 36741264 23812512
23:42:48 6420 8192000000 10982666592 11405938688 2008265408 19.688 100 81 163 2 2069196816 36560656 24370752
23:43:02 6789 8192000000 10986959072 11411447808 2011916240 19.717 100 71 142 2 2075353904 41783568 21654096
23:43:18 5885 8192000000 10969390784 11393912832 1997258976 19.601 100 72 145 3 2056423536 36854432 22310128
23:43:33 3089 8192000000 10986706448 11411341312 2009787792 19.700 100 71 141 2 2068264848 37178896 21298160
23:43:43 2850 8192000000 10985724336 11407634432 2007196464 19.679 100 76 152 1 2069100896 37968688 23935744
23:43:54 1562 8192000000 10983030528 11397828608 1998772384 19.613 100 86 174 0 2066197872 40573920 26851568
23:44:02 2511 8192000000 10966665440 11383083008 1979656448 19.462 99 77 151 0 2045291040 41355232 24279360
23:44:13 2426 8192000000 10962777392 11379339264 1971401456 19.397 99 80 160 1 2036410448 38832016 26176976
23:44:24 3263 8192000000 10963156288 11379118080 1981964048 19.480 100 80 160 5 2046840560 39533840 25342672
23:44:41 3186 8192000000 10966935968 11387625472 1987625024 19.525 100 79 158 0 2052405520 40160784 24619712
23:44:53 2557 8192000000 10983436032 11399921664 1997176160 19.600 100 82 164 0 2068362816 45659312 25527344
23:45:05 3437 8192000000 10968696800 11382857728 1953347600 19.253 98 84 164 1 2020328816 41896448 25084768
23:45:17 4592 8192000000 10970211744 11383246848 1980463792 19.468 100 78 154 0 2050045488 45119824 24461872
23:45:28 3143 8192000000 10973799488 11387203584 1986053392 19.513 100 80 161 2 2057901776 46725728 25122656
23:45:39 3333 8192000000 10973310704 11387654144 1983548416 19.493 100 80 159 0 2056017472 47409808 25059248
23:45:50 2366 8192000000 10979064992 11393921024 1988259424 19.530 100 83 166 2 2061792336 47373392 26159520
23:45:59 2687 8192000000 10983873504 11396890624 1989457680 19.540 100 81 162 1 2064243888 48394928 26391280
23:46:08 4351 8192000000 10960591648 11378446336 1971730576 19.399 99 74 148 1 2044399392 49011328 23657488
23:46:21 1783 8192000000 10995691504 11408056320 1995612768 19.588 100 90 170 3 2077565744 54631600 27321376
23:46:29 1618 8192000000 10962696192 11372843008 1969510320 19.382 99 82 161 2 2040891184 45907680 25473184
23:46:39 3920 8192000000 10972621072 11384172544 1980743168 19.471 100 84 168 2 2053279344 46556176 25980000
23:46:51 1080 8192000000 10979855344 11385913344 1972919616 19.409 99 92 184 1 2049734336 48132672 28682048
23:47:00 2453 8192000000 10967426688 11370426368 1967921056 19.369 99 89 178 1 2047457824 51573680 27963088
23:47:11 6969 8192000000 10976618784 11394662400 1985015968 19.504 100 78 156 0 2061583712 52114864 24452880
23:47:25 1221 8192000000 10980890448 11392442368 1984886464 19.503 100 88 173 1 2064621840 51501664 28233712
23:47:37 2906 8192000000 10980918000 11401371648 1988133280 19.529 100 73 146 0 2062332384 49887552 24311552
23:47:49 2286 8192000000 10983705136 11392155648 1976759792 19.439 99 83 163 0 2054111216 51400928 25950496
23:47:59 2036 8192000000 10990139504 11404750848 1989285632 19.538 100 81 162 0 2068897952 53111696 26500624
23:48:13 9800 8192000000 10979178368 11412004864 1987576480 19.525 100 47 94 0 2059481536 55871504 16033552
23:48:34 10268 8192000000 10977100240 11414368256 1989075904 19.536 100 57 114 1 2066261856 57637312 19548640
23:48:58 6048 8192000000 10953281280 11386728448 1961969840 19.322 99 43 86 1 2024837744 48349136 14518768
23:49:12 9133 8192000000 10957061248 11393191936 1961861296 19.321 99 41 82 1 2025728016 49742256 14124464
23:49:30 5847 8192000000 10962131488 11400798208 1982221600 19.482 100 42 85 0 2046616880 49856416 14538864
23:49:45 7189 8192000000 10940779232 11384627200 1971282080 19.396 100 43 85 1 2034188560 49039568 13866912
23:50:02 4783 8192000000 10948315040 11384729600 1967657712 19.367 100 39 79 1 2028182416 47825984 12698720
23:50:19 2724 8192000000 10952537360 11385167872 1939720800 19.145 98 80 160 2 2019478256 53776416 25981040
23:50:28 2568 8192000000 10974932384 11393138688 1973665056 19.415 100 80 158 0 2052309120 52743600 25900464
23:50:38 14614 8192000000 10961984352 11397455872 1976639744 19.438 100 45 90 1 2048645632 56521200 15484688
23:51:03 9115 8192000000 10943621056 11389063168 1952670880 19.248 99 35 70 2 2022226976 56880784 12675312
23:51:25 7168 8192000000 10932670752 11366277120 1932979520 19.091 99 37 74 3 1997741808 52079888 12682400
23:51:40 16597 8192000000 10930912752 11377242112 1949758864 19.225 100 26 52 0 2014383552 55740000 8884688
23:52:13 14121 8192000000 10914323440 11347525632 1926817312 19.041 100 29 58 2 1987474864 49790608 10866944
23:52:34 29740 8192000000 10900904032 11352666112 1912062896 18.923 99 21 42 1 1974944992 55003968 7878128
23:53:25 30782 8192000000 10907767920 11370663936 1927926512 19.050 100 20 40 1 1992846800 57480576 7439712
23:54:25 45996 8192000000 10874362768 11328684032 1926942448 19.042 100 13 26 0 1954380816 23505984 3932384
23:55:18 59652 8192000000 10864847152 11322753024 1920856688 18.994 99 12 24 0 1933013616 8853824 3303104
23:56:27 31643 8192000000 10867078128 11325489152 1923944448 19.018 99 14 28 1 1936811744 9029664 3837632
23:57:06 82231 8192000000 10887927776 11346259968 1923727584 19.017 99 10 21 0 1934412544 8354416 2330544
23:58:36 84554 8192000000 10887555984 11342221312 1901680048 18.840 97 18 36 1 1921293920 15065072 4548800
00:00:19 81811 8192000000 10885609472 11330699264 1921100416 18.996 98 19 38 1 1941358768 14572720 5685632
00:01:47 92818 8192000000 10905039984 11367800832 1937899040 19.130 99 17 35 1 1958335392 15465552 4970800
00:03:29 74873 8192000000 10871049392 11329925120 1931418720 19.078 99 20 40 1 1956141504 18823648 5899136
00:04:57 52112 8192000000 10879076960 11341111296 1957324224 19.285 100 36 67 1 1973878608 7073760 9480624
00:06:04 83553 8192000000 10899531280 11355344896 1965436480 19.349 100 18 35 2 1980752752 10404208 4912064
00:07:46 2216 8192000000 10914380944 11355529216 1975538400 19.429 100 54 108 4 1997957504 6937248 15481856
00:07:55 56189 8192000000 10901172048 11365056512 1971991328 19.401 100 13 25 1 1985770352 10118464 3660560
00:09:03 43308 8192000000 10906798048 11361832960 1965008320 19.346 99 35 70 3 1985461600 10256816 10196464
00:09:55 54906 8192000000 10926314880 11371266048 1947202688 19.204 98 40 80 1 1971727168 12565696 11958784
00:11:03 59703 8192000000 10923694944 11392753664 1990689088 19.549 100 26 52 2 2019061776 20667248 7705440
00:13:15 53022 8192000000 10898196960 11368816640 1945639952 19.192 98 12 23 2 1970473792 20962448 3871392
00:14:14 30687 8192000000 10898559888 11375661056 1970020464 19.386 100 15 30 1 1992456912 18280688 4155760
00:14:52 45260 8192000000 10887211232 11349446656 1951026816 19.235 99 18 37 0 1972131744 15970224 5134704
00:15:56 57453 8192000000 10844672544 11306246144 1897474592 18.806 97 23 46 1 1920205280 15074800 7655888
00:17:04 46583 8192000000 10867820576 11345707008 1934434096 19.102 99 22 43 1 1955574480 15096960 6043424
00:18:04 49135 8192000000 10859845072 11334696960 1930137728 19.068 99 20 40 0 1944689248 9123376 5428144
00:19:10 56123 8192000000 10854274064 11338289152 1931950160 19.082 99 3 6 0 1942238896 9660480 628256
00:20:21 49901 8192000000 10870764720 11334901760 1904263184 18.861 97 23 46 0 1919354880 8360896 6730800
00:21:23 60870 8192000000 10872417152 11341430784 1912719328 18.928 98 17 34 0 1927812224 10401216 4691680
00:22:30 43451 8192000000 10877575536 11349901312 1935243504 19.109 99 11 22 0 1953910064 14750448 3916112
00:23:21 24099 8192000000 10904399712 11360591872 1963108704 19.331 100 20 40 2 1983620288 15132400 5379184
00:23:52 55228 8192000000 10899130704 11361370112 1929888736 19.066 98 34 69 0 1959693552 19750288 10054528
00:25:07 66990 8192000000 10886105856 11366453248 1925406928 19.030 98 19 38 2 1954031024 22776176 5847920
00:26:32 116718 8192000000 10877703632 11355181056 1856717840 18.477 95 14 28 0 1883901360 22945440 4238080
00:28:35 70361 8192000000 10894866592 11365871616 1928317280 19.053 98 19 38 2 1945728832 11580720 5830832
00:29:58 96554 8192000000 10877599744 11356172288 1883762560 18.695 96 15 30 0 1904684160 17036784 3884816
00:31:41 93065 8192000000 10880744128 11340156928 1834541168 18.296 94 7 14 1 1846577072 10557520 1478384
00:33:27 55918 8192000000 10883746864 11356119040 1931443184 19.078 99 25 46 2 1953102848 15528272 6131392
00:34:29 135025 8192000000 10900199664 11349069824 1923783632 19.017 98 27 54 1 1945326032 13425392 8117008
00:36:54 106597 8192000000 10883243920 11348889600 1888719680 18.735 96 22 44 1 1904356240 9508784 6127776
00:38:47 25224 8192000000 10869049936 11345874944 1932456880 19.087 99 8 16 0 1948902512 14294544 2151088
00:39:19 22487 8192000000 10886785440 11341459456 1935000464 19.107 99 19 38 0 1953375776 12358576 6016736
00:39:51 72330 8192000000 10866504352 11337240576 1937273840 19.125 99 10 20 0 1950388256 10358240 2756176
00:41:16 65175 8192000000 10866149552 11335479296 1900001136 18.826 97 20 40 2 1917471392 11202320 6267936
00:42:47 42179 8192000000 10860794304 11332587520 1899331376 18.821 97 18 37 0 1915962320 10894528 5736416
00:43:35 69222 8192000000 10880170368 11358834688 1937894304 19.130 99 10 20 0 1958556320 17707504 2954512
00:45:05 87005 8192000000 10878424272 11336306688 1913225216 18.933 98 24 48 3 1933842096 13217200 7399680
00:47:04 36034 8192000000 10859864864 11331903488 1917845776 18.970 99 20 40 1 1934590128 11036928 5707424
00:48:03 34158 8192000000 10844135440 11304718336 1884837584 18.704 97 12 24 2 1895008768 6620880 3550304
00:48:46 41751 8192000000 10866146096 11316240384 1914086928 18.939 99 29 58 1 1932449312 10574576 7787808
00:49:34 29119 8192000000 10884649808 11337895936 1937548368 19.127 100 25 50 1 1956926544 12156240 7221936
00:50:15 63216 8192000000 10868018656 11346452480 1910366992 18.910 98 19 38 0 1929458032 13213296 5877744
00:51:24 71260 8192000000 10891279792 11354939392 1935239504 19.109 99 11 22 0 1951959536 12963888 3756144
00:52:42 86220 8192000000 10898585296 11361402880 1943703984 19.176 99 20 40 1 1962115680 12631216 5780480
00:54:23 76781 8192000000 10904102464 11359490048 1956389616 19.277 99 24 48 2 1977063552 14271360 6402576
00:55:48 51640 8192000000 10902986800 11373228032 1956470112 19.278 99 24 48 1 1974648128 11431920 6746096
00:56:55 124977 8192000000 10900322608 11363983360 1866080688 18.553 94 11 22 0 1881014544 12399968 2533888
00:59:11 72370 8192000000 10911314000 11386843136 1966475664 19.357 99 12 24 0 1991228432 21554800 3197968
01:00:30 157972 8192000000 10918531792 11400527872 1995875056 19.590 100 27 54 2 2013653552 9864432 7914064
01:03:16 48732 8192000000 10907234944 11374866432 1967220160 19.363 98 22 43 2 1981978688 8110512 6648016
01:04:23 62891 8192000000 10905166960 11384303616 1963668864 19.335 98 24 48 1 1978985072 8639440 6676768
01:05:39 51075 8192000000 10889533984 11372351488 1921151104 18.996 97 7 14 0 1934378992 11650208 1577680
01:06:41 66031 8192000000 10890980688 11366674432 1940321904 19.149 98 10 19 2 1950859376 8080352 2457120
01:09:09 86898 8192000000 10924394944 11400708096 1967374000 19.365 99 21 41 1 1988189744 14565680 6250064
01:10:43 95235 8192000000 10889541824 11364515840 1905988688 18.874 96 13 26 0 1936266272 26601088 3676496
01:12:47 78964 8192000000 10879218048 11364675584 1936541792 19.119 98 12 24 0 1954453056 14189984 3721280
01:14:13 44582 8192000000 10877022400 11349585920 1938537312 19.135 99 18 36 2 1951246304 7863312 4845680
01:15:04 42276 8192000000 10900485248 11352408064 1926491904 19.039 98 29 58 3 1942008144 6966784 8549456
01:15:54 21879 8192000000 10865781200 11320954880 1874867728 18.624 96 34 68 0 1892468768 8617712 8983328
01:16:28 10883 8192000000 10893029248 11337601024 1944832144 19.185 100 47 92 2 1968885120 10794752 13258224
01:17:11 78720 8192000000 10871544624 11338674176 1891893920 18.761 97 17 34 0 1905197280 8671248 4632112
01:18:47 52117 8192000000 10878919440 11345981440 1936893616 19.122 99 29 58 2 1957089344 12048752 8146976
01:19:46 34284 8192000000 10889553472 11363831808 1957150000 19.283 100 18 36 2 1975080208 12887728 5042480
01:20:39 94619 8192000000 10878952912 11341598720 1864788320 18.542 95 13 26 0 1883508000 14703072 4016608
01:22:26 25686 8192000000 10849960432 11293843456 1797384864 17.992 92 35 70 1 1823764976 16450176 9929936
01:23:01 91010 8192000000 10858176512 11326300160 1892656544 18.767 99 19 38 0 1913125776 15331600 5137632
01:25:01 88825 8192000000 10844098032 11309379584 1912109056 18.924 99 27 54 1 1927668704 7025760 8533888
01:26:36 30087 8192000000 10193846800 10595561472 1314405616 13.826 68 4 7 0 1321715216 6325312 984288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 30-11-2020 01:29:01 to 30-11-2020 01:29:32.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-11-2020 01:29:33 to 30-11-2020 01:29:35.

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          238065
MON$OLDEST_ACTIVE               238066
MON$OLDEST_SNAPSHOT             238066
MON$NEXT_TRANSACTION            238066
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                       2026656
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:119: 
:120: mscs-test-161.budzdorov.ru    Mon Nov 30 01:27:10 2020
:121:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:122: 
--- end of diff output ---

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

30.11.20 01:29:36. 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
2020-11-30 01:29:38 No severe PSQL-related problems occured
30.11.20 01:29:40. End of report.