Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.02.2021 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 17011732 kB
MemAvailable 31173760 kB
Buffers 0 kB
Cached 14713840 kB
SwapCached 4064 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-02-19 01:27:15
DTS_END                         2021-02-19 01:27:15.6460
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59080
TRN_ID                          235777
ATT_ID                          671
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: 9244.59 23307 1109351
customer order: creation 166.33 365 19959
customer order: refuse 14.86 360 1783
order to supplier: creation 43.28 1323 5193
order to supplier: removal 3.46 114151 415
invoice (draft): creation 43.47 3564 5216
invoice (draft): removal 55.28 806 6633
invoice accept: apply 39.41 18560 4729
invoice accept: cancel 50.18 787 6022
customer reserve: creation 3652.56 183 438307
customer reserve: removal 4883.67 63 586040
realization accept: apply 79.02 190 9482
realization accept: cancel 88.58 109 10630
payment from customer: creation 56.99 106 6839
payment from customer: removal 5.65 102 678
payment to supplier: creation 47.27 133 5672
payment to supplier: removal 3.07 103 368
service: total inventory turnovers 4.51 1039 541
service: total monetary turnovers 6.11 29 733
service: aggregate perf. data 0.89 17377 107
service: refresh index statistics 0.03 306780 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-02-2021 01:29:20 to 19-02-2021 01:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4395
TEST_TIME 2 2540
TEST_TIME 3 4267
TEST_TIME 4 4446
TEST_TIME 5 4465
TEST_TIME 6 5119
TEST_TIME 7 5577
TEST_TIME 8 5950
TEST_TIME 9 5895
TEST_TIME 10 5830
TEST_TIME 11 5871
TEST_TIME 12 5908
TEST_TIME 13 5835
TEST_TIME 14 6122
TEST_TIME 15 6422
TEST_TIME 16 7101
TEST_TIME 17 7400
TEST_TIME 18 7231
TEST_TIME 19 7644
TEST_TIME 20 7968
TEST_TIME 21 8389
TEST_TIME 22 8323
TEST_TIME 23 8746
TEST_TIME 24 9022
TEST_TIME 25 9474
TEST_TIME 26 9547
TEST_TIME 27 10770
TEST_TIME 28 10634
TEST_TIME 29 10472
TEST_TIME 30 10370
TEST_TIME 31 10452
TEST_TIME 32 10165
TEST_TIME 33 9953
TEST_TIME 34 9906
TEST_TIME 35 9858
TEST_TIME 36 9920
TEST_TIME 37 9961
TEST_TIME 38 9962
TEST_TIME 39 9943
TEST_TIME 40 9805
TEST_TIME 41 9680
TEST_TIME 42 9686
TEST_TIME 43 9732
TEST_TIME 44 9708
TEST_TIME 45 9661
TEST_TIME 46 9690
TEST_TIME 47 9556
TEST_TIME 48 9495
TEST_TIME 49 9536
TEST_TIME 50 9439
TEST_TIME 51 9329
TEST_TIME 52 9294
TEST_TIME 53 9302
TEST_TIME 54 9288
TEST_TIME 55 9339
TEST_TIME 56 9439
TEST_TIME 57 9455
TEST_TIME 58 9412
TEST_TIME 59 9518
TEST_TIME 60 9560
TEST_TIME 61 9560
TEST_TIME 62 9593
TEST_TIME 63 9620
TEST_TIME 64 9691
TEST_TIME 65 9680
TEST_TIME 66 9830
TEST_TIME 67 9749
TEST_TIME 68 9674
TEST_TIME 69 9647
TEST_TIME 70 9568
TEST_TIME 71 9620
TEST_TIME 72 9528
TEST_TIME 73 9500
TEST_TIME 74 9511
TEST_TIME 75 9433
TEST_TIME 76 9365
TEST_TIME 77 9409
TEST_TIME 78 9449
TEST_TIME 79 9421
TEST_TIME 80 9422
TEST_TIME 81 9399
TEST_TIME 82 9471
TEST_TIME 83 9477
TEST_TIME 84 9453
TEST_TIME 85 9492
TEST_TIME 86 9518
TEST_TIME 87 9567
TEST_TIME 88 9554
TEST_TIME 89 9579
TEST_TIME 90 9554
TEST_TIME 91 9511
TEST_TIME 92 9467
TEST_TIME 93 9449
TEST_TIME 94 9460
TEST_TIME 95 9428
TEST_TIME 96 9365
TEST_TIME 97 9328
TEST_TIME 98 9344
TEST_TIME 99 9306
TEST_TIME 100 9332
TEST_TIME 101 9347
TEST_TIME 102 9342
TEST_TIME 103 9328
TEST_TIME 104 9355
TEST_TIME 105 9397
TEST_TIME 106 9418
TEST_TIME 107 9433
TEST_TIME 108 9446
TEST_TIME 109 9438
TEST_TIME 110 9418
TEST_TIME 111 9535
TEST_TIME 112 9529
TEST_TIME 113 9452
TEST_TIME 114 9391
TEST_TIME 115 9363
TEST_TIME 116 9340
TEST_TIME 117 9331
TEST_TIME 118 9315
TEST_TIME 119 9316
TEST_TIME 120 9249

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-02-2021 01:29:24 to 19-02-2021 01:29:27.

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 1516742 1516742 0 0.00 0 32784 6 0 0
doc_list_biud 1516742 1516742 0 0.00 0 47517 31 0 0
sp_add_invoice_to_stock 4812 4729 83 1.72 40 241850 18560 0 83
sp_cancel_adding_invoice 6022 6022 0 0.00 5 56037 788 0 0
sp_cancel_client_order 1783 1783 0 0.00 4 7870 361 0 0
sp_cancel_customer_reserve 586040 586040 0 0.00 1 47523 64 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 3 11236 102 0 0
sp_cancel_pay_to_supplier 368 368 0 0.00 2 6318 103 0 0
sp_cancel_supplier_invoice 6637 6633 4 0.06 2 16407 806 0 4
sp_cancel_supplier_order 415 415 0 0.00 9 1155648 114152 0 0
sp_cancel_write_off 10630 10630 0 0.00 1 26254 109 0 0
sp_client_order 19959 19959 0 0.00 3 40765 365 0 0
sp_customer_reserve 438307 438307 0 0.00 0 63846 183 0 0
sp_fill_shopping_cart 30362 30362 0 0.00 1 25425 36 0 0
sp_fill_shopping_cart_clo_res 438299 438299 0 0.00 0 39363 16 0 0
sp_get_clo_for_invoice 4720 4720 0 0.00 0 23949 331 0 0
sp_kill_cost_storno 17698 17698 0 0.00 0 7600 59 0 0
sp_kill_qstorno_ret_qs2qd 1189758 1189758 0 0.00 0 47515 34 0 0
sp_kill_qty_storno 625724 625724 0 0.00 0 47517 73 0 0
sp_lock_selected_doc 19811 19811 0 0.00 0 11230 6 0 0
sp_make_cost_storno 26712 26712 0 0.00 0 14129 55 0 0
sp_multiply_rows_for_pdistr 26712 26712 0 0.00 0 7360 34 0 0
sp_multiply_rows_for_qdistr 19959 19959 0 0.00 0 40538 182 0 0
sp_pay_from_customer 6839 6839 0 0.00 4 9232 107 0 0
sp_pay_to_supplier 5672 5672 0 0.00 5 14138 134 0 0
sp_payment_common 12511 12511 0 0.00 1 9325 32 0 0
sp_qd_handle_on_cancel_clo 1783 1783 0 0.00 0 7850 332 0 0
sp_qd_handle_on_invoice_upd_sts 10741 10741 0 0.00 0 34255 359 0 0
sp_qd_handle_on_reserve_upd_sts 9482 9482 0 0.00 0 18206 62 0 0
sp_reserve_write_off 9482 9482 0 0.00 6 18358 191 0 0
sp_supplier_invoice 5216 5216 0 0.00 7 84707 3565 0 0
sp_supplier_order 5193 5193 0 0.00 6 48682 1324 0 0
srv_aggregate_perf_data 107 107 0 0.00 2737 148951 17377 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1475 140479 32378 0 0
srv_find_qd_qs_mism 1064459 1064459 0 0.00 0 32784 5 0 0
srv_make_invnt_saldo 541 541 0 0.00 13 16950 1040 0 0
srv_make_money_saldo 733 733 0 0.00 1 1776 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 171607 508178 306780 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4730 4730 0 0.00 0 21234 243 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 0 6319 118 0 0
t$perf-norm:sp_cancel_client_order 1783 1783 0 0.00 0 1818 14 0 0
t$perf-norm:sp_cancel_customer_reserve 645 645 0 0.00 0 1311 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 678 678 0 0.00 0 11112 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 368 368 0 0.00 0 5611 33 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 1573 21 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 49082 2040 0 0
t$perf-norm:sp_cancel_write_off 947 947 0 0.00 0 6917 22 0 0
t$perf-norm:sp_client_order 19959 19959 0 0.00 0 19544 22 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 5970 17 0 0
t$perf-norm:sp_pay_from_customer 6839 6839 0 0.00 0 28836 14 0 0
t$perf-norm:sp_pay_to_supplier 5672 5672 0 0.00 0 13850 19 0 0
t$perf-norm:sp_reserve_write_off 9482 9482 0 0.00 0 27095 20 0 0
t$perf-norm:sp_supplier_invoice 5216 5216 0 0.00 0 9875 23 0 0
t$perf-norm:sp_supplier_order 5193 5193 0 0.00 0 28281 26 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 19014 180 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 4291 40 0 0
t$perf-norm:srv_make_invnt_saldo 541 541 0 0.00 0 1193 26 0 0
t$perf-norm:srv_make_money_saldo 733 733 0 0.00 0 832 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9604 9438 166 1.72 0 5718 19 0 166
v_all_customers 36188 36188 0 0.00 0 20 1 0 0
v_all_suppliers 29018 29018 0 0.00 0 38 1 0 0
v_all_wares 39916 39916 0 0.00 0 100 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 2910 10 0 0
v_cancel_client_order 3566 3566 0 0.00 0 3051 6 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 2448 6 0 0
v_cancel_customer_reserve 1290 1290 0 0.00 0 1189 6 0 0
v_cancel_payment_to_supplier 736 736 0 0.00 0 1810 6 0 0
v_cancel_supplier_invoice 782 774 8 1.02 0 3113 24 0 8
v_cancel_supplier_order 830 830 0 0.00 0 1187 5 0 0
v_cancel_write_off 1894 1894 0 0.00 0 1515 14 0 0
v_max_id_clo_ord 5193 5193 0 0.00 0 1107 2 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 13514 27 0 0
v_max_id_ord_sup 5211 5211 0 0.00 0 2907 3 0 0
v_max_non_paid_invoice 1566 1566 0 0.00 0 301 3 0 0
v_max_non_paid_realizn 3618 3618 0 0.00 0 2879 6 0 0
v_min_id_clo_ord 5192 5192 0 0.00 0 3668 7 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 6917 23 0 0
v_min_id_ord_sup 5211 5211 0 0.00 0 3829 5 0 0
v_min_non_paid_invoice 5672 5672 0 0.00 0 9322 26 0 0
v_min_non_paid_realizn 6839 6839 0 0.00 0 6595 18 0 0
v_our_firm 10170 10170 0 0.00 0 22 1 0 0
v_reserve_write_off 18962 18962 0 0.00 0 2858 5 0 0
x_lock_depdocs_on_canc_invoice 12268 12268 0 0.00 0 18715 128 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 13223 386 0 0
x_make_qstorno_1000_1200 5193 5193 0 0.00 2 48672 1239 0 0
x_make_qstorno_1200_2000 5216 5216 0 0.00 3 84697 3442 0 0
x_make_qstorno_2100_3300 438307 438307 0 0.00 0 53700 164 0 0

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

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:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:25 9148 8192000000 10198584256 10502877184 973588944 10.622 77 61 123 0 997076640 2681200 20806496
22:57:43 24348 8192000000 10318659136 10634014720 1359852288 14.236 100 82 164 0 1391567600 4697680 27017632
22:58:18 16748 8192000000 10369608400 10692182016 1425335968 14.820 100 83 165 1 1458499232 6183136 26980128
22:58:43 34751 8192000000 10406735136 10734055424 1448163632 15.022 100 86 172 0 1483464656 7264208 28036816
22:59:26 24069 8192000000 10436736384 10770284544 1483840128 15.335 100 85 170 0 1519189648 7806672 27542848
23:00:06 18514 8192000000 10456546736 10795175936 1512955312 15.589 100 87 174 1 1549649264 8737536 27956416
23:00:41 17617 8192000000 10481734736 10823630848 1535916688 15.788 100 80 160 0 1570879328 9136976 25825664
23:01:07 19608 8192000000 10504204672 10849124352 1558057488 15.979 100 86 172 0 1594447040 9565184 26824368
23:01:38 16148 8192000000 10522995024 10867580928 1575529152 16.130 100 86 172 0 1612822848 10400432 26893264
23:02:04 14609 8192000000 10528850768 10885922816 1590203072 16.256 100 73 146 0 1622633552 10500336 21930144
23:02:28 6245 8192000000 10554084640 10913300480 1617623264 16.490 100 85 170 1 1653677840 10434336 25620240
23:02:52 13594 8192000000 10580306496 10947395584 1648165056 16.749 100 71 142 0 1680145264 10970784 21009424
23:03:15 13294 8192000000 10611295952 10972442624 1668316144 16.919 100 81 162 3 1703514608 11655408 23543056
23:03:36 8892 8192000000 10624146336 10987888640 1683686144 17.048 100 83 166 0 1720178016 12333264 24158608
23:03:52 9223 8192000000 10641712432 11007705088 1697695728 17.166 100 81 160 0 1733281840 12722320 22863792
23:04:08 4805 8192000000 10653140672 11025641472 1717398480 17.331 100 76 150 1 1751224800 12268448 21557872
23:04:21 6980 8192000000 10669911136 11043655680 1735080896 17.478 100 82 162 4 1770538464 12188224 23269344
23:04:38 6921 8192000000 10680889216 11057008640 1742801504 17.542 100 74 148 1 1775777072 12156224 20819344
23:04:51 5063 8192000000 10698909504 11073830912 1758539616 17.672 100 87 174 1 1795953520 12798576 24615328
23:05:04 4110 8192000000 10701801536 11079507968 1768146848 17.752 100 87 171 1 1806158336 13522960 24488528
23:05:16 4579 8192000000 10719754656 11097157632 1778006400 17.833 100 91 182 2 1817531568 13750016 25775152
23:05:27 3299 8192000000 10714069600 11099365376 1781061360 17.858 100 72 145 0 1813643824 12652784 19929680
23:05:37 4266 8192000000 10727442816 11103854592 1791586608 17.945 100 82 164 2 1826828080 12485936 22755536
23:05:48 2666 8192000000 10741562784 11119874048 1798997616 18.006 100 81 162 1 1833904384 11999680 22907088
23:05:58 6696 8192000000 10741079616 11125792768 1807159472 18.073 100 83 166 1 1844453488 14393440 22900576
23:06:12 5931 8192000000 10769072016 11150303232 1808432672 18.083 100 81 163 0 1844693968 14363008 21898288
23:06:26 3661 8192000000 10771608960 11154575360 1824597632 18.215 100 90 180 4 1869438384 19796336 25044416
23:06:36 2542 8192000000 10767238080 11150266368 1827824448 18.242 100 84 167 0 1866460480 14116000 24520032
23:06:45 2427 8192000000 10767460640 11151376384 1828845408 18.250 100 84 169 1 1866655936 13420880 24389648
23:06:54 1708 8192000000 10773258976 11162492928 1837651152 18.322 100 88 174 1 1875804720 12759264 25394304
23:07:02 3509 8192000000 10787044208 11172642816 1844604208 18.378 100 90 181 0 1889213072 18322464 26286400
23:07:12 2292 8192000000 10787376128 11174957056 1842702048 18.363 100 87 174 1 1881401056 13995840 24703168
23:07:20 3520 8192000000 10789984688 11177373696 1851627360 18.435 100 91 182 2 1889683024 12495328 25560336
23:07:31 2447 8192000000 10801092592 11186552832 1855650784 18.468 100 94 188 2 1896620256 13878896 27090576
23:07:39 1946 8192000000 10794319904 11182817280 1856349088 18.474 100 84 166 0 1892650992 12764336 23537568
23:07:48 1568 8192000000 10806181424 11189497856 1863059264 18.528 100 97 190 0 1903442512 13386496 26996752
23:07:56 2041 8192000000 10802656000 11188088832 1860543392 18.508 100 92 182 2 1900277456 12934336 26799728
23:08:05 1941 8192000000 10798469760 11188903936 1863266016 18.530 100 83 165 1 1898553168 11157728 24129424
23:08:14 2391 8192000000 10812591408 11197980672 1864913520 18.543 100 92 184 2 1902072832 11394736 25764576
23:08:23 1300 8192000000 10813419488 11201662976 1869947216 18.584 100 91 183 1 1908885888 13118832 25819840
23:08:30 19946 8192000000 10804811504 11201359872 1866442896 18.555 100 58 116 0 1894647232 11910592 16293744
23:08:57 4238 8192000000 10804595472 11206836224 1875708624 18.630 100 84 168 0 1911510976 11731488 24070864
23:09:09 11216 8192000000 10808599504 11206516736 1872520352 18.605 100 53 106 1 1897246544 10477600 14248592
23:09:27 1420 8192000000 10814562224 11209551872 1879505744 18.661 100 79 158 1 1914168688 11528128 23134816
23:09:36 11783 8192000000 10787417456 11205644288 1871414176 18.596 100 41 83 0 1892870304 9737120 11719008
23:09:54 6805 8192000000 10784327264 11203649536 1870247424 18.586 100 35 71 0 1887905568 8154096 9504048
23:10:08 7345 8192000000 10787631888 11204079616 1872934720 18.608 100 40 79 3 1893363008 9384944 11043344
23:10:22 5109 8192000000 10785947840 11205644288 1871792192 18.599 100 34 68 1 1889642320 7971904 9878224
23:10:34 5550 8192000000 10770367728 11202342912 1873328112 18.611 100 40 80 2 1892094752 6915104 11851536
23:10:51 5234 8192000000 10783079152 11205423104 1876978992 18.641 100 34 67 2 1892710912 5705872 10026048
23:11:05 2659 8192000000 10798760432 11207823360 1876265504 18.635 100 40 82 0 1894200192 5991072 11943616
23:11:17 5165 8192000000 10787512336 11211108352 1872934624 18.608 100 21 43 0 1889550816 10509440 6106752
23:11:28 10278 8192000000 10780101376 11210592256 1874620240 18.622 100 22 44 0 1887133616 6447824 6065552
23:11:46 12605 8192000000 10799922128 11221848064 1882528704 18.686 100 22 44 0 1894043040 5601216 5913120
23:12:10 15176 8192000000 10801658320 11232645120 1893716752 18.776 100 22 43 3 1905669360 6219104 5733504
23:12:36 6198 8192000000 10806313808 11233738752 1898367696 18.813 100 32 65 4 1913476560 5917184 9191680
23:12:48 7855 8192000000 10810456288 11239354368 1900329968 18.829 100 24 47 1 1912865648 6418304 6117376
23:13:04 8991 8192000000 10811323104 11237216256 1898806720 18.817 100 19 38 1 1910007840 4561040 6640080
23:13:19 12855 8192000000 10817758144 11243487232 1912658032 18.928 100 44 86 1 1931641632 5861648 13121952
23:13:40 67194 8192000000 10820526944 11259842560 1914232416 18.941 100 34 66 1 1929445616 6012512 9200688
23:14:57 9429 8192000000 10829408112 11266678784 1914529088 18.943 100 25 50 4 1927615792 6559040 6527664
23:15:15 4078 8192000000 10836166208 11270414336 1917781808 18.969 100 26 52 0 1931211568 5874416 7555344
23:15:25 6188 8192000000 10834612976 11269844992 1916495200 18.959 100 18 36 0 1928133744 6760304 4878240
23:15:39 5691 8192000000 10834804688 11271503872 1921127040 18.996 100 42 83 3 1941460320 8429904 11903376
23:15:51 6053 8192000000 10840066304 11265986560 1921051024 18.995 100 30 60 1 1936556880 6742080 8763776
23:16:06 6472 8192000000 10831376368 11264835584 1918630720 18.976 100 18 36 1 1929395360 5718480 5046160
23:16:19 8549 8192000000 10824514512 11264212992 1896361792 18.797 99 15 30 1 1910791248 10301616 4127840
23:16:34 5980 8192000000 10823984528 11259457536 1908815440 18.897 100 32 63 3 1925215600 6949776 9450384
23:16:48 6982 8192000000 10816056688 11241242624 1884358992 18.700 99 26 52 3 1897558448 5589808 7609648
23:17:03 7663 8192000000 10788054384 11218997248 1864110256 18.537 99 17 34 2 1873906208 5073584 4722368
23:17:17 9684 8192000000 10793746736 11220594688 1827183776 18.236 97 27 52 1 1839651344 5564336 6903232
23:17:33 9276 8192000000 10777022352 11198136320 1811842304 18.111 97 15 30 1 1821092336 5019072 4230960
23:17:50 13153 8192000000 10760792400 11192832000 1824544160 18.215 98 16 32 2 1834896768 5530320 4822288
23:18:11 67372 8192000000 10738062544 11159965696 1749919968 17.601 94 31 62 0 1764534800 5018880 9595952
23:19:28 6526 8192000000 10755650096 11170734080 1800119184 18.015 98 46 93 0 1821720832 8095248 13506400
23:19:42 7868 8192000000 10738038080 11165724672 1771358480 17.778 96 28 56 2 1786323360 6965456 7999424
23:19:58 4244 8192000000 10752943120 11167735808 1799598448 18.011 98 36 72 1 1821792544 11952832 10241264
23:20:09 4058 8192000000 10721003088 11141869568 1795817632 17.980 99 36 72 0 1813494416 6865696 10811088
23:20:22 9059 8192000000 10678923280 11093688320 1673647232 16.964 93 21 40 2 1689251488 9806448 5797808
23:20:37 6888 8192000000 10679233808 11089121280 1729732000 17.433 97 29 58 0 1743926624 5784176 8410448
23:20:50 7815 8192000000 10690872880 11109576704 1747880928 17.584 98 19 38 1 1759137680 5732320 5524432
23:21:06 4770 8192000000 10700013712 11104518144 1724007200 17.386 96 37 74 0 1740535392 4818464 11709728
23:21:19 7679 8192000000 10697584928 11102699520 1739547200 17.515 97 31 62 1 1754492720 5295280 9650240
23:21:35 8809 8192000000 10716482480 11136045056 1783096672 17.875 99 14 28 1 1792359904 5019360 4243872
23:21:50 8354 8192000000 10740147584 11155030016 1805393136 18.058 99 21 42 2 1815788896 4960272 5435488
23:22:04 12818 8192000000 10723417120 11137765376 1785350480 17.894 98 27 53 0 1798132624 4661632 8120512
23:22:26 11295 8192000000 10727922352 11144310784 1808015408 18.080 99 26 50 3 1825664272 10577104 7071760
23:22:46 57356 8192000000 10759864336 11165569024 1828606704 18.248 100 32 63 2 1844265328 5341552 10317072
23:23:53 32119 8192000000 10761119200 11178295296 1837373280 18.319 100 21 42 1 1847714960 4670336 5671344
23:24:31 7045 8192000000 10761966288 11182620672 1844561472 18.378 100 27 53 2 1858773248 6167984 8043792
23:24:45 8233 8192000000 10762156144 11185840128 1846984064 18.398 100 27 55 2 1859519040 4806736 7728240
23:25:01 8702 8192000000 10769999888 11188785152 1852628784 18.443 100 20 40 0 1863915568 5417968 5868816
23:25:17 6475 8192000000 10772237296 11191885824 1852284976 18.441 100 38 76 1 1871193584 7316096 11592512
23:25:29 6019 8192000000 10767017264 11194400768 1850445920 18.426 100 23 45 1 1863065456 5806784 6812752
23:25:44 5486 8192000000 10772987408 11198558208 1854110240 18.456 100 19 39 1 1865289232 4974640 6204352
23:25:56 7545 8192000000 10777282176 11205652480 1858326368 18.490 100 26 52 0 1871855696 5749264 7780064
23:26:14 10289 8192000000 10775501728 11208605696 1864469600 18.540 100 16 32 0 1874266624 5445696 4351328
23:26:34 7184 8192000000 10795464416 11217838080 1870119536 18.585 100 18 36 1 1879964560 4937568 4907456
23:26:49 11105 8192000000 10796932944 11219247104 1871073232 18.593 100 28 56 2 1889540112 9761984 8704896
23:27:06 10679 8192000000 10795616080 11226161152 1882478704 18.685 100 15 30 0 1891732032 5128928 4124400
23:27:34 15100 8192000000 10831691104 11243962368 1897330048 18.805 100 37 75 1 1913166944 5345792 10491104
23:27:57 18451 8192000000 10848359024 11259801600 1913102032 18.932 100 59 118 3 1939465392 8965584 17397776
23:28:25 125301 8192000000 10849288992 11284348928 1925196048 19.028 100 47 95 2 1950297312 11558128 13543136
23:30:40 75866 8192000000 10868130864 11306037248 1933624624 19.096 100 24 48 1 1953126736 12429680 7072432
23:32:02 20209 8192000000 10893760096 11323453440 1955089376 19.267 100 48 97 2 1981092160 12430992 13571792
23:32:39 35484 8192000000 10900578752 11335499776 1961582448 19.319 100 50 99 0 1991663888 15989072 14092368
23:33:28 4072 8192000000 10907231936 11332034560 1963667136 19.335 100 56 111 1 1997693056 16396256 17629664
23:33:38 2695 8192000000 10916030048 11332644864 1964081984 19.338 100 58 115 0 1994724048 14446832 16195232
23:33:49 3884 8192000000 10916025440 11336798208 1961088848 19.315 100 64 129 4 1995869200 15100400 19679952
23:34:01 5943 8192000000 10918604304 11339915264 1967566208 19.366 100 69 138 1 2005124720 17036016 20522496
23:34:19 3645 8192000000 10914676128 11341426688 1967276832 19.364 100 57 112 1 2002877504 18621312 16979360
23:34:30 4083 8192000000 10927329120 11347148800 1975587376 19.430 100 71 138 1 2012770592 16372656 20810560
23:34:41 12414 8192000000 10935137024 11351961600 1979030928 19.457 100 63 124 0 2018846448 22232336 17583184
23:35:01 7442 8192000000 10926042800 11355058176 1980239696 19.467 100 55 110 0 2014189952 17129248 16821008
23:35:15 16228 8192000000 10929695328 11360464896 1985036688 19.505 100 62 124 0 2021254960 17100320 19117952
23:35:45 13978 8192000000 10919073872 11348348928 1975110512 19.426 100 47 94 3 2004410896 14492784 14807600
23:36:09 9164 8192000000 10912804688 11345600512 1962026080 19.322 99 53 108 1 1996633808 18804384 15803344
23:36:35 10152 8192000000 10934177280 11364311040 1983689408 19.494 100 50 100 1 2018952464 20189120 15073936
23:37:02 14240 8192000000 10947176832 11375460352 1989203120 19.537 100 51 102 1 2028770224 23997232 15569872
23:37:24 9245 8192000000 10928081456 11353923584 1957476944 19.286 99 60 117 1 2005924256 31046368 17400944
23:37:52 17415 8192000000 10917962400 11356585984 1958751120 19.296 99 59 116 3 2004250000 27958560 17540320
23:38:21 10477 8192000000 10920243952 11352203264 1952519200 19.247 99 44 88 1 1994910576 28641840 13749536
23:38:40 4069 8192000000 10941411856 11367297024 1976573616 19.438 100 52 103 0 2025202112 33463216 15165280
23:38:51 3453 8192000000 10955611568 11373416448 1988015120 19.528 100 62 122 0 2035244368 29432192 17797056
23:39:01 3942 8192000000 10951743824 11377983488 1986359344 19.515 100 64 127 1 2035585984 29557504 19669136
23:39:12 4272 8192000000 10965348144 11385593856 1996978448 19.599 100 64 128 1 2047978672 31235200 19765024
23:39:31 2771 8192000000 10957448128 11365445632 1962495808 19.326 99 82 165 5 2020680624 32776560 25408256
23:39:41 4287 8192000000 10951442096 11373531136 1984306688 19.499 100 74 146 0 2040091952 33523312 22261952
23:39:52 9046 8192000000 10953913200 11380699136 1987232560 19.522 100 66 132 1 2042543776 34622784 20688432
23:40:12 3570 8192000000 10941170576 11351453696 1949604336 19.223 98 72 144 1 2012677472 41795632 21277504
23:40:27 6056 8192000000 10949964800 11376685056 1982429552 19.484 100 67 134 1 2041907296 38842400 20635344
23:40:41 6159 8192000000 10960791504 11388682240 1988907488 19.535 100 63 126 0 2047807824 39371072 19529264
23:40:56 2464 8192000000 10972839536 11394641920 1996783312 19.597 100 74 148 0 2060639376 40614800 23241264
23:41:08 3462 8192000000 10960579856 11377127424 1981947552 19.480 100 81 159 0 2049460112 42732848 24779712
23:41:19 3379 8192000000 10965771136 11386421248 1986004320 19.512 100 74 148 0 2052833984 42940336 23889328
23:41:32 5327 8192000000 10979491280 11393687552 1989440480 19.539 100 81 162 1 2058369344 43845568 25083296
23:41:45 7198 8192000000 10970623152 11393519616 1984966592 19.504 100 72 144 1 2053603184 45500656 23135936
23:42:00 3835 8192000000 10980104816 11391238144 1985247184 19.506 100 82 164 1 2057163856 46651696 25264976
23:42:11 4794 8192000000 10968455728 11385856000 1968521296 19.374 99 78 154 0 2038108864 45630944 23956624
23:42:24 3716 8192000000 10975222912 11392688128 1967327584 19.364 99 75 149 0 2037509648 47072976 23109088
23:42:34 3298 8192000000 10985257536 11396808704 1992722192 19.565 100 75 145 0 2063450704 47467760 23260752
23:42:45 3115 8192000000 10990972304 11407343616 1993548304 19.572 100 71 141 0 2064298688 48241968 22508416
23:42:55 1474 8192000000 10965110336 11378753536 1969339088 19.380 99 81 163 2 2043933904 48854368 25740448
23:43:04 3341 8192000000 10959625072 11368574976 1944827216 19.185 98 82 163 0 2021844080 51147104 25869760
23:43:16 3929 8192000000 10942673408 11362242560 1940308656 19.149 99 71 143 0 2015296432 51827200 23160576
23:43:26 1970 8192000000 10951144304 11365687296 1955138864 19.267 100 83 166 0 2034475424 52400928 26935632
23:43:35 1900 8192000000 10938339984 11341037568 1933443808 19.094 99 89 174 2 2015453392 53587904 28421680
23:43:43 2162 8192000000 10943746048 11353919488 1949417920 19.222 100 83 164 2 2025228816 49496800 26314096
23:43:52 4765 8192000000 10950626896 11367923712 1961519104 19.318 100 72 144 0 2031635376 47196384 22919888
23:44:04 3160 8192000000 10955057040 11374927872 1966576400 19.358 100 66 130 1 2035174192 47949232 20648560
23:44:16 2283 8192000000 10971870480 11386220544 1977126016 19.442 100 78 155 1 2049381184 46852480 25402688
23:44:27 4701 8192000000 10951180656 11368415232 1954389168 19.261 100 69 138 0 2023860304 47271344 22199792
23:44:44 2890 8192000000 10956324720 11380236288 1969381632 19.381 100 66 132 0 2041065728 49209504 22474592
23:44:56 5819 8192000000 10951313872 11370262528 1950511568 19.231 99 64 128 0 2018754032 46561184 21681280
23:45:12 7080 8192000000 10961346496 11386744832 1975063616 19.426 100 67 133 0 2042717536 46406656 21247264
23:45:26 3017 8192000000 10970330704 11391873024 1981878352 19.480 100 71 141 2 2053204064 48207824 23117888
23:45:36 3693 8192000000 10962548912 11377336320 1964653968 19.343 99 76 148 1 2037804656 48824656 24326032
23:45:47 4111 8192000000 10950429264 11364171776 1954072816 19.259 99 80 159 0 2031098576 51166336 25859424
23:46:03 2531 8192000000 10976263440 11390652416 1975947088 19.433 100 73 143 1 2052414496 52441872 24025536
23:46:14 2201 8192000000 10968763520 11378302976 1964666960 19.343 100 91 182 0 2047492000 53056448 29768592
23:46:23 4021 8192000000 10957486160 11377717248 1969680176 19.383 100 80 161 1 2047114800 51948736 25485888
23:46:35 2086 8192000000 10978127904 11388755968 1980393232 19.468 100 88 177 1 2060552080 52521072 27637776
23:46:44 5562 8192000000 10969623568 11388403712 1976700592 19.439 100 74 148 1 2051521952 50357120 24464240
23:46:58 1901 8192000000 10969411104 11391422464 1975598352 19.430 100 74 146 0 2050479152 51659552 23221248
23:47:07 4136 8192000000 10966394496 11394965504 1977300368 19.443 100 61 122 2 2048442848 51666368 19476112
23:47:20 8932 8192000000 10943168064 11385905152 1958286928 19.292 99 53 104 0 2026537200 50884304 17365968
23:47:47 3022 8192000000 10967743040 11392786432 1976324704 19.436 100 55 110 1 2045621264 50996672 18299888
23:47:59 9394 8192000000 10959669664 11405713408 1979325264 19.459 100 43 86 2 2048490240 54318784 14846192
23:48:16 8014 8192000000 10958645984 11394535424 1959018320 19.298 99 45 90 0 2029142416 54280192 15843904
23:48:35 3819 8192000000 10971851216 11387547648 1967882336 19.369 99 83 160 2 2049521504 56278464 25360704
23:48:48 2064 8192000000 10976592448 11397709824 1977765472 19.447 100 81 162 1 2053880608 49946848 26168288
23:49:01 7303 8192000000 10953481536 11387596800 1972500960 19.405 100 53 106 4 2034272736 44582640 17189136
23:49:15 2990 8192000000 10966819824 11389587456 1975996656 19.433 100 72 146 2 2045212688 45586848 23629184
23:49:26 15963 8192000000 10954759600 11389526016 1969402896 19.381 100 49 97 1 2032687936 47252112 16032928
23:50:02 8152 8192000000 10953814880 11398991872 1975689440 19.431 100 45 90 0 2043886560 52770448 15426672
23:50:17 17506 8192000000 10957625376 11406925824 1977249952 19.443 100 44 88 1 2042442128 50444656 14747520
23:50:42 6068 8192000000 10957611968 11408134144 1976815968 19.439 100 34 68 0 2037133136 48358496 11958672
23:50:54 20658 8192000000 10949087264 11406327808 1980246656 19.467 100 31 62 1 2031647568 41063280 10337632
23:51:25 16485 8192000000 10948810416 11407495168 1979265552 19.459 100 32 64 0 2030575040 40089264 11220224
23:52:04 7093 8192000000 10940320160 11398721536 1970097216 19.386 100 24 48 0 2023360128 44465600 8797312
23:52:53 30104 8192000000 10896077472 11354370048 1907281120 18.885 98 25 50 2 1959146640 42509360 9356160
23:53:43 24248 8192000000 10911986000 11362054144 1915258176 18.949 99 24 48 1 1971166640 46614816 9293648
23:54:14 25699 8192000000 10920155360 11386490880 1949039696 19.219 100 24 48 2 2007113312 49449984 8623632
23:54:46 48556 8192000000 10889235056 11353346048 1933631344 19.096 99 14 28 0 1948625744 10575600 4418800
23:55:45 18586 8192000000 10890401408 11323482112 1899756176 18.824 97 48 92 4 1926755424 13246512 13752736
23:56:14 33208 8192000000 10877578304 11338584064 1939358352 19.142 100 12 23 1 1955348256 12712368 3277536
23:57:05 64245 8192000000 10899814224 11344334848 1933866432 19.098 99 19 38 0 1952214336 12751296 5596608
23:58:24 140479 8192000000 10914045312 11359350784 1931672496 19.080 98 35 70 0 1961492160 19386880 10432784
00:00:51 84796 8192000000 10891860128 11359952896 1959870400 19.305 100 16 32 0 1982057440 17692560 4494480
00:02:22 17615 8192000000 10891709520 11339853824 1904711376 18.864 97 29 56 3 1927013760 14048784 8253600
00:02:46 77294 8192000000 10877081760 11329916928 1916921744 18.962 98 20 38 3 1938434320 15915120 5597456
00:04:11 39526 8192000000 10897020240 11358498816 1957558032 19.287 100 22 44 0 1980385024 16381760 6445232
00:05:04 55178 8192000000 10891734496 11364933632 1958606592 19.295 100 17 34 0 1975567840 11680496 5280752
00:06:06 21488 8192000000 10897556672 11366395904 1955646720 19.271 99 33 66 1 1978896624 13335664 9914240
00:06:34 45751 8192000000 10887983488 11365335040 1953972256 19.258 99 9 18 0 1969685952 13213600 2500096
00:07:57 39533 8192000000 10910537456 11382910976 1978532624 19.453 100 15 30 0 1997991952 14777392 4681936
00:08:44 34384 8192000000 10910650816 11383271424 1965958592 19.353 99 14 28 0 1988173104 17373008 4841504
00:09:25 73579 8192000000 10893603376 11371622400 1945217536 19.188 98 15 30 0 1967604032 17800288 4586208
00:10:57 52243 8192000000 10903844752 11380957184 1980722960 19.470 100 16 32 1 1999383152 13842384 4817808
00:12:30 27528 8192000000 10918983216 11381628928 1978722528 19.455 100 29 58 0 2000835952 13271472 8841952
00:13:54 44326 8192000000 10908606144 11380957184 1988757056 19.534 100 39 78 2 2012666432 13006224 10903152
00:14:45 67992 8192000000 10913384688 11388923904 1992289840 19.562 100 22 44 0 2007731088 9308320 6132928
00:16:04 52793 8192000000 10907145792 11400634368 1993272096 19.570 100 15 30 0 2007063904 9271904 4519904
00:17:05 59121 8192000000 10922107792 11396669440 1997935456 19.606 100 8 15 0 2009455040 9837008 1682576
00:18:18 56277 8192000000 10918926384 11405803520 2006294816 19.672 100 14 28 0 2017711728 7271136 4145776
00:19:21 58554 8192000000 10923141568 11409154048 1970032592 19.386 98 6 12 0 1982490336 10139472 2318272
00:20:30 49908 8192000000 10930698464 11397476352 1950446400 19.230 97 24 48 2 1969438496 12280320 6711776
00:21:31 40318 8192000000 10910227904 11400437760 1986488912 19.516 100 18 36 1 2008351360 16864592 4997856
00:22:24 88903 8192000000 10927617936 11419467776 1983294064 19.491 99 9 19 0 2000280160 13768064 3218032
00:24:01 59576 8192000000 10924792016 11401420800 1986333712 19.515 99 24 48 0 2003907280 10724896 6848672
00:25:13 92691 8192000000 10885936000 11370459136 1833900144 18.291 92 15 30 0 1850800640 12910720 3989776
00:26:56 65374 8192000000 10887505328 11356975104 1889898544 18.745 96 21 41 1 1906134848 10811440 5424864
00:29:26 118413 8192000000 10872108928 11331678208 1800183728 18.015 92 18 35 1 1820570352 15163936 5222688
00:31:31 93061 8192000000 10846094368 11315478528 1846856256 18.397 95 13 26 2 1868548192 17702784 3989152
00:33:22 82984 8192000000 10823916672 11302162432 1830305216 18.262 95 10 20 0 1849227360 16022720 2899424
00:34:57 75584 8192000000 10834289360 11288854528 1847972272 18.406 97 13 26 1 1863622176 11364368 4285536
00:36:19 50155 8192000000 10841297072 11303567360 1897504288 18.806 99 35 70 1 1917913712 10734672 9674752
00:37:16 9465 8192000000 10861321600 11315183616 1925523360 19.031 100 42 84 2 1948297328 10848272 11925696
00:37:32 12198 8192000000 10851700848 11308089344 1905883568 18.874 99 39 78 0 1927601840 10837136 10881136
00:37:50 7017 8192000000 10860237360 11291332608 1903808368 18.857 99 51 100 6 1928269040 10252320 14208352
00:38:04 40249 8192000000 10835416784 11305107456 1905681008 18.872 99 24 48 0 1925012224 12633664 6697552
00:38:51 70050 8192000000 10854785296 11327610880 1931650864 19.080 100 14 28 0 1949917152 13902176 4364112
00:40:25 81485 8192000000 10816936944 11285372928 1812654848 18.118 94 12 25 0 1829763856 13498880 3610128
00:42:05 58838 8192000000 10832586752 11301908480 1893815280 18.777 99 22 43 1 1911618944 11083232 6720432
00:43:17 50157 8192000000 10856671072 11329077248 1916913664 18.962 100 10 20 1 1933821616 13242160 3665792
00:44:17 52639 8192000000 10839259408 11318116352 1874354448 18.619 97 8 16 0 1890267328 13563504 2349376
00:45:26 49078 8192000000 10877695248 11324497920 1892572352 18.767 98 24 48 2 1918358640 18184832 7601456
00:46:25 41298 8192000000 10871940688 11338563584 1933541040 19.095 100 27 54 0 1949091584 8582544 6968000
00:47:16 66955 8192000000 10902808560 11360477184 1951360304 19.237 100 16 32 0 1964369728 8711104 4298320
00:48:30 105273 8192000000 10872708224 11347677184 1891970640 18.762 97 18 36 1 1914439456 17644896 4823920
00:50:22 58599 8192000000 10887015632 11351535616 1914500160 18.943 98 17 34 2 1927608480 8013824 5094496
00:51:33 58300 8192000000 10874907904 11350962176 1916626096 18.960 98 19 38 0 1938034624 15625040 5783488
00:52:45 65436 8192000000 10873888544 11343785984 1890371360 18.749 97 19 38 0 1910576752 14791968 5413424
00:53:57 28259 8192000000 10887249248 11355439104 1945467328 19.190 100 19 38 1 1965064256 14163632 5433296
00:54:32 106419 8192000000 10868119184 11346001920 1886593216 18.718 97 14 28 1 1908066368 17675024 3798128
00:56:24 53769 8192000000 10868821584 11338276864 1872220672 18.602 96 14 28 0 1889253136 12871680 4160784
00:57:24 100285 8192000000 10892194864 11358281728 1945028480 19.187 100 21 42 0 1967378592 16369872 5980240
00:59:12 83359 8192000000 10888296704 11359879168 1929724464 19.065 98 24 48 1 1946528576 10157696 6646416
01:00:42 3248 8192000000 10870206096 11341340672 1938285104 19.133 99 22 44 0 1954965488 11120640 5559744
01:00:52 14365 8192000000 10883782768 11348525056 1953835568 19.257 100 26 53 1 1971273312 10419520 7018224
01:01:21 31162 8192000000 10886339296 11365777408 1969082912 19.378 100 31 62 2 1989507920 11794672 8630336
01:02:05 44982 8192000000 10887500144 11372150784 1968138512 19.371 100 8 16 0 1979599952 9206112 2255328
01:02:59 56888 8192000000 10918585712 11388846080 1983405376 19.492 100 22 45 1 1997944096 8473280 6065440
01:04:13 51785 8192000000 10922538000 11396296704 1994276624 19.578 100 17 34 0 2011188736 12136624 4775488
01:05:13 64213 8192000000 10901375152 11387383808 1977754432 19.447 99 21 42 2 1998744656 14579328 6410896
01:06:36 117620 8192000000 10920764720 11413565440 1968703152 19.375 99 9 18 0 1986623504 15401168 2519184
01:08:39 77322 8192000000 10907117024 11382116352 1934205008 19.100 97 16 32 0 1954640336 15742080 4693248
01:10:08 48866 8192000000 10906201312 11377147904 1947590320 19.207 98 37 73 1 1974400144 15979856 10829968
01:11:05 68582 8192000000 10914867168 11378024448 1945789168 19.193 98 16 31 2 1965087232 15211184 4086880
01:12:20 46219 8192000000 10902990352 11378585600 1951052880 19.235 99 27 54 0 1973238192 15087904 7097408
01:13:13 37620 8192000000 10905519744 11371819008 1936950528 19.122 98 22 44 0 1955972704 13311552 5710624
01:14:01 26791 8192000000 10908339008 11373592576 1935264816 19.109 98 34 68 0 1958403200 13719264 9419120
01:14:34 19320 8192000000 10912850400 11378360320 1968782096 19.376 100 30 60 1 1991011920 13974368 8255456
01:15:00 17247 8192000000 10903531808 11356659712 1950167184 19.228 99 35 70 0 1973441184 13757888 9516112
01:15:26 41203 8192000000 10868246384 11337093120 1907844864 18.889 97 28 56 1 1927335328 11882512 7607952
01:16:15 28590 8192000000 10911618384 11353157632 1900415424 18.830 97 31 62 1 1915135232 6364320 8355488
01:16:53 20510 8192000000 10919282496 11373338624 1964045728 19.338 100 41 83 0 1993451696 17803408 11602560
01:17:20 64429 8192000000 10886703616 11370295296 1904626496 18.863 97 18 36 0 1929939776 20301808 5011472
01:20:11 96992 8192000000 10887685360 11349463040 1923675376 19.016 98 30 60 2 1943019104 10746784 8596944
01:21:57 73913 8192000000 10800863232 11277262848 1810884704 18.103 93 20 39 1 1827989872 11631536 5473632
01:23:18 47637 8192000000 10832474032 11315175424 1896952176 18.802 99 9 18 0 1914708752 14812880 2943696
01:24:38 110900 8192000000 10844724448 11328348160 1889782400 18.744 98 14 28 0 1906685296 12687088 4215808
01:26:46 39624 8192000000 9169107088 9417039872 334120656 3.918 18 4 8 1 340052816 4890912 1041248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 19-02-2021 01:29:34 to 19-02-2021 01:30:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 83 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-02-2021 01:30:07 to 19-02-2021 01:30:09.

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          233102
MON$OLDEST_ACTIVE               236065
MON$OLDEST_SNAPSHOT             236065
MON$NEXT_TRANSACTION            236065
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                       2032032
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.33418 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33418 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33418 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33418 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 ---
:37: 
:38: mscs-test-161.budzdorov.ru    Fri Feb 19 01:27:36 2021
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
--- end of diff output ---

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

19.02.21 01:30:10. 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-02-19 01:30:12 No severe PSQL-related problems occured
19.02.21 01:30:13. End of report.